Re: [Neo4j] Neo4j: Ver 3.0.4 delete and re-insert label corruption

2016-09-30 Thread Kevin McGinn
I appreciate you responding to my issue. Unfortunately, do to time constraints I rebuilt the database before I was able to do as you suggested. As an aside, I have found that many issues are resolved when I shut down neo4j, remove the /schema/label dir and allow it to rebuild on startup. The one

Re: [Neo4j] Neo4j: Ver 3.0.4 delete and re-insert label corruption

2016-09-19 Thread 'Mattias Persson' via Neo4j
Failures to populate index should put the actual error in /schema/index/lucene//failure-message or similar. Can you see what's inside that file? On Friday, September 2, 2016 at 5:31:24 PM UTC+2, Kevin McGinn wrote: > > I deleted the index and attempted to restart. After an hour, I received an

Re: [Neo4j] Neo4j: Ver 3.0.4 delete and re-insert label corruption

2016-09-02 Thread 'Michael Hunger' via Neo4j
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 >

Re: [Neo4j] Neo4j: Ver 3.0.4 delete and re-insert label corruption

2016-09-02 Thread Kevin McGinn
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

Re: [Neo4j] Neo4j: Ver 3.0.4 delete and re-insert label corruption

2016-09-02 Thread 'Michael Hunger' via Neo4j
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

[Neo4j] Neo4j: Ver 3.0.4 delete and re-insert label corruption

2016-09-01 Thread kmcginn
I deleted the nodes from a label: match(n:clients) delete n; When I attempted to re-load from CSV: using periodic commit 1 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