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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*