You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@marmotta.apache.org by "Sebastian Schaffert (JIRA)" <ji...@apache.org> on 2013/09/11 17:57:51 UTC
[jira] [Resolved] (MARMOTTA-280) SPARQL Timeout: Too many error
messages and invalid transaction
[ https://issues.apache.org/jira/browse/MARMOTTA-280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sebastian Schaffert resolved MARMOTTA-280.
------------------------------------------
Resolution: Fixed
> 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
> Components: Triple Store
> Reporter: Sebastian Schaffert
> Assignee: Sebastian Schaffert
> Priority: Minor
> Fix For: 3.1-incubating
>
>
> 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