1. 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.

Discussion in 'Troubleshooting and Problems' started by LurkerLou, Aug 11, 2014.

  1. LurkerLou

    LurkerLou Active Member

    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
     
  2. Mike

    Mike XenForo Developer Staff Member

    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. LurkerLou

    LurkerLou Active Member

    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. LurkerLou

    LurkerLou Active Member

    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: Aug 12, 2014
  5. Mike

    Mike XenForo Developer Staff Member

Share This Page