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

XF 1.5 proxy.php: Resource temporarily unavailable & Too many connections

dieg0

Active member
#1
Hello,

I'm getting these errors quite often:

Code:
Error Info
Zend_Db_Adapter_Mysqli_Exception: Resource temporarily unavailable - library/Zend/Db/Adapter/Mysqli.php:333
Generated By: Cuenta desconocida, Ayer a las 9:05 PM
Stack Trace
#0 /home/webs/mysite.com/library/Zend/Db/Adapter/Abstract.php(315): Zend_Db_Adapter_Mysqli->_connect()
#1 /home/webs/mysite.com/library/XenForo/Application.php(730): Zend_Db_Adapter_Abstract->getConnection()
#2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config))
#3 /home/webs/mysite.com/library/XenForo/Application.php(973): call_user_func_array(Array, Array)
#4 /home/webs/mysite.com/library/XenForo/Application.php(1004): XenForo_Application->lazyLoad('db', NULL)
#5 /home/webs/mysite.com/library/XenForo/Application.php(1632): XenForo_Application::get('db')
#6 /home/webs/mysite.com/library/XenForo/Model.php(161): XenForo_Application::getDb()
#7 /home/webs/mysite.com/library/XenForo/Model/DataRegistry.php(138): XenForo_Model->_getDb()
#8 /home/webs/mysite.com/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#9 /home/webs/mysite.com/library/XenForo/Dependencies/Abstract.php(147): XenForo_Model_DataRegistry->getMulti(Array)
#10 /home/webs/mysite.com/library/XenForo/ProxyOutput.php(383): XenForo_Dependencies_Abstract->preLoadData()
#11 /home/webs/mysite.com/proxy.php(12): XenForo_ProxyOutput::run()
#12 {main}
Solicitar estado
array(3) {
  ["url"] => string(153) "https://www.mysite.com/proxy.php?image=http%3A%2F%2Fart.gametdb.com%2Fwii%2Fcover3D%2FUS%2FRU8EFS.png%3F1317736159&hash=c9797a4f6f60e3c8185f25357f19632c"
  ["_GET"] => array(2) {
    ["image"] => string(59) "http://art.gametdb.com/wii/cover3D/US/RU8EFS.png?1317736159"
    ["hash"] => string(32) "c9797a4f6f60e3c8185f25357f19632c"
  }
  ["_POST"] => array(0) {
  }
}


Code:
Error Info
Zend_Db_Adapter_Mysqli_Exception: Too many connections - library/Zend/Db/Adapter/Mysqli.php:333
Generated By: Cuenta desconocida, Viernes a las 12:14 AM
Stack Trace
#0 /home/webs/mysite.com/library/Zend/Db/Adapter/Abstract.php(315): Zend_Db_Adapter_Mysqli->_connect()
#1 /home/webs/mysite.com/library/XenForo/Application.php(730): Zend_Db_Adapter_Abstract->getConnection()
#2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config))
#3 /home/webs/mysite.com/library/XenForo/Application.php(973): call_user_func_array(Array, Array)
#4 /home/webs/mysite.com/library/XenForo/Application.php(1004): XenForo_Application->lazyLoad('db', NULL)
#5 /home/webs/mysite.com/library/XenForo/Application.php(1632): XenForo_Application::get('db')
#6 /home/webs/mysite.com/library/XenForo/Model.php(161): XenForo_Application::getDb()
#7 /home/webs/mysite.com/library/XenForo/Model/DataRegistry.php(138): XenForo_Model->_getDb()
#8 /home/webs/mysite.com/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#9 /home/webs/mysite.com/library/XenForo/Dependencies/Abstract.php(147): XenForo_Model_DataRegistry->getMulti(Array)
#10 /home/webs/mysite.com/library/XenForo/ProxyOutput.php(383): XenForo_Dependencies_Abstract->preLoadData()
#11 /home/webs/mysite.com/proxy.php(12): XenForo_ProxyOutput::run()
#12 {main}
Solicitar estado
array(3) {
  ["url"] => string(153) "https://www.mysite.com/proxy.php?image=http%3A%2F%2Fart.gametdb.com%2Fwii%2Fcover3D%2FEN%2FRNOP01.png%3F1317736103&hash=b40f1fd81b49f90609ad38efabcd3639"
  ["_GET"] => array(2) {
    ["image"] => string(59) "http://art.gametdb.com/wii/cover3D/EN/RNOP01.png?1317736103"
    ["hash"] => string(32) "b40f1fd81b49f90609ad38efabcd3639"
  }
  ["_POST"] => array(0) {
  }
}
I'm running php 5.6 , tinyproxy/1.8.3 and xenforo 1.5.12

Any ideas as to why is this happening?
 

Mike

XenForo developer
Staff member
#4
These errors being from proxy.php is generally incidental. They won't relate to it beyond the fact that proxy.php may be called particularly frequently.

The resource unavailable message has a few potential causes: http://stackoverflow.com/questions/10131615/mysql-resource-temporarily-unavailable This could well be the file descriptors issue.

Too many connections is likely the same thing manifesting slightly differently, this time being constrained by your MySQL config itself rather than server resources.
 

dieg0

Active member
#5
vi /usr/lib/systemd/system/mariadb.service
[Service]
Type=simple
User=mysql
Group=mysql
LimitNOFILE=65535

Fixed it.