Thanks, Endre A colleague of mine already submitted an issue to them but we haven't received any response yet: https://github.com/dnvriend/akka-persistence-jdbc/issues/9 . Is it possible to have the coordinator's persistence use a different journal than the one used by our own persistent actors?
El martes, 23 de diciembre de 2014 14:42:24 UTC-5, Akka Team escribió: > > Hi Miguel, > > This seems to be a journal issue. You should contact the maintainer of the > JDBC journal. > > -Endre > > On Tue, Dec 23, 2014 at 7:43 PM, Miguel Vilá <[email protected] > <javascript:>> wrote: > >> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at http://groups.google.com/group/akka-user. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Akka Team > Typesafe - The software stack for applications that scale > Blog: letitcrash.com > Twitter: @akkateam > -- >>>>>>>>>> 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.
