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.
