Re: table crash frequently
Hi,
did you upgrade by dumping and loading?
Or did you just run the 5.0 server on the existing tables? Since you have varchar in your tbale, the latter could cause problems as we have a bug in the varchar code that is not fixed yet. In this case I recommend to run ALTER TABLE table_name ENGINE=MyISAM when you have a good backup. This makes a copy of the old table and transforms the varchars. If you hit this problem, you should be able to repeat it with a certain statement and certain data.
But I do also suspect a bug in the keycache, which might be guilty for corruptions when unsing concurrent table modifications. This is almost impossible to repeat deliberately.
Regards
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
15436
April 26, 2006 01:54AM
7120
April 26, 2006 04:27AM
6389
April 27, 2006 05:07AM
6348
April 27, 2006 05:39AM
4856
April 27, 2006 10:01AM
4751
May 05, 2006 03:29AM
4697
May 08, 2006 02:21AM
5429
May 16, 2006 12:46AM
Re: table crash frequently
5475
May 16, 2006 05:05AM
4431
May 17, 2006 04:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.