org.postgresql.util.PSQLException: ERROR: restart transaction: txn "sql/executor.go:492 sql txn" id=8af60dec key=/Table/52/2/1473772745977/"ns0"/"k28"/0 rw=false pri=0.03528562 iso=SERIALIZABLE stat=PENDING epo=1 ts=1473775603.683415039,1 orig=1473775603.683415039,1 max=1473775599.758548667,0 wto=false rop=false failed to push "sql/executor.go:492 sql txn" id=2f6d7d07 key=/Table/52/1/"ns0"/"k28"/0 rw=true pri=0.03528567 iso=SERIALIZABLE stat=PENDING epo=0 ts=1473775603.679379439,0 orig=1473775603.679379439,0 max=1473775603.679379439,0 wto=false rop=false

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

,
via stackoverflow.com by Unknown author

Upgrade the database driver to the latest and check.

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>9.3-1101-jdbc41</version>
</dependency>

Replace version with the latest driver version.

,
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 GitHub by kosii
, 1 year ago
=1473775599.758548667,0 wto=false rop=false failed to push "sql/executor.go:492 sql txn" id=2f6d7d07 key=/Table/52/1/"ns0"/"k28"/0 rw=true pri=0.03528567 iso=SERIALIZABLE stat=PENDING epo=0 ts=1473775603.679379439,0 orig=1473775603.679379439,0 max=1473775603.679379439,0 wto=false rop=false
via JIRA by Nicky Kernohan, 4 months ago
ERROR: invalid input syntax for type json Detail: Escape sequence "\�" is invalid. Where: JSON data, line 1: ...SpiritMQConnectionFactory/RefAddr/10/Content=\�...
via GitHub by rdp
, 1 year ago
ERROR: canceling statement due to user request
via Stack Overflow by Aarish
, 11 months ago
ERROR: function array_remove(text[], character varying) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 60
via Stack Overflow by displayname
, 2 months ago
ERROR: null value in column "created" violates not-null constraint Detail: Failing row contains (1, null, null, null, $2a$10$0GEFgVryvwG3Dv5LN1tg6evPpl4wQ9uJOWiMKMyZq8HVQXCMRt.kS, null, test).
via Atlassian JIRA by Nick Menere [Atlassian], 1 year ago
ERROR: update or delete on "content" violates foreign key constraint "fk9eb4c0e0c45e94dc" on "ancestors" Detail: Key (contentid)=(69518087748070383) is still referenced from table "ancestors".
org.postgresql.util.PSQLException: ERROR: restart transaction: txn "sql/executor.go:492 sql txn" id=8af60dec key=/Table/52/2/1473772745977/"ns0"/"k28"/0 rw=false pri=0.03528562 iso=SERIALIZABLE stat=PENDING epo=1 ts=1473775603.683415039,1 orig=1473775603.683415039,1 max=1473775599.758548667,0 wto=false rop=false failed to push "sql/executor.go:492 sql txn" id=2f6d7d07 key=/Table/52/1/"ns0"/"k28"/0 rw=true pri=0.03528567 iso=SERIALIZABLE stat=PENDING epo=0 ts=1473775603.679379439,0 orig=1473775603.679379439,0 max=1473775603.679379439,0 wto=false rop=false
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:133)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at scalikejdbc.DBConnectionAttributesWiredPreparedStatement.executeUpdate(DBConnectionAttributesWiredPreparedStatement.scala:79)
at scalikejdbc.StatementExecutor$$anonfun$executeUpdate$1.apply$mcI$sp(StatementExecutor.scala:342)
at scalikejdbc.StatementExecutor$$anonfun$executeUpdate$1.apply(StatementExecutor.scala:342)
at scalikejdbc.StatementExecutor$$anonfun$executeUpdate$1.apply(StatementExecutor.scala:342)
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.scala:18)
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(StatementExecutor.scala:320)
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(StatementExecutor.scala:264)
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(StatementExecutor.scala:320)
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(StatementExecutor.scala:297)
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:320)
at scalikejdbc.StatementExecutor.executeUpdate(StatementExecutor.scala:342)
at scalikejdbc.DBSession$$anonfun$updateWithFilters$1.apply(DBSession.scala:477)
at scalikejdbc.DBSession$$anonfun$updateWithFilters$1.apply(DBSession.scala:475)
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18)
at scalikejdbc.ActiveSession.scalikejdbc$DBSession$$super$using(DBSession.scala:706)
at scalikejdbc.DBSession$class.using(DBSession.scala:30)
at scalikejdbc.ActiveSession.using(DBSession.scala:706)
at scalikejdbc.DBSession$class.updateWithFilters(DBSession.scala:474)
at scalikejdbc.ActiveSession.updateWithFilters(DBSession.scala:706)
at scalikejdbc.DBSession$class.updateWithFilters(DBSession.scala:449)
at scalikejdbc.ActiveSession.updateWithFilters(DBSession.scala:706)
at scalikejdbc.SQLUpdate.apply(SQL.scala:632)
at undefined.Main$$anonfun$clean$1.apply(Main.scala:39)
at undefined.Main$.clean(Main.scala:38)
at undefined.Main$$anonfun$1$$anonfun$6$$anonfun$2.apply$mcJ$sp(Main.scala:59)
at undefined.Main$$anonfun$1$$anonfun$6$$anonfun$2.apply(Main.scala:59)
at scala.util.Try$.apply(Try.scala:192)
at undefined.Main$$anonfun$1$$anonfun$6.apply(Main.scala:59)
at scalikejdbc.DBConnection$$anonfun$3.apply(DBConnection.scala:305)
at scalikejdbc.DBConnection$class.scalikejdbc$DBConnection$$rollbackIfThrowable(DBConnection.scala:274)
at scalikejdbc.DBConnection$class.localTx(DBConnection.scala:303)
at scalikejdbc.DB.localTx(DB.scala:60)
at scalikejdbc.DB$.localTx(DB.scala:260)
at undefined.Main$$anonfun$1.apply$mcV$sp(Main.scala:56)
at undefined.Main$$anonfun$1.apply(Main.scala:56)
at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

37 times, 1 week ago
3 times, 1 month ago
Once, 2 months ago
Once, 2 months ago
32 times, 2 months ago

Write tip

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