XF 2.1 User xenforo already has more than 'max_user_connections' active connections

[Littlebigdunc]

can anyone help with the following log, any help would be appreciated

• XF\Db\Exception: User xenforo already has more than 'max_user_connections' active connections
• src\XF\Db\Mysqli\Adapter.php:165

• Generated by: Unknown account
• Feb 15, 2020 at 12:52 PM

Stack trace

#0 src\XF\Db\Mysqli\Adapter.php(28): XF\Db\Mysqli\Adapter->makeConnection(Array)
#1 src\XF\Db\AbstractAdapter.php(60): XF\Db\Mysqli\Adapter->getConnection()
#2 src\XF\Db\Mysqli\Adapter.php(113): XF\Db\AbstractAdapter->connect()
#3 src\XF\Db\AbstractAdapter.php(516): XF\Db\Mysqli\Adapter->escapeString('addOnsComposer')
#4 src\XF\Db\AbstractAdapter.php(494): XF\Db\AbstractAdapter->quote('addOnsComposer')
#5 src\XF\DataRegistry.php(138): XF\Db\AbstractAdapter->quote(Array)
#6 src\XF\DataRegistry.php(83): XF\DataRegistry->readFromDb(Array, Array)
#7 src\XF\DataRegistry.php(226): XF\DataRegistry->get(Array)
#8 src\XF\App.php(1650): XF\DataRegistry->offsetGet('addOnsComposer')
#9 src\XF\Container.php(28): XF\App->XF\{closure}(Object(XF\Container))
#10 src\XF\App.php(2164): XF\Container->offsetGet('addon.composer')
#11 src\XF\App.php(1749): XF\App->setupAddOnComposerAutoload()
#12 src\XF\Pub\App.php(89): XF\App->setup(Array)
#13 src\XF.php(364): XF\Pub\App->setup(Array)
#14 src\XF.php(387): XF::setupApp('XF\\Pub\\App')
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}

Request state

array(4) {
["url"] => string(530) "/v3/index.php?chat/update&users%5B1%5D=1%2C7558%2C11469%2C6983%2C5172%2C7243%2C2430%2C6047%2C4815%2C11144%2C7069%2C10850%2C294&users%5B2%5D=1%2C7558%2C11469&users%5B4%5D=1%2C7558&users%5B5%5D=1%2C11469&users%5B6%5D=1%2C7558%2C11469&channel=room&room_id=1&last_id%5B1%5D=11963&conv_id=0&conv_only=0&conv_items=&conv_last_active=1581769181&conv_last_update=1581769181&user_last_update=1581771114&is_chat_page=0&_xfRequestUri=%2Fv3%2Findex.php&_xfWithData=1&_xfToken=1581769181%2C8c8ff38e77e0b4c6ed35769f51a387b0&_xfResponseType=json"
["referrer"] => string(38) "v3/index.php[/URL]"
["_GET"] => array(16) {
["chat/update"] => string(0) ""
["users"] => array(5) {
[1] => string(63) "1,7558,11469,6983,5172,7243,2430,6047,4815,11144,7069,10850,294"
[2] => string(12) "1,7558,11469"
[4] => string(6) "1,7558"
[5] => string(7) "1,11469"
[6] => string(12) "1,7558,11469"
}
["channel"] => string(4) "room"
["room_id"] => string(1) "1"
["last_id"] => array(1) {
[1] => string(5) "11963"
}
["conv_id"] => string(1) "0"
["conv_only"] => string(1) "0"
["conv_items"] => string(0) ""
["conv_last_active"] => string(10) "1581769181"
["conv_last_update"] => string(10) "1581769181"
["user_last_update"] => string(10) "1581771114"
["is_chat_page"] => string(1) "0"
["_xfRequestUri"] => string(13) "/v3/index.php"
["_xfWithData"] => string(1) "1"
["_xfToken"] => string(43) "1581769181,8c8ff38e77e0b4c6ed35769f51a387b0"
["_xfResponseType"] => string(4) "json"
}
["_POST"] => array(0) {
}
}

 

[Paul B]

It's a server limitation imposed by your host.

You would need to contact them and ask them to increase the limit.

 

[Littlebigdunc]

thankyou ive looked at my server and found the ini file and edited the max connections per user , hopefully this will fix the issue thanks for pointing me in the right direction