sourcebans-pp
sourcebans-pp copied to clipboard
[AJAX] SQLSTATE[HY000] [1203] User already has more than 'max_user_connections' active connections
What are the steps to reproduce this issue?
- Visit Sourcebans++ instalation
What happens?
AJAX returns an error reporting that the database user has exhausted the maximum number of connections allowed per user.
What were you expecting to happen?
That error does not appear
Any logs, error output, etc.?
Error: the XML response that was returned from the server is invalid. Received: SQLSTATE[HY000] [1203] User already has more than 'max_user_connections' active connections
Any other comments?
Even though another user has written about this error before, the solution given is very fuzzy and doesn't fix anything.
I first increased the value of max_user_connections to 25 as recommended on Discord and the error continued. Then I went up from 25 to 150 and it still gives the same error. Only 4 game servers are linked. Both the servers and the website have their own user.
How many connections are necessary to solve the problem? Since normal web hosting is not enough and it is already necessary to self-host the database or look for a serverless solution.
https://github.com/sbpp/sourcebans-pp/issues/564
What versions of software are you using?
Operating System: Debian 11 SourceBans++ Version: Stable Latest PHP Version: 8.2 or 8.3 MySQL Version: MariaDB 10.3.1 Link to your project: Link to a phpinfo() output: