mysql optimization/clarification

Help for integrating the Laravel package
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!
Post Reply
MikaelNazarenko
Expert
Posts: 274
Joined: 27 Jun 2019, 16:19

mysql optimization/clarification

Post by MikaelNazarenko » 13 May 2021, 09:31

Hi community,

I faced this problem:

Code: Select all

User noname already has more than 'max_user_connections' active connections
then I get mysql general log for this job "order/email/payment"

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
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:

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
Top
MikaelNazarenko
Expert
Posts: 274
Joined: 27 Jun 2019, 16:19

Re: mysql optimization/clarification

Post by MikaelNazarenko » 13 May 2021, 19:30

ah and the max_user_connections is 35
Top
User avatar
aimeos
Administrator
Posts: 7881
Joined: 01 Jan 1970, 00:00

Re: mysql optimization/clarification

Post by aimeos » 14 May 2021, 15:06

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, Image give us a star
Top
MikaelNazarenko
Expert
Posts: 274
Joined: 27 Jun 2019, 16:19

Re: mysql optimization/clarification

Post by MikaelNazarenko » 14 May 2021, 16:10

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:

Code: Select all

for($i = 0; $i <= 3000; $i++) {
    echo aitrans('April');
}
And it produces the same error. Is it my wrong use of aitrans() or ?

Best regards, thank you !
Top
MikaelNazarenko
Expert
Posts: 274
Joined: 27 Jun 2019, 16:19

Re: mysql optimization/clarification

Post by MikaelNazarenko » 14 May 2021, 20:55

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:

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 )
Top
User avatar
aimeos
Administrator
Posts: 7881
Joined: 01 Jan 1970, 00:00

Re: mysql optimization/clarification

Post by aimeos » 15 May 2021, 10:17

Which PHP version are you using?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
MikaelNazarenko
Expert
Posts: 274
Joined: 27 Jun 2019, 16:19

Re: mysql optimization/clarification

Post by MikaelNazarenko » 15 May 2021, 14:09

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!
Top
User avatar
aimeos
Administrator
Posts: 7881
Joined: 01 Jan 1970, 00:00

Re: mysql optimization/clarification

Post by aimeos » 15 May 2021, 16:20

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
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
MikaelNazarenko
Expert
Posts: 274
Joined: 27 Jun 2019, 16:19

Re: mysql optimization/clarification

Post by MikaelNazarenko » 15 May 2021, 16:29

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 ?
Top
User avatar
aimeos
Administrator
Posts: 7881
Joined: 01 Jan 1970, 00:00

Re: mysql optimization/clarification

Post by aimeos » 15 May 2021, 17:18

The aitrans() problem
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star
Top
Post Reply

Return to “Laravel package”