XF 1.1 Error writing file '/tmp/MY8TEnzY' (Errcode: 28)

xmlxp

Active member
Hi all

again i am getting lot of this errors about the /tmp and Errcode: 28 and causing spikes of high load on my machine.

I already increased the size of temp directory from 1GB to 2GB and still this issue dont want to go a way

Code:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Error writing file '/tmp/MYWJgkyk' (Errcode: 28) - library/Zend/Db/Statement/Mysqli.php:214
 
Stack Trace
#0 /home/vbcom/public_html/community/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/vbcom/public_html/community/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/vbcom/public_html/community/library/XenForo/Model.php(218): Zend_Db_Adapter_Abstract->query('?????SELECT thr...', Array, 2)
#3 /home/vbcom/public_html/community/library/XenForo/Model/Thread.php(371): XenForo_Model->fetchAllKeyed('?????SELECT thr...', 'thread_id')
#4 /home/vbcom/public_html/community/library/XenForo/Model/Thread.php(426): XenForo_Model_Thread->getThreads(Array, Array)
#5 /home/vbcom/public_html/community/library/XenForo/ControllerPublic/Forum.php(87): XenForo_Model_Thread->getThreadsInForum(6, Array, Array)
#6 /home/vbcom/public_html/community/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_Forum->actionIndex()
#7 /home/vbcom/public_html/community/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /home/vbcom/public_html/community/index.php(13): XenForo_FrontController->run()
#9 {main}

 
Request State
 
array(3) {
  ["url"] => string(72) "http://www.mywebsite.com/community/forums/6/page-1127?order=view_count"
  ["_GET"] => array(1) {
    ["order"] => string(10) "view_count"
I run xenforo 1.1.1
OS redhat 5.9 ( 32 bits )
dual processor
4GB ram
cpanel with mysql 5.1.66 & php 5.3.21 and (MyISAM tables )
xcache2.1
online users bitween 250 t0 450

I realy need to solve this problem
 

Mike Edge

Well-known member
Is that not awful advice? If he can't cd to /tmp for whatever reason will it not rm -rf * his login directory?

yeah true, though I don't recall anyone ever getting denied accessing tmp as root..

Ok, first do.....

cd /tmp

then run this line once you confirmed your in /tmp.. service httpd stop;service mysql stop;rm -rf *;service mysql start;service httpd start;
 

xmlxp

Active member
Hi Borgan

there is enough space i just need to know what size of tmp files exactly is causing this problem so can determine what size i should set my temp folder to
disk.png

SSH in as root.. run this.. service httpd stop;service mysql stop;cd /tmp;rm -rf *;service mysql start;service httpd start;
Hi Mike
even if i empty the /tmp now it will be filled again at any time soon and get the same issue
 

RobParker

Well-known member
yeah true, though I don't recall anyone ever getting denied accessing tmp as root..

Ok, first do.....

cd /tmp

then run this line once you confirmed your in /tmp.. service httpd stop;service mysql stop;rm -rf *;service mysql start;service httpd start;
Yeah but he could typo your command and try to cd into /tnp or something. Just thought it was better to be safe like you've changed it to above :)
 

Mike Edge

Well-known member
This is likely MySQL temp tables being written.

The best thing to do is create a directory like
mkdir /home/mysqltmp
chown mysql:mysql /home/mysqltmp
Then put the following in /etc/my.cnf under [mysqld]
tmpdir=/home/mysqltmp
and restart MySQL.

When you run
mysqladmin variables|grep tmpdir

you should now see this

# mysqladmin variables|grep tmpdir
| tmpdir | /home/mysqltmp |
#
 

Mike Edge

Well-known member
after I move the MySQL tmp to /home/mysqltmp do i still need /tmp size to stay 2GB or I can reduce it back to 1GB like before? Because I am recieving DISKWAR emails that /dev/sda3 is 83%

Before decreasing it, I'd assure it was MySQL causing it.

Run this again..

cd /tmp

then run this line once you confirmed your in /tmp.. service httpd stop;service mysql stop;rm -rf *;service mysql start;service httpd start;

Then wait a day and see how much space you use and then make it double of that size.
 

xmlxp

Active member
This is likely MySQL temp tables being written.

The best thing to do is create a directory like
mkdir /home/mysqltmp
chown mysql:mysql /home/mysqltmp
Then put the following in /etc/my.cnf under [mysqld]
tmpdir=/home/mysqltmp
and restart MySQL.

When you run
mysqladmin variables|grep tmpdir

you should now see this

# mysqladmin variables|grep tmpdir
| tmpdir | /home/mysqltmp |
#
Thank you very much for your advise. since that date I never had this problem
 
Top