Skip to content
This repository has been archived by the owner on Mar 3, 2020. It is now read-only.

mySQL "too many connections" error #696

Open
ghost opened this issue Feb 3, 2020 · 1 comment
Open

mySQL "too many connections" error #696

ghost opened this issue Feb 3, 2020 · 1 comment

Comments

@ghost
Copy link

ghost commented Feb 3, 2020

Please include the following information when filing an issue
• Current version of FBCTF installed (commit head)
I believe I am running the latest version by I am not sure how to confirm an actual version number.

• System and Installation details, such as the Linux distribution used, and installation method you chose.
Ubuntu 16.04.04 LTS Automatic installation per admin documentation

• Detailed description of the problem. Include steps to reproduce the problem when possible.
After a few minutes of play with as few as 20 participants, the players receive the "Start Over Error" on the gameboard over and over again. The problem persists and occurs for all players every couple of minutes where they must refresh their browsers and login again. The hhvm error log indicates "too many connections" to the mysql database even the maximum connection pool was increased to 214. why are there so many connections to the mysql database?

• Relevant output from any logs examined.
image
This error occurs rapidly until the game ends once the error starts.

• Any steps you have taken to resolve the issue.
I have tried increasing the number of concurrent connections but fear it will be exhausted given the ratio I have experienced of database connections per user.

@ghost
Copy link
Author

ghost commented Feb 6, 2020

today I experienced this error again. This time the mysql connections error did not appear. I restarted the server and after less than 5 minutes the error appeared again. I then flushed memcache from the control panel. The game ran without error for 10 minutes until we received the error again. I once again flushed memcache and the error went away for 10 minutes at which point we were done. There were 15 users, 58 active quiz levels / countries.

Is anyone monitoring issues?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

0 participants