Matt it would help to know:
Your platform: Linux? What version? your kernel?
Which MySQL version?
Did you compile it your self? Using what options?
What is your my.cnf? Are you running low on resources?
Many time a signal 11 indicates a Harware/memory problem are you
running ECC memory?
You need to provide more info than just the error: also try using
mysqlbug to generate a bug report.
Ken
----- Original Message -----
From: "matt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 04, 2001 10:01 AM
Subject: killed by SIGSEGV
> Hello list,
>
> I've got a problem with mysql being killed by signal 11
(segmentation
> violation). It gets killed on average every 4 days, and on that day
it
> will on averate get killed 4 times. Sometimes it will be as many as
8
> times, sometimes only once (see below for log).
>
> I've read 'Debugging a MySQL server' in the manual, and have taken
the
> stacktrace (which is the same everytime it gets killed) and resolved
> it to get:
>
> 0x400645e2 _end + 937899586
> 0x40063bc2 _end + 937896994
> 0x80bcd6e create_new_thread__FP3THD + 638
> 0x80bd232 handle_connections_sockets__FPv + 1058
> 0x80bc8e5 main + 2625
> 0x400e89b7 _end + 938441239
> 0x8088821 _start + 33
>
> Unsurprisingly, this doesn't help me out much except that it looks
> like it happens when a new thread is created.
>
> As I said, I have read the online manual so I know that this may not
> help anyone else out either, but I have no idea how to get the fault
> to happen on demand - so this seems like a good enough way to start.
> If anyone can make any suggestions on tests/things to try then
> please do.
>
> Thanks, Matt
>
>
> This is what a typical log entry looks like:
> --------------------
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tells you how to use a
> stack trace and/or the core file to produce a readable backtrace
that
> may
> help in finding out why mysqld died
> Attemping backtrace. You can use the following information to find
out
> where mysqld died. If you see no messages after this, something
went
> terribly wrong
> Cannot determine thread, ebp=0xbffff484, backtrace may not be
correct
> stack range sanity check, ok, backtrace follows
> 0x400645e2
> 0x40063bc2
> 0x80bcd6e
> 0x80bd232
> 0x80bc8e5
> 0x400e89b7
> 0x8088821
> New value of ebp failed sanity check terminating backtrace
>
> Number of processes running now: 0
> 011129 12:16:57 mysqld restarted
> /usr/local/mysql/libexec/mysqld: ready for connections
>
> This is how often it gets killed (these are all caused by SIGSEGV)
> --------------------
> $ grep -e 'mysqld restarted' bertha.err | uniq -w6 -c
> 1 010930 19:10:32 mysqld restarted
> 8 011001 09:40:39 mysqld restarted
> 2 011002 09:49:22 mysqld restarted
> 3 011020 09:16:26 mysqld restarted
> 3 011025 14:00:11 mysqld restarted
> 7 011026 13:46:05 mysqld restarted
> 1 011029 20:01:59 mysqld restarted
> 2 011031 12:29:03 mysqld restarted
> 1 011107 16:24:05 mysqld restarted
> 2 011112 13:39:32 mysqld restarted
> 7 011113 14:52:30 mysqld restarted
> 7 011120 15:04:52 mysqld restarted
> 4 011122 11:46:56 mysqld restarted
> 4 011126 09:45:53 mysqld restarted
> 6 011127 10:12:18 mysqld restarted
> 1 011129 12:16:57 mysqld restarted
>
> --
> #!/usr/bin/perl
> $A='A';while(print+($A.=(grep{($A=~/(...).{78}$/)[0]eq$_}" A A A "
> =~m{(...)}g)?"A":" ")=~/([ A])$/){if(!(++$l%80)){print"\n";sleep 1}}
>
>
> --------------------------------------------------------------------
-
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
