Very big problem with board

[tbkraus]

Our Vbulletin forum was running quite well with a couple hundred thousand posts on it, and over 4000 members. Today I wake up to find my mailbox is filled with thousands of error message emails. When people visit the forum, or I try to go to the admin page this comes up:

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience

The error emails all say something like this:

Database error in vBulletin: Invalid SQL: SELECT sessionhash,userid,host,useragent,styleid
FROM session WHERE userid=0 AND host='204.169.172.129' AND useragent='Mozilla/4.0
(compatible; MSIE 5.5; Windows 98)'
mysql error: Can't open file: 'session.MYD'. (errno: 145)
mysql error number: 1016
Date: Thursday 03rd of May 2001 09:53:11 AM
Script: /
Referer: http://www.cloudchaser.com/cc/sega/

Since I cant get to the admin page I have no idea how to go about fixing this problem or if it is fixable at all. I'm just wondering why it happened, and how it can be corrected. The forum is at forums.cloudchaser.com.

Thanks,

Adam Kraus

[Mike Sullivan]

Error 145 happens when MySQL marks the table as crashed, and needs to be repaired (through myisamchk).

Alternatively, you could drop and recreate it with the schema found in install1.php.

[tbkraus]

Thanks Ed-

Could you or someone else explain in a more thorough manner what you said requires? Is following the schema in install1.php just reinstalling the forum using that particular install? If that is all it takes Ill try it right now, if it doesnt work how do i run myisamchk?

Thanks,

Adam Kraus

[Mike Sullivan]

Run these queries (if you can):

DROP TABLE session;
CREATE TABLE session (
sessionhash char(32) NOT NULL,
userid int(10) unsigned DEFAULT '0' NOT NULL,
host char(50) NOT NULL,
useragent char(50) NOT NULL,
lastactivity int(10) unsigned DEFAULT '0' NOT NULL,
styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (sessionhash)
);

If you have MySQL 3.23, then run this query:
ALTER TABLE session TYPE=HEAP;

If you can't run those queries, you'll have to use myisamchk. How to use this tool has been posted many times.

[tbkraus]

Im just curious since I have to do this anyway but, would upgrading to the newest version of the forum script correct the error?

Thanks,

Adam Kraus

[Mike Sullivan]

Possibly. Doubt it though.

[tbkraus]

I did the queries you suggested, and that solved the problem - but after working for a few hours the forum screwed up with the same problem. What could be causing this?

Thanks,

Adam Kraus

[etones]

the mysql db is getting thrased basically :)

how many users do u have on your site at any time?

[John]

I would also suggest that the members area would be a good place to stop off.

You are running the ALPHA version, which was only distributed to a very limited set of people - and I do not think that you were one of them!

Try upgrading to RC2, as there have been significant changes in the code for performance issues since the alpha release. Check back here with a report AFTER upgrading to RC2.

John

[chrispadfield]

sure wastn't ever in the alpha section. A quater of a million post forum, that is scary.

[Philipp]

He is running Beta 3 :). Originally there was a typo in the footer template of the first beta (Alpha instead $ versionnumber).

[tbkraus]

After getting the site up and running again for a second time it seems that the Gaming Noise section of our forum is the only section that does not work. It gives the following error message when attempting to go into it:

Warning: MySQL: Unable to save result set in /home/jbenjami/cloudchaser/htdocs/forums/admin/db_mysql.php on line 93

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

HERE is the email error I receive in my mailbox:

Database error in vBulletin: Invalid SQL: SELECT COUNT(*) AS threads FROM thread
WHERE thread.forumid='11' AND thread.visible=1 AND (sticky = 1 or lastpost >= 987731137)
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Friday 04th of May 2001 08:45:37 PM
Script: /forumdisplay.php?forumid=11
Referer: http://forums.cloudchaser.com/

If anyone has any ideas on how to fix this it would be great, as I wouldn't have to worry about cleaning out a couple hundred error messages every night along with the hundreds of complaints I'm getting for it not working.

Thanks,

Adam Kraus



P.S. Chris p, yeah quarter of a million is a lot, but we would of had double that if we didn't clean it out couple months back.

[eva2000]

mysql error: Got error 127 from table handler this means you have a corrupted thread table in your forum database,

you'll have to run a repair on it

details at

- http://i4net.tv/marticle/get.php?action=getarticle&articleid=7

- http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Check

[tbkraus]

I'm trying to run myisamchk, but it keeps givng me, "error: 20 when opening MyISAM-table" /usr/bin/mysql/forums/*.MYI" this is the directory where the forums are kept so I am confused. what exactly is error twenty, and what do I do to not get it anymore?

Thanks,

Adam Kraus

[eva2000]

did you shut down mysql before running this ?

in my example

/usr/bin/myisamchk /usr/mysql/forum/*.MYI


is myisamchk located at /usr/bin/myisamchk on your server ?

[bira]

run myisamchk -rf

[tbkraus]

yes for both. my mysql is in usr/bin/mysql though, but I made the change in the command

[tbkraus]

bira,

that produces the same error (20).

[eva2000]

Originally posted by tbkraus
bira,

that produces the same error (20). i think error 20 means not a directory - what ever that means