I have been having problems with my access table as of late. I notice the problem every hour when the subscriptions cron job is scheduled to go off.
This is what I get in the e-mail.
This is what I get when checking the db:
Thus it looks like there is an obvious problem in the db. Another problem, however, is that my db is 2 GB in size. I have tried to repair it but it has taken several hours to simply try and repair the access table, which means the site is down while it is trying to repair it.
Does anyone have any suggestions on what I can do? Thanks!
This is what I get in the e-mail.
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT COUNT(*) AS masks
FROM access
WHERE userid = 980
mysql error: Can't open file: 'access.MYI'. (errno: 144)
mysql error number: 1016
Date: Thursday 04th of August 2005 12:21:08 AM
Script: http://www.uspoliticsonline.com/foru...p?&rand=437864
Referer: http://www.uspoliticsonline.com/forums/index.php?
Invalid SQL:
SELECT COUNT(*) AS masks
FROM access
WHERE userid = 980
mysql error: Can't open file: 'access.MYI'. (errno: 144)
mysql error number: 1016
Date: Thursday 04th of August 2005 12:21:08 AM
Script: http://www.uspoliticsonline.com/foru...p?&rand=437864
Referer: http://www.uspoliticsonline.com/forums/index.php?
politics_discussion.access
warning : Table is marked as crashed and last repair failed
warning : Size of datafile is: 371019941 Should be: 13
error : Can't read indexpage from filepos: -1
error : Corrupt
warning : Table is marked as crashed and last repair failed
warning : Size of datafile is: 371019941 Should be: 13
error : Can't read indexpage from filepos: -1
error : Corrupt
Thus it looks like there is an obvious problem in the db. Another problem, however, is that my db is 2 GB in size. I have tried to repair it but it has taken several hours to simply try and repair the access table, which means the site is down while it is trying to repair it.
Does anyone have any suggestions on what I can do? Thanks!
Comment