version is 1.6.3 This problem occurred against a specific vertex. I have a vertex called store that connects to products via edges. I deleted the connected products to that vertex by using delete vertex where @class="products" and in.out.storename = "x"
This seemed to put that store vertex into an inconsistent state. It's edge count for in_myedge was a big number, where it should have been 0. Note that I am not using lightweight edges. I am using edges with unique indexes to prevent duplication of edges between the same vertices. I fixed the problem by issuing update storerid set in_myedge = [] In the past, this type of problem would take down the entire database, so it is good to see that the problem is now compartmentalized. However, there needs to be more information about how to get Orientdb out of these types of inconsistent states when they occur, and perhaps some scripts to run that attempt to identify and fix these problems. Generally, when I have asked about these types of problems in the past, the answer has been "you're kind of screwed" or "attach a debugger to the database". This is really an unacceptable answer...there needs to be a better way to fix these types of inconsistent state problems. On Thu, Feb 6, 2014 at 3:34 AM, Luca Garulli <[email protected]> wrote: > What version are you using? > > Sent from Mobile device > Il 05/feb/2014 22:42 "Jonathan Rosen" <[email protected]> ha scritto: > >> Here is the error message: >> >> Error: >> com.orientechnologies.orient.enterprise.channel.binary.OResponseProcessingException: >> Exception during response processing. >> >> Error: >> com.orientechnologies.orient.core.exception.OCommandExecutionException: >> Error on execution of command: sql.select out_carries_product.in.namefrom >> #13:4 >> >> Error: java.lang.NullPointerException >> >> >> >> What is the best way to debug this and fix the database? >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" 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/groups/opt_out. >> > -- > > --- > You received this message because you are subscribed to a topic in the > Google Groups "OrientDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/orient-database/pJxT5aWqDds/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" 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/groups/opt_out.
