search

sbpp / sourcebans-pp

Admin, ban, and comms management system for the Source engine
https://sbpp.github.io/
Creative Commons Attribution Share Alike 4.0 International
327 stars 175 forks source link

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

Closed sys-arch closed 1 month ago

sys-arch commented 1 month ago

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 commented 1 month ago

Since there is no response and interest, it has been fixed by going to an older, more functional version.