What the hell is going on?

[vB3Dev.Com]

Database error in vBulletin 3.0.0 Beta 5:

Invalid SQL:
INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline,
iconid, visible, attach, similar)
VALUES
('A New World Order', 1062444737, 5,
1, 0, 'Max', 1,
'Max', 1062444737, 0, 1,
0, '')

mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Monday 01st of September 2003 03:32:17 PM
Script: http://politicsforum.com/newthread.php
Referer: http://politicsforum.com/newthread.php?do=newthread&f=5
Username: Max
IP Address: 172.153.96.220


Please explain why this is happening?

[Scott MacVicar]

127 means the table has crashed.

Did mysql get restarted at all recently?

REPAIR TABLE thread;

will fix this. Though it may be one of the MyISAM bugs in 4.0.14 and below thats going to be fixed in 4.0.15.

[vB3Dev.Com]

Ah, yes I did fix it but it happens all the freakin time, BUT why is it that only my vB database gets corrupted? My SocketMail database is used heavily as well and never gets corrupted and it has 82 tables...?

[Scott MacVicar]

its not to do with table size or amount but the frequent use of indexes.

The thread table has alot of indexes for increased performance, these are the only tables affected.

[vB3Dev.Com]

Ah, that makes sense. Ok, any idea when the new MySQL version will be out?

[Scott MacVicar]

4.0.15 is no longer being updated and a status page for 4.0.16 has been created, so I shall presume there testing it at the moment.

[cirisme]

4.0.15 is no longer being updated and a status page for 4.0.16 has been created, so I shall presume there testing it at the moment.
I sure hope so, I need the upgrade badly.