That sounds really unusual. Can you stop the server and delete $NEO4J_HOME/data/databases/graph.db/schema/label
and restart, then the label index should be rebuilt. also please share the result of the "schema" command. Michael > Am 02.09.2016 um 14:28 schrieb Kevin McGinn > <kmcg...@absolute-performance.com>: > > The count of 29 is via the command: > match(n:clients) return count(*); > > The query > match(n:clients) return n; > > returns an empty set. > > ClientsID had a unique constraint defined on. I dropped it with the intent of > re-creating in hopes it would help correct the problem. > > Currently, I can not restart neo4j. I shut down neo4j and removed the indexes > to force an index rebuild. At restart attempt, the neo4j.log file contains > the error: > > Caused by: java.lang.IllegalStateException: Index entered FAILED state while > recovery waited for it to be fully populated > > If I can figure out what this means and fix this error, I will regen the > clients data error and get more information to you. As an aside, I have 66G > of data; 13G of indexes but have only 36G of ram. > > > Kevin P. McGinn, PMP > > Absolute Performance Inc. > 12303 Airport Way, Suite 100 > Broomfield, CO 80021 > > cell: (303) 305-9844 > kmcg...@absolute-performance.com <mailto:kmcg...@absolute-performance.com> > > > NON-DISCLOSURE NOTICE: This communication including any and all attachments > is for the intended recipient(s) only and may contain confidential and > privileged information. If you are not the intended recipient of this > communication, any disclosure, copying further distribution or use of this > communication is prohibited. If you received this communication in error, > please contact the sender and delete/destroy all copies of this communication > immediately. > > On Fri, Sep 2, 2016 at 3:44 AM, 'Michael Hunger' via Neo4j > <neo4j@googlegroups.com <mailto:neo4j@googlegroups.com>> wrote: > This sounds very unsual. > > Where does the count show 29 ? > > Do you have a constraint on clients(ClientsID) ? > please note that both labels and properties are case-sensitive > Are you sure that your row.ClientsID is unique ? > > Can you share the full error, it misses the second part that explains the > duplicate. > > I presume the duplicate is on another constrained field. > >> Am 01.09.2016 um 22:05 schrieb kmcg...@absolute-performance.com >> <mailto:kmcg...@absolute-performance.com>: >> >> I deleted the nodes from a label: >> match(n:clients) delete n; >> >> When I attempted to re-load from CSV: >> using periodic commit 10000 >> LOAD CSV WITH HEADERS FROM >> 'file:/export/warehouse/tmp/clients_08-31-2016_02-03.txt' as row >> FIELDTERMINATOR '\t' with row as row where row.ClientsID is not null >> merge (x:clients {ClientsID:row.ClientsID}) >> on create set x+=row on match set x=row >> return count(*); >> >> I get the error: >> 104 ms >> >> WARNING: Node with id 122046120 >> >> I take it this is a node re-use error. >> >> But the label is now corrupted. There are no node properties when I attempt >> to access the nodes. >> >> Trying to delete all nodes: >> match (n:clients) delete n; >> >> produces the result: >> +--------------------------------------------+ >> | No data returned, and nothing was changed. | >> +--------------------------------------------+ >> 6 ms >> >> A count shows there are 29 rows. How do I remove the rows or then entire >> label? >> >> >> >> >> -- >> 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 neo4j+unsubscr...@googlegroups.com >> <mailto:neo4j+unsubscr...@googlegroups.com>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. > > > -- > You received this message because you are subscribed to a topic in the Google > Groups "Neo4j" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/neo4j/gwurFd4JGhM/unsubscribe > <https://groups.google.com/d/topic/neo4j/gwurFd4JGhM/unsubscribe>. > To unsubscribe from this group and all its topics, send an email to > neo4j+unsubscr...@googlegroups.com > <mailto:neo4j+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout > <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 neo4j+unsubscr...@googlegroups.com > <mailto:neo4j+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout > <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 neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
