XF 1.1 Crashing during upgrade.

[Edrondol]

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.

 

[Edrondol]

Earlier I got this error:



So I think I have some disconnect with the database.

 

[MattW]

You'll need to manually repair the table that is marked as crashed. Do that through phpMyAdmin if you have access to it.

 

[Edrondol]

You'll need to manually repair the table that is marked as crashed. Do that through phpMyAdmin if you have access to it.

How do I do that? It says repair failed.

 

[Paul B]

The search index table needs to be repaired at least.
The first problem indicates connection issues with the server during the cache rebuild.

Can you check and repair the DB and then try to rebuild the master data?

 

[Edrondol]

Trying to repair now. (I was looking in the table for the repair, not the index.)

 

[Paul B]

If you can't repair it, you can always truncate it and rebuilt the search index afterwards.

 

[Edrondol]

If you can't repair it, you can always truncate it and rebuilt the search index afterwards.

That will be plan "B". Thanks for helping me off the ledge.

 

[Edrondol]

Silly question, but how long should this repair take? It's been 1/2 hour already.

 

[Paul B]

The search index can be quite large.
How big is the table?

 

[Edrondol]

I have no idea how big it is. All stats are gone because of the crash.

 

[MattW]

Are you sure it's still running the repair? Is it being done through phpmyadmin or via command line by hour host?

 

[Edrondol]

Finally got into it thanks to the host helping out, truncated the table...and I still get the server error. So something else is going on. Yay! (Yes, I know this isn't an XF issue, but posting here has helped me narrow down what I needed to do.)

 

[Mike Edge]

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.

 

[Brandon Sheley]

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.

Can he run the upgrade now, or re-run it if needed?

 

[Mike Edge]

No, gets the same error.

 

[MattW]

How long does it take during the update process before you get the error with MySQL going away?

 

[Paul B]

Have you tried contacting the host to see if they can help?

 

[MattW]

Have you tried contacting the host to see if they can help?

I think Mike is the host

 

[Dodgeboard]

Have you tried contacting the host to see if they can help?

I suspect Mike is the host.