Uploaded image for project: 'Marmotta (Retired)'
  1. Marmotta (Retired)
  2. MARMOTTA-583

Exception when using larger Sparql select limit

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.3.0
    • None
    • Platform
    • None

    • H2

    Description

      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

      Attachments

        Activity

          People

            Unassigned Unassigned
            kud1ing Lenny
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: