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

[dieg0]

Hello,

I'm getting these errors quite often:

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) {
  }
}

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?

 

[whynot]

Any ideas as to why is this happening?

Seems the number of connections are restricted with your host.
Are you on a shared server?

 

[dieg0]

Dedicated

 

[Mike]

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]

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

Fixed it.