Openfire never attempts to reconnect when MySQL "Too many connections" error occurs

Openfire Openfire Support
1

Situation:

  • Openfire is running with a MySQL backend and authenticating against Active Directory/LDAP

  • MySQL backend gets “too many connections” due to a problem unrelated to Openfire.

  • Openfire stops “working”, as it can’t retrieve the users’ rosters.

  • MySQL database is restarted, or MySQL connections are killed to free connections.

As far as I can see, there are two problems:

  1. Openfire should return an error to the users, rather than stalling their connection forever

  2. Openfire should resume operation automatically once the MySQL server has available connections.

1 Like