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.

 

[Mike Edge]

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.

 

[MattW]

Mike, what are your settings below set at?

wait_timeout =
connect_timeout =

 

[Mike Edge]

Wait! I just realized.. I stumped Brogan Bot by not realizing I was the host

 

[Dodgeboard]

Wait! I just realized.. I stumped Brogan Bot by not realizing I was the host

During his absence over the past year, he doesn't realize that you've taken over every Xenforo customers hosting accounts....except his.

 

[Mike Edge]

Is no wait and connect is 120.

 

[Mike Edge]

During his absence over the past year, he doesn't realize that you've taken over every Xenforo customers hosting accounts....except his.

I think my user title deserves changing to ' Stumped Brogan Bot '

 

[MattW]

Is no wait and connect is 120.

Try and increase those. That's only 2 minutes. I have mine set to 300, but you could do 600.

 

[Edrondol]

I love all you guys, by the way.

 

[Mike Edge]

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.

 

[Edrondol]

Same thing. I think it's time to roll back and restore from last night's backup and hit this another time. Unless anyone has any other ideas.

 

[MattW]

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)

 

[Paul B]

http://stackoverflow.com/questions/1884859/lost-connection-to-mysql-server-during-query

You can get more information about the lost connections by starting mysqld with the --log-warnings=2 option. This logs some of the disconnected errors in the hostname.err file

 

[MattW]

Try setting interactive_timeout as well (from my my.cnf)

wait_timeout=300
interactive_timeout=300

 

[Edrondol]

I reset the files to 1.1.2 and the site is up. I'm reindexing the search right now.

 

[Mike Edge]

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)

mysql>


Ok try it again now with the new setting added

 

[Edrondol]

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.

 

[MattW]

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.

 

[Edrondol]

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.

 

[Edrondol]

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
XenForo_Application::handleException()

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.

 

[MattW]

It's definitely an issue on the server if you are getting those errors again trying to do add an add-on