Fehlermeldung und wie vermeide ich diese

Moin allerseits,

sporadisch tritt folgende Fehlermeldung in Front- und Backend auf. Kann ich diese irgendwie vermeiden? Bin in dem Bereich kein Experte und hoffe auf Tipps bzw. Hilfe.

Fehlermeldung Frontend:

Fatal error : Uncaught RuntimeException: Could not connect to database. Message from SQL Server: SQLSTATE[HY000] [1203] User ****** already has more than ‘max_user_connections’ active connections in /www/htdocs/w0079993/engine/Shopware/Components/DependencyInjection/Bridge/Db.php:71 Stack trace: #0 /www/htdocs/w0079993/engine/Shopware/Kernel.php(269): Shopware\Components\DependencyInjection\Bridge\Db::createPDO(Array) #1 /www/htdocs/w0079993/engine/Shopware/Components/HttpCache/AppCache.php(249): Shopware\Kernel->boot() #2 /www/htdocs/w0079993/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #3 /www/htdocs/w0079993/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #4 /www/htdocs/w0079993/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Reques in  /www/htdocs/w0079993/engine/Shopware/Components/DependencyInjection/Bridge/Db.php  on line  71

Fehlermeldung Backend: 

Ups! Ein Fehler ist aufgetreten!

Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.

Could not connect to database. Message from SQL Server: SQLSTATE[HY000] [1203] User ****** already has more than ‘max_user_connections’ active connections in engine/Shopware/Components/DependencyInjection/Bridge/Db.php on line 71

Stack trace:

 #0 engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(490): Shopware\Components\DependencyInjection\Bridge\Db::createPDO(Array) #1 engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(384): Shopware\_Plugins\_Backend\_Auth\_Bootstrap-\>createSaveHandler(Object(ShopwareProductiona300b76b3f19b02075ef06163690af65639da446ProjectContainer)) #2 engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Backend\_Auth\_Bootstrap-\>onInitResourceBackendSession(Object(Enlight\_Event\_EventArgs)) #3 engine/Library/Enlight/Event/EventManager.php(251): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Event\_EventArgs)) #4 engine/Shopware/Components/DependencyInjection/Container.php(173): Enlight\_Event\_EventManager-\>notifyUntil('Enlight\_Bootstr...', Object(Enlight\_Event\_EventArgs)) #5 engine/Shopware/Components/DependencyInjection/Container.php(157): Shopware\Components\DependencyInjection\Container-\>doLoad('backendsession') #6 engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(403): Shopware\Components\DependencyInjection\Container-\>load('backendsession') #7 engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Backend\_Auth\_Bootstrap-\>onInitResourceAuth(Object(Enlight\_Event\_EventArgs)) #8 engine/Library/Enlight/Event/EventManager.php(251): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Event\_EventArgs)) #9 engine/Shopware/Components/DependencyInjection/Container.php(173): Enlight\_Event\_EventManager-\>notifyUntil('Enlight\_Bootstr...', Object(Enlight\_Event\_EventArgs)) #10 engine/Shopware/Components/DependencyInjection/Container.php(138): Shopware\Components\DependencyInjection\Container-\>doLoad('auth', 1) #11 engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(441): Shopware\Components\DependencyInjection\Container-\>get('auth') #12 engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(269): Shopware\_Plugins\_Backend\_Auth\_Bootstrap-\>getCurrentLocale() #13 engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(212): Shopware\_Plugins\_Backend\_Auth\_Bootstrap-\>initLocale() #14 engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Backend\_Auth\_Bootstrap-\>onPreDispatchBackend(Object(Enlight\_Controller\_ActionEventArgs)) #15 engine/Library/Enlight/Event/EventManager.php(214): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Controller\_ActionEventArgs)) #16 engine/Library/Enlight/Controller/Action.php(136): Enlight\_Event\_EventManager-\>notify('Enlight\_Control...', Object(Enlight\_Controller\_ActionEventArgs)) #17 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch('indexAction') #18 engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #19 engine/Shopware/Kernel.php(179): Enlight\_Controller\_Front-\>dispatch() #20 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel-\>handle(Object(Enlight\_Controller\_Request\_RequestHttp), 1, true) #21 engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #22 vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #23 engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #24 shopware.php(117): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #25 {main}

Wenn Du kein schlecht programmiertes Plugin im Einsatz hast, könntest Du versuchen den Wert von max_user_connections zu erhöhen. Du könntest es auch so, aber vielleicht sollte man vorher die Software verbessern. Wenn max_user_connections Dir nichts sagt, wäre der Hoster Dein AP.

Evtl. steht max_user_connections bei Dir auf einem sehr niedrigen Wert. Bitte kläre einmal mit Deinem Hoster, ob hier Handlungsbedarf besteht.

Timme Hosting - schnelles nginx-Hosting

www.timmehosting.de