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

Strange Occurance

Discussion in 'Troubleshooting and Problems' started by Mycologist, Dec 6, 2010.

  1. Mycologist

    Mycologist Member

    I wasn't going to post this at all, since it's been resolved for us, but maybe it can be helpful or someone knows why it happened.

    About 15min ago my users started messaging me that they were getting constant database errors. So I logged into the admin area and it looked like this:

    Untitled-1.png

    The whole site either looked like the CSS had been removed or it would spit out a database error. I checked every site I have hosted on the same web server, they all functioned fine; some on the same database. So I assume it had to be Xenforo. I rebooted the server and the problem went away. Anyone know what could have caused it?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    What were the database errors?
     
  3. Blandt

    Blandt Well-Known Member

    Hard to tell with the info you gave.

    It could be lots of things ... server configuration, database configuration, htaccess .... your guess is better than mine :D
     
  4. Mycologist

    Mycologist Member

    All it said was "A database error has occurred."
     
  5. Mike

    Mike XenForo Developer Staff Member

    You can check in the server error log (in the tools tab in the admin CP). Though that error message usually happens when the connection to the database fails (preventing it from doing anything else).
     
  6. Mycologist

    Mycologist Member

    Here are the two errors that were in the log.

    Code:
    Zend_Db_Adapter_Mysqli_Exception: Too many connections - library/Zend/Db/Adapter/Mysqli.php:333
    Generated By: Unknown Account, Today at 11:56 AM
    Stack Trace
    
    #0 /var/www/vhosts/website.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(304): Zend_Db_Adapter_Mysqli->_connect()
    #1 /var/www/vhosts/website.com/httpdocs/library/XenForo/Application.php(508): Zend_Db_Adapter_Abstract->getConnection()
    #2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config))
    #3 /var/www/vhosts/website.com/httpdocs/library/XenForo/Application.php(735): call_user_func_array(Array, Array)
    #4 /var/www/vhosts/website.com/httpdocs/library/XenForo/Application.php(765): XenForo_Application->lazyLoad('db', NULL)
    #5 /var/www/vhosts/website.com/httpdocs/library/XenForo/Model.php(161): XenForo_Application::get('db')
    #6 /var/www/vhosts/website.com/httpdocs/library/XenForo/Model/DataRegistry.php(138): XenForo_Model->_getDb()
    #7 /var/www/vhosts/website.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
    #8 /var/www/vhosts/website.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
    #9 /var/www/vhosts/website.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
    #10 /var/www/vhosts/website.com/httpdocs/admin.php(13): XenForo_FrontController->run()
    #11 {main}
    
    Request State
    
    array(3) {
      ["url"] => string(103) "http://www.website.com/admin.php?_css/&css=public%3Axenforo%2Cpublic%3Aform%2Cadmin&d=1291470713"
      ["_GET"] => array(3) {
        ["_css/"] => string(0) ""
        ["css"] => string(32) "public:xenforo,public:form,admin"
        ["d"] => string(10) "1291470713"
      }
      ["_POST"] => array(0) {
      }
    }
    
    Code:
    Error Info
    Zend_Db_Adapter_Mysqli_Exception: Too many connections - library/Zend/Db/Adapter/Mysqli.php:333
    Generated By: Unknown Account, Today at 11:57 AM
    Stack Trace
    
    #0 /var/www/vhosts/website.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(304): Zend_Db_Adapter_Mysqli->_connect()
    #1 /var/www/vhosts/website.com/httpdocs/library/XenForo/Application.php(508): Zend_Db_Adapter_Abstract->getConnection()
    #2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config))
    #3 /var/www/vhosts/website.com/httpdocs/library/XenForo/Application.php(735): call_user_func_array(Array, Array)
    #4 /var/www/vhosts/website.com/httpdocs/library/XenForo/Application.php(765): XenForo_Application->lazyLoad('db', NULL)
    #5 /var/www/vhosts/website.com/httpdocs/library/XenForo/Model.php(161): XenForo_Application::get('db')
    #6 /var/www/vhosts/website.com/httpdocs/library/XenForo/Model/DataRegistry.php(138): XenForo_Model->_getDb()
    #7 /var/www/vhosts/website.com/httpdocs/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
    #8 /var/www/vhosts/website.com/httpdocs/library/XenForo/Dependencies/Abstract.php(133): XenForo_Model_DataRegistry->getMulti(Array)
    #9 /var/www/vhosts/website.com/httpdocs/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
    #10 /var/www/vhosts/website.com/httpdocs/admin.php(13): XenForo_FrontController->run()
    #11 {main}
    
    Request State
    
    array(3) {
      ["url"] => string(78) "http://www.website.com/admin.php?_css/&css=footer%2Cheader&d=1291665445"
      ["_GET"] => array(3) {
        ["_css/"] => string(0) ""
        ["css"] => string(13) "footer,header"
        ["d"] => string(10) "1291665445"
      }
      ["_POST"] => array(0) {
      }
    }
    
     
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    The MySQL server has hit its connection limit. You need to contact your web host and ask them to increase the connection limit in MySQL.
     
  8. Dean

    Dean Well-Known Member

    So Jake, have you seen people with this type of error before? ;)
     
  9. Mycologist

    Mycologist Member

    Alright, interesting solution. It's a dedicated server, so I guess I'll have to contact myself. ;) What's strange is the fact that all my other sites and services that use the same database were not effected at all. Thanks anyway.
     

Share This Page