mysql optimization/clarification
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
- Expert
- Posts: 274
- Joined: 27 Jun 2019, 16:19
mysql optimization/clarification
Hi community,
I faced this problem:
then I get mysql general log for this job "order/email/payment"
It is only job which is set on cron each 1 minute.
Are not it is too much queries from mshop_locale_language, mshop_locale_site, mshop_locale ?
And also what I see that queries are not performed under single connection.. You can see it connects more then 1 time, why is that and would not it better to use 1 db connection ?
Can you please give me some recommendations ? Should I configure something to mysql settings or also possible to configure something to aimeos/laravel to improve that ?
As usual I am really very thankful for the support !
Here are components versions:
I faced this problem:
Code: Select all
User noname already has more than 'max_user_connections' active connections
Code: Select all
/usr/sbin/mysqld, Version: 5.7.34-0ubuntu0.18.04.1-log ((Ubuntu)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
2021-05-13T09:12:38.429125Z 2 Connect noname@localhost on schmuck using TCP/IP
2021-05-13T09:12:38.429663Z 2 Query SET SESSION sort_buffer_size=2097144;
2021-05-13T09:12:38.429727Z 2 Query SET NAMES 'utf8mb4';
2021-05-13T09:12:38.429768Z 2 Query SET SESSION sql_mode='ANSI'
2021-05-13T09:12:38.430846Z 2 Query SELECT DISTINCT
mlocla."id" AS "locale.language.id", mlocla."label" AS "locale.language.label",
mlocla."siteid" AS "locale.language.siteid", mlocla."status" AS "locale.language.status",
mlocla."mtime" AS "locale.language.mtime", mlocla."editor" AS "locale.language.editor",
mlocla."ctime" AS "locale.language.ctime"
FROM "mshop_locale_language" AS mlocla
WHERE mlocla."status" = 1
ORDER BY mlocla."id" ASC
LIMIT 100 OFFSET 0
2021-05-13T09:12:38.434883Z 2 Query SELECT DISTINCT
mlocsi."id" AS "locale.site.id", mlocsi."code" AS "locale.site.code",
mlocsi."label" AS "locale.site.label", mlocsi."config" AS "locale.site.config",
mlocsi."status" AS "locale.site.status", mlocsi."editor" AS "locale.site.editor",
mlocsi."mtime" AS "locale.site.mtime", mlocsi."ctime" AS "locale.site.ctime"
FROM "mshop_locale_site" AS mlocsi
WHERE mlocsi."level" = 0 AND ( mlocsi."level" = 0 AND 1 = 1 )
ORDER BY mlocsi."id" ASC
LIMIT 100 OFFSET 0
2021-05-13T09:12:38.462460Z 2 Query SELECT DISTINCT
mlocsi."id" AS "locale.site.id", mlocsi."code" AS "locale.site.code",
mlocsi."label" AS "locale.site.label", mlocsi."config" AS "locale.site.config",
mlocsi."status" AS "locale.site.status", mlocsi."editor" AS "locale.site.editor",
mlocsi."mtime" AS "locale.site.mtime", mlocsi."ctime" AS "locale.site.ctime"
FROM "mshop_locale_site" AS mlocsi
WHERE mlocsi."level" = 0 AND ( mlocsi."code" = 'default' )
ORDER BY mlocsi."id" ASC
LIMIT 1 OFFSET 0
2021-05-13T09:12:38.465305Z 2 Query SELECT mloc."pos",
mloc."id" AS "locale.id", mloc."siteid" AS "locale.siteid",
mloc."langid" AS "locale.languageid", mloc."currencyid" AS "locale.currencyid",
mloc."pos" AS "locale.position", mloc."status" AS "locale.status",
mloc."mtime" AS "locale.mtime", mloc."editor" AS "locale.editor",
mloc."ctime" AS "locale.ctime"
FROM "mshop_locale" AS mloc
LEFT JOIN "mshop_locale_site" AS mlocsi ON (mloc."siteid" = mlocsi."id")
LEFT JOIN "mshop_locale_language" AS mlocla ON (mloc."langid" = mlocla."id")
LEFT JOIN "mshop_locale_currency" AS mloccu ON (mloc."currencyid" = mloccu."id")
WHERE ( mloc."siteid" IN (1) AND 1 = 1 )
GROUP BY mloc."pos",
mloc."id", mloc."siteid", mloc."langid", mloc."currencyid",
mloc."pos", mloc."status", mloc."mtime", mloc."editor", mloc."ctime"
ORDER BY mloc."pos" ASC
LIMIT 100 OFFSET 0
2021-05-13T09:12:38.479310Z 3 Connect noname@localhost on schmuck using TCP/IP
2021-05-13T09:12:38.479454Z 3 Query SET SESSION sort_buffer_size=2097144;
2021-05-13T09:12:38.479492Z 3 Query SET NAMES 'utf8mb4';
2021-05-13T09:12:38.479512Z 3 Query SET SESSION sql_mode='ANSI'
2021-05-13T09:12:38.483352Z 3 Query SELECT
mord."id" AS "order.id", mord."baseid" AS "order.baseid",
mord."siteid" AS "order.siteid", mord."type" AS "order.type",
mord."datepayment" AS "order.datepayment", mord."datedelivery" AS "order.datedelivery",
mord."statuspayment" AS "order.statuspayment", mord."statusdelivery" AS "order.statusdelivery",
mord."relatedid" AS "order.relatedid", mord."ctime" AS "order.ctime",
mord."mtime" AS "order.mtime", mord."editor" AS "order.editor", mord."statuscommission" AS "order.statuscommission"
FROM "mshop_order" AS mord
WHERE ( mord."siteid" IN (1) AND ( mord."mtime" >= '2021-04-13 09:12:38' AND mord."statuspayment" = 3 AND ( SELECT COUNT(mordst_cs."parentid")
FROM "mshop_order_status" AS mordst_cs
WHERE mord."id" = mordst_cs."parentid" AND mordst_cs."siteid" IN (1)
AND mordst_cs."type" = 'email-payment' AND mordst_cs."value" IN ( '3' ) ) = 0 ) )
GROUP BY
mord."id", mord."baseid", mord."siteid", mord."type", mord."datepayment",
mord."datedelivery", mord."statuspayment", mord."statusdelivery", mord."relatedid",
mord."ctime", mord."mtime", mord."editor"
LIMIT 100 OFFSET 0
2021-05-13T09:12:38.484546Z 3 Query SELECT
mord."id" AS "order.id", mord."baseid" AS "order.baseid",
mord."siteid" AS "order.siteid", mord."type" AS "order.type",
mord."datepayment" AS "order.datepayment", mord."datedelivery" AS "order.datedelivery",
mord."statuspayment" AS "order.statuspayment", mord."statusdelivery" AS "order.statusdelivery",
mord."relatedid" AS "order.relatedid", mord."ctime" AS "order.ctime",
mord."mtime" AS "order.mtime", mord."editor" AS "order.editor", mord."statuscommission" AS "order.statuscommission"
FROM "mshop_order" AS mord
WHERE ( mord."siteid" IN (1) AND ( mord."mtime" >= '2021-04-13 09:12:38' AND mord."statuspayment" = 4 AND ( SELECT COUNT(mordst_cs."parentid")
FROM "mshop_order_status" AS mordst_cs
WHERE mord."id" = mordst_cs."parentid" AND mordst_cs."siteid" IN (1)
AND mordst_cs."type" = 'email-payment' AND mordst_cs."value" IN ( '4' ) ) = 0 ) )
GROUP BY
mord."id", mord."baseid", mord."siteid", mord."type", mord."datepayment",
mord."datedelivery", mord."statuspayment", mord."statusdelivery", mord."relatedid",
mord."ctime", mord."mtime", mord."editor"
LIMIT 100 OFFSET 0
2021-05-13T09:12:38.485007Z 3 Query SELECT
mord."id" AS "order.id", mord."baseid" AS "order.baseid",
mord."siteid" AS "order.siteid", mord."type" AS "order.type",
mord."datepayment" AS "order.datepayment", mord."datedelivery" AS "order.datedelivery",
mord."statuspayment" AS "order.statuspayment", mord."statusdelivery" AS "order.statusdelivery",
mord."relatedid" AS "order.relatedid", mord."ctime" AS "order.ctime",
mord."mtime" AS "order.mtime", mord."editor" AS "order.editor", mord."statuscommission" AS "order.statuscommission"
FROM "mshop_order" AS mord
WHERE ( mord."siteid" IN (1) AND ( mord."mtime" >= '2021-04-13 09:12:38' AND mord."statuspayment" = 5 AND ( SELECT COUNT(mordst_cs."parentid")
FROM "mshop_order_status" AS mordst_cs
WHERE mord."id" = mordst_cs."parentid" AND mordst_cs."siteid" IN (1)
AND mordst_cs."type" = 'email-payment' AND mordst_cs."value" IN ( '5' ) ) = 0 ) )
GROUP BY
mord."id", mord."baseid", mord."siteid", mord."type", mord."datepayment",
mord."datedelivery", mord."statuspayment", mord."statusdelivery", mord."relatedid",
mord."ctime", mord."mtime", mord."editor"
LIMIT 100 OFFSET 0
2021-05-13T09:12:38.485459Z 3 Query SELECT
mord."id" AS "order.id", mord."baseid" AS "order.baseid",
mord."siteid" AS "order.siteid", mord."type" AS "order.type",
mord."datepayment" AS "order.datepayment", mord."datedelivery" AS "order.datedelivery",
mord."statuspayment" AS "order.statuspayment", mord."statusdelivery" AS "order.statusdelivery",
mord."relatedid" AS "order.relatedid", mord."ctime" AS "order.ctime",
mord."mtime" AS "order.mtime", mord."editor" AS "order.editor", mord."statuscommission" AS "order.statuscommission"
FROM "mshop_order" AS mord
WHERE ( mord."siteid" IN (1) AND ( mord."mtime" >= '2021-04-13 09:12:38' AND mord."statuspayment" = 6 AND ( SELECT COUNT(mordst_cs."parentid")
FROM "mshop_order_status" AS mordst_cs
WHERE mord."id" = mordst_cs."parentid" AND mordst_cs."siteid" IN (1)
AND mordst_cs."type" = 'email-payment' AND mordst_cs."value" IN ( '6' ) ) = 0 ) )
GROUP BY
mord."id", mord."baseid", mord."siteid", mord."type", mord."datepayment",
mord."datedelivery", mord."statuspayment", mord."statusdelivery", mord."relatedid",
mord."ctime", mord."mtime", mord."editor"
LIMIT 100 OFFSET 0
2021-05-13T09:12:38.486480Z 3 Quit
2021-05-13T09:12:38.486515Z 2 Quit
Are not it is too much queries from mshop_locale_language, mshop_locale_site, mshop_locale ?
And also what I see that queries are not performed under single connection.. You can see it connects more then 1 time, why is that and would not it better to use 1 db connection ?
Can you please give me some recommendations ? Should I configure something to mysql settings or also possible to configure something to aimeos/laravel to improve that ?
As usual I am really very thankful for the support !
Here are components versions:
Code: Select all
laravel/framework v5.8.35 The Laravel Framework.
aimeos/ai-admin-jqadm 2019.10.6 Aimeos ai-admin-jqadm extension
aimeos/ai-admin-jsonadm 2019.10.2 Aimeos ai-admin-jsonadm extension
aimeos/ai-client-html 2019.10.10 Aimeos ai-client-html extension
aimeos/ai-client-jsonapi 2019.10.2 Aimeos JSON API extension
aimeos/ai-controller-frontend 2019.10.3 Aimeos ai-controller-frontend extension
aimeos/ai-controller-jobs 2019.10.4 Aimeos ai-controller-jobs extension
aimeos/ai-gettext 2019.10.1 Aimeos Gettext extension
aimeos/ai-laravel 2019.10.2 Laravel adapter for Aimeos web shops and e-commerce solutions
aimeos/ai-payments 2019.10.1 Payment extension for Aimeos web shops and e-commerce solutions
aimeos/ai-swiftmailer 2019.10.1 SwiftMailer adapter for Aimeos web shops and e-commerce solutions
aimeos/aimeos-core 2019.10.7 Full-featured e-commerce components for high performance online shops
aimeos/aimeos-laravel 2019.10.1 Professional, full-featured and high performance Laravel e-commerce package for online shops and complex B2B projects
-
- Expert
- Posts: 274
- Joined: 27 Jun 2019, 16:19
Re: mysql optimization/clarification
ah and the max_user_connections is 35
Re: mysql optimization/clarification
35 connections should be more then enough. Did you have some custom code with uses the database manager to acquire() connections without calling the correspondent release() method?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
-
- Expert
- Posts: 274
- Joined: 27 Jun 2019, 16:19
Re: mysql optimization/clarification
Yes I am sure, all my custom code in all places in any case has called release() method, I checked it..
I noticed the same error in another aimeos project latest version, but here I know 100% what is the reason. aitrans() - this function makes the error. I have it in the loop called maybe 100+ times. I have checked it like this:
And it produces the same error. Is it my wrong use of aitrans() or ?
Best regards, thank you !
I noticed the same error in another aimeos project latest version, but here I know 100% what is the reason. aitrans() - this function makes the error. I have it in the loop called maybe 100+ times. I have checked it like this:
Code: Select all
for($i = 0; $i <= 3000; $i++) {
echo aitrans('April');
}
Best regards, thank you !
-
- Expert
- Posts: 274
- Joined: 27 Jun 2019, 16:19
Re: mysql optimization/clarification
I just tried the first project on my local computer with NO any custom code, and I got the same error when I go to back-end.
The max_user_connections = 22.
Here is the error log:
Here are the components versions:
And I checked it on second project with newest aimeos version, there this problem occurred with max_user_connections = 5-10
I would be very very thankful if you can help or give some helpful recommendations )
The max_user_connections = 22.
Here is the error log:
Code: Select all
[2021-05-14 20:36:45] local.ERROR: An exception occurred in driver: SQLSTATE[HY000] [1203] User noname already has more than 'max_user_connections' active connections {"userId":74,"exception":"[object] (Aimeos\\MW\\DB\\Exception(code: 0): An exception occurred in driver: SQLSTATE[HY000] [1203] User noname already has more than 'max_user_connections' active connections at /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Manager/DBAL.php:113)
[stacktrace]
#0 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(84): Aimeos\\MW\\DB\\Manager\\DBAL->acquire()
#1 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(692): Aimeos\\MShop\\Common\\Manager\\Base->createSearch()
#2 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(525): Aimeos\\MShop\\Locale\\Manager\\Site\\Standard->createSearch()
#3 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(354): Aimeos\\MShop\\Common\\Manager\\Base->findItemBase()
#4 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(130): Aimeos\\MShop\\Locale\\Manager\\Site\\Standard->findItem()
#5 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Standard.php(124): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->findItem()
#6 [internal function]: Aimeos\\MShop\\Locale\\Manager\\Standard->bootstrap()
#7 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(51): call_user_func_array()
#8 /var/www/schmuck/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Base/Locale.php(94): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->__call()
#9 /var/www/schmuck/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Base/Support.php(78): Aimeos\\Shop\\Base\\Locale->getBackend()
#10 /var/www/schmuck/app/Providers/AuthServiceProvider.php(33): Aimeos\\Shop\\Base\\Support->checkUserGroup()
#11 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Access/Gate.php(455): App\\Providers\\AuthServiceProvider->App\\Providers\\{closure}()
#12 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Access/Gate.php(352): Illuminate\\Auth\\Access\\Gate->callAuthCallback()
#13 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Access/Gate.php(322): Illuminate\\Auth\\Access\\Gate->raw()
#14 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Auth/Access/AuthorizesRequests.php(23): Illuminate\\Auth\\Access\\Gate->authorize()
#15 /var/www/schmuck/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Controller/JsonadmController.php(57): Aimeos\\Shop\\Controller\\JsonadmController->authorize()
#16 [internal function]: Aimeos\\Shop\\Controller\\JsonadmController->getAction()
#17 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array()
#18 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#19 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#20 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController()
#21 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(680): Illuminate\\Routing\\Route->run()
#22 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#23 /var/www/schmuck/app/Http/Middleware/Membership.php(30): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#24 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\Membership->handle()
#25 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /var/www/schmuck/app/Http/Middleware/IsDisabled.php(22): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#27 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\IsDisabled->handle()
#28 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#30 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#31 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#33 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#34 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#36 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#37 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#39 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#40 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#42 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle()
#43 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#44 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#45 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#46 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#48 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#49 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#50 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#51 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Pipeline\\Pipeline->then()
#52 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(657): Illuminate\\Routing\\Router->runRouteWithinStack()
#53 /var[2021-05-14 20:36:45] local.ERROR: An exception occurred in driver: SQLSTATE[HY000] [1203] User noname already has more than 'max_user_connections' active connections {"userId":74,"exception":"[object] (Aimeos\\MW\\DB\\Exception(code: 0): An exception occurred in driver: SQLSTATE[HY000] [1203] User noname already has more than 'max_user_connections' active connections at /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Manager/DBAL.php:113)
[stacktrace]
#0 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(84): Aimeos\\MW\\DB\\Manager\\DBAL->acquire()
#1 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(692): Aimeos\\MShop\\Common\\Manager\\Base->createSearch()
#2 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(525): Aimeos\\MShop\\Locale\\Manager\\Site\\Standard->createSearch()
#3 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(354): Aimeos\\MShop\\Common\\Manager\\Base->findItemBase()
#4 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(130): Aimeos\\MShop\\Locale\\Manager\\Site\\Standard->findItem()
#5 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Standard.php(124): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->findItem()
#6 [internal function]: Aimeos\\MShop\\Locale\\Manager\\Standard->bootstrap()
#7 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(51): call_user_func_array()
#8 /var/www/schmuck/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Base/Locale.php(94): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->__call()
#9 /var/www/schmuck/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Base/Support.php(78): Aimeos\\Shop\\Base\\Locale->getBackend()
#10 /var/www/schmuck/app/Providers/AuthServiceProvider.php(33): Aimeos\\Shop\\Base\\Support->checkUserGroup()
#11 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Access/Gate.php(455): App\\Providers\\AuthServiceProvider->App\\Providers\\{closure}()
#12 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Access/Gate.php(352): Illuminate\\Auth\\Access\\Gate->callAuthCallback()
#13 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Access/Gate.php(322): Illuminate\\Auth\\Access\\Gate->raw()
#14 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Auth/Access/AuthorizesRequests.php(23): Illuminate\\Auth\\Access\\Gate->authorize()
#15 /var/www/schmuck/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Controller/JsonadmController.php(57): Aimeos\\Shop\\Controller\\JsonadmController->authorize()
#16 [internal function]: Aimeos\\Shop\\Controller\\JsonadmController->getAction()
#17 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array()
#18 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#19 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#20 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController()
#21 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(680): Illuminate\\Routing\\Route->run()
#22 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#23 /var/www/schmuck/app/Http/Middleware/Membership.php(30): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#24 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\Membership->handle()
#25 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /var/www/schmuck/app/Http/Middleware/IsDisabled.php(22): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#27 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\IsDisabled->handle()
#28 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#30 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#31 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#33 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#34 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#36 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#37 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#39 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#40 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#42 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle()
#43 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#44 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#45 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#46 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#48 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#49 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#50 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#51 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Pipeline\\Pipeline->then()
#52 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(657): Illuminate\\Routing\\Router->runRouteWithinStack()
#53 /var[2021-05-14 20:36:45] local.ERROR: An exception occurred in driver: SQLSTATE[HY000] [1203] User noname already has more than 'max_user_connections' active connections {"userId":74,"exception":"[object] (Aimeos\\MW\\DB\\Exception(code: 0): An exception occurred in driver: SQLSTATE[HY000] [1203] User noname already has more than 'max_user_connections' active connections at /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Manager/DBAL.php:113)
[stacktrace]
#0 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(84): Aimeos\\MW\\DB\\Manager\\DBAL->acquire()
#1 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(692): Aimeos\\MShop\\Common\\Manager\\Base->createSearch()
#2 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(525): Aimeos\\MShop\\Locale\\Manager\\Site\\Standard->createSearch()
#3 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(354): Aimeos\\MShop\\Common\\Manager\\Base->findItemBase()
#4 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(130): Aimeos\\MShop\\Locale\\Manager\\Site\\Standard->findItem()
#5 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Standard.php(124): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->findItem()
#6 [internal function]: Aimeos\\MShop\\Locale\\Manager\\Standard->bootstrap()
#7 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(51): call_user_func_array()
#8 /var/www/schmuck/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Base/Locale.php(94): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->__call()
#9 /var/www/schmuck/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Base/Support.php(78): Aimeos\\Shop\\Base\\Locale->getBackend()
#10 /var/www/schmuck/app/Providers/AuthServiceProvider.php(33): Aimeos\\Shop\\Base\\Support->checkUserGroup()
#11 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Access/Gate.php(455): App\\Providers\\AuthServiceProvider->App\\Providers\\{closure}()
#12 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Access/Gate.php(352): Illuminate\\Auth\\Access\\Gate->callAuthCallback()
#13 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Access/Gate.php(322): Illuminate\\Auth\\Access\\Gate->raw()
#14 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Auth/Access/AuthorizesRequests.php(23): Illuminate\\Auth\\Access\\Gate->authorize()
#15 /var/www/schmuck/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Controller/JsonadmController.php(57): Aimeos\\Shop\\Controller\\JsonadmController->authorize()
#16 [internal function]: Aimeos\\Shop\\Controller\\JsonadmController->getAction()
#17 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array()
#18 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#19 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#20 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController()
#21 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(680): Illuminate\\Routing\\Route->run()
#22 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#23 /var/www/schmuck/app/Http/Middleware/Membership.php(30): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#24 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\Membership->handle()
#25 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /var/www/schmuck/app/Http/Middleware/IsDisabled.php(22): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#27 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\IsDisabled->handle()
#28 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#30 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#31 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#33 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#34 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#36 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#37 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#39 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#40 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#42 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle()
#43 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#44 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#45 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#46 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#48 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#49 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#50 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#51 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Pipeline\\Pipeline->then()
#52 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(657): Illuminate\\Routing\\Router->runRouteWithinStack()
#53 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(623): Illuminate\\Routing\\Router->runRoute()
#54 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(612): Illuminate\\Routing\\Router->dispatchToRoute()
#55 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch()
#56 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#57 /var/www/schmuck/app/Http/Middleware/CatalogTree.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#58 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\CatalogTree->handle()
#59 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#60 /var/www/schmuck/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#61 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle()
#62 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#63 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#64 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#65 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#66 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#67 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#68 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#69 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#70 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#71 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#72 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#73 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#74 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#75 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#76 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then()
#77 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#78 /var/www/schmuck/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#79 {main}
"}
/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(623): Illuminate\\Routing\\Router->runRoute()
#54 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(612): Illuminate\\Routing\\Router->dispatchToRoute()
#55 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch()
#56 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#57 /var/www/schmuck/app/Http/Middleware/CatalogTree.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#58 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\CatalogTree->handle()
#59 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#60 /var/www/schmuck/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#61 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle()
#62 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#63 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#64 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#65 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#66 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#67 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#68 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#69 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#70 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#71 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#72 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#73 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#74 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#75 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#76 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then()
#77 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#78 /var/www/schmuck/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#79 {main}
"}
/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(623): Illuminate\\Routing\\Router->runRoute()
#54 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(612): Illuminate\\Routing\\Router->dispatchToRoute()
#55 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch()
#56 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#57 /var/www/schmuck/app/Http/Middleware/CatalogTree.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#58 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\CatalogTree->handle()
#59 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#60 /var/www/schmuck/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#61 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle()
#62 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#63 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#64 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#65 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#66 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#67 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#68 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#69 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#70 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#71 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#72 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#73 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#74 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#75 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#76 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then()
#77 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#78 /var/www/schmuck/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#79 {main}
"}
[2021-05-14 20:36:45] local.ERROR: An exception occurred in driver: SQLSTATE[HY000] [1203] User noname already has more than 'max_user_connections' active connections {"userId":74,"exception":"[object] (Aimeos\\MW\\DB\\Exception(code: 0): An exception occurred in driver: SQLSTATE[HY000] [1203] User noname already has more than 'max_user_connections' active connections at /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Manager/DBAL.php:113)
[stacktrace]
#0 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(84): Aimeos\\MW\\DB\\Manager\\DBAL->acquire()
#1 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(692): Aimeos\\MShop\\Common\\Manager\\Base->createSearch()
#2 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(525): Aimeos\\MShop\\Locale\\Manager\\Site\\Standard->createSearch()
#3 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(354): Aimeos\\MShop\\Common\\Manager\\Base->findItemBase()
#4 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(130): Aimeos\\MShop\\Locale\\Manager\\Site\\Standard->findItem()
#5 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Standard.php(124): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->findItem()
#6 [internal function]: Aimeos\\MShop\\Locale\\Manager\\Standard->bootstrap()
#7 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(51): call_user_func_array()
#8 /var/www/schmuck/app/Http/Middleware/Membership.php(23): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->__call()
#9 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\Membership->handle()
#10 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#11 /var/www/schmuck/app/Http/Middleware/IsDisabled.php(22): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#12 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\IsDisabled->handle()
#13 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#14 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#15 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#16 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#17 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#18 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#19 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#21 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#22 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#23 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#24 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#25 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#27 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle()
#28 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#30 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#31 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#33 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#34 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#36 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Pipeline\\Pipeline->then()
#37 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(657): Illuminate\\Routing\\Router->runRouteWithinStack()
#38 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(623): Illuminate\\Routing\\Router->runRoute()
#39 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(612): Illuminate\\Routing\\Router->dispatchToRoute()
#40 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch()
#41 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#42 /var/www/schmuck/app/Http/Middleware/CatalogTree.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#43 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\CatalogTree->handle()
#44 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /var/www/schmuck/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#46 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle()
#47 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#48 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#49 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#50 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#52 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#53 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#54 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#55 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#56 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#58 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#59 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#60 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#61 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then()
#62 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#63 /var/www/schmuck/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#64 {main}
"}
[2021-05-14 20:36:45] local.ERROR: An exception occurred in driver: SQLSTATE[HY000] [1203] User noname already has more than 'max_user_connections' active connections {"userId":74,"exception":"[object] (Aimeos\\MW\\DB\\Exception(code: 0): An exception occurred in driver: SQLSTATE[HY000] [1203] User noname already has more than 'max_user_connections' active connections at /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Manager/DBAL.php:113)
[stacktrace]
#0 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(84): Aimeos\\MW\\DB\\Manager\\DBAL->acquire()
#1 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(692): Aimeos\\MShop\\Common\\Manager\\Base->createSearch()
#2 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(525): Aimeos\\MShop\\Locale\\Manager\\Site\\Standard->createSearch()
#3 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(354): Aimeos\\MShop\\Common\\Manager\\Base->findItemBase()
#4 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(130): Aimeos\\MShop\\Locale\\Manager\\Site\\Standard->findItem()
#5 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Standard.php(124): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->findItem()
#6 [internal function]: Aimeos\\MShop\\Locale\\Manager\\Standard->bootstrap()
#7 /var/www/schmuck/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Base.php(51): call_user_func_array()
#8 /var/www/schmuck/app/Http/Middleware/Membership.php(23): Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->__call()
#9 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\Membership->handle()
#10 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#11 /var/www/schmuck/app/Http/Middleware/IsDisabled.php(22): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#12 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\IsDisabled->handle()
#13 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#14 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#15 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#16 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#17 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#18 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#19 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#21 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#22 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#23 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#24 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#25 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#27 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle()
#28 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#30 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#31 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#33 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#34 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#36 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Pipeline\\Pipeline->then()
#37 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(657): Illuminate\\Routing\\Router->runRouteWithinStack()
#38 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(623): Illuminate\\Routing\\Router->runRoute()
#39 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Router.php(612): Illuminate\\Routing\\Router->dispatchToRoute()
#40 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch()
#41 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#42 /var/www/schmuck/app/Http/Middleware/CatalogTree.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#43 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\CatalogTree->handle()
#44 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /var/www/schmuck/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#46 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle()
#47 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#48 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#49 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#50 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#52 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#53 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#54 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#55 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#56 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#58 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#59 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#60 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}()
#61 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then()
#62 /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#63 /var/www/schmuck/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#64 {main}
"}
Here are the components versions:
Code: Select all
aimeos/ai-admin-jqadm 2019.10.6 Aimeos ai-admin-jqadm extension
aimeos/ai-admin-jsonadm 2019.10.2 Aimeos ai-admin-jsonadm extension
aimeos/ai-client-html 2019.10.10 Aimeos ai-client-html extension
aimeos/ai-client-jsonapi 2019.10.2 Aimeos JSON API extension
aimeos/ai-controller-frontend 2019.10.3 Aimeos ai-controller-frontend extension
aimeos/ai-controller-jobs 2019.10.4 Aimeos ai-controller-jobs extension
aimeos/ai-gettext 2019.10.1 Aimeos Gettext extension
aimeos/ai-laravel 2019.10.2 Laravel adapter for Aimeos web shops and e-commerce solutions
aimeos/ai-payments 2019.10.1 Payment extension for Aimeos web shops and e-commerce solutions
aimeos/ai-swiftmailer 2019.10.1 SwiftMailer adapter for Aimeos web shops and e-commerce solutions
aimeos/aimeos-core 2019.10.7 Full-featured e-commerce components for high performance online shops
aimeos/aimeos-laravel 2019.10.1 Professional, full-featured and high performance Laravel e-commerce package for online shops and complex B2B projects
And I checked it on second project with newest aimeos version, there this problem occurred with max_user_connections = 5-10
I would be very very thankful if you can help or give some helpful recommendations )
Re: mysql optimization/clarification
Which PHP version are you using?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
-
- Expert
- Posts: 274
- Joined: 27 Jun 2019, 16:19
Re: mysql optimization/clarification
For the project with oldest aimeos version:
apache-php: PHP Version 7.3.10
php-cli: php7.2.22-cli
For the project with newest aimeos version:
apache-php: PHP Version 7.4.18
php-cli: not used yet (jobs not used yet)
For now my problem is mostly for the project with older aimeos version... There I can't understand why the problem with max_user_connections occurred.. (
But also for newest aimeos version why the function aitrans() makes problem ? Does it connect to DB each time ?
Best regards!
apache-php: PHP Version 7.3.10
php-cli: php7.2.22-cli
For the project with newest aimeos version:
apache-php: PHP Version 7.4.18
php-cli: not used yet (jobs not used yet)
For now my problem is mostly for the project with older aimeos version... There I can't understand why the problem with max_user_connections occurred.. (
But also for newest aimeos version why the function aitrans() makes problem ? Does it connect to DB each time ?
Best regards!
Re: mysql optimization/clarification
There should be only one database connection retrieving the entries from the mshop_locale table:
https://github.com/aimeos/aimeos-larave ... le.php#L71
Can you check if it's called several times in your installation and why? The relevant lines are:
- https://github.com/aimeos/aimeos-larave ... #L100-L109
- https://github.com/aimeos/aimeos-larave ... rs.php#L39
https://github.com/aimeos/aimeos-larave ... le.php#L71
Can you check if it's called several times in your installation and why? The relevant lines are:
- https://github.com/aimeos/aimeos-larave ... #L100-L109
- https://github.com/aimeos/aimeos-larave ... rs.php#L39
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
-
- Expert
- Posts: 274
- Joined: 27 Jun 2019, 16:19
Re: mysql optimization/clarification
Is your above post regarding aitrans() problem ? Or my problem with older aimeos installation where it is not clear why 35 connections is not enough ?
Re: mysql optimization/clarification
The aitrans() problem
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star