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 [email protected]: > > 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 [email protected] > <mailto:[email protected]>. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
