Re: Innodb funny error - Michael Widenius - com.mysql.lists.mysql

12 messages in com.mysql.lists.mysqlRe: Innodb funny error

From	Sent On	Attachments
Ken Menzel	17 Jan 2002 13:49
Heikki Tuuri	17 Jan 2002 14:46
Jason Hall	18 Jan 2002 09:44
Ken Menzel	21 Jan 2002 14:06
Sanja Byelkin	22 Jan 2002 00:46
Ken Menzel	22 Jan 2002 06:27
Heikki Tuuri	22 Jan 2002 06:41
Egor Egorov	22 Jan 2002 07:36
Ken Menzel	22 Jan 2002 08:05
Michael Widenius	25 Jan 2002 09:32
Michael Widenius	25 Jan 2002 09:35
Ken Menzel	25 Jan 2002 11:15

Subject:	Re: Innodb funny error
From:	Michael Widenius (mon...@mysql.com)
Date:	01/25/2002 09:32:29 AM
List:	com.mysql.lists.mysql

Hi!

"HeikkiiH" == Heikki Tuuri <Heik...@innodb.com> writes:

HeikkiiH> Ken, HeikkiiH> the 'connection lost' error suggests some bug in the client or HeikkiiH> communication. Since you are running 4.0.1-alpha, it could be
something with HeikkiiH> the query cache. I think Sanja has already fixed some bugs there since
4.0.1 HeikkiiH> was released. The query cache is suspect since the error did not crash
the HeikkiiH> server, and it was restricted to one table.

HeikkiiH> Well, the next time you get the problem you could try just inserting a HeikkiiH> single additional row to the table. That should invalidate the query
cache, HeikkiiH> I think. ALTER TABLE certainly does that.

If this is a cache problem, then any insert or 'reset query cache' would invalidate the cache.

Note however that the query cache is not on by default; If Ken didn't enable it, it should not have caused by this problem.

HeikkiiH> I am forwarding this report to Monty and Sanja.

HeikkiiH> Best regards,

It would have been nice to know if restarting MySQL would have helped. If not, then we would like to have had a copy of the InnoDB table space to be able to replicate the problem!

Regards, Monty