On Monday 21 May 2001 23:29, Steve wrote:
> 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
>
First, you seem to be resolving a different stack trace than the one you have
posted. Can you resolve the original one too?
Can you try our 3.23.38 binary and see if it solves the problem? Your own
source build is not going to be very stable as the number of connections
increases unless you take some measures to fix up LinuxThreads - see
http://www.mysql.com/doc/L/i/Linux.html .
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
---------------------------------------------------------------------
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
