DicDal 179 Posted December 30, 2019 Share Posted December 30, 2019 I get this error, but the value is already 200 IPS\Db\Exception: User 'dbuser' has exceeded the 'max_user_connections' resource (current value: 30) (1226) #0 /home/imm8eyjnvqja/public_html/system/Db/Db.php(349): IPS\_Db->_establishConnection(false) #1 /home/imm8eyjnvqja/public_html/system/Db/Db.php(480): IPS\_Db->checkConnection(false) #2 /home/imm8eyjnvqja/public_html/system/Db/Select.php(373): IPS\_Db->preparedQuery('SELECT * FROM `...', Array, true) #3 /home/imm8eyjnvqja/public_html/system/Db/Select.php(436): IPS\Db\_Select->runQuery() #4 /home/imm8eyjnvqja/public_html/system/Db/Select.php(355): IPS\Db\_Select->rewind() #5 /home/imm8eyjnvqja/public_html/system/Session/Store/Database.php(60): IPS\Db\_Select->first() #6 /home/imm8eyjnvqja/public_html/system/Session/Front.php(93): IPS\Session\Store\_Database->loadSession('e53c0s5efdv4229...') #7 [internal function]: IPS\Session\_Front->read('e53c0s5efdv4229...') #8 /home/imm8eyjnvqja/public_html/system/Session/Session.php(91): session_start() #9 /home/imm8eyjnvqja/public_html/system/Dispatcher/Front.php(438): IPS\_Session::i() #10 /home/imm8eyjnvqja/public_html/system/Dispatcher/Front.php(38): IPS\Dispatcher\_Front->checkCached() #11 /home/imm8eyjnvqja/public_html/system/Dispatcher/Dispatcher.php(109): IPS\Dispatcher\_Front->init() #12 /home/imm8eyjnvqja/public_html/index.php(13): IPS\_Dispatcher::i() #13 {main} Link to comment Share on other sites More sharing options...
Phun 723 Posted January 8, 2020 Share Posted January 8, 2020 What results do you get if you run this query in phpMyAdmin: SHOW GLOBAL VARIABLES LIKE '%max_user_connections%'; SHOW VARIABLES LIKE '%max_user_connections%'; With a GLOBAL modifier, the statement displays global system variable values. With a SESSION modifier, the statement displays the system variable values that are in effect for the current connection. I mean i guess you already have shown the session one being 200 - but still. Are you sure it's set correctly in your my.cnf? Alternatively you can also run SHOW FULL PROCESSLIST; To see what your connections are doing Link to comment Share on other sites More sharing options...
Recommended Posts