MySQLCC segmentation fault

Swift&Smart · 09-22-2003, 12:26 AM

Are there anyone using MySQLCC?Please give me some hints of the following error.

My problem is...I have successfully installed MySQL server on my Linux server.However,I am pretty lazy to work with my MySQL server via command line so I chose MySQLCC as my GUI.Unfortunately,when I have installed it and run it,it generated a "Segmentation fault" error in my console. What's that?

And I have found this forum around and couldn't find an answer.Would you guys give me a clue?Thanks.

Swift&Smart · 09-22-2003, 06:58 AM

Did anyone overcome this problem?Please reply.I am frustrated....

ziggamon · 09-22-2003, 08:57 AM

I've also had that problem... anyone know how to fix it?

jharris · 09-22-2003, 09:05 AM

You might want to trace what its doing using strace. So from an xterm run "strace mysqlcc > debug.output 2> &1" then see what is in debug.output - it might give you some clues. Have any entries been written to the system logs that might give a hint too?

cheers

Jamie...

Swift&Smart · 09-22-2003, 10:50 AM

First off,thank you for your reply,jharris.

I have generated a debug.output log tonight.The output is astonishing!!!The output are as follows:

execve("./mysqlcc", ["./mysqlcc"], [/* 30 vars */]) = 0
uname({sys="Linux", node="192.168.0.5", ...}) = 0
brk(0) = 0x8733ce8
open("/etc/ld.so.preload", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/local/qt/lib/i686/mmx/libXext.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/local/qt/lib/i686/mmx", 0xbfffe550) = -1 ENOENT (No such file or directory)
open("/usr/local/qt/lib/i686/libXext.so.6", O_RDONLY) = -1 ENOENT (No such file
or directory)
stat64("/usr/local/qt/lib/i686", 0xbfffe550) = -1 ENOENT (No such file or directory)
open("/usr/local/qt/lib/mmx/libXext.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/local/qt/lib/mmx", 0xbfffe550) = -1 ENOENT (No such file or directory)
open("/usr/local/qt/lib/libXext.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/local/qt/lib", 0xbfffe550) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=38277, ...}) = 0
old_mmap(NULL, 38277, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40014000
close(3) = 0
.....and much more.....

jharris,do you think the problem lies on qt package or something?Because I found this log mentioned about gt.Should I get a new GT or something?Any suggestion is appreciated!

jharris · 09-22-2003, 10:58 AM

The last few lines of the output should show you what happened just before the process seg faults. Post those and we can take a look.

cheers

Jamie...

Swift&Smart · 09-22-2003, 11:04 AM

jharris,you replied my message very fast!Thanks.

Here is the error:
socket(PF_UNIX, SOCK_STREAM, 0) = 6
fcntl64(6, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(6, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(6, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(6, {sin_family=AF_UNIX, path="/tmp/mysql.sock"}, 110) = -1 ECONNREFUSED
(Connection refused)
fcntl64(6, F_SETFL, O_RDWR) = 0
shutdown(6, 2 /* send and receive */) = 0
close(6) = 0
--- SIGSEGV (Segmentation fault) ---

Thanksssss a lot.

jharris · 09-23-2003, 05:54 AM

Looks to me like it tries to connect to your local MySQL server via /tmp/mysql.sock fails then dies. Are you running a local MySQL server? Such a failure shouldn't cause MySQLcc to die like this.

cheers

Jamie...

Crashed_Again · 09-23-2003, 07:05 AM

Well, I love using a gui for all my MySQL stuff but like you guys I had serious issues with mysqlcc. It would randomly crash and give seg faults left and right. What I've found is that for some reason the older version are more stable. I believe the version I am using now is the first mysqlcc ever released. It hasn't crashed on me yet...

/me crosses his fingers

Swift&Smart · 09-23-2003, 10:53 AM

Thanks again,jharris,Crashed_Again.

By the way,my mysql.sock's permission is 777.So,why does it generate this error??Yeah,Crashed_Again,what's the stable version?Would you mind giving me some hints?

P.S. I have tried MySQLCC 0.8.3 and it didn't have segmentation fault.However,it has connection failed!!!!The password is correct.....

Thanks a lot.

dclett · 11-02-2003, 08:33 PM

hi Swift&Smart,

I am experiencing the same thing. Have you found a solution?
Recently I discovered that the problem disappears when run
as root. My mysql.sock's permissions are also 777.
Does this make sense to anyone?

cheers.

Swift&Smart · 11-03-2003, 08:51 AM

Thanks for your reply,dclett.

Indeed,I can't find any solution on this problem.As long as I can remember,I have no successful history on running MySQLCC.I opted to use command line instead of GUI.

Command line is wasting my time....

Maybe I wouldn't figure out this problem in depth,because I know how to use command to control the database.

However,if you have the solution,I welcome you post your solution here.