MySQL Forums
Forum List  »  Newbie

Corruptions like crazy
Posted by: John Bowles
Date: April 29, 2015 11:33AM

Hi, I have a website using a MySql database. I am adding records to three tables using a web page that is designed to do this. I am getting the errors shown below. It works fine and I never got these errors that much before as far as I know but I have started getting these errors appearing almost after every update (immediately after I run the fixes). It starts out with only the first error (the first line error). Then after maybe 2 more updates it gives the whole set. I asked on a PHP forum and the person suggested the disk might be going bad. I have a request in at the hosting company to check the disk. Is it possible that I am doing something wrong that is just starting to surface as the tables start to get over 500 records. It is MyIsam by the way.

I hope I get an email notice on this. Sometimes I forget to get back to the forum.

Thanks,
John

myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Size of datafile is: 14092 Should be: 14128
myisamchk: error: Found key at page 7168 that points to record outside datafile
myisamchk: error: Record-count is not ok; is 393 Should be: 394
myisamchk: warning: Found 393 key parts. Should be: 394
MyISAM-table '/var/lib/mysql/MyDatabaseDirectory/tblMyTable1.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Size of datafile is: 24936 Should be: 24968
myisamchk: error: Found 3 keys of 718
myisamchk: error: Record-count is not ok; is 717 Should be: 718
myisamchk: warning: Found 717 key parts. Should be: 718
MyISAM-table '/var/lib/mysql/MyDatabaseDirectory/tblMyTable2.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Size of datafile is: 42504 Should be: 42546
myisamchk: error: Found key at page 10240 that points to record outside datafile
MyISAM-table '/var/lib/mysql/MyDatabaseDirectory/tblMyTable3.MYI' is corrupted

Options: ReplyQuote


Subject
Written By
Posted
Corruptions like crazy
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
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.