Out of resources when opening file '/tmp/#sql_26b7_0.MYI' (Errcode: 24)

Hi everyone,

How are you doing? I am running VBulletin forum on my dedicated server (rent new recently - new set up, my server is: Intel Xeon E3-1270 16GB DDR3, 2 x 3TB HDD), but recently I keep got VBulletin Database error message with:

Code:

 Out of resources when opening file '/tmp/#sql_26b7_0.MYI' (Errcode: 24)

or:

Out of resources when opening file './abcdef_forum/vb_post.MYD' (Errcode: 24)

or: 

MySQL Error  : Out of resources when opening file '/tmp/#sql_26b7_0.MYI' (Errcode: 24)
Error Number  : 23

I have access to my dedicated server, please show me in details step by step how to fix this problem ! Thank you very much in advance!

Regards,
Calvin

==============================================================
Here is some example of the full error:

Code:

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid  ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid,
                        node.layoutid, node.publishdate, node.setpublish, node.issection, parent.permissionsfrom as parentpermissions,
                        node.showrating,
                        node.permissionsfrom, node.publicpreview, node.shownav, node.hidden, node.nosearch , info.description, info.title, info.viewcount, info.creationdate, info.workflowdate,
                    info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid,
                    user.username, sectionorder.displayorder
                   
                   
                FROM vb_cms_node AS node
                INNER JOIN vb_cms_nodeinfo AS info ON info.nodeid = node.nodeid
                LEFT JOIN vb_user AS user ON user.userid = node.userid
                LEFT JOIN vb_cms_sectionorder AS sectionorder ON sectionorder.sectionid = node.parentnode
                AND sectionorder.nodeid = node.nodeid
                LEFT JOIN vb_cms_node AS parent ON parent.nodeid = node.parentnode    
               
                WHERE node.new != 1  AND node.nodeid IN (1,45,5,11,2,3)  AND ( (node.permissionsfrom IN (-1)) OR (node.userid =198306)  OR ( node.permissionsfrom in (1) AND (node.parentnode IN (1) OR node.nodeid = 1) AND
                node.setpublish > 0 AND node.publishdate < 1405971769 ))AND node.new != 1
               
                  ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
                    node.publishdate DESC;

MySQL Error  : Out of resources when opening file '/tmp/#sql_26b7_0.MYI' (Errcode: 24)
Error Number  : 23
Request Date  : Monday, July 21st 2014 @ 07:42:49 PM
Error Date    : Monday, July 21st 2014 @ 07:42:49 PM
Script        : domain.com/forum/content.php?styleid=27
Referrer      : domain.com/index_frame.html
IP Address    : 42.112.xxx.xxx
Username      : username
Classname    : vB_Database
MySQL Version :

 

Hi Vanessa,

Thank you for the link, I follow it but I can't do it, especially the commands:

vi /etc/my.cnf

or

vi /etc/security/limits.conf

It doesn't work !

Regards,
Calvin

 

Hi SS-Maddy,

This is what I get for df -h & df -i , I'm not sure if /tmp is enough ?

===============================

Hi cPanelMichael,

Yes, I log in as root, but somehow the "vi" show the file my.cnf but won't let me edit ? Could you please help me what to do to resolve this ? I don't want to restart MySQL from WHM everytime I got "VBulletin Database error".

Thank you very much !

Sincerely,
Calvin

 

Hello SS-Maddy,

This is what I got for lsattr but I don't know what the result means

@edigest: I use sudo nano and I can edit it

I put in the limits.conf:

and I restart MySQL, but the "open files" still shows (-n) 1024 ? Something is wrong ?

So, I don't know what was wrong here, would you please help? Thank you very much !

Sincerely,
Calvin