Thanks a lot for the detailed description Can you reproduce it on a blank store? Otherwise would you be able to share the stores?
I asked the eng team for their feedback, Let's see Sent from mobile device Am 23.04.2014 um 13:27 schrieb Gwendal Mousset <[email protected]>: > In reading the 2.0.2 changlog I see the fix "Fixes an issue where indexes > that have been dropped would fail recovery if commands to activate them were > run in recovery." > > Can it be a solution to the issue I have ? > > On Tuesday, April 22, 2014 4:23:49 PM UTC+2, Gwendal Mousset wrote: >> >> to continue... >> >> - >I try recreating constraint but no effect, may be because the constraint >> already exists (without the associated index). >> -> I try drop constraint -> transaction error, Neo4j became unstable and >> need to be restarted. >> >> So I don't see how to repair the db... >> >> >> On Tuesday, April 22, 2014 10:48:58 AM UTC+2, Gwendal Mousset wrote: >>> >>> Hi Michael, >>> >>> On my 2 instances I see the same things (the index on user has been created >>> by I manually to make some test): >>> >>> Indexes >>> ON :User(id) ONLINE >>> ON :_User(id) ONLINE >>> >>> Constraints >>> ON (uip:Uip) ASSERT uip.id IS UNIQUE >>> ON (abstractuuidnode:AbstractUUIDNode) ASSERT abstractuuidnode.id IS >>> UNIQUE >>> ON (i18nlocale:I18nLocale) ASSERT i18nlocale.language IS UNIQUE >>> ON (user:User) ASSERT user.id IS UNIQUE >>> ON (category:Category) ASSERT category.id IS UNIQUE >>> ON (invitation:Invitation) ASSERT invitation.id IS UNIQUE >>> ON (event:Event) ASSERT event.id IS UNIQUE >>> ON (i18nresource:I18nResource) ASSERT i18nresource.id IS UNIQUE >>> ON (purchasableitem:PurchasableItem) ASSERT purchasableitem.id IS UNIQUE >>> ON (betcomment:BetComment) ASSERT betcomment.id IS UNIQUE >>> ON (bet:Bet) ASSERT bet.id IS UNIQUE >>> ON (betanswer:BetAnswer) ASSERT betanswer.id IS UNIQUE >>> ON (abstractuuidrelationship:AbstractUUIDRelationship) ASSERT >>> abstractuuidrelationship.id IS UNIQUE >>> ON (country:Country) ASSERT country.code IS UNIQUE >>> >>> It seems that all indexes have disappeared. >>> >>> When I start my app on a clean db, the index status is: >>> >>> Indexes >>> ON :AbstractUUIDNode(id) ONLINE (for uniqueness constraint) >>> ON :AbstractUUIDRelationship(id) ONLINE (for uniqueness constraint) >>> ON :Bet(id) ONLINE (for uniqueness constraint) >>> ON :BetAnswer(id) ONLINE (for uniqueness constraint) >>> ON :BetComment(id) ONLINE (for uniqueness constraint) >>> ON :Category(id) ONLINE (for uniqueness constraint) >>> ON :Country(code) ONLINE (for uniqueness constraint) >>> ON :Event(id) ONLINE (for uniqueness constraint) >>> ON :I18nLocale(language) ONLINE (for uniqueness constraint) >>> ON :I18nResource(id) ONLINE (for uniqueness constraint) >>> ON :Invitation(id) ONLINE (for uniqueness constraint) >>> ON :PurchasableItem(id) ONLINE (for uniqueness constraint) >>> ON :Uip(id) ONLINE (for uniqueness constraint) >>> ON :User(id) ONLINE (for uniqueness constraint) >>> >>> Constraints >>> ON (uip:Uip) ASSERT uip.id IS UNIQUE >>> ON (abstractuuidnode:AbstractUUIDNode) ASSERT abstractuuidnode.id IS >>> UNIQUE >>> ON (i18nlocale:I18nLocale) ASSERT i18nlocale.language IS UNIQUE >>> ON (user:User) ASSERT user.id IS UNIQUE >>> ON (category:Category) ASSERT category.id IS UNIQUE >>> ON (invitation:Invitation) ASSERT invitation.id IS UNIQUE >>> ON (event:Event) ASSERT event.id IS UNIQUE >>> ON (i18nresource:I18nResource) ASSERT i18nresource.id IS UNIQUE >>> ON (purchasableitem:PurchasableItem) ASSERT purchasableitem.id IS UNIQUE >>> ON (betcomment:BetComment) ASSERT betcomment.id IS UNIQUE >>> ON (bet:Bet) ASSERT bet.id IS UNIQUE >>> ON (betanswer:BetAnswer) ASSERT betanswer.id IS UNIQUE >>> ON (abstractuuidrelationship:AbstractUUIDRelationship) ASSERT >>> abstractuuidrelationship.id IS UNIQUE >>> ON (country:Country) ASSERT country.code IS UNIQUE >>> >>> So each unicity constraint has it own index. >>> >>> I tried to manually drop index to make some tests: >>> >>> drop index on :User(id) >>> Neo4j throws an error. >>> Unable to drop index on :User(id): Index belongs to constraint: :User(id) >>> >>> So, it's very strange, because neo4j doesn't accept to have a unicity >>> constraint without corresponding index, but they have all been dropped... >>> >>> Maybe a Neo4j bug ? >>> >>> Thanks >>> >>> >>> >>> On Friday, April 18, 2014 9:28:04 PM UTC+2, Michael Hunger wrote: >>>> >>>> Does this happen on both machines? >>>> >>>> Does it also happen on the store when you start it directly with shell or >>>> single instance when you try accessing the index? >>>> >>>> Can you check your indexes with the schema command in the shell? >>>> >>>> Thx >>>> >>>> Sent from mobile device >>>> >>>> Am 18.04.2014 um 18:46 schrieb Gwendal Mousset <[email protected]>: >>>> >>>> Hi all, >>>> >>>> I'm using Neo4j 2.0.1 with SDN 3.0.1. Neo4j works IN HA mode with 2 server >>>> instances. >>>> >>>> My application was working normally for days and until a problem appears. >>>> I work with neo4j for 6 month and it's the first time get this exception. >>>> I restart the web app and the neo4j instances without success, the >>>> database seems "broken". >>>> >>>> What can I do to repaire and fix this problem ? >>>> >>>> The stack trace : >>>> >>>> An unexpected error has occured: No such index found. Label: `User` >>>> Property name: `id` at IndexHintException >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.EntityProducerFactory$$anonfun$7$$anonfun$13.apply(EntityProducerFactory.scala:141) >>>> >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.EntityProducerFactory$$anonfun$7$$anonfun$13.apply(EntityProducerFactory.scala:141) >>>> scala.Option.getOrElse(Option.scala:120) >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.EntityProducerFactory$$anonfun$7.applyOrElse(EntityProducerFactory.scala:140) >>>> >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.EntityProducerFactory$$anonfun$7.applyOrElse(EntityProducerFactory.scala:119) >>>> scala.PartialFunction$OrElse.apply(PartialFunction.scala:162) >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.EntityProducerFactory$$anonfun$2.applyOrElse(EntityProducerFactory.scala:61) >>>> >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.EntityProducerFactory$$anonfun$2.applyOrElse(EntityProducerFactory.scala:61) >>>> scala.PartialFunction$OrElse.apply(PartialFunction.scala:162) >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.EntityProducerFactory$$anonfun$1.applyOrElse(EntityProducerFactory.scala:49) >>>> >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.EntityProducerFactory$$anonfun$1.applyOrElse(EntityProducerFactory.scala:49) >>>> scala.PartialFunction$OrElse.apply(PartialFunction.scala:162) >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.EntityProducerFactory$$anonfun$3.applyOrElse(EntityProducerFactory.scala:70) >>>> >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.EntityProducerFactory$$anonfun$3.applyOrElse(EntityProducerFactory.scala:70) >>>> scala.PartialFunction$OrElse.apply(PartialFunction.scala:162) >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.MergeStartPointBuilder$$anonfun$5.apply(MergeStartPointBuilder.scala:103) >>>> >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.MergeStartPointBuilder$$anonfun$5.apply(MergeStartPointBuilder.scala:102) >>>> >>>> scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244) >>>> >>>> scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244) >>>> scala.collection.immutable.List.foreach(List.scala:318) >>>> scala.collection.TraversableLike$class.map(TraversableLike.scala:244) >>>> scala.collection.AbstractTraversable.map(Traversable.scala:105) >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.MergeStartPointBuilder.org$neo4j$cypher$internal$compiler$v2_0$executionplan$builders$MergeStartPointBuilder$$findNodeProducer(MergeStartPointBuilder.scala:102) >>>> >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.MergeStartPointBuilder$$anonfun$org$neo4j$cypher$internal$compiler$v2_0$executionplan$builders$MergeStartPointBuilder$$solveUnsolvedMergePoints$1.apply(MergeStartPointBuilder.scala:58) >>>> >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.MergeStartPointBuilder$$anonfun$org$neo4j$cypher$internal$compiler$v2_0$executionplan$builders$MergeStartPointBuilder$$solveUnsolvedMergePoints$1.apply(MergeStartPointBuilder.scala:56) >>>> >>>> org.neo4j.cypher.internal.compiler.v2_0.executionplan.builders.QueryToken.map(QueryToken.scala:30) >>>> org.neo4j.cypher.internal.compiler<spa >>>> ... > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
