MySQL Forums
Forum List  »  Newbie

Re: Corruptions like crazy
Posted by: John Bowles
Date: April 29, 2015 02:00PM

After reading the extract below from the document, based upon what it is saying, it appears that either the disk drive has a problem or there is "A software bug in the MySQL or MyISAM code". It seems strange that if it is a disk drive problem it would consistently effect three tables at exactly the same time in exactly the same way (the two stages of errors as described in the first post). This morning the problem was such that I repaired the tables and ran the check to make sure there were no errors but the update from my webpage issued an error suggesting I repair the table when when I ran the myisamchk command it said there were no errors. So I had no choice but return the database with phpMyAdmin and that fixed the problem. So I guess it is time to take a break and eat.

15.2.4.1 Corrupted MyISAM Tables
Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur:

The mysqld process is killed in the middle of a write.

An unexpected computer shutdown occurs (for example, the computer is turned off).

Hardware failures.

You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time.

A software bug in the MySQL or MyISAM code.

Options: ReplyQuote


Subject
Written By
Posted
April 29, 2015 11:33AM
April 29, 2015 11:49AM
April 29, 2015 12:20PM
April 29, 2015 12:40PM
April 29, 2015 01:04PM
April 29, 2015 01:36PM
April 29, 2015 01:48PM
Re: Corruptions like crazy
April 29, 2015 02:00PM
April 29, 2015 02:59PM
April 29, 2015 03:30PM
April 29, 2015 04:24PM
April 30, 2015 07:44AM
April 30, 2015 07:48AM
April 30, 2015 08:44AM
April 30, 2015 08:57AM
April 30, 2015 08:59AM
April 30, 2015 09:40AM
April 30, 2015 10:19AM
April 30, 2015 01:45PM
April 30, 2015 02:42PM
April 30, 2015 03:36PM
April 30, 2015 07:36PM
April 30, 2015 10:50PM


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.