User xxx has more than 'max_user_connections' error

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!
sixbynine
Posts: 93
Joined: 10 Jan 2018, 11:22

User xxx has more than 'max_user_connections' error

Post by sixbynine » 08 Oct 2018, 09:38

I read the LOG of my server errors and I see many : "User xxx has more than 'max_user_connections' active connections" errors on various Aimeos Requests (like createsearch, finditem, etc.). It seems to be often different ones.

I'm currently trying to detect how and when those errors happen exactly.

I'm wondering if my server config is not powerful enough for Aimeos or if I made something wrong... maybe I should manually close some connections at some point or on some errors.

Do you have any recommendations or experience about this problem?
Are sometimes, Aimeos DB requests closed manually ?

Thank you very much !

sbn

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: User xxx has more than 'max_user_connections' error

Post by aimeos » 09 Oct 2018, 19:37

Aimeos uses max three connections per request (resource/db/limit setting). If the connections aren't closed by the database server, do you have persistant connections enabled?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply