XF 1.1 Crashing during upgrade.


Well-known member
Here's the error:

Server Error
Mysqli statement execute error : Lost connection to MySQL server during query
Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in XenForo/Model/DataRegistry.php at line 164
XenForo_Model_DataRegistry->set() in XenForo/Model/Style.php at line 434
XenForo_Model_Style->rebuildStyleCache() in XenForo/DataWriter/Style.php at line 171
XenForo_DataWriter_Style->_rebuildCache() in XenForo/DataWriter/Style.php at line 162
XenForo_DataWriter_Style->_postSave() in XenForo/DataWriter.php at line 1385
XenForo_DataWriter->save() in XenForo/Model/StyleProperty.php at line 699
XenForo_Model_StyleProperty->updatePropertyCacheInStyle() in XenForo/Model/StyleProperty.php at line 632
XenForo_Model_StyleProperty->rebuildPropertyCacheInStyleAndChildren() in XenForo/Model/StyleProperty.php at line 2316
XenForo_Model_StyleProperty->importStylePropertiesFromArray() in XenForo/Model/StyleProperty.php at line 2187
XenForo_Model_StyleProperty->importStylePropertyXml() in XenForo/Model/StyleProperty.php at line 2120
XenForo_Model_StyleProperty->importStylePropertyDevelopmentXml() in XenForo/CacheRebuilder/ImportMasterData.php at line 45
XenForo_CacheRebuilder_ImportMasterData->rebuild() in XenForo/ControllerHelper/CacheRebuild.php at line 26
XenForo_ControllerHelper_CacheRebuild->rebuildCache() in XenForo/Install/Controller/Upgrade.php at line 232
XenForo_Install_Controller_Upgrade->actionRebuild() in XenForo/FrontController.php at line 310
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /home/davidn/public_html/xenforo/install/index.php at line 18

Any hints to tell my host what's up? I have a ticket open with just the error for now.
Have you tried contacting the host to see if they can help?

Yes as stated Any further idea's on this. We restarted MySQL, search index is empty, but he continues to get the error. Also MySQL logs don't show any issues resulting from this either.

No other boards have had issues upgrading.
Ok, give it another try, I increased connect_ to 600 as suggested

@Matt there is no wait_timeout = in the file is what I ment.
Oh OK, set that as well, otherwise it will use the default value (you can check what is currently set

mysql> SHOW VARIABLES LIKE '%wait_timeout%';
| Variable_name            | Value    |
| innodb_lock_wait_timeout | 50       |
| lock_wait_timeout        | 31536000 |
| wait_timeout             | 300      |
3 rows in set (0.00 sec)
Thanks.. added 600

I now have

mysql> SHOW VARIABLES LIKE '%wait_timeout%';
| Variable_name | Value |
| innodb_lock_wait_timeout | 50 |
| lock_wait_timeout | 31536000 |
| wait_timeout | 28800 |
3 rows in set (0.00 sec)


Ok try it again now with the new setting added
I'm going to hold off on the upgrade for a bit. I'm going to make sure the table gets reindexed and works before I do the next step, which I'll probably do tonight or tomorrow night. Just got back up and users are filtering in so I don't really want to kick them off again so soon.
Could you make a copy your forum/database to a different install and try an offline upgrade?

Your forum is twice the size of mine, and the upgrade to 1.1.4 took about 2 minutes.
I never got past the initial "Upgrade" screen because of the db issue. It normally takes me hardly any time at all. This is the first issue I had and it was really nobody's fault.

I also have several templates which means it takes a while to do much of anything. But I'm aware of that so it doesn't bother me.
Okay, so the site is up and running okay, but I still can't add any addons or anything like that.

I get this error:

An exception occurred: Mysqli prepare error: MySQL server has gone away in /home/davidn/public_html/xenforo/library/Zend/Db/Statement/Mysqli.php on line 77
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Error.php at line 50
XenForo_Error::unexpectedException() in XenForo/Application.php at line 295

Now, I know that it's not the config file because if it was there's no way my site would be up. So there's still something up with something at the host level.
Top Bottom