While testing koa.test01 on Ubuntu 20.04, I’ve encountered a few issues with database communication.
We’re running MySQL on a backend system and we never had database issues with MySQL 5.6 and previous Open edX releases.
It all starts with a few error messages of the type “2020-11-25T12:35:32.282538Z 2997 [Note] Aborted connection 2997 to db: ‘discovery’ user: ‘discov001’ host: ‘ip-10-0-0-71.ec2.internal’ (Got timeout reading communication packets)”. It could be any user connecting to the database.
Then at one point, I get “too many connections” and the LMS and CMS just freezes and I need to restart MySQL in order to unfreeze them again.
I was wondering if anyone testing Koa right now has encountered these error messages in their MySQL logs? I was able to reproduce this on two different installations now. I am therefore a little bit worried.
By the way, does Open edX provide specific parameters to use for MySQL? I don’t remember seeing anything special.