Sebastian Schaffert created MARMOTTA-280: --------------------------------------------
Summary: SPARQL Timeout: Too many error messages and invalid transaction Key: MARMOTTA-280 URL: https://issues.apache.org/jira/browse/MARMOTTA-280 Project: Marmotta Issue Type: Bug Reporter: Sebastian Schaffert When the new SPARQL timeout mechanism stops a running SPARQL query, the error log is filled with exception traces; this should not happen, the SPARQL evaluation should abort completely on such errors. Stack Traces: 11:21:19.926 ERROR o.a.m.k.s.p.KiWiSparqlConnection - error executing SPARQL query java.util.concurrent.ExecutionException: org.postgresql.util.PSQLException: FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252) [na:1.7.0_03] at java.util.concurrent.FutureTask.get(FutureTask.java:111) [na:1.7.0_03] at org.apache.marmotta.kiwi.sparql.persistence.KiWiSparqlConnection.evaluateJoin(KiWiSparqlConnection.java:314) ~[kiwi-sparql-3.1.0-incubating-20130722.144056-26.jar:3.1.0-incubating-SNAPSHOT] at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategyImpl.evaluate(KiWiEvaluationStrategyImpl.java:73) [kiwi-sparql-3.1.0-incubating-20130722.144056-26.jar:3.1.0-incubating-SNAPSHOT] Later: 11:21:19.927 WARN o.a.m.kiwi.sail.KiWiSailConnection - Rolling back transaction due to connection close java.lang.Throwable: null at org.openrdf.sail.helpers.SailConnectionBase.close(SailConnectionBase.java:240) [sesame-sail-api-2.7.3.jar:na] at org.openrdf.sail.helpers.SailConnectionWrapper.close(SailConnectionWrapper.java:88) [sesame-sail-api-2.7.3.jar:na] at org.openrdf.sail.helpers.SailConnectionWrapper.close(SailConnectionWrapper.java:88) [sesame-sail-api-2.7.3.jar:na] at org.openrdf.repository.sail.SailRepositoryConnection.close(SailRepositoryConnection.java:129) [sesame-repository-sail-2.7.3.jar:na] And later: 11:21:19.928 ERROR o.a.m.p.s.s.sparql.SparqlServiceImpl - error while evaluating query: {} org.openrdf.query.QueryEvaluationException: org.openrdf.query.QueryEvaluationException: java.sql.SQLException: error executing SPARQL query at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:67) ~[sesame-repository-sail-2.7.3.jar:na] at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:75) ~[sesame-repository-sail-2.7.3.jar:na] at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl.query(SparqlServiceImpl.java:248) ~[marmotta-sparql-3.1.0-incubating-20130722.130026-21.jar:3.1.0-incubating-SNAPSHOT] at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl.access$200(SparqlServiceImpl.java:71) ~[marmotta-sparql-3.1.0-incubating-20130722.130026-21.jar:3.1.0-incubating-SNAPSHOT] at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl$2.call(SparqlServiceImpl.java:133) [marmotta-sparql-3.1.0-incubating-20130722.130026-21.jar:3.1.0-incubating-SNAPSHOT] at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl$2.call(SparqlServiceImpl.java:122) [marmotta-sparql-3.1.0-incubating-20130722.130026-21.jar:3.1.0-incubating-SNAPSHOT] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [na:1.7.0_03] at java.util.concurrent.FutureTask.run(FutureTask.java:166) [na:1.7.0_03] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_03] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_03] at java.lang.Thread.run(Thread.java:722) [na:1.7.0_03] Caused by: org.openrdf.sail.SailException: org.openrdf.query.QueryEvaluationException: java.sql.SQLException: error executing SPARQL query at org.apache.marmotta.kiwi.sparql.sail.KiWiSparqlSailConnection.evaluate(KiWiSparqlSailConnection.java:92) ~[kiwi-sparql-3.1.0-incubating-20130722.144056-26.jar:3.1.0-incubating-SNAPSHOT] at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:60) ~[sesame-repository-sail-2.7.3.jar:na] ... 10 common frames omitted Caused by: org.openrdf.query.QueryEvaluationException: java.sql.SQLException: error executing SPARQL query at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategyImpl.evaluate(KiWiEvaluationStrategyImpl.java:80) ~[kiwi-sparql-3.1.0-incubating-20130722.144056-26.jar:3.1.0-incubating-SNAPSHOT] Caused by: java.sql.SQLException: error executing SPARQL query at org.apache.marmotta.kiwi.sparql.persistence.KiWiSparqlConnection.evaluateJoin(KiWiSparqlConnection.java:343) ~[kiwi-sparql-3.1.0-incubating-20130722.144056-26.jar:3.1.0-incubating-SNAPSHOT] at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategyImpl.evaluate(KiWiEvaluationStrategyImpl.java:73) ~[kiwi-sparql-3.1.0-incubating-20130722.144056-26.jar:3.1.0-incubating-SNAPSHOT] ... 22 common frames omitted Caused by: java.util.concurrent.ExecutionException: org.postgresql.util.PSQLException: FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252) [na:1.7.0_03] at java.util.concurrent.FutureTask.get(FutureTask.java:111) [na:1.7.0_03] at org.apache.marmotta.kiwi.sparql.persistence.KiWiSparqlConnection.evaluateJoin(KiWiSparqlConnection.java:314) ~[kiwi-sparql-3.1.0-incubating-20130722.144056-26.jar:3.1.0-incubating-SNAPSHOT] ... 23 common frames omitted Caused by: org.postgresql.util.PSQLException: FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) ~[postgresql-9.2-1002.jdbc4.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ~[postgresql-9.2-1002.jdbc4.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql-9.2-1002.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) ~[postgresql-9.2-1002.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) ~[postgresql-9.2-1002.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) ~[postgresql-9.2-1002.jdbc4.jar:na] at org.apache.marmotta.kiwi.sparql.persistence.KiWiSparqlConnection$1.call(KiWiSparqlConnection.java:307) ~[kiwi-sparql-3.1.0-incubating-20130722.144056-26.jar:3.1.0-incubating-SNAPSHOT] at org.apache.marmotta.kiwi.sparql.persistence.KiWiSparqlConnection$1.call(KiWiSparqlConnection.java:304) ~[kiwi-sparql-3.1.0-incubating-20130722.144056-26.jar:3.1.0-incubating-SNAPSHOT] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira