Found cause of crash - simple SQL statement.

2002-08-12 Thread mysqlbug2
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

Re: Found cause of crash - simple SQL statement.

2002-08-12 Thread Heikki Tuuri
Julian, the crash probably means the table is corrupt. That is a very basic query you run. Difficult to believe in any bug in SQL itself. Please dump your tables. Then upgrade to MySQL-Max-3.23.51. It is best to use an official binary. Then run CHECK TABLE on the table statcache. What does it

Re: Found cause of crash - simple SQL statement.

2002-08-12 Thread William R. Mussatto
this and didn't notice any threads on it. On Mon, 12 Aug 2002, Heikki Tuuri wrote: Date: Mon, 12 Aug 2002 20:52:14 +0300 From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Found cause of crash - simple SQL statement. Julian, the crash probably means the table

Re: Found cause of crash - simple SQL statement.

2002-08-12 Thread Heikki Tuuri
William, - Original Message - From: William R. Mussatto [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, August 12, 2002 10:29 PM Subject: Re: Found cause of crash - simple SQL statement. Pardon my ignorance, what Linux table corruption and what