1. 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)

Discussion in 'Troubleshooting and Problems' started by xmlxp, Mar 17, 2013.

  1. xmlxp

    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
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Chris D and Jake Bunce like this.
  3. The Forum Heroes

    The Forum Heroes Well-Known Member

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

    RobParker 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?
     
  5. The Forum Heroes

    The Forum Heroes 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;
     
  6. xmlxp

    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

    Hi Mike
    even if i empty the /tmp now it will be filled again at any time soon and get the same issue
     
  7. RobParker

    RobParker Well-Known Member

    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 :)
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

    What is causing your tmp directory to fill up so quickly?
     
  9. The Forum Heroes

    The Forum Heroes 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 |
    #
     
    Jake Bunce likes this.
  10. xmlxp

    xmlxp Active Member

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

    xcache.mmap_path="/tmp/xcache"
     
  11. The Forum Heroes

    The Forum Heroes Well-Known Member


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

    xmlxp Active Member

    should I also do this? :
    chmod 1777 /home/mysqltmp
     
  13. The Forum Heroes

    The Forum Heroes Well-Known Member

    Nope, no need
     
  14. Digital Doctor

    Digital Doctor Well-Known Member

    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 ?
     
  15. The Forum Heroes

    The Forum Heroes Well-Known Member


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

    xmlxp Active 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%
     
  17. Digital Doctor

    Digital Doctor Well-Known Member

    Could Xenforo do some sort of periodic cleanup of /tmp ?
    Does Xenforo use /tmp more than other similar software ?
     
  18. The Forum Heroes

    The Forum Heroes Well-Known Member


    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.
     
  19. xmlxp

    xmlxp Active Member

    Thank you very much for your advise. since that date I never had this problem
     

Share This Page