mysql error number: 1030 - Got error 28 from table handler

[Rick Grunwald]

I received this error via email this morning. Aquick Gooooogle search says I am either out of space (not) or a table needs repair

It happened while someone on a Bejing server was on the site. I have no registered members from Bejing

Any insight?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT poll.*, threadid, forumid, replycount
FROM thread AS thread
LEFT JOIN poll AS poll ON (thread.pollid = poll.pollid)
WHERE thread.pollid != 0
AND open != 0
AND open != 10
AND visible
AND forumid IN (7,8,10,11)
ORDER BY dateline DESC
LIMIT 1

mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Friday 15th of April 2005 10:22:22 PM
Script: http://grunwalds.com/
Referer:
Username: Unregistered
IP Address: 61.135.145.207

[djnoz]

Well perror tells us that error message indicates you have "no space left on device."

Is this a unix system? If so, you may want to try doing a:

df -h

to see what kind of space is left on each volume. I had this same error a while back when my /tmp dir was filling up. Check for any volume that is more than 60% full.

HIH

[Steve Machol]

Error code 28: No space left on device

One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

[Rick Grunwald]

Thanks - I have forwarded the message to them

[ChrisLM2001]

Make sure your /tmp directory is hardened and secured, as that's a place for exploits...

http://www.usenix.org/events/sec03/tech/full_papers/tsyrklevich/tsyrklevich_html/

Chris

[Rick Grunwald]

I got one error email again this morning with the same error, reffering to the Poll table only from a different page. Bots have set it off in both cases.

The host had a space allocation corruption issue that they were working on. Using Putty and running df shows all areas as far as I can see at 19% or less usage - so it doesn't appear to be a space issue as such

I don't think it is a vbulletin issue that the support team can fix: I am posting so anyone searching can find all pertenent information (but feel free to add to this! )

>>>>>>>>>>>>>>>>>>>>>>>>>
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT poll.*, threadid, forumid, replycount
FROM thread AS thread
LEFT JOIN poll AS poll ON (thread.pollid = poll.pollid)
WHERE thread.pollid != 0
AND open != 0
AND open != 10
AND visible
AND forumid IN (7,8,10,11)
ORDER BY dateline DESC
LIMIT 1

mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Saturday 30th of April 2005 04:54:17 AM
Script: http://grunwalds.com/modules.php?name=News
Referer:
Username: Unregistered
IP Address: 207.46.98.35

[George L]

for now to prevent further corruption i'd close your forums so not more write/reading for mysql database until host resolves the issue

[Steve Machol]

For future reference:

mysql error: Got error 28 from table handler

Means:

System error: 28 = No space left on device

[Rick Grunwald]

I contacted them and /tmp was temporarily full - and was resolved almost immediately according to the tech (and they have been good about admitting errors on their servers etc.)

Steve: thanks for the input - the first time this happened they had another issue that may have cause it to appear to be out of space. THis time it was a space issue.
I posted the second instance mostly for searching by others in the forum. On curiosity - perhaps just coincidental - both instances were triggered by bots and both while reading "polls"