>Description: See previous bug report Mysql crashes when executing simple query: mysql> delete from statcache where spamdate < 1028304682; ERROR 2013: Lost connection to MySQL server during query
Table def: CREATE TABLE statcache ( reportid int(10) unsigned NOT NULL default '0', spamid int(10) unsigned NOT NULL default '0', issueid int(10) unsigned NOT NULL default '0', recipid int(10) unsigned NOT NULL default '0', spamdate int(10) unsigned NOT NULL default '0', type tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (reportid), KEY date (spamdate), KEY dr (recipid,type,spamdate), KEY di (issueid,type,spamdate) ) TYPE=InnoDB; I can provide table contents if needed. I'll dump it now so we have a snapshot of the problematic data. mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402649088 record_buffer=2093056 sort_buffer=2097144 max_used_connections=50 max_connections=100 threads_connected=10 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 802411 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8720c8a8 Attempting 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, fp=0xbfc7e2f8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8071b58 + 134683480 0x825a668 + 136685160 0x81737bf + 135739327 0x816f5bd + 135722429 0x815960e + 135632398 0x812a29b + 135439003 0x8135131 + 135483697 0x8136142 + 135487810 0x8136332 + 135488306 0x8122a7d + 135408253 0x80c91ad + 135041453 0x80a6c41 + 134900801 0x807bad0 + 134724304 0x807d955 + 134732117 0x8078ed3 + 134713043 0x807ece1 + 134737121 0x80780ae + 134709422 0x8257c7c + 136674428 0x828d3ba + 136893370 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x84e8788 = delete from statcache where spamdate < 1028304682 thd->thread_id=806 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 806 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 >How-To-Repeat: See above. >Fix: Still working on a workaround. Will have to set up a non-production server to bang on. >Submitter-Id: <submitter ID> >Originator: >Organization: spamcop.net (Julian Haight) >MySQL support: licence >Synopsis: MySQL crashes on simple 'delete from' query >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.39 (Source distribution) >Environment: System: Linux sandyman 2.4.18 #8 SMP Thu Jul 18 18:24:01 EDT 2002 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/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Mar 19 12:57 /lib/libc.so.6 -> libc-2.2.3.so -rwxr-xr-x 1 root root 4783716 May 25 2001 /lib/libc-2.2.3.so -rw-r--r-- 1 root root 24721042 May 25 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 May 25 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql/mysql.sock --localstatedir=/var/lib/mysql --with-pthread --enable-thread-safe-client --enable-assembler --with-raid --with-libwrap --without-bench i386-slackware-linux --------------------------------------------------------------------- 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