Fatal error: db User already has more than 'max_user_connections' active connections

[Bruce1952]

Hi All,

On a linux server using version 1.58a and php8.1

I am getting this error message when using Mozilla browser (have cleared all cookies and Cache) but still getting. It does show on Google Chrome only some times.

Message: Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1203] User zen158dba already has more than 'max_user_connections' active connections in /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connectors/Connector.php:70 Stack trace: #0 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connectors/Connector.php(70): PDO->__construct() #1 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection() #2 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection() #3 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect() #4 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}() #5 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(1064): call_user_func() #6 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(1100): Illuminate\Database\Connection->getPdo() #7 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(442): Illuminate\Database\Connection->getReadPdo() #8 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(368): Illuminate\Database\Connection->getPdoForSelect() #9 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}() #10 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback() #11 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run() #12 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select() #13 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect() #14 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #15 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns() #16 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get() #17 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels() #18 /home/xxxx/outdoorking.com.au/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get() #19 /home/xxxx/outdoorking.com.au/includes/application_top.php(213): Zencart\PluginManager\PluginManager->getInstalledPlugins() #20 /home/xxxx/outdoorking.com.au/index.php(25): require('/home/a1ntacdk3...') #21 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000] [1203] User zen158dba already has more than 'max_user_connections' active connections (SQL: select * from `plugin_control` where (`status` = 1)) in /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php:712 Stack trace: #0 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback() #1 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run() #2 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select() #3 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect() #4 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns() #6 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get() #7 /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels() #8 /home/xxxx/outdoorking.com.au/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get() #9 /home/xxxx/outdoorking.com.au/includes/application_top.php(213): Zencart\PluginManager\PluginManager->getInstalledPlugins() #10 /home/xxxx/outdoorking.com.au/index.php(25): require('/home/a1ntacdk3...') #11 {main} thrown in /home/xxxx/outdoorking.com.au/laravel/vendor/illuminate/database/Connection.php on line 712

Any help to lead me in the right direction on how to fix the issue would be appreciated.

[brittainmark]

The issue is on your server, you have too many database connections. I have a shared server and I think the limit for me is 32 connections. But you will need to talk to who ever manages your server.

[Bruce1952]

The issue is on your server, you have too many database connections. I have a shared server and I think the limit for me is 32 connections. But you will need to talk to who ever manages your server.

Thank you I spoke to them and it now appears to be working correctly again.

[Bruce1952]

The issue is on your server, you have too many database connections. I have a shared server and I think the limit for me is 32 connections. But you will need to talk to who ever manages your server.

Thanks for the reply but I think that I have found where the error originates from and if I test by pressing the home button in the green bar below the logo it is not an issue.

If when I am on a category page like Clearance item and on the top red bar I press the home button I get the error message each time.

I had a look using Developers Tool Kit for home and came up with these two files showing that it appears to be directing to the public_html folder
/home/xxxx/outdoorking.com.au/xxxxx/includes/configure_php

Line #52 : define('DIR_FS_CATALOG', '/home/xxxx/public_html/');

Also this file:
/home/xxxx/outdoorking.com.au/xxxx/includes/configurephp

Line #52 : define('DIR_FS_CATALOG', '/home/xxxx/public_html/');

Any help would be apprteciated on what needs to be done.

[Bruce1952]

Does anyone out there have any idea why only one button is causing the error.

[torvista]

I get this regularly and can usually link it to some extra bot traffic or an Ip, that I subsequently block.
But, some are google or bing so I can't block those.

But I've always had the suspicion that perhaps there is some underlying problem/bottleneck that a bit of extra traffic + a "low" value of max_user_connections allows the problem to show up.

As far as I know this instance is the only one that can be triggered on demand, so is certainly worth some investigation.

Perhaps a developer could suggest some additional debugging code to progress this?

[simon1066]

Does anyone out there have any idea why only one button is causing the error.

No solution but I do note that the green-bar home button url is without www whereas the red-bar home button (and it appears the rest of the site) is with www.