Foglight not accessible after backend PostgreSQL database cluster fail-over (4292163)

FMS repository is configured as a 3 node PostgreSQL cluster with 1 active node (read-write) and 2 standby (read-only) nodes. Foglight is configured to connect to a VIP address that always directs to the primary node.

After a fail-over of the backend database it is not possible to access the Foglight console. The following messages are logged in the Management Server logs:

YYYY-MM-DD hh:mm:ss.SSS ERROR   [DataAccess-9-thread-4] com.quest.nitro.service.persistence.obs.handler.query.AbstractBatchQueryExecutor - An error has occurred while processing the MetricBatchRetrieveLastNValues batch query.

org.postgresql.util.PSQLException: ERROR: cannot execute CREATE TABLE in a read-only transaction

WORKAROUND

Note: Using a clustered PostgreSQL configuration as a FMS repository has not been validated as supported by Quest R&D.

1. Modify the database connection string parameter in '$FMS_HOME/config/server.config' to:

server.database.url = "jdbc:postgresql://node1,node2,node3/databaseName?targetServerType=primary";

server.vm.optionX = "-Dsun.net.inetaddr.ttl=60";

Note: There are multiple PostgreSQL cluster solutions and the same configuration parameters may not work in all scenarios. The above parameters were used for a 3 node PostgreSQL cluster managed by Patroni.

STATUS

Enhancement request FOGGENERAL-I-201 has been submitted for consideration in a future release of the Foglight Management Server.