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

Samebug tips1

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>


rafaelrafael

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Stack trace

  • 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 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 Main$$anonfun$clean$1.apply(Main.scala:39) at Main$$anonfun$clean$1.apply(Main.scala:38) at scala.collection.immutable.List.map(List.scala:277) at Main$.clean(Main.scala:38) at Main$$anonfun$1$$anonfun$6$$anonfun$2.apply$mcJ$sp(Main.scala:59) at Main$$anonfun$1$$anonfun$6$$anonfun$2.apply(Main.scala:59) at Main$$anonfun$1$$anonfun$6$$anonfun$2.apply(Main.scala:59) at scala.util.Try$.apply(Try.scala:192) at Main$$anonfun$1$$anonfun$6.apply(Main.scala:59) at Main$$anonfun$1$$anonfun$6.apply(Main.scala:57) 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 Main$$anonfun$1.apply$mcV$sp(Main.scala:56) at Main$$anonfun$1.apply(Main.scala:56) at Main$$anonfun$1.apply(Main.scala:56) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(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)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

serious2monkeysserious2monkeys
4 times, last one
Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
derproggerderprogger
Once,
Unknown UserUnknown User
7 times, last one
91 more bugmates