mysql error: Got error 28 from table handler (error number 1030)

[South Fork]

Any ideas?

Database error in vBulletin 3.0.4:
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=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50

mysql error: Got error 28 from table handler
mysql error number: 1030
Date: Monday 01st of August 2005 09:17:11 PM
Script: http://www.sitename.com/board/private.php?

[South Fork]

Resolved.

tmp space filled. had to be cleared and sized up.

[eva2000]

yup error 28 = disk space lacking can occur in mysql data partition or tmp directory that mysql uses

[HeadRat]

What? I'm having this happen to me right now, how do I resolve it? But can you put it in simple terms?

[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 (if you can) 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.

[oztrack]

Here is the message

Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT session.userid, username, usergroupid, (user.options & 512) AS invisible,
IF(displaygroupid = 0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity > 1128427009
ORDER BY invisible ASC, username ASC

mysql error: Got error 12 from table handler
mysql error number: 1030
Date: Tuesday 04th of October 2005 07:11:49 AM
Script: http://www.futuresprinting.com/


Please help. My site has been down for a day now. It has 1500 members.

Steve

[oztrack]

I just noticed that the forums work OK and its only the main index page giving trouble look at http://www.futuresprinting.com/forum/index.php?

Its fine.

But the main home page is a problem

[eva2000]

Here is the message

Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT session.userid, username, usergroupid, (user.options & 512) AS invisible,
IF(displaygroupid = 0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity > 1128427009
ORDER BY invisible ASC, username ASC

mysql error: Got error 12 from table handler
mysql error number: 1030
Date: Tuesday 04th of October 2005 07:11:49 AM
Script: http://www.futuresprinting.com/


Please help. My site has been down for a day now. It has 1500 members.

Steve

different error number yours means

perror 12
System error: 12 = Cannot allocate memory

start a new thread with the following info asked at http://www.vbulletin.com/forum/showthread.php?t=70117

[dragginblazer]

I am getting error # 28 also. How can I clear the tmp file?

[eva2000]

I am getting error # 28 also. How can I clear the tmp file?

most likely the tmp file isn't exactly full after the error only during the the running of the query

your tmp file is usually empty and mysql needs at least 3x times the free space on tmp as the largest sized mysql database table you have

take a read of http://dev.mysql.com/doc/refman/5.0/...ary-files.html

easiest thing to do is set a a tmpdir path for mysql on a partition with more disk space

i.e. in ssh telnet type

df -h

look at your disk usage per partition

usually /home is the one with most free disk space

so

create a new directory at /home/mysqltmp

then in /etc/my.cnf under [mysqld]

add

[mysqld]
tmpdir = /home/mysqltmp


and restart mysql server