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.
