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. &g

Re: Found cause of crash - simple SQL statement.

2002-08-12 Thread William R. Mussatto
news, but I thougth I was following 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

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