mysql error: Got error 28 from storage engine - mysql error number: 1030

[Mephisteus]

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT session.userid, user.username, user.displaygroupid, user.usergroupid, (user.options & 512) AS invisible,userfield.field23
FROM session AS session
LEFT JOIN user AS user USING (userid)
LEFT JOIN usergroup AS usergroup ON(usergroup.usergroupid=user.usergroupid)
LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
WHERE session.lastactivity > 1115705709
ORDER BY usergroup.orderid DESC, user.username ASC

mysql error: Got error 28 from storage engine

mysql error number: 1030

Date: Tuesday 10th of May 2005 08:30:09 AM
Script: showthread.php?goto=lastpost&t=996

This goes for every connection to my board, anyone have any idea whats up with that? Ive been receiving em for almost 6 hours now (started when I was asleep).

[daemon]

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. You need to shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.

[Mephisteus]

During viewing? Then how come I can view it properly from phpmyadmin, and the phpbb2. thingy (that latest beta thing) board isnt having any problems?

[ceska]

I have just started to get this same error, and our server has all of the space in the world.

I have never saw these errors before, they just started happening last night. First I was trying to send a PM, and got the message. Now when I click to go to my PMs, the error comes up and I can't access them at all. So far nothing else I click will produce this error.

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=3 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50

mysql error: Got error -1 from storage engine

mysql error number: 1030

EDIT: I am including proof that the server is fine.

[ceska]

Getting it now in AdminCP.

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder

mysql error: Got error -1 from storage engine

mysql error number: 1030



We have PHP 4.3.11 (cli) (built: Apr 17 2005 23:59:16)
MySQL 4.1.11

[ceska]

I am going to shut down our forum, it is getting worse by the minute. Now new posts aren't recording in New Posts...

Oh .. wait. I can't. Admin CP "vBulletin Options" doesn't work anymore. I will have to slip in an index file.

[Mephisteus]

oddly enough, it seems to have fixed itself (it was working again a few hours after I got home from school). And I am 100% positive the host hasn't been on yet so no clue as to whats going on...

[ceska]

What I just found is that someone upgraded our server last night from MySQL 4 to 4.1. This is the problem! Slowly during the night the errors started surfacing.

My next question would be, does this mean our database is messed up?
The last backup we have is from 1 AM, and should be ok, I guess. The most errors happened in just the past hour, when the PM inbox returned an error, when I learned Admin CP vBulletin Options would not work, and when new posts stopped recording.

I doubt we both have the same problem though (a MySQL upgrade) or that would just be a really strange coincidence.

[Mephisteus]

MySQL version 4.1.11-standard

Dont know when it was upgraded though.

Note to self: bug the host

[Marco van Herwaarden]

@ceska

You would probably get better support/responses if you opened your own thread instead of "hijacking" someone elses thread.

You error message is NOT the same, you are getting an error -1 and not 28.

[Zachery]

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.

[Steve Machol]

The -1 error is most likely database corruption due to the earlier out of space error. If you have fixed the out of space condition, then you should now repair and optimize the database.

[epctechno]

99.99% is because of the /tmp directory is full, so if anyone ever faces this, this is the cause! I just found out that's what our problem was today.

[ECMatt90]

How do I check the /tmp file & how to I empty it?

[epctechno]

Do you have a dedicated that you manage? If so, I would just check the disk usage, and what file(s)/folder(s) may be causing it by using the du command If you need to know more about du go here: http://www.wtfnix.com/2009/01/man-du/

Hope this helps.