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

XF 1.5 Too Many Connections

Discussion in 'XenForo Questions and Support' started by Nirjonadda, Jul 2, 2016.

  1. Nirjonadda

    Nirjonadda Active Member

    Hello,

    I am getting many more Server Error Logs about Too many connections by Mysqli , Please can you let me know, what we need to raise to fixing on this error issue? I am using MariaDB 10.1.15 Version.

    PHP:
    Server Error Log
    Error Info
    Zend_Db_Adapter_Mysqli_Exception
    Too many connections library/Zend/Db/Adapter/Mysqli.php:333
    Generated By
    Unknown Account24 minutes ago
    Stack Trace

    #0 /home/USER/public_html/library/Zend/Db/Adapter/Abstract.php(315): Zend_Db_Adapter_Mysqli->_connect()
    #1 /home/nadda/public_html/library/XenForo/Application.php(730): Zend_Db_Adapter_Abstract->getConnection()
    #2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config))
    #3 /home/nadda/public_html/library/XenForo/Application.php(973): call_user_func_array(Array, Array)
    #4 /home/nadda/public_html/library/XenForo/Application.php(1004): XenForo_Application->lazyLoad('db', NULL)
    #5 /home/nadda/public_html/library/XenForo/Application.php(1609): XenForo_Application::get('db')
    #6 /home/nadda/public_html/library/XenForo/Session.php(236): XenForo_Application::getDb()
    #7 /home/nadda/public_html/library/XenForo/Session.php(323): XenForo_Session->__construct()
    #8 /home/nadda/public_html/library/XenForo/Session.php(257): XenForo_Session::getPublicSession(Object(Zend_Controller_Request_Http))
    #9 /home/nadda/public_html/library/XenForo/Controller.php(293): XenForo_Session::startPublicSession(Object(Zend_Controller_Request_Http))
    #10 /home/nadda/public_html/library/XenForo/Controller.php(306): XenForo_Controller->_setupSession('Index')
    #11 /home/nadda/public_html/library/XenForo/FrontController.php(350): XenForo_Controller->preDispatch('Index', 'XenForo_Control...')
    #12 /home/nadda/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #13 /home/nadda/public_html/index.php(13): XenForo_FrontController->run()
    #14 {main}

    Request State

    array(3) {
      [
    "url"] => string(35"http://www.mysite.com/index.php"
      
    ["_GET"] => array(0) {
      }
      [
    "_POST"] => array(1) {
        [
    "kPZJ9W_"] => string(7" HpjUO4"
      
    }
    }
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    This is a limitation imposed by your host.

    Contact them and ask them to raise the limit.
     
  3. Joeychgo

    Joeychgo Well-Known Member


    Exactly.... And if your host says they cannot, you should look for a different hosting company.
     
    Xon likes this.
  4. Tracy Perry

    Tracy Perry Well-Known Member

    And if you are your own sysadmin, then simply raising the max connections in your my.cnf will work.
    if you don't know where the my.cnf is, run
    updatedb && locate my.cnf
    it will normally be in /etc or /etc/mysql
    Load that file in an editor and look for max connections.
     

Share This Page