Description:
Periodically, I am getting mysqld server crashes and lost connections when attempting to write to a table called "session". This table is using ENGINE=MEMORY.
My application is outputing this error about 10 times each day:
---------- cut ---------------
Invalid SQL:
UPDATE session
SET lastactivity = 1146024012, location = '/showthread.php?t=526365', inthread = 526365, incalendar = 0, badlocation = 0
WHERE sessionhash = 'c08e8769e737381bb295f1a3c73e4fa8';
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
---------- cut ---------------
Here is my "SHOW CREATE TABLE sessions" output:
-----------cut --------------
CREATE TABLE `session` (
`sessionhash` varchar(32) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`host` varchar(15) NOT NULL default '',
`useragent` varchar(100) NOT NULL default '',
`lastactivity` int(10) unsigned NOT NULL default '0',
`styleid` smallint(5) unsigned NOT NULL default '0',
`location` varchar(255) NOT NULL default '',
`althash` varchar(32) NOT NULL default '',
`badlocation` smallint(5) unsigned NOT NULL default '0',
`inforum` smallint(5) unsigned NOT NULL default '0',
`inthread` int(10) unsigned NOT NULL default '0',
`incalendar` int(10) unsigned NOT NULL default '0',
`loggedin` smallint(5) unsigned NOT NULL default '0',
`idhash` varchar(32) NOT NULL default '',
`bypass` smallint(6) NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`sessionhash`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1
-----------cut--------------
Also, it is important to note that these child mysql server crashes are not generating anything in the error log.
How to repeat:
I do not know how to duplicate this error on demand. Perhaps it happens under high load.
I am running linux-2.4.21-37.ELsmp (AS3 update 6) on a 32 bit dual proc P3@1.0Ghz w/ 2GB Ram.
Suggested fix:
not known
