Hi,
Version 5.0.16 is also crashing, but with more info in syslog.
Without the delayed the query works fine.
On another 5.0.16 server the query also works fine so maybe a bit of
load is needed.
CREATE TABLE `xwi_login_failures` (
`ipa` int(11) NOT NULL default '0',
`gsku` int(11) NOT NULL default '0',
`name` varchar(9) NOT NULL default '',
`pass` varchar(8) NOT NULL default '',
`serial` varchar(22) default NULL,
`sid` int(11) NOT NULL default '0',
`msg` varchar(255) NOT NULL default '',
`time` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
insert delayed into xwi_login_failures (ipa, gsku, name, pass, serial,
sid, msg, time) values (0,0,"","",NULL,0,"",0);
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> insert delayed into xwi_login_failures (ipa, gsku, name, pass,
serial, sid, msg, time) values (0,0,"","",NULL,0,"",0);
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 5
Current database: xcc
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
Jan 1 14:19:59 xwis mysqld[4151]: mysqld got signal 11;
Jan 1 14:19:59 xwis mysqld[4151]: This could be because you hit a bug.
It is also possible that this binary
Jan 1 14:19:59 xwis mysqld[4151]: or one of the libraries it was linked
against is corrupt, improperly built,
Jan 1 14:19:59 xwis mysqld[4151]: or misconfigured. This error can also
be caused by malfunctioning hardware.
Jan 1 14:19:59 xwis mysqld[4151]: We will try our best to scrape up
some info that will hopefully help diagnose
Jan 1 14:19:59 xwis mysqld[4151]: the problem, but since we have
already crashed, something is definitely wrong
Jan 1 14:19:59 xwis mysqld[4151]: and this may fail.
Jan 1 14:19:59 xwis mysqld[4151]:
Jan 1 14:19:59 xwis mysqld[4151]: key_buffer_size=16777216
Jan 1 14:19:59 xwis mysqld[4151]: read_buffer_size=131072
Jan 1 14:19:59 xwis mysqld[4151]: max_used_connections=31
Jan 1 14:19:59 xwis mysqld[4151]: max_connections=100
Jan 1 14:19:59 xwis mysqld[4151]: threads_connected=32
Jan 1 14:19:59 xwis mysqld[4151]: It is possible that mysqld could use
up to
Jan 1 14:19:59 xwis mysqld[4151]: key_buffer_size + (read_buffer_size +
sort_buffer_size)*max_connections = 233983 K
Jan 1 14:19:59 xwis mysqld[4151]: bytes of memory
Jan 1 14:19:59 xwis mysqld[4151]: Hope that's ok; if not, decrease some
variables in the equation.
Jan 1 14:19:59 xwis mysqld[4151]:
Jan 1 14:19:59 xwis mysqld[4151]: thd=0x8af53b0
Jan 1 14:19:59 xwis mysqld[4151]: Attempting backtrace. You can use the
following information to find out
Jan 1 14:19:59 xwis mysqld[4151]: where mysqld died. If you see no
messages after this, something went
Jan 1 14:19:59 xwis mysqld[4151]: terribly wrong...
Jan 1 14:19:59 xwis mysqld[4151]: Cannot determine thread,
fp=0xb0ca8fcc, backtrace may not be correct.
Jan 1 14:19:59 xwis mysqld[4151]: Stack range sanity check OK,
backtrace follows:
Jan 1 14:19:59 xwis mysqld[4151]: 0x81890fb
Jan 1 14:19:59 xwis mysqld[4151]: 0xffffe420
Jan 1 14:19:59 xwis mysqld[4151]: (nil)
Jan 1 14:19:59 xwis mysqld[4151]: 0x81ea24f
Jan 1 14:19:59 xwis mysqld[4151]: 0x819f17b
Jan 1 14:19:59 xwis mysqld[4151]: 0x81a2288
Jan 1 14:19:59 xwis mysqld[4151]: 0x81a2849
Jan 1 14:19:59 xwis mysqld[4151]: 0x81a382d
Jan 1 14:19:59 xwis mysqld[4151]: 0x81a40d5
Jan 1 14:19:59 xwis mysqld[4151]: 0xb7f19cfd
Jan 1 14:19:59 xwis mysqld[4151]: 0xb7d5d13e
Jan 1 14:19:59 xwis mysqld[4151]: New value of fp=(nil) failed sanity
check, terminating stack trace!
Jan 1 14:19:59 xwis mysqld[4151]: Please read
http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
Jan 1 14:19:59 xwis mysqld[4151]: stack trace is much more helpful in
diagnosing the problem, so please do
Jan 1 14:19:59 xwis mysqld[4151]: resolve it
Jan 1 14:19:59 xwis mysqld[4151]: Trying to get some variables.
Jan 1 14:19:59 xwis mysqld[4151]: Some pointers may be invalid and
cause the dump to abort...
Jan 1 14:19:59 xwis mysqld[4151]: thd->query at 0x8b29630 = insert
delayed into xwi_login_failures (ipa, gsku, name, pass, serial, sid,
msg, time) values (0,0,"","",NULL,0,"",0)
Jan 1 14:19:59 xwis mysqld[4151]: thd->thread_id=1
Jan 1 14:19:59 xwis mysqld[4151]: The manual page at
http://www.mysql.com/doc/en/Crashing.html contains
Jan 1 14:19:59 xwis mysqld[4151]: information that should help you find
out what is causing the crash.
Jan 1 14:19:59 xwis mysqld_safe[4218]: Number of processes running now: 0
Jan 1 14:19:59 xwis mysqld_safe[4220]: restarted
--
Olaf van der Spek
http://xccu.sf.net/
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
