Fehler: 500 und 503, SQLSTATE(08004) (1040) Too many connections

Shopware 5 Allgemein
1

Hallo, vielleicht hat hier wer eine Idee. Ich habe sporadisch diesen Fehler auf meinem Devshop. Die Seite lädt dann sehr lange und dann kommt dieser Fehler bei raus, woran könnte das Problem liegen, das er zu viele Verbindungen zur Datenbank aufbaut? Viele Grüße, Thomas

Channel: core
request:	
{
    "uri": "/backend/widgets/getLastOrders?_dc=1558697595196&page=1&start=0&limit=25",
    "method": "GET",
    "query": {
        "_dc": "1558697595196",
        "page": "1",
        "start": "0",
        "limit": "25",
        "module": "backend",
        "controller": "widgets",
        "action": "getLastOrders"
    },
    "post": []
}


RuntimeException: Could not connect to database. Message from SQL Server: SQLSTATE(08004) (1040) Too many connections in /engine/Shopware/Components/DependencyInjection/Bridge/Db.php:76 Stack trace:
#0 /engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(513): Shopware\Components\DependencyInjection\Bridge\Db::createPDO(Array)
#1 /engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(369): Shopware_Plugins_Backend_Auth_Bootstrap->createSaveHandler(Object(ShopwareProduction848e0ed9018f82ce933306af81420882d546e34bProjectContainer))
#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(256): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Event_EventArgs))
#4 /engine/Shopware/Components/DependencyInjection/Container.php(195): Enlight_Event_EventManager->notifyUntil('Enlight_Bootstr...', Object(Enlight_Event_EventArgs))
#5 /engine/Shopware/Components/DependencyInjection/Container.php(156): Shopware\Components\DependencyInjection\Container->doLoad('backendsession')
#6 /engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(391): 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(256): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Event_EventArgs))
#9 /engine/Shopware/Components/DependencyInjection/Container.php(195): 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(226): Shopware\Components\DependencyInjection\Container->get('auth')
#12 /engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(207): Shopware_Plugins_Backend_Auth_Bootstrap->checkAuth()
#13 /engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Backend_Auth_Bootstrap->onPreDispatchBackend(Object(Enlight_Controller_ActionEventArgs))
#14 /engine/Library/Enlight/Event/EventManager.php(219): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#15 /engine/Library/Enlight/Controller/Action.php(170): Enlight_Event_EventManager->notify('Enlight_Control...', Object(Enlight_Controller_ActionEventArgs))
#16 /engine/Library/Enlight/Controller/Dispatcher/Default.php(563): Enlight_Controller_Action->dispatch('popupAction')
#17 /engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#18 /engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch()
#19 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#20 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#21 /engine/Shopware/Components/HttpCache/AppCache.php(260): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#22 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#23 /engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#24 /html/shop/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#25

RuntimeException: Could not connect to database. Message from SQL Server: SQLSTATE(HY000) (1040) Too many connections in /engine/Shopware/Components/DependencyInjection/Bridge/Db.php:76 Stack trace:
#0 /engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(513): Shopware\Components\DependencyInjection\Bridge\Db::createPDO(Array)
#1 /engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(369): Shopware_Plugins_Backend_Auth_Bootstrap->createSaveHandler(Object(ShopwareProduction848e0ed9018f82ce933306af81420882d546e34bProjectContainer))
#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(256): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Event_EventArgs))
#4 /engine/Shopware/Components/DependencyInjection/Container.php(195): Enlight_Event_EventManager->notifyUntil('Enlight_Bootstr...', Object(Enlight_Event_EventArgs))
#5 /engine/Shopware/Components/DependencyInjection/Container.php(156): Shopware\Components\DependencyInjection\Container->doLoad('backendsession')
#6 /engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(391): 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(256): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Event_EventArgs))
#9 /engine/Shopware/Components/DependencyInjection/Container.php(195): 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(226): Shopware\Components\DependencyInjection\Container->get('auth')
#12 /engine/Shopware/Plugins/Default/Backend/Auth/Bootstrap.php(207): Shopware_Plugins_Backend_Auth_Bootstrap->checkAuth()
#13 /engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Backend_Auth_Bootstrap->onPreDispatchBackend(Object(Enlight_Controller_ActionEventArgs))
#14 /engine/Library/Enlight/Event/EventManager.php(219): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#15 /engine/Library/Enlight/Controller/Action.php(170): Enlight_Event_EventManager->notify('Enlight_Control...', Object(Enlight_Controller_ActionEventArgs))
#16 /engine/Library/Enlight/Controller/Dispatcher/Default.php(563): Enlight_Controller_Action->dispatch('getLastOrdersAc...')
#17 /engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#18 /engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch()
#19 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#20 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#21 /engine/Shopware/Components/HttpCache/AppCache.php(260): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#22 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#23 /engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#24 /html/shop/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#25

 

2

Ist das evtl. ein Shared Hosting? Ich könnte mir vorstellen, dass Du evtl. Nachbarn auf dem Server hast, die die Datenbank zu stark in Anspruch nehmen.

Timme Hosting - schnelles nginx-Hosting

www.timmehosting.de

1 „Gefällt mir“
3

Tatächlich ist es ein managed vServer von Mittwald, werde ich den Support mal befragen müssen. Ich dachte nur im ersten Moment das Shopware vielleicht zu viele Verbindungen zur Datenbank aufbaut.