Resolve Dative not working — 2024-06-04

[jrwdunham]

Problem: Requests to OLD API return 500.

AC:

• Figure out and document the root cause in this ticket.
• Solve the issue: ensure users can login via Dative and use the system.

[jrwdunham]

Root cause: MySQL connections sleeping for up to 8h! (Root cause of that is that SQLAlchemy is misconfigured and/or one MySQL database per OLD instance is bad architecture.)

Resolution: set MySQL wait_timeout to 300, ie 5m.

Added the following to /etc/mysql/my.cnf, which sets the connection timeout to 5 minutes:

  [mysqld]
  wait_timeout = 300
  interactive_timeout = 300