Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    532
    Plugin Contributions
    0

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

    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.

  2. #2
    Join Date
    Apr 2009
    Posts
    429
    Plugin Contributions
    2

    Default Re: Fatal Error

    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.
    Mark Brittain
    http:\\innerlightcrystals.co.uk\sales\

  3. #3
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    532
    Plugin Contributions
    0

    Default Re: Fatal Error

    Quote Originally Posted by brittainmark View Post
    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.

  4. #4
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    532
    Plugin Contributions
    0

    Default Re: Fatal Error

    Quote Originally Posted by brittainmark View Post
    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.

  5. #5
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    532
    Plugin Contributions
    0

    Default Re: Fatal Error

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

  6. #6
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,607
    Plugin Contributions
    30

    Default Re: Fatal Error

    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?
    Steve
    github.com/torvista: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...

  7. #7
    Join Date
    Feb 2009
    Location
    UK
    Posts
    1,249
    Plugin Contributions
    1

    Default Re: Fatal Error

    Quote Originally Posted by Bruce1952 View Post
    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.
    Simon

 

 

Similar Threads

  1. v155 User already has more than 'max_user_connections
    By mikebr in forum All Other Contributions/Addons
    Replies: 12
    Last Post: 19 Feb 2024, 09:31 AM
  2. v155 Spike in "more than max_user_connections" errors
    By swguy in forum General Questions
    Replies: 13
    Last Post: 21 Nov 2018, 06:50 PM
  3. Replies: 7
    Last Post: 9 Jul 2015, 10:04 PM
  4. How to set up different shipping options than what UPS has already?
    By bnieukirk in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 6 Sep 2009, 06:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR