Hi Michael, Any news from the neo4j team ?
Thanks On Wednesday, April 23, 2014 2:22:25 PM UTC+2, Michael Hunger wrote: > > 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]<javascript:> > >: > > 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] <javascript:>. > 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.
