Keycloak doesn't re-evaluate DNS for the database

[cvarjao]

When patroni failover to a new master, keycloak doesn't seem to detect that and keeps re-using the IP of the previous master which is now in read-only mode. It seems to keep a lock to the IP.

It may be related to java DNS lookup caching

Workaround: Flush connections to fore connections to be established.

[brycereid73]

Test if this is still an issue in Sandbox.

[arcshiftsolutions]

This is still an issue; our team had issues during a node drain recently.

[zsamji]

closing and tracking here bcgov/sso-keycloak#72