facebookarchive / fbctf

Platform to host Capture the Flag competitions
Other
6.52k stars 1.32k forks source link

mySQL "too many connections" error #696

Open ghost opened 4 years ago

ghost commented 4 years ago

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 commented 4 years ago

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?