mysql error: Got error 12 from table handler

[marocnl]

...[edited]

[conqsoft]

MySQL Error 1030:

While this error is rare, it can be difficult to track down the actual culprit. Typically, the error is caused by the server not having enough disk space for MySQL to perform the action. Contact your Host or server admin and ask that they make sure there is sufficient space on the server.

[marocnl]

MySQL Error 1030:

While this error is rare, it can be difficult to track down the actual culprit. Typically, the error is caused by the server not having enough disk space for MySQL to perform the action. Contact your Host or server admin and ask that they make sure there is sufficient space on the server.


Well, the server is mine. There is plenty of space available voor de db's.

[Steve Machol]

Error code 12: Cannot allocate memory

This is a server memory error. Have you tried rebooting the server?

[oztrack]

I just got this error. I am having trouble with my host provider with this error coming again and again.

Database error in vBulletin 3.5.0:
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 > 1129638592
ORDER BY invisible ASC, username ASC;
MySQL Error : Got error 12 from table handler
Error Number : 1030

What is it??

[marocnl]

I just got this error. I am having trouble with my host provider with this error coming again and again.

Database error in vBulletin 3.5.0:
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 > 1129638592
ORDER BY invisible ASC, username ASC;
MySQL Error : Got error 12 from table handler
Error Number : 1030

What is it??


I don't really remember what the cause of this was. Does mysqld run up to 99% and jamms up? If so, try tracking the query that takes all of the resources. I recently solved that prob by checking out slow queries of mysl. In /etc/my.cnf add the
log-slow-queries=/var/log/mysql-slow.log
set-variable = long_query_time=10
log-long-format # this will log selects not using indexes


Please checkout mysql.com before you use the variables, i am not quite sure i spelled them right. :)