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]<javascript:> > >: > > 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.
