10,000 vB database error messages

[Bob Isaac]

This morning we woke to over 10,000 vBulletin database error messages like these:

Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open,
postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount,
IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount





FROM vb_thread AS thread



LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)



WHERE thread.threadid IN
(0,14947,116546,139360,14901,138141,104331,130312,135082,14963,130815,129718,129632,128528 ,18878,128272,128005,113170,102149,41294,120257)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Table './dbname/vb_post' is marked as crashed and last
(automatic?) repair failed
Error Number : 144
Request Date : Wednesday, December 28th 2011 @ 08:20:23 AM
Error Date : Wednesday, December 28th 2011 @ 08:20:23 AM
Script : http://www.volvoforums.org.uk/forumdisplay.php?f=59
Referrer :
IP Address : 83.145.232.94
Username : Unregistered
Classname : vB_Database
MySQL Version :

This is an odd one involving cron

Invalid SQL:

DELETE FROM vb_posthash
WHERE dateline < 1325035427;

MySQL Error : Incorrect key file for table './dbname/vb_posthash.MYI'; try to repair it
Error Number : 126
Request Date : Wednesday, December 28th 2011 @ 01:28:47 AM
Error Date : Wednesday, December 28th 2011 @ 01:28:48 AM
Script : http://www.volvoforums.org.uk/cron.php?rand=1325035723
Referrer : http://www.volvoforums.org.uk/index.php
IP Address : 2.223.13.245
Username : Unregistered
Classname : vB_Database
MySQL Version :

Our db that is almost 1Gb is now 300Mb. Yes, we have backups, but no point restoring and opening the forum if we don't know what happened. Any help will be appreciated.Bob

[Wayne Luke]

You need to repair your tables as the error messages state..

Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin Control Panel -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP, then you can use phpMyAdmin to repair tables.

If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=44909

You may have to ask your host to try and repair this for you.


Appears your server may have cycled its power while files were opened and locked causing these issues.

[Bob Isaac]

Thanks for the quick reply Wayne, greatly appreciated. Repair of vb_post by any means does not work, it just hangs and then falls over. I think a restore from a backup is the best way forward. Interesting comment about the server power cycle, I will pass that to the host.

Bob

[Paul M]

If you know what you are doing, you can try manually dropping the vb_post indexes, and then [manually] re-creating them.