• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

xmlxp

Active member
#1
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
#5
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
#6
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
#7
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
#9
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 |
#
 

xmlxp

Active member
#16
Yes, storing MySQL tmp in a bigger partation as I explained above how to do.
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%
 

Mike Edge

Well-known member
#18
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
#19
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