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
[image: API Logo]
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> 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:
>
> 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.
> For more options, visit 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.
> To unsubscribe from this group and all its topics, send an email to
> neo4j+unsubscr...@googlegroups.com.
> 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 neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
