I started getting hundreds of database errors such as the below last week on a certain day.
My email servers and the cpanel itself shut down.
My host looked into it, and responded as follows:
"
I understand you have contacted us regarding the VPS ***.com which was full on inodes.
I found that there were over 600,000 files in /tmp, which caused the server to reach the 1,000,000 file limit. I have gone ahead and removed most of the files to allow services to come back online.
Please check your website softwares to determine which website is generating /tmp/vbvurl* files to address the issue that filled up the VPS.
"
Question: Why would so many of these empty temp files be created by vbulletin forums? (They started with the two letters VB so I knew they were yours.) If so, why is/did this happen and how may I stop this from happening in the future?
Also my host added as follows:
“
The majority of the files were created within the past week.
The normal files/folders expected in /tmp are directory .ICE-unix and symlink mysql.sock. It seems the fm*.txt are related to FormMail and vbvurl* files are related to vBulletin. Keep in mind, I am referring to the server's main /tmp and not the user's /home/*****/tmp directory (The contents of /home/*****/tmp are as expected, with nothing I do not expect to see).
“
---
Database error in vBulletin 5.4.5:
Invalid SQL:
(
SELECT
a.filedataid,
n.nodeid, n.parentid, n.contenttypeid,
a.visible, a.counter, a.posthash, a.filename, a.reportthreadid, a.settings,
NULL AS height, NULL AS width, NULL AS style,
a.caption,
n.displayorder
FROM node AS n
JOIN attach AS a ON (a.nodeid = n.nodeid)
WHERE n.contenttypeid = 24 AND n.parentid IN (279)
)
UNION ALL
(
SELECT
p.filedataid,
n.nodeid, n.parentid, n.contenttypeid,
NULL AS visible, NULL AS counter, NULL AS posthash, NULL AS filename, NULL AS reportthreadid, NULL AS settings,
p.height, p.width, p.style,
p.caption,
n.displayorder
FROM node AS n
JOIN photo AS p ON (p.nodeid = n.nodeid)
WHERE n.contenttypeid = 23 AND n.parentid IN (279)
)
ORDER BY displayorder
/**fetchNodeAttachments**/;
MySQL Error : Can't create/write to file '/tmp/#sql_1449_0.MYI' (Errcode: 122 - Internal (unspecified) error in handler)
Error Number : 1
Request Date : Friday, December 21st 2018 @ 12:37:33 PM
Error Date : Friday, December 21st 2018 @ 12:37:33 PM
Script : https://www.******.com/forums/forum/***/***/page2
Referrer :
IP Address : 23.94.XX.XX
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1203
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 572
#3 vB_Database->query_read() called in [path]/vb/db/result.php on line 126
#4 vB_dB_Result->rewind() called in [path]/vb/db/result.php on line 63
#5 vB_dB_Result->__construct() called in [path]/vb/db/query/stored.php on line 104
#6 vB_dB_Query_Stored->execSQL() called in [path]/vb/db/assertor.php on line 301
#7 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 650
#8 vB_dB_Assertor->getRows() called in [path]/vb/library/node.php on line 1780
#9 vB_Library_Node->fetchNodeAttachments() called in [path]/vb/library/node.php on line 1945
#10 vB_Library_Node->addFullContentInfo() called in [path]/vb/library/node.php on line 1418
#11 vB_Library_Node->getFullContentforNodes() called in [path]/vb/api/search.php on line 403
#12 vB_Api_Search->getMoreResults() called in [path]/vb/api/search.php on line 230
#13 vB_Api_Search->getInitialResults() called in [path]/vb/api/wrapper.php on line 199
#14 vB_Api_Wrapper->__call() called in /home/*****/public_html/forums/includes/api/interface/collapsed.php on line 101
#15 Api_Interface_Collapsed->callApi() called in /home/*****/public_html/forums/includes/vb5/template/runtime.php on line 989
#16 vB5_Template_Runtime:arseDataWithErrors() called in /home/*****/public_html/forums/includes/vb5/template.php(369) : eval()'d code on line 824
#17 eval() called in /home/*****/public_html/forums/includes/vb5/template.php on line 369
#18 vB5_Template->render() called in /home/*****/public_html/forums/includes/vb5/template/cache.php on line 134
#19 vB5_Template_Cache->replacePlaceholders() called in /home/*****/public_html/forums/includes/vb5/template.php on line 391
#20 vB5_Template->render() called in /home/*****/public_html/forums/includes/vb5/template/cache.php on line 134
#21 vB5_Template_Cache->replacePlaceholders() called in /home/*****/public_html/forums/includes/vb5/template.php on line 391
#22 vB5_Template->render() called in /home/*****/public_html/forums/includes/vb5/template/cache.php on line 134
#23 vB5_Template_Cache->replacePlaceholders() called in /home/*****/public_html/forums/includes/vb5/template.php on line 391
#24 vB5_Template->render() called in /home/*****/public_html/forums/includes/vb5/template/cache.php on line 134
#25 vB5_Template_Cache->replacePlaceholders() called in /home/*****/public_html/forums/includes/vb5/template.php on line 391
#26 vB5_Template->render() called in /home/*****/public_html/forums/includes/vb5/frontend/controller/page.php on line 259
#27 vB5_Frontend_Controller_Page->index() called in /home/*****/public_html/forums/index.php on line 74
My email servers and the cpanel itself shut down.
My host looked into it, and responded as follows:
"
I understand you have contacted us regarding the VPS ***.com which was full on inodes.
I found that there were over 600,000 files in /tmp, which caused the server to reach the 1,000,000 file limit. I have gone ahead and removed most of the files to allow services to come back online.
Please check your website softwares to determine which website is generating /tmp/vbvurl* files to address the issue that filled up the VPS.
"
Question: Why would so many of these empty temp files be created by vbulletin forums? (They started with the two letters VB so I knew they were yours.) If so, why is/did this happen and how may I stop this from happening in the future?
Also my host added as follows:
“
The majority of the files were created within the past week.
The normal files/folders expected in /tmp are directory .ICE-unix and symlink mysql.sock. It seems the fm*.txt are related to FormMail and vbvurl* files are related to vBulletin. Keep in mind, I am referring to the server's main /tmp and not the user's /home/*****/tmp directory (The contents of /home/*****/tmp are as expected, with nothing I do not expect to see).
“
---
Database error in vBulletin 5.4.5:
Invalid SQL:
(
SELECT
a.filedataid,
n.nodeid, n.parentid, n.contenttypeid,
a.visible, a.counter, a.posthash, a.filename, a.reportthreadid, a.settings,
NULL AS height, NULL AS width, NULL AS style,
a.caption,
n.displayorder
FROM node AS n
JOIN attach AS a ON (a.nodeid = n.nodeid)
WHERE n.contenttypeid = 24 AND n.parentid IN (279)
)
UNION ALL
(
SELECT
p.filedataid,
n.nodeid, n.parentid, n.contenttypeid,
NULL AS visible, NULL AS counter, NULL AS posthash, NULL AS filename, NULL AS reportthreadid, NULL AS settings,
p.height, p.width, p.style,
p.caption,
n.displayorder
FROM node AS n
JOIN photo AS p ON (p.nodeid = n.nodeid)
WHERE n.contenttypeid = 23 AND n.parentid IN (279)
)
ORDER BY displayorder
/**fetchNodeAttachments**/;
MySQL Error : Can't create/write to file '/tmp/#sql_1449_0.MYI' (Errcode: 122 - Internal (unspecified) error in handler)
Error Number : 1
Request Date : Friday, December 21st 2018 @ 12:37:33 PM
Error Date : Friday, December 21st 2018 @ 12:37:33 PM
Script : https://www.******.com/forums/forum/***/***/page2
Referrer :
IP Address : 23.94.XX.XX
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1203
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 572
#3 vB_Database->query_read() called in [path]/vb/db/result.php on line 126
#4 vB_dB_Result->rewind() called in [path]/vb/db/result.php on line 63
#5 vB_dB_Result->__construct() called in [path]/vb/db/query/stored.php on line 104
#6 vB_dB_Query_Stored->execSQL() called in [path]/vb/db/assertor.php on line 301
#7 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 650
#8 vB_dB_Assertor->getRows() called in [path]/vb/library/node.php on line 1780
#9 vB_Library_Node->fetchNodeAttachments() called in [path]/vb/library/node.php on line 1945
#10 vB_Library_Node->addFullContentInfo() called in [path]/vb/library/node.php on line 1418
#11 vB_Library_Node->getFullContentforNodes() called in [path]/vb/api/search.php on line 403
#12 vB_Api_Search->getMoreResults() called in [path]/vb/api/search.php on line 230
#13 vB_Api_Search->getInitialResults() called in [path]/vb/api/wrapper.php on line 199
#14 vB_Api_Wrapper->__call() called in /home/*****/public_html/forums/includes/api/interface/collapsed.php on line 101
#15 Api_Interface_Collapsed->callApi() called in /home/*****/public_html/forums/includes/vb5/template/runtime.php on line 989
#16 vB5_Template_Runtime:arseDataWithErrors() called in /home/*****/public_html/forums/includes/vb5/template.php(369) : eval()'d code on line 824
#17 eval() called in /home/*****/public_html/forums/includes/vb5/template.php on line 369
#18 vB5_Template->render() called in /home/*****/public_html/forums/includes/vb5/template/cache.php on line 134
#19 vB5_Template_Cache->replacePlaceholders() called in /home/*****/public_html/forums/includes/vb5/template.php on line 391
#20 vB5_Template->render() called in /home/*****/public_html/forums/includes/vb5/template/cache.php on line 134
#21 vB5_Template_Cache->replacePlaceholders() called in /home/*****/public_html/forums/includes/vb5/template.php on line 391
#22 vB5_Template->render() called in /home/*****/public_html/forums/includes/vb5/template/cache.php on line 134
#23 vB5_Template_Cache->replacePlaceholders() called in /home/*****/public_html/forums/includes/vb5/template.php on line 391
#24 vB5_Template->render() called in /home/*****/public_html/forums/includes/vb5/template/cache.php on line 134
#25 vB5_Template_Cache->replacePlaceholders() called in /home/*****/public_html/forums/includes/vb5/template.php on line 391
#26 vB5_Template->render() called in /home/*****/public_html/forums/includes/vb5/frontend/controller/page.php on line 259
#27 vB5_Frontend_Controller_Page->index() called in /home/*****/public_html/forums/index.php on line 74
Comment