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

Strange Occurance

#1
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?
 

Blandt

Well-known member
#3
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
 

Mike

XenForo developer
Staff member
#5
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
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) {
  }
}
 

Jake Bunce

XenForo moderator
Staff member
#7
Zend_Db_Adapter_Mysqli_Exception: Too many connections
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.
 
#9
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.
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.