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

XF 1.4 Mysqli statement execute error : Can't create/write to file '/tmp/MYtoHV7R' (Errcode: 28)

Discussion in 'Troubleshooting and Problems' started by Mian Shahid, Dec 16, 2014.

  1. Mian Shahid

    Mian Shahid Well-Known Member

    Hi, we are facing the following error since last 12 hours when trying to open forum index

    11111.gif

    but few link like "Unread Watched Threads", "New Posts", "Latest Alerts" and "Current Visitors" are working fine, but showing following error when trying to enter ACP and/or posting in threads.

    2222.png

    also please, if plugin disabling required , then kindly let me know how to disable few or all plugin without entering ACP.

    Thanks
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    This sounds like a lack of disk space.
     
    Mian Shahid likes this.
  3. Mian Shahid

    Mian Shahid Well-Known Member

    Initially, Hosting company replied the disk usage is ok, then they said, server needs reboot as SSH is stuck, then finally they said
    Code:
    While checking your issue i could see that one of the MySQL table was crashed.
    
    =================================================================================================
    141218 6:58:12 [ERROR] /usr/sbin/mysqld: Table './home_xen/xf_session' is marked as crashed and should be repaired
    141218 6:58:12 [ERROR] /usr/sbin/mysqld: Table './home_xen/xf_session' is marked as crashed and should be repaired
    141218 6:58:21 [ERROR] /usr/sbin/mysqld: Table './home_xen/xf_session' is marked as crashed and should be repaired
    141218 6:58:22 [ERROR] /usr/sbin/mysqld: Table './home_xen/xf_session' is marked as crashed and should be repaired
    =================================================================================================
    
    I have repaired the table and corrected /tmp permission. Your website is loading fine now
    
    If you require further assistance, please don't hesitate to let us know.
    
    i viewed this new error in server error log

    PHP:
    Mysqli prepare errorTable './home_xen/xf_search_index' is marked as crashed and last (automatic?) repair failed
    Yesterday at 5
    :11 PM library/Zend/Db/Statement/Mysqli.php:77
    but before that, about 13182 errors were logged regarding mentioned "unable to write" error.

    now our site is working fine, any tip from experts for future?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Issues such as that are typically server related.

    If it continues, you should consider changing hosts.
     
    Mian Shahid likes this.

Share This Page