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:

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

[Message index]

		interpret consistency check error By: WilliamBurns on Fri, 11 February 2005 18:55
		Re: interpret consistency check error By: Ilia on Fri, 11 February 2005 20:34
		Re: interpret consistency check error By: WilliamBurns on Fri, 11 February 2005 23:11
		Re: interpret consistency check error By: Ilia on Sat, 12 February 2005 20:27
		Re: interpret consistency check error By: WilliamBurns on Mon, 14 February 2005 22:31
		Re: interpret consistency check error By: Ilia on Mon, 14 February 2005 23:31
		Re: interpret consistency check error By: WilliamBurns on Tue, 15 February 2005 00:20
		Re: interpret consistency check error By: Ilia on Tue, 15 February 2005 15:02
		Re: interpret consistency check error By: WilliamBurns on Wed, 16 February 2005 00:38
		Re: interpret consistency check error By: Ilia on Wed, 16 February 2005 03:26

Previous Topic:	newbie zlib question
Next Topic:	Messages

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 02:19:16 GMT 2024

Total time taken to generate the page: 0.19725 seconds