Database corruption

[Zachariah B]

I have read http://www.vbulletin.com/forum/showthread.php?threadid=69803 .

I ran the repair.php it fixed the problem. (2 times in 2 weeks) .. This is a new host(only time this has happened is on this new host).

I noticed the pathing is wrong Last line in reported error (bottem of post)..... Forums is in the link 2 times should be once. - All pathings are correct in Admin CP. :confused:

Shared Hosting
VB 2.9 (with quick reply and Arcade hack : since 2.9 was out)
Operating System Linux
Perl Version 5.008
Perl Path /usr/bin/perl
PHP Version 4.3.1
Mysql Version 4.0.12
Sendmail Path /usr/sbin/sendmail
Cpanel 5 (something)
( for more info http://www.gzhq.net/php.php )

Email created and sent to me
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT threadid,lastpost
FROM thread
WHERE forumid = 118
AND visible=1
AND sticky=1

mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Tuesday 06th of May 2003 12:19:55 PM
Script: http://www.gzhq.net/forums/forums/forumdisplay.php?s=&forumid=118 (http://www.gzhq.net/forums/forums/forumdisplay.php?s=&forumid=118)
Referer:

[Steve Machol]

The double 'forums' means nothing. It's an artifact of the error process.

[Zachariah B]

Another Error just 2 min ago (given all info to help)

I am reindexing to see if it may help.

Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT

thread.threadid
FROM thread
WHERE thread.forumid = 23
AND thread.sticky=0
AND thread.visible=1
AND lastpost >= 1049665788 AND sticky=0

ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
mysql error: Got error 127 from table handler

mysql error number: 1030

[Steve Machol]

Run repair.php.

[replicon]

Nothing will help, repairing, reindexing, etc. It just gets worse and worse, corrupting on a daily basis eventually, then you'll start to lose threads when that table crashes. I've reverted back to mySQL 3.23 until the problem gets fixed.

Has vB logged a bug with mySQL yet? Or are we supposed to do it ourselves since it's not really a vB issue?

[Steve Machol]

Have you read this at all:

http://www.vbulletin.com/forum/showthread.php?threadid=69803

[Zachariah B]

Well i did another repair .....

here is log of Fix.

http://www.gzhq.net/forums/error.htm

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT COUNT(*) AS threads FROM thread
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

[Steve Machol]

http://www.vbulletin.com/forum/showthread.php?threadid=69803

[replicon]

Yes it's been read, yes I've backed up my corrupted databases, yes I've repaired my corrupted database, yes it will still continue to corrupt the repaired database (mysql 4.0.12) regardless if it's windows or linux, and yes corruption frequency increases as time goes by. I went from a weekly corruption, to daily, to once every few hours before I gave up and downgraded mySQL. All is well now (but I do miss the speed of mysql 4.0.12).

[eva2000]

Yes it's been read, yes I've backed up my corrupted databases, yes I've repaired my corrupted database, yes it will still continue to corrupt the repaired database (mysql 4.0.12) regardless if it's windows or linux, and yes corruption frequency increases as time goes by. I went from a weekly corruption, to daily, to once every few hours before I gave up and downgraded mySQL. All is well now (but I do miss the speed of mysql 4.0.12).
you've tried mysqldumping to sql file a backup and then creating new database and importing sql file into this and edit config.php to point to the new database ?

it's worked on every vB client's server i handled so far - recurring corruption has stopped

[ridemonkey]

you've tried mysqldumping to sql file a backup and then creating new database and importing sql file into this and edit config.php to point to the new database ?

it's worked on every vB client's server i handled so far - recurring corruption has stopped

1. Why was the thread about this issue closed? This is a very important issue that warrants continued discussion.

2. My problems were in several applications, not just vBulletin. This is a Mysql 4 problem, not a vBulletin problem.

3. After downgrading to 3.x - I have had no more crashes.

Are there any ongoing discussions of this matter?

[Steve Machol]

Did you see this in that post?

Click here to start a new thread in MySQL forum for this issue (http://www.vbulletin.com/forum/newthread.php?do=newthread&forumid=18)

[replicon]

you've tried mysqldumping to sql file a backup and then creating new database and importing sql file into this and edit config.php to point to the new database?Yes I have. It did reduce recurring corruption at first, but it's back after a few days. On windows mySQL 4.0.12 there's no difference at all.

If only we can figure out the sequence of events that actually causes this corruption, the mySQL guys could fix it.

http://bugs.mysql.com/bug.php?id=197

They can't reproduce the bug, but at least somebody has logged it in there.

[Zachariah B]

Ok we killed the DB and made a new one.
Did a freash install of VB2.3.0

Imported user, forum, posts from the old DB. All is ok :p, anyway for 2 days then crash http://www.gzhq.net/error/ . The repair.php quick fixes every time.

VB3 beta haven this problem ? If not is it too late to play w/ the a public beta ?

Quick reply hack and /me (adds irc /me actions) is the only thing installed that is not from a stock install

2 different e-mail errors.

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT threadid,visible FROM thread WHERE forumid='118' AND postuserid='146' AND title='Pandots 1.6 is out, everyone get it now' AND dateline>1053955449 AND replycount=0
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Monday 26th of May 2003 06:29:09 AM



Database error in vBulletin 2.3.0:

Invalid SQL: SELECT threadid,lastpost
FROM thread
WHERE forumid = 118
AND visible=1
AND sticky=1

mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Monday 26th of May 2003 06:29:13 AM

[Steve Machol]

Duid you follow this advice posted by eva2000:

If you're still on mysql 4.0.12 try using mysqldump to create a sql backup your database - mysqldump guide at http://www.sitepoint.com/article/678

Then create a new empty database name and import the mysql sql backup back into the empty database, and edit config.php to point to the new database

Also take a read of

http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html

and

http://www.vbulletin.com/forum/showthread.php?threadid=69803