Hi!

>>>>> "HeikkiiH" == Heikki Tuuri <[EMAIL PROTECTED]> 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

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Michael Widenius <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
       <___/   www.mysql.com

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to