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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via JIRA by Rafael Chaves, 1 year ago
ERROR: cannot execute UPDATE in a read-only transaction
via JIRA by Rafael Chaves, 1 year ago
ERROR: cannot execute UPDATE in a read-only transaction
via adempiere by vpj-cd
, 1 year ago
ERROR: column "entitytype" cannot be cast to type "pg\_catalog.numeric"; State=42804; ErrorCode=0
via Google Groups by Michael Paesold, 3 months ago
ERROR: syntax error at or near "$2"
via Google Groups by Csaba Nagy, 3 months ago
via Stack Overflow by Zsolt J&#225;nos
, 2 months ago
ERROR: syntax error at or near "$2" Position: 177
org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at liquibase.executor.jvm.JdbcExecutor$1UpdateStatementCallback.doInStatement(JdbcExecutor.java:231)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.update(JdbcExecutor.java:240)
at liquibase.executor.jvm.JdbcExecutor.update(JdbcExecutor.java:214)
at liquibase.lockservice.StandardLockService.releaseLock(StandardLockService.java:232)
at liquibase.Liquibase.update(Liquibase.java:264)
at liquibase.Liquibase.update(Liquibase.java:240)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
102 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.