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

XF 1.3 Persistent database errors.

#1
Zend_Db_Adapter_Mysqli_Exception: Lost connection to MySQL server at 'reading initial communication packet', system error: 104 - library/Zend/Db/Adapter/Mysqli.php:333

#0 /home/*****/***.com/library/Zend/Db/Adapter/Abstract.php(315): Zend_Db_Adapter_Mysqli->_connect()
#1 /home/*****/***.com/library/XenForo/Application.php(685): Zend_Db_Adapter_Abstract->getConnection()
#2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config))
#3 /home/*****/***.com/library/XenForo/Application.php(922): call_user_func_array(Array, Array)
#4 /home/*****/***.com/library/XenForo/Application.php(953): XenForo_Application->lazyLoad('db', NULL)
#5 /home/*****/***.com/library/XenForo/Application.php(1481): XenForo_Application::get('db')
#6 /home/*****/***.com/library/XenForo/Model.php(161): XenForo_Application::getDb()
#7 /home/*****/***.com/library/XenForo/Model/DataRegistry.php(138): XenForo_Model->_getDb()
#8 /home/*****/***.com/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#9 /home/*****/***.com/library/XenForo/Dependencies/Abstract.php(144): XenForo_Model_DataRegistry->getMulti(Array)
#10 /home/*****/***.com/library/XenForo/FrontController.php(127): XenForo_Dependencies_Abstract->preLoadData()
#11 /home/*****/***.com/index.php(13): XenForo_FrontController->run()
#12 {main}

Also

Zend_Db_Adapter_Mysqli_Exception: Lost connection to MySQL server at 'reading authorization packet', system error: 0 - library/Zend/Db/Adapter/Mysqli.php:333
 

Mike

XenForo developer
Staff member
#2
Both of these really just represent server issues. There's nothing XF can do to cause or prevent them. I would suspect that this indicates a high load or an inconsistent network link (if MySQL is on a separate server).
 
#3
There's usually under 250 people on at a time. It hasn't been a problem in the past. The provider is claiming it's because of server load. I call BS on that because it hasn't been an issue in the past and server load has declined in the past month, not increased.
 
#4
One of their suggestions is to optimize the database. Is there any danger in doing so through myPHP? The directions seem almost too easy, select the tables and then select optimize.
 
Last edited: