Could it be that the constraint was not yet online when you tried to drop it? I.e. it was still building?
It seems lucene was still writing to the backing files. Caused by: java.io.IOException: Cannot delete C:\Users\Olivia Stella\Documents\Neo4j\DB_1000\schema\index\lucene\3\_0.fdt On Sun, Mar 30, 2014 at 10:45 AM, Rio Eduardo <rioeduard...@gmail.com>wrote: > Oh ok, here is my graph.db/messages.log. Oh yeah I almost forgot to tell > and it's successful when I create/drop constraint in web ui browser but not > in Neo4j Shell. > > Thank you. > > > On Sunday, March 30, 2014 3:16:20 PM UTC+7, Michael Hunger wrote: > >> Something went wrong there. >> >> Can you share your graph.db/messages.log file to see if we can find out >> the reason? >> >> Your create/drop constraint syntax is correct. >> >> >> On Sun, Mar 30, 2014 at 7:52 AM, Rio Eduardo <rioedu...@gmail.com> wrote: >> >>> I create constraint in Neo4j Shell(2.0.1) with this syntax => CREATE >>> CONSTRAINT ON(U:User) ASSERT U.user_id is UNIQUE; >>> And can see the schema with this syntax => schema ls -l :User >>> >>> but when I want to drop contraint with this syntax => DROP CONSTRAINT >>> ON(U:User) ASSERT U.user_id is UNIQUE; >>> it returns error result => SystemException: TM has encountered some >>> problem, please perform necessary action (tx recovery/restart) >>> And when I want to see the scema with this syntax => schema ls -l :User >>> it returns error result too => SystemException: TM has encountered some >>> problem, please perform necessary action (tx recovery/restart) >>> >>> And when I restart my neo4j, and see the schema, suddenly there is no >>> indexes and constraints that I already created before. >>> >>> so, What happened to my neo4j actually? and how to solve this problem? >>> and how to drop constraint with this syntax => DROP CONSTRAINT ON(U:User) >>> ASSERT U.user_id is UNIQUE;? >>> >>> Thank you. >>> >>> -- >>> 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+un...@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. > -- 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.
