You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@marmotta.apache.org by "Lenny (JIRA)" <ji...@apache.org> on 2014/12/26 10:28:13 UTC
[jira] [Commented] (MARMOTTA-583) Exception when changing Sparql
select limit
[ https://issues.apache.org/jira/browse/MARMOTTA-583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14259013#comment-14259013 ]
Lenny commented on MARMOTTA-583:
--------------------------------
FWIW i get the same behaviour when using cURL:
curl --silent --show-error -X GET 'http://localhost:8080/marmotta/sparql/select?query=select%20*%20where%20%7B?s%20?p%20?o%7D%20limit%205'
works most of the time
curl --silent --show-error -X GET 'http://localhost:8080/marmotta/sparql/select?query=select%20*%20where%20%7B?s%20?p%20?o%7D%20limit%2020'
fails reliably.
> Exception when changing Sparql select limit
> -------------------------------------------
>
> Key: MARMOTTA-583
> URL: https://issues.apache.org/jira/browse/MARMOTTA-583
> Project: Marmotta
> Issue Type: Bug
> Components: Platform
> Affects Versions: 3.3.0
> Reporter: Lenny
>
> In the SPARQL/Squebi browser, changing the default example
> SELECT * WHERE {
> ?subject ?property ?object
> } LIMIT 10
> to different limits > 10, i reliably get exceptions:
> Marker - 25 Dec 2014 18:25:32
> 18:25:39.068 ERROR o.a.m.p.s.s.sparql.SparqlServiceImpl - error while evaluating query: {}
> org.openrdf.query.QueryEvaluationException: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Transaction is closed [1.4.178/4]"; SQL statement:
> SELECT id,ntype,svalue,ivalue,dvalue,tvalue,tzoffset,bvalue,lang,ltype,createdAt FROM nodes WHERE id IN(?,?) LIMIT 2 [50000-178]
> at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:67) ~[sesame-repository-sail-2.7.13.jar:na]
> at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:75) ~[sesame-repository-sail-2.7.13.jar:na]
> at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl.query(SparqlServiceImpl.java:344) ~[marmotta-sparql-3.3.0.jar:3.3.0]
> at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl.query(SparqlServiceImpl.java:351) ~[marmotta-sparql-3.3.0.jar:3.3.0]
> at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl.access$700(SparqlServiceImpl.java:60) ~[marmotta-sparql-3.3.0.jar:3.3.0]
> at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl$5.call(SparqlServiceImpl.java:290) [marmotta-sparql-3.3.0.jar:3.3.0]
> at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl$5.call(SparqlServiceImpl.java:279) [marmotta-sparql-3.3.0.jar:3.3.0]
> at java.util.concurrent.FutureTask.run(FutureTask.java:262) [na:1.7.0_55]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_55]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_55]
> at java.lang.Thread.run(Thread.java:745) [na:1.7.0_55]
> Caused by: org.openrdf.sail.SailException: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Transaction is closed [1.4.178/4]"; SQL statement:
> SELECT id,ntype,svalue,ivalue,dvalue,tvalue,tzoffset,bvalue,lang,ltype,createdAt FROM nodes WHERE id IN(?,?) LIMIT 2 [50000-178]
> at org.apache.marmotta.kiwi.sparql.sail.KiWiSparqlSailConnection.evaluate(KiWiSparqlSailConnection.java:100) ~[kiwi-sparql-3.3.0.jar:3.3.0]
> at org.openrdf.sail.helpers.SailConnectionWrapper.evaluate(SailConnectionWrapper.java:95) ~[sesame-sail-api-2.7.13.jar:na]
> at org.openrdf.sail.helpers.SailConnectionWrapper.evaluate(SailConnectionWrapper.java:95) ~[sesame-sail-api-2.7.13.jar:na]
> at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:60) ~[sesame-repository-sail-2.7.13.jar:na]
> ... 10 common frames omitted
> Caused by: org.openrdf.query.QueryEvaluationException: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Transaction is closed [1.4.178/4]"; SQL statement:
> SELECT id,ntype,svalue,ivalue,dvalue,tvalue,tzoffset,bvalue,lang,ltype,createdAt FROM nodes WHERE id IN(?,?) LIMIT 2 [50000-178]
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategy.evaluateNative(KiWiEvaluationStrategy.java:404) ~[kiwi-sparql-3.3.0.jar:3.3.0]
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategy.evaluate(KiWiEvaluationStrategy.java:173) ~[kiwi-sparql-3.3.0.jar:3.3.0]
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:589) ~[sesame-queryalgebra-evaluation-2.7.13.jar:na]
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:197) ~[sesame-queryalgebra-evaluation-2.7.13.jar:na]
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:662) ~[sesame-queryalgebra-evaluation-2.7.13.jar:na]
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategy.evaluate(KiWiEvaluationStrategy.java:109) ~[kiwi-sparql-3.3.0.jar:3.3.0]
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:577) ~[sesame-queryalgebra-evaluation-2.7.13.jar:na]
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:197) ~[sesame-queryalgebra-evaluation-2.7.13.jar:na]
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:607) ~[sesame-queryalgebra-evaluation-2.7.13.jar:na]
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:197) ~[sesame-queryalgebra-evaluation-2.7.13.jar:na]
> at org.apache.marmotta.kiwi.sparql.sail.KiWiSparqlSailConnection.evaluate(KiWiSparqlSailConnection.java:97) ~[kiwi-sparql-3.3.0.jar:3.3.0]
> ... 13 common frames omitted
> Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Transaction is closed [1.4.178/4]"; SQL statement:
> SELECT id,ntype,svalue,ivalue,dvalue,tvalue,tzoffset,bvalue,lang,ltype,createdAt FROM nodes WHERE id IN(?,?) LIMIT 2 [50000-178]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.message.DbException.get(DbException.java:167) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.message.DbException.convert(DbException.java:294) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.command.Command.executeQuery(Command.java:209) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:109) ~[h2-1.4.178.jar:1.4.178]
> at org.apache.marmotta.kiwi.persistence.KiWiConnection.loadNodesByIds(KiWiConnection.java:496) ~[kiwi-triplestore-3.3.0.jar:3.3.0]
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategy$2.apply(KiWiEvaluationStrategy.java:250) ~[kiwi-sparql-3.3.0.jar:3.3.0]
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategy$2.apply(KiWiEvaluationStrategy.java:236) ~[kiwi-sparql-3.3.0.jar:3.3.0]
> at org.apache.marmotta.kiwi.persistence.util.ResultSetIteration.next(ResultSetIteration.java:115) ~[kiwi-triplestore-3.3.0.jar:3.3.0]
> at info.aduna.iteration.Iterations.addAll(Iterations.java:83) ~[sesame-util-2.7.13.jar:na]
> at info.aduna.iteration.Iterations.asList(Iterations.java:44) ~[sesame-util-2.7.13.jar:na]
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategy.evaluateNative(KiWiEvaluationStrategy.java:379) ~[kiwi-sparql-3.3.0.jar:3.3.0]
> ... 23 common frames omitted
> Caused by: java.lang.IllegalStateException: Transaction is closed [1.4.178/4]
> at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:757) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.mvstore.db.TransactionStore$Transaction.checkNotClosed(TransactionStore.java:808) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1165) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1133) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.mvstore.db.TransactionStore$TransactionMap.containsKey(TransactionStore.java:1153) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.mvstore.db.TransactionStore$TransactionMap$2.fetchNext(TransactionStore.java:1468) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.mvstore.db.TransactionStore$TransactionMap$2.next(TransactionStore.java:1483) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.next(MVSecondaryIndex.java:509) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.index.IndexCursor.next(IndexCursor.java:278) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.table.TableFilter.next(TableFilter.java:361) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.command.dml.Select.queryFlat(Select.java:533) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.command.dml.Select.queryWithoutCache(Select.java:646) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.command.dml.Query.query(Query.java:323) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.command.dml.Query.query(Query.java:291) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.command.dml.Query.query(Query.java:37) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.command.CommandContainer.query(CommandContainer.java:91) ~[h2-1.4.178.jar:1.4.178]
> at org.h2.command.Command.executeQuery(Command.java:197) ~[h2-1.4.178.jar:1.4.178]
> ... 31 common frames omitted
> 18:25:39.068 INFO o.a.m.p.s.s.sparql.SparqlServiceImpl - SPARQL query execution aborted due to exception
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)