Upgrade Error (RC release)

[Teascu Dorin]

I have a database error on upgrading from 1.2.0 RC1 to 1.2.0 RC2 :

Server Error

Mysqli statement execute error : Error writing file '/tmp/mysqltmp/MLHQkAR8' (Errcode: 28)
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in XenForo/Model/Template.php at line 1501
    XenForo_Model_Template->compileTemplateInStyleTree() in XenForo/Model/Template.php at line 1310
    XenForo_Model_Template->compileNamedTemplateInStyleTree() in XenForo/Model/Template.php at line 1249
    XenForo_Model_Template->compileAllTemplates() in XenForo/Deferred/Template.php at line 36
    XenForo_Deferred_Template->execute() in XenForo/Deferred/Atomic.php at line 61
    XenForo_Deferred_Atomic->execute() in XenForo/Model/Deferred.php at line 197
    XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 320
    XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 254
    XenForo_Model_Deferred->runByUniqueKey() in XenForo/Install/Controller/Abstract.php at line 34
    XenForo_Install_Controller_Abstract->_manualDeferredRunner() in XenForo/Install/Controller/Upgrade.php at line 216
    XenForo_Install_Controller_Upgrade->actionRunDeferred() in XenForo/FrontController.php at line 337
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/content/................/html/xen1dev/install/index.php at line 18

 

[Chris D]

Thanks to an earlier post by @Brogan I can confirm that the error and ErrCode 28 means no space left on drive:

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

Basically means your server is physically out of disk space, or the MySQL allocation for logs and temp files is full.

 

[Teascu Dorin]

Maybe the logs because I have 10GB available on my host (GoDaddy.com)

 

[Mike]

It's more of an underlying server issue - you may want to contact your host about that.

 

[Teascu Dorin]

Even with a fresh install when I upload a language file I got that kind of an error 3 times. Only when is working a little more this type of error appears.

 

[MattW]

The host still needs to look at the /tmp directory and free some space up.

 

[Teascu Dorin]

The /tmp folder has been cleared but the problem is still there. Same error as in first post.

 

[Mike]

This is an error that only they can resolve. It's a space (or quota) issue. They can reconfigure MySQL if needed (to put temporary files elsewhere) or make /tmp bigger. Otherwise, I could only recommend another host.

 

[Teascu Dorin]

I use and used XenForo, vBulletin and IP.Board on the same server and same settings for more then 2 years now but this problem appeared only from v1.2.0 and more specific when loading/ using differend.php file.