I can't figure out exactly what leads to it, but sometimes it takes a few weeks and sometimes it takes a few hours to get one of these error messages:
Database error in vBulletin 5.2.2:
Invalid SQL:
SELECT * FROM vb5_nodehash
WHERE `dupehash` = 3922050991 AND `userid` = 77 AND `dateline` > 1467564152
LIMIT 1;
MySQL Error : Table './[ourdatabasename]/vb5_nodehash' is marked as crashed and should be repaired
Error Number : 145
Request Date : Sunday, July 3rd 2016 @ 09:47:32 AM
Error Date : Sunday, July 3rd 2016 @ 09:47:32 AM
Script : http:///create-content/text/
Referrer : http://bearhawkforums.com/forum/bear...o-buck-a-rivet
IP Address : [IP is here]
Username : [username is here]
Classname : vB_Database_MySQLi
MySQL Version :
When I manually repair and optimize the table, it starts working again, perhaps for a few weeks or perhaps for a few hours. I can setup a cron job to periodically fix the table, but is there a way to try and get to the bottom of what is causing the error?
Database error in vBulletin 5.2.2:
Invalid SQL:
SELECT * FROM vb5_nodehash
WHERE `dupehash` = 3922050991 AND `userid` = 77 AND `dateline` > 1467564152
LIMIT 1;
MySQL Error : Table './[ourdatabasename]/vb5_nodehash' is marked as crashed and should be repaired
Error Number : 145
Request Date : Sunday, July 3rd 2016 @ 09:47:32 AM
Error Date : Sunday, July 3rd 2016 @ 09:47:32 AM
Script : http:///create-content/text/
Referrer : http://bearhawkforums.com/forum/bear...o-buck-a-rivet
IP Address : [IP is here]
Username : [username is here]
Classname : vB_Database_MySQLi
MySQL Version :
When I manually repair and optimize the table, it starts working again, perhaps for a few weeks or perhaps for a few hours. I can setup a cron job to periodically fix the table, but is there a way to try and get to the bottom of what is causing the error?
Comment