Website Down

[Bruce1952]

Hi All,

I am getting this error on the site and looking for help. I changed the database password but it has come back again.

Running php8.1

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1203] User outdoorking_xxxx 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 outdoorking_dblive 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 would be appreciated as my site is down and I need to get it up and running again quickly because it has been down all day

[torvista]

It is what it says: the number of simultaneous connections to the database has been exceeded.

Look in your admin, version for server info and the value you have for
max_user_connections

The quick fix is to increase this in your hosting if possible, then review the access logs to see what bot is hitting the site to block it.

There are multiple threads in the forum about max_user_connections and also this comment

https://github.com/zencart/zencart/issues/1344

I have this problem, less so since I reduced the crawl rate in robots.txt for all Microsoft bot user agents.

https://www.bing.com/webmasters/help...g-use-8c184ec0

[Bruce1952]

Thank you for your imput it was appreciated.

We ended up changing all the admin passwords as well as the admin name after install a patch that we missed for spam.

The site is back up and running again and has no issues so far fingers crossed.

The other thing we found and removed was an old FTP (from another installer) access, so that was removed as well.

Thanks again for the help.