Hi, Well its a bug in MySQL 5.1.31 and fixed in MySQL 5.1.33. The reason being InnoDB engine can't take a float kind of datatype as auto_increment field. In my table, auto_increment was defined as double. Hence the issue.
Regards, - Kurian Mathew Thayil. (GPG KeyID: E232394F) On Sat, 2009-12-19 at 10:11 +0530, Kurian Thayil wrote: > Hi, > > Installed compiled mysql-5.1.31 in a centOS 4.4 box. When tried to > execute an insert query I get Error 2013. In fact mysql server crashes > and restarts. > > mysql> INSERT INTO `session_table` VALUES > (2,'2',122,'38507720d9d18aede22a2346571a35e7','2009-03-18 10:50:57'); > ERROR 2013 (HY000): Lost connection to MySQL server during query > > Any idea why this is happening? I was able to restore a database which > has tables with 400000-500000 records without any issues. Attached is > the error log. Thanks in advance. > > Regards, > > Kurian Thayil.
signature.asc
Description: This is a digitally signed message part
