Constant DB errors

[Blairwarlock]

About 3 weeks ago, the POST table went corrupt with:

mysql error: Got error 127 from table handler
mysql error number: 1030

The specific errors vary. I repaired the table via mysqlcheck. Since then, every day, the same error occurs and the same table goes corrupt at least once a day. I've been repairing it daily, but it keeps corrupting. I shut down the DB yesterday and ran myisamchk on the index files of the post.myi but just a few minutes ago the errors began. Most of the time, the errors go away on their own, however, other times, users are no longer able to post and get DB errors diplayed. A few times, the postindex table corrupted as well. As far as I know, NOTHING changed to the system when the errors starting happening. I've been running vB 3.0.7 w/ mySQL 4.0.16 for some time now without a hiccup and now this. It's a dedicated Windows server and I have full control of it. The DB is maybe 700mb.

Can anyone assist with what may be happening here? I read about the bug in mySQL 4.0.12, but that's not the version I'm running and as I mentioned, I've been running 4.0.16 for a VERY long time without issues. TIA!!

[Zachery]

You should really upgrade, or get your host to upgrade to 4.0.24. I think the DB corrupution stops after 4.0.17

What are the rest of the errors? IT really helps if we know them all.

[George L]

yes upgrade to MySQL 4.0.24 and read this thread http://www.vbulletin.com/forum/showthread.php?t=69803 to see how to handle such corruption

[Blairwarlock]

Ok, I can certainly upgrade. I guess I just don't understand why things were working so well for so long w/o any issues. I suppose this is as good a time to upgrade as any. Thanks guys!

[Blairwarlock]

What are the rest of the errors? IT really helps if we know them all.

Well, all the errors are 127/1030, but the descriptions vary as such, for example:

Invalid SQL:
SELECT post.*,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON (editlog.postid = post.postid)
WHERE post.postid = 1020018

mysql error: Got error 127 from table handler

mysql error number: 1030

------------------------------------

Invalid SQL:
SELECT postid FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
WHERE threadid = 15265 AND visible = 1 AND deletionlog.primaryid IS NULL
ORDER BY dateline
LIMIT 0, 10

mysql error: Got error 127 from table handler

mysql error number: 1030

------------------------------------

Invalid SQL:
SELECT filename, attachment.postid, attachment.userid, attachmentid,
attachment.dateline, SUBSTRING(filedata, 1, 2097152) AS filedata, filesize,
attachment.visible, mimetype, NOT ISNULL(deletionlog.primaryid) AS isdeleted,
thread.forumid, forum.password, thread.threadid
FROM attachment AS attachment
LEFT JOIN attachmenttype AS attachmenttype ON(attachmenttype.extension = SUBSTRING_INDEX(attachment.filename, '.', -1))
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
WHERE attachmentid = 44206

mysql error: Got error 127 from table handler

mysql error number: 1030

------------------------------------

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


FROM thread AS thread


LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN (0,106909,106749,106281,104268,105935,106835,106770,106758,105958,106630,79968,96969,10645 4,43303,106525,106112,105770,106339,106422,106293,106117,105979,105933,106016,105950,10593 2,105704,105730,105347,105769,105539,105446,105714,104199,105464,104574,105583,105159,1054 34,104010)
ORDER BY sticky DESC, lastpost DESC

mysql error: Got error 127 from table handler

mysql error number: 1030

------------------------------------

Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid,
thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
thread.pollid, thread.open, thread.lastpost AS postdateline,
thread.lastpost, thread.lastposter, thread.attach, thread.postusername, thread.forumid,
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
FROM thread AS thread
LEFT JOIN user AS user ON(user.userid = thread.postuserid)
LEFT JOIN subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 20671)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN
(106936, 106840, 106916, 106927, 104427, 106933, 105744, 106762, 100359, 105887, 106935, 106934, 106648, 106798, 106746, 106924, 106663, 106932, 106913, 106570, 106847, 105105, 106901, 106832, 106931)
mysql error: Got error 127 from table handler

mysql error number: 1030

------------------------------------

Any further thoughts or should I just upgrade? Thanks again.

[Zachery]

mysql error: Got error 127 from table handler thats the only importat one

[Blairwarlock]

mysql error: Got error 127 from table handler thats the only importat one

I was just trying to be helpful

Ok, I will go ahead and upgrade. I'm running php 4.3.4. Any issues with that version of php and mySQL 4.0.24?

[Zachery]

You very urgently need to upgrade php as well, there are several large security issues with 4.3.4.

Best off with 4.3.11(php) and 4.0.24(mysql)

[Blairwarlock]

You very urgently need to upgrade php as well, there are several large security issues with 4.3.4.

Best off with 4.3.11(php) and 4.0.24(mysql)

Man, you're just trying to create more work for me aren't you??

Ok, I will upgrade php as well. Thanks!

[Zachery]

Well you don't want anyone gaining system access do you?

[Blairwarlock]

Well you don't want anyone gaining system access do you?

Didn't you read above that I'm running a Windows server? I don't think the door can be opened any wider We are moving to Linux very shortly to also help mitigate performance issues.

[Zachery]

Theres nothing wrong with windows, it makes an exelent server platform

[Blairwarlock]

Theres nothing wrong with windows, it makes an exelent server platform

Dear Zachery Gates-

Someone at Jelsoft must be serving some REALLY good Kool-Aid!

[Blairwarlock]

Ok, updated both php and mySQL as recommended. Upgrade went smooth as usual. If we can make it 48hrs w/o a hiccup then we've solved the corruption issue. Will keep you posted. Thanks again!

[Blairwarlock]

Well, everything was ok until I started getting tons of Link-ID == false, connect failed errors. Are there any issues with php 4.3.11 or mySQL 4.0.24 that would cause this? I've NEVER had this error before after the forums were running. I increased max_connections from 400 to 650. Are there any variables I need to be concerned with changing with this upgrade??