Hi Brian, What release are you using? Lvc@
On 20 June 2014 21:11, Brian O'Keefe <[email protected]> wrote: > Hi all, > > I haven't been able to reliably reproduce this issue, but I wanted to > raise the potential of an error with the new PARALLEL queries. Most > importantly, when I ran this query without the "PARALLEL" keyword, I > received 2304 results vs. 2276 with PARALLEL and no hint about an error > occurring in Studio...I only found it when I went looking after I noticed > the difference in record counts. The log below was extracted from my test > server (I obfuscated some sensitive information in the > table/cluster/variable names, so any inconsistencies are likely due to that > exercise). I give more detail as I discover it. > > Error on executing parallel query: select in.name as Name1, out.name as > Name2, in.outE().in.name, out.companies, out.*theNames*, in.*IId*, out. > *IId*, score from ResolvesTo WHERE source <> '*SOURCE1*' AND multiMatch > is NULL PARALLEL > com.orientechnologies.orient.core.exception.ODatabaseException: Error on > retrieving record #17:1346431 (cluster: *CLUSTERNAME*) > -> java.util.concurrent.FutureTask.report(FutureTask.java:122) > -> java.util.concurrent.FutureTask.get(FutureTask.java:188) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parallelExec(OCommandExecutorSQLSelect.java:1087) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.fetchFromTarget(OCommandExecutorSQLSelect.java:1019) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.executeSearch(OCommandExecutorSQLSelect.java:500) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.execute(OCommandExecutorSQLSelect.java:457) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.execute(OCommandExecutorSQLDelegate.java:60) > -> > com.orientechnologies.orient.core.storage.OStorageEmbedded.executeCommand(OStorageEmbedded.java:94) > -> > com.orientechnologies.orient.core.storage.OStorageEmbedded.command(OStorageEmbedded.java:83) > -> > com.orientechnologies.orient.core.command.OCommandRequestTextAbstract.execute(OCommandRequestTextAbstract.java:59) > -> > com.orientechnologies.orient.server.network.protocol.http.command.post.OServerCommandPostCommand.execute(OServerCommandPostCommand.java:73) > -> > com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.service(ONetworkProtocolHttpAbstract.java:176) > -> > com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.execute(ONetworkProtocolHttpAbstract.java:572) > -> com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:45) > Error on retrieving record #17:1346431 (cluster: *CLUSTERNAME*) > -> java.util.concurrent.FutureTask.report(FutureTask.java:122) > -> java.util.concurrent.FutureTask.get(FutureTask.java:188) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parallelExec(OCommandExecutorSQLSelect.java:1087) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.fetchFromTarget(OCommandExecutorSQLSelect.java:1019) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.executeSearch(OCommandExecutorSQLSelect.java:500) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.execute(OCommandExecutorSQLSelect.java:457) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.execute(OCommandExecutorSQLDelegate.java:60) > -> > com.orientechnologies.orient.core.storage.OStorageEmbedded.executeCommand(OStorageEmbedded.java:94) > -> > com.orientechnologies.orient.core.storage.OStorageEmbedded.command(OStorageEmbedded.java:83) > -> > com.orientechnologies.orient.core.command.OCommandRequestTextAbstract.execute(OCommandRequestTextAbstract.java:59) > -> > com.orientechnologies.orient.server.network.protocol.http.command.post.OServerCommandPostCommand.execute(OServerCommandPostCommand.java:73) > -> > com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.service(ONetworkProtocolHttpAbstract.java:176) > -> > com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.execute(ONetworkProtocolHttpAbstract.java:572) > -> com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:45) > Cannot unlock a never acquired lock > -> java.util.concurrent.FutureTask.report(FutureTask.java:122) > -> java.util.concurrent.FutureTask.get(FutureTask.java:188) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parallelExec(OCommandExecutorSQLSelect.java:1087) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.fetchFromTarget(OCommandExecutorSQLSelect.java:1019) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.executeSearch(OCommandExecutorSQLSelect.java:500) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.execute(OCommandExecutorSQLSelect.java:457) > -> > com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.execute(OCommandExecutorSQLDelegate.java:60) > -> > com.orientechnologies.orient.core.storage.OStorageEmbedded.executeCommand(OStorageEmbedded.java:94) > -> > com.orientechnologies.orient.core.storage.OStorageEmbedded.command(OStorageEmbedded.java:83) > -> > com.orientechnologies.orient.core.command.OCommandRequestTextAbstract.execute(OCommandRequestTextAbstract.java:59) > -> > com.orientechnologies.orient.server.network.protocol.http.command.post.OServerCommandPostCommand.execute(OServerCommandPostCommand.java:73) > -> > com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.service(ONetworkProtocolHttpAbstract.java:176) > -> > com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.execute(ONetworkProtocolHttpAbstract.java:572) > -> com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:45) > > -- > > --- > 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/d/optout. > -- --- 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/d/optout.
