Hi all,
I'm having a problem with akka-persistence and akka-sharding. Every now and
then, sometimes after running our app for a long time I get this error:
DELETE FROM USERSIS.snapshot WHERE persistence_id =
'/user/sharding/TokenRouterCoordinator/singleton/coordinator' AND
sequence_nr = 2
[ERROR] [12/18/2014 13:51:28.826] [TokenCluster-akka.actor.default-
dispatcher-16] [akka://TokenCluster/system/snapshot-store] No more data to
read from socket
java.sql.SQLRecoverableException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(
T4CPreparedStatement.java:1046)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
OracleStatement.java:1336)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
OraclePreparedStatement.java:3613)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(
OraclePreparedStatementWrapper.java:1354)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:105)
at scalikejdbc.StatementExecutor$$anonfun$executeUpdate$1.apply$mcI$sp(
StatementExecutor.scala:337)
at scalikejdbc.StatementExecutor$$anonfun$executeUpdate$1.apply(
StatementExecutor.scala:337)
at scalikejdbc.StatementExecutor$$anonfun$executeUpdate$1.apply(
StatementExecutor.scala:337)
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.
scala:33)
at scalikejdbc.StatementExecutor$$anon$1.
scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(
StatementExecutor.scala:317)
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(
StatementExecutor.scala:264)
at scalikejdbc.StatementExecutor$$anon$1.
scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(
StatementExecutor.scala:317)
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(
StatementExecutor.scala:295)
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:
317)
at scalikejdbc.StatementExecutor.executeUpdate(StatementExecutor.scala:
337)
at scalikejdbc.DBSession$$anonfun$updateWithFilters$1.apply(DBSession.
scala:352)
at scalikejdbc.DBSession$$anonfun$updateWithFilters$1.apply(DBSession.
scala:350)
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:33)
at scalikejdbc.ActiveSession.using(DBSession.scala:457)
at scalikejdbc.DBSession$class.updateWithFilters(DBSession.scala:349)
at scalikejdbc.ActiveSession.updateWithFilters(DBSession.scala:457)
at scalikejdbc.DBSession$class.updateWithFilters(DBSession.scala:327)
at scalikejdbc.ActiveSession.updateWithFilters(DBSession.scala:457)
at scalikejdbc.SQLUpdate$$anonfun$10.apply(SQL.scala:486)
at scalikejdbc.SQLUpdate$$anonfun$10.apply(SQL.scala:486)
at scalikejdbc.DBConnection$class.autoCommit(DBConnection.scala:183)
at scalikejdbc.DB.autoCommit(DB.scala:75)
at scalikejdbc.DB$$anonfun$autoCommit$1.apply(DB.scala:218)
at scalikejdbc.DB$$anonfun$autoCommit$1.apply(DB.scala:217)
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:33)
at scalikejdbc.DB$.using(DB.scala:150)
at scalikejdbc.DB$.autoCommit(DB.scala:217)
at scalikejdbc.SQLUpdate.apply(SQL.scala:486)
at akka.persistence.jdbc.snapshot.GenericStatements$class.deleteSnapshot
(Statements.scala:30)
at akka.persistence.jdbc.snapshot.OracleSyncSnapshotStore.deleteSnapshot
(SnapshotStores.scala:16)
at akka.persistence.jdbc.snapshot.JdbcSyncSnapshotStore$class.delete(
JdbcSyncSnapshotStore.scala:34)
at akka.persistence.jdbc.snapshot.OracleSyncSnapshotStore.delete(
SnapshotStores.scala:16)
at akka.persistence.snapshot.SnapshotStore$$anonfun$receive$1.
applyOrElse(SnapshotStore.scala:44)
at akka.actor.Actor$class.aroundReceive(Actor.scala:465)
at akka.persistence.jdbc.snapshot.OracleSyncSnapshotStore.aroundReceive(
SnapshotStores.scala:16)
at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516)
at akka.actor.ActorCell.invoke(ActorCell.scala:487)
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238)
at akka.dispatch.Mailbox.run(Mailbox.scala:220)
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)
So it looks like the persistence of the shard coordinators is failing. We
are using a jdbc journal with this plugin:
https://github.com/dnvriend/akka-persistence-jdbc/ .
Any idea what may be causing this?
Thanks,
Miguel Vilá
--
>>>>>>>>>> Read the docs: http://akka.io/docs/
>>>>>>>>>> Check the FAQ:
>>>>>>>>>> http://doc.akka.io/docs/akka/current/additional/faq.html
>>>>>>>>>> Search the archives: https://groups.google.com/group/akka-user
---
You received this message because you are subscribed to the Google Groups "Akka
User List" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/akka-user.
For more options, visit https://groups.google.com/d/optout.
