1.7.3 On Saturday, June 21, 2014 10:29:42 AM UTC-4, Lvc@ wrote: > > Hi Brian, > What release are you using? > > Lvc@ > > > > On 20 June 2014 21:11, Brian O'Keefe <[email protected] <javascript:>> > 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] <javascript:>. >> 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.
