sourcebans-pp icon indicating copy to clipboard operation
sourcebans-pp copied to clipboard

[AJAX] SQLSTATE[HY000] [1203] User already has more than 'max_user_connections' active connections

Open sys-arch opened this issue 9 months ago • 0 comments

What are the steps to reproduce this issue?

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

sys-arch avatar May 20 '24 09:05 sys-arch