I cannot tell the cause or exactly when it happened, but I am getting lots of emails about database errors like this:
When I look at the table in Navicat, postindex shows as 0KB with rows listed as -1. The searchcore_text table also shows as 0KB with rows -1, while the searchcare table shows as 113,280KB and 1,359,152 rows.
I've actually been searching all over for what to do with searchcore_text, as I've seen many people have this table corrupt, but I can't find a clear answer on what to do about it. Can it be emptied? Do I also have to empty searchcore? Do I try to restore data in this table from a backup?
I have attempted to run a repair database from cPanel but it gets locked up and sucks all the CPU resources and brings the server to a halt it seems.
As for postindex, I'm not getting errors on that one, but thought it strange that it's also reporting -1 rows.
This is kind of an emergency! Searchcore_text seems to be accessed with every submit, search, posting etc, I need to get it fixed!
Code:
MySQL Error : Table './xxxxxxxx_forum/searchcore_text' is marked as crashed and last (automatic?) repair failed Error Number : 144 Request Date : Monday, January 27th 2014 @ 10:28:18 PM Error Date : Monday, January 27th 2014 @ 10:28:18 PM Username : SomeYumGuy Classname : vB_Database
I've actually been searching all over for what to do with searchcore_text, as I've seen many people have this table corrupt, but I can't find a clear answer on what to do about it. Can it be emptied? Do I also have to empty searchcore? Do I try to restore data in this table from a backup?
I have attempted to run a repair database from cPanel but it gets locked up and sucks all the CPU resources and brings the server to a halt it seems.
As for postindex, I'm not getting errors on that one, but thought it strange that it's also reporting -1 rows.
This is kind of an emergency! Searchcore_text seems to be accessed with every submit, search, posting etc, I need to get it fixed!
Comment