PostgreSQL remains in read only mode after failover in the high-availability mode

In the high-availability mode, when the TrueSight Presentation Server recovers from a failover, the components that are connected to the TrueSight Presentation Server including PostgreSQL remain in the read-only mode. The following error appear in the TrueSight.log file:

Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)

Workaround

Do one of the following:

• If the primary TrueSight Presentation Server is down, restart the secondary TrueSight Presentation Server.
• If the primary TrueSight Presentation Server is up, do the following:
  1. Stop the secondary TrueSight Presentation Server that has the PostgreSQL in the read-only mode.
  2. Restart the primary TrueSight Presentation Server.
  3. Start the secondary TrueSight Presentation Server.

Where to go from here

Troubleshooting the Presentation Server and the TrueSight console.