FUDforum: How To » interpret consistency check error

Home » FUDforum » How To » interpret consistency check error

Show: Today's Messages :: Polls :: Message Navigator

interpret consistency check error [message #22714]

Fri, 11 February 2005 18:55

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma: 0

Senior Member

I seem to have run into a wall in terms of server capacity to run mysql. My site seems to hang up, and the techs tell me it is because mysql is hogging capacity and power. So....
I got in as administrator and "compacted the messages" in case that would help. Then I ran the consistency check, and I received the following response (and it left my browser in a weird state, unable to scroll upward on the page. The following is from the page source):
...
Checking threads against messages 
(/usr/local/forumdata/include/theme/default/db.inc:118 
/usr/local/etc/httpd/htdocs/wforum/adm/consist.php:192 
) 1: Can't create/write to file '/var/tmp/#sql15c90_1a7b9_0.MYD' (Errcode: 24) 
Query: SELECT m.thread_id, t.id, count(*) as cnt FROM fud261_thread t LEFT JOIN fud261_msg m ON t.id=m.thread_id WHERE m.apr=1 GROUP BY m.thread_id,t.id ORDER BY cnt 
Server Version: 3.23.58 
[Referring Page] http://www.rpinet.com/wforum/adm/consist.php?rid=2&S=1b444ff7b2bd386a2a 763f9cb96aa2df&SQ=f5de4e491e6960f1ecb005196305fa99 
...
What does it mean, and, more important, what do I do?

Impatient cuss that I am, I went ahead and attempted to repeat the check, this time getting:
Checking threads against messages 
(/usr/local/forumdata/include/theme/default/db.inc:118 
/usr/local/etc/httpd/htdocs/wforum/adm/consist.php:192 
) 1: Can't create/write to file '/var/tmp/#sql15c90_1a7b9_0.MYD' (Errcode: 24) 
Query: SELECT m.thread_id, t.id, count(*) as cnt FROM fud261_thread t LEFT JOIN fud261_msg m ON t.id=m.thread_id WHERE m.apr=1 GROUP BY m.thread_id,t.id ORDER BY cnt 
Server Version: 3.23.58 
[Referring Page] http://www.rpinet.com/wforum/adm/consist.php?rid=2&S=1b444ff7b2bd386a2a 763f9cb96aa2df&SQ=f5de4e491e6960f1ecb005196305fa99 

Again, what does it mean, and, more important, what do I do?

[Updated on: Fri, 11 February 2005 19:17]

Report message to a moderator

Re: interpret consistency check error [message #22717 is a reply to message #22714]

Fri, 11 February 2005 20:34

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

What you are seeing is an SQL error, that occured because temporary table could not be created or the place holder for temporary tables run out of space.

FUDforum Core Developer

Report message to a moderator

Re: interpret consistency check error [message #22718 is a reply to message #22717]

Fri, 11 February 2005 23:11

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma: 0

Senior Member

OK, I get that it was an SQL error, but what steps can I take to correct the system? The current symptom (on both MS ie 6, and Netscape 7.1 is that a blank page appears rather than the forum home page). Have I lost it all?

Report message to a moderator

Re: interpret consistency check error [message #22727 is a reply to message #22718]

Sat, 12 February 2005 20:27

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You need to get the consistency checker to run to completion. Forum creates all sorts of caches, absense of those can result in the problems you are experiencing. Also make sure that your forum's SQL tables are not corrupt, if they REPAIR command can be used to fix them.

FUDforum Core Developer

Report message to a moderator

Re: interpret consistency check error [message #22759 is a reply to message #22727]

Mon, 14 February 2005 22:31

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma: 0

Senior Member

Thank you. The diagnostic message that I get, 127, names a data file fud261_ses. But there is no data file by that name, at least not in the same folder where the other fud261_ files are found. What does that mean?

Also, in that folder, I find a rather large file fud261_index.MYI which appears to be over 15 megs in size. Another file, fud261_forum.MYD has zero bytes. does this mean I have lost all my forum data?

Report message to a moderator

Re: interpret consistency check error [message #22761 is a reply to message #22759]

Mon, 14 February 2005 23:31

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Have you tried repairing the table(s)?

FUDforum Core Developer

Report message to a moderator

Re: interpret consistency check error [message #22764 is a reply to message #22761]

Tue, 15 February 2005 00:20

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma: 0

Senior Member

I don't know enough about Unix/Linux OR mysql to be comfortable (or successful) running the repair. With Mysql-3.23.58 the site host told me to run something called mysqlcheck. However, it is in the bin folder, and the tables seem to be in another folder. When I run it, it complains about an apparently unrelated (to FUDforum) file not being in the right place in yet another folder. Also, there seems to be a database name that those support people said was simply "mysql" -- I am assuming that if I can cracklearn the syntax and run this command on that mysql database, it will attempt to repair all the tables in the database. In a quick look at the mysql website, it too presumes great familiarity with the command environment, and gives no explicit examples.

You didn't answer my question about the fud261_forum.MYD file. Does it mean anything that this file shows 0 bytes of content?

Report message to a moderator

Re: interpret consistency check error [message #22770 is a reply to message #22764]

Tue, 15 February 2005 15:02

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You can repair tables via mysql rather then having to run commands.
For example try and repair the fud261_forum.MYD brokeness, you would run "REPAIR fud261_forum" command.

FUDforum Core Developer

Report message to a moderator

Re: interpret consistency check error [message #22782 is a reply to message #22770]

Wed, 16 February 2005 00:38

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma: 0

Senior Member

And so what does it mean when I go into mysql from the command line and I get this error:
mysql> REPAIR TABLE fud261_forum.MYD EXTENDED USE_FRM;
Error 1044: Access denied for user: '@localhost' to database 'fud261_forum'
mysql> Aborted

Report message to a moderator

Re: interpret consistency check error [message #22784 is a reply to message #22782]

Wed, 16 February 2005 03:26

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Looks like you need to ask your admin to do this for you, since you don't have permissions to repair a table.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	newbie zlib question
Next Topic:	Messages

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 15:37:27 GMT 2024

Total time taken to generate the page: 0.03840 seconds