PostgreSQL remains in read only mode after failover in the high-availability mode - Documentation for BMC TrueSight Presentation Server 11.3.04

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)

You Might Also Like