Jump to content

max_user_connections' resource (current value: 30) (1226)


DicDal

Recommended Posts

I get this error, but the value is already 200

ghg.png.d1de9da306b56b354b611e4e49dfd34c.png

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

  • 2 weeks later...

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

Guest
This topic is now closed to further replies.
×
×
  • Create New...