Hi,
I am running mysql 3.23.33 getting this error about once a day causeing
mysql to restart
****************************************************************************
************************************************
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
stack range sanity check, ok, backtrace follows
0x400737c6
0x80ff2af
0x80ff1e1
0x8101227
0x80e4873
0x80e45b8
0x80dd605
0x80c3265
0x80c72bf
0x80c2675
0x80c1cde
stack trace successful, now will try to get some
variables. Some pointers may be invalid and cause dump abort
thd->query at 0x81f9bf0 = SELECT * FROM hyperseek_links WHERE ID
in(988779528,988588937,988779473,988599648,988630588,988634546,988
600011,988613411,988613424,988605698,988614258,988614259,988613615,988619035
,988616328,988596036,988599643,988613419,988635422,98862
2151,988627434,988613538,988627431,988622188,988613415,988621976,988592381,9
88636427,988613413,988631044,988623929,988614599,9886231
05,988635148,988595545,988597946,988610251,988616059,988627430,988608473,988
598139,988627429,988611026,988598120,988625124,988634377
,988627427,988604205,988629277,988631289,988612742,988592490,988635848,98862
8639,988593015,988611041,988589630,988593784,988593696,9
88590456,988590457,988610004,988609853,988609428,988628676,988625092,9885967
10,988614174,988611930,988628208,988628684,988589448,988
634777,988631086,988627424,988589395,988629406,988593093,988627423,988605901
,988619264,988589911,988624763,988610330,988588752,98863
3204,988605807,988627421,988613695,988626494,988613013,988606490,988600691,9
88627420,988628061,988614780,988592519,988594515,9
thd->thread_id = 7951
successfully dumped variables, if you ran with --log
take a look at the details of what thread 7951 did to cause the crash.
In some cases of really bad corruption, this value can be invalid
Please use the information above to create a repeatable
test case for the crash, and send it to [EMAIL PROTECTED]
Number of processes running now: 2
010521 19:14:19 mysqld restarted
/usr/local/mysql/libexec/mysqld: ready for connections
010521 19:59:34 Aborted connection 1646 to db: 'search' user: 'search'
host: `203.111.10.101' (Got an error reading communication p
ackets)
****************************************************************************
************************************************
then ran (note this was on a previous error, I included the above error as
it was the most informative in the log file):
root@netmsc1:/tmp# resolve_stack_dump -s /tmp/mysqld.sym -n mysql.stack
Cannot determine thread, ebp=0xbffff14c, backtrace may not be correct
stack range sanity check, ok, backtrace follows
0x400737c6 _end + 938024678
0x40072d66 _end + 938022022
0x80be19a create_new_thread__FP3THD + 606
0x80be61b handle_connections_sockets__FPv + 1015
0x80bdd90 main + 2412
0x400f5577 _end + 938556567
0x808891d _start + 33
New value of ebp failed sanity check terminating backtrace
Some more info from mysqlbug:
System: Linux netmsc1 2.4.4 #1 Tue May 15 13:40:14 /etc/localtime 2001 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from
/usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 May 15 08:17 /lib/libc.so.6 ->
libc-2.1.3.so
-rwxr-xr-x 1 root root 1013224 Mar 21 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20266642 Mar 20 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 20 2000 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql
critical
Thanks and Regards,
Steve Reed
Network Administrator
Oznetwork Pty. Ltd.
8233 1900
142 Phillip St
Sydney NSW 2000
---------------------------------------------------------------------
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
