{"action":"created","issue":{"url":"https://api.github.com/repos/scullxbones/akka-persistence-mongo/issues/136","repository_url":"https://api.github.com/repos/scullxbones/akka-persistence-mongo","labels_url":"https://api.github.com/repos/scullxbones/akka-persistence-mongo/issues/136/labels{/name}","comments_url":"https://api.github.com/repos/scullxbones/akka-persistence-mongo/issues/136/comments","events_url":"https://api.github.com/repos/scullxbones/akka-persistence-mongo/issues/136/events","html_url":"https://github.com/scullxbones/akka-persistence-mongo/issues/136","id":196017500,"number":136,"title":"Error message \"Sort exceeded memory limit of 104857600 bytes\" when creating PersistenceActor","user":{"login":"thjaeckle","id":1331526,"avatar_url":"https://avatars.githubusercontent.com/u/1331526?v=3","gravatar_id":"","url":"https://api.github.com/users/thjaeckle","html_url":"https://github.com/thjaeckle","followers_url":"https://api.github.com/users/thjaeckle/followers","following_url":"https://api.github.com/users/thjaeckle/following{/other_user}","gists_url":"https://api.github.com/users/thjaeckle/gists{/gist_id}","starred_url":"https://api.github.com/users/thjaeckle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thjaeckle/subscriptions","organizations_url":"https://api.github.com/users/thjaeckle/orgs","repos_url":"https://api.github.com/users/thjaeckle/repos","events_url":"https://api.github.com/users/thjaeckle/events{/privacy}","received_events_url":"https://api.github.com/users/thjaeckle/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-12-16T09:39:57Z","updated_at":"2016-12-16T09:43:46Z","closed_at":"2016-12-16T09:43:46Z","body":"Hi.\r\nWe're getting following Exception when instantiating a PersistenceActor (using version 1.2.5 of akka-persistence-mongo):\r\n\r\n```\r\nakka.actor.ActorInitializationException: akka://things-cluster/user/thingsRoot/things/StreamSupervisor-0/flow-655798-1-actorPublisherSource: exception during creation\r\n\tat akka.actor.ActorInitializationException$.apply(Actor.scala:174)\r\n\tat akka.actor.ActorCell.create(ActorCell.scala:607)\r\n\tat akka.actor.ActorCell.invokeAll$1_aroundBody2(ActorCell.scala:461)\r\n\tat akka.actor.ActorCell$AjcClosure3.run(ActorCell.scala:1)\r\n\tat org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)\r\n\tat akka.kamon.instrumentation.ActorSystemMessageInstrumentation$$anonfun$aroundSystemMessageInvoke$1.apply(ActorSystemMessageInstrumentation.scala:34)\r\n\tat kamon.trace.Tracer$.withContext(TracerModule.scala:58)\r\n\tat akka.kamon.instrumentation.ActorSystemMessageInstrumentation.aroundSystemMessageInvoke(ActorSystemMessageInstrumentation.scala:34)\r\n\tat akka.actor.ActorCell.invokeAll$1(ActorCell.scala:1)\r\n\tat akka.actor.ActorCell.systemInvoke(ActorCell.scala:483)\r\n\tat akka.dispatch.Mailbox.processAllSystemMessages(Mailbox.scala:282)\r\n\tat akka.dispatch.Mailbox.run(Mailbox.scala:223)\r\n\tat akka.dispatch.Mailbox.exec(Mailbox.scala:234)\r\n\tat scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)\r\n\tat scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)\r\n\tat scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)\r\n\tat scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)\r\nCaused by: com.mongodb.MongoCommandException: Command failed with error 16819: 'Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.' on server mongodb-server.ourhost:30000. The full response is { \"ok\" : 0.0, \"errmsg\" : \"Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.\", \"code\" : 16819 }\r\n\tat com.mongodb.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:115)\r\n\tat com.mongodb.connection.CommandProtocol.execute(CommandProtocol.java:114)\r\n\tat com.mongodb.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:159)\r\n\tat com.mongodb.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:286)\r\n\tat com.mongodb.connection.DefaultServerConnection.command(DefaultServerConnection.java:173)\r\n\tat com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:215)\r\n\tat com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:206)\r\n\tat com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:112)\r\n\tat com.mongodb.operation.AggregateOperation$1.call(AggregateOperation.java:227)\r\n\tat com.mongodb.operation.AggregateOperation$1.call(AggregateOperation.java:223)\r\n\tat com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:239)\r\n\tat com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:212)\r\n\tat com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:223)\r\n\tat com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:65)\r\n\tat com.mongodb.Mongo.execute(Mongo.java:772)\r\n\tat com.mongodb.Mongo$2.execute(Mongo.java:759)\r\n\tat com.mongodb.DBCollection.aggregate(DBCollection.java:1377)\r\n\tat com.mongodb.DBCollection.aggregate(DBCollection.java:1347)\r\n\tat com.mongodb.casbah.MongoCollectionBase$class.aggregate(MongoCollection.scala:710)\r\n\tat com.mongodb.casbah.MongoCollection.aggregate(MongoCollection.scala:1106)\r\n\tat com.mongodb.casbah.MongoCollectionBase$class.aggregate(MongoCollection.scala:685)\r\n\tat com.mongodb.casbah.MongoCollection.aggregate(MongoCollection.scala:1106)\r\n\tat akka.contrib.persistence.mongodb.SequenceNumbersOfPids.initialCursor(CrCasbahPersistenceReadJournaller.scala:107)\r\n\tat akka.contrib.persistence.mongodb.SequenceNumbersOfPids.initialCursor(CrCasbahPersistenceReadJournaller.scala:98)\r\n\tat akka.contrib.persistence.mongodb.SyncActorPublisher$class.preStart(MongoReadJournal.scala:201)\r\n\tat akka.contrib.persistence.mongodb.SequenceNumbersOfPids.preStart(CrCasbahPersistenceReadJournaller.scala:98)\r\n\tat akka.actor.Actor$class.aroundPreStart(Actor.scala:489)\r\n\tat akka.contrib.persistence.mongodb.SequenceNumbersOfPids.akka$stream$actor$ActorPublisher$$super$aroundPreStart(CrCasbahPersistenceReadJournaller.scala:98)\r\n\tat akka.stream.actor.ActorPublisher$class.aroundPreStart(ActorPublisher.scala:338)\r\n\tat akka.contrib.persistence.mongodb.SequenceNumbersOfPids.aroundPreStart(CrCasbahPersistenceReadJournaller.scala:98)\r\n\tat akka.actor.ActorCell.create(ActorCell.scala:590)\r\n\t... 15 common frames omitted\r\n```\r\n\r\nI currently cannot see for which specific persistenceIds this is happening, could be that those are PersistenceActor with a lot of events in their journal.\r\n\r\nWould it be an option to set the \"allowDiskUse:true\" to the query made there? Or is this just fighting \tsymptoms?"},"comment":{"url":"https://api.github.com/repos/scullxbones/akka-persistence-mongo/issues/comments/267555581","html_url":"https://github.com/scullxbones/akka-persistence-mongo/issues/136#issuecomment-267555581","issue_url":"https://api.github.com/repos/scullxbones/akka-persistence-mongo/issues/136","id":267555581,"user":{"login":"thjaeckle","id":1331526,"avatar_url":"https://avatars.githubusercontent.com/u/1331526?v=3","gravatar_id":"","url":"https://api.github.com/users/thjaeckle","html_url":"https://github.com/thjaeckle","followers_url":"https://api.github.com/users/thjaeckle/followers","following_url":"https://api.github.com/users/thjaeckle/following{/other_user}","gists_url":"https://api.github.com/users/thjaeckle/gists{/gist_id}","starred_url":"https://api.github.com/users/thjaeckle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thjaeckle/subscriptions","organizations_url":"https://api.github.com/users/thjaeckle/orgs","repos_url":"https://api.github.com/users/thjaeckle/repos","events_url":"https://api.github.com/users/thjaeckle/events{/privacy}","received_events_url":"https://api.github.com/users/thjaeckle/received_events","type":"User","site_admin":false},"created_at":"2016-12-16T09:43:46Z","updated_at":"2016-12-16T09:43:46Z","body":"Aah, first think then post.\r\nSorry, I just realized that the \"SequenceNumbersOfPids\" is our own ReadJournal query.\r\n\r\nNothing wrong in akka-persistence-mongo.\r\n\r\nSorry again"}}
{"actor":{"display_login":"thjaeckle"}}