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

xml · Mar 17, 2013

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

Paul B · Mar 17, 2013

OS Error code 28: No space left on device

http://forums.mysql.com/read.php?21,113364,113442#msg-113442

Mike Edge · Mar 17, 2013

SSH in as root.. run this.. service httpd stop;service mysql stop;cd /tmp;rm -rf *;service mysql start;service httpd start;

RobParker · Mar 17, 2013

Mike Edge said:
SSH in as root.. run this.. service httpd stop;service mysql stop;cd /tmp;rm -rf *;service mysql start;service httpd start;

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

Mike Edge · Mar 17, 2013

RobParker said:
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;

xml · Mar 17, 2013

Brogan said:
OS Error code 28: No space left on device

http://forums.mysql.com/read.php?21,113364,113442#msg-113442

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

Mike Edge said:
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 · Mar 17, 2013

Mike Edge said:
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

Paul B · Mar 17, 2013

What is causing your tmp directory to fill up so quickly?

Mike Edge · Mar 17, 2013

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 |
#

xml · Mar 17, 2013

Brogan said:
What is causing your tmp directory to fill up so quickly?

I just run xenforo 1.1.1 so i expect its the caching files from xcache

xcache.mmap_path="/tmp/xcache"

Mike Edge · Mar 17, 2013

xmlxp said:
I just run xenforo 1.1.1 so i expect its the caching files from xcache

xcache.mmap_path="/tmp/xcache"

online users bitween 250 t0 450... I'm pretty confident it is MySQL temp tables.

xml · Mar 17, 2013

Mike Edge said:
mkdir /home/mysqltmp
chown mysql:mysql /home/mysqltmp

should I also do this? :
chmod 1777 /home/mysqltmp

Mike Edge · Mar 17, 2013

Nope, no need

Digital Doctor · Mar 17, 2013

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

Happens a fair amount.

Is there a way to avoid this MySQL temp tables filling up /tmp

Does this happen with XF more than vB ? Anyone know why that might be ?

Mike Edge · Mar 17, 2013

Digital Doctor said:
Happens a fair amount.

Is there a way to avoid this MySQL temp tables filling up /tmp

Does this happen with XF more than vB ? Anyone know why that might be ?

Yes, storing MySQL tmp in a bigger partation as I explained above how to do.

xml · Mar 17, 2013

Mike Edge said:
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%

Digital Doctor · Mar 17, 2013

Mike Edge said:
Yes, storing MySQL tmp in a bigger partation as I explained above how to do.

Could Xenforo do some sort of periodic cleanup of /tmp ?
Does Xenforo use /tmp more than other similar software ?

Mike Edge · Mar 17, 2013

xmlxp said:
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.

xml · Oct 2, 2016

The Forum Heroes said:
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

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

Active member

XenForo moderator

Well-known member

Well-known member

Well-known member

Active member

Well-known member

XenForo moderator

Well-known member

Active member

Well-known member

Active member

Well-known member

Well-known member

Well-known member

Active member

Well-known member

Well-known member

Active member

Similar threads

We value your privacy