[
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
