Today I got the "error while evaluating query" from my client using marmotta.js
(Marmotta running with H2).
So I do have the error stack trace:
error (Bad Request): {"message":"error while evaluating query
","trace":"org.apache.marmotta.platform.core.exception.MarmottaException:
error while evaluating query \n
org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl$5.call(SparqlServiceImpl.java:356)\n
org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl$5.call(SparqlServiceImpl.java:324)\n
java.util.concurrent.FutureTask.run(FutureTask.java:262)\n
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\n
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\n
java.lang.Thread.run(Thread.java:745)\nCaused by:
org.openrdf.query.QueryEvaluationException: org.h2.jdbc.JdbcSQLException:
General error: \"java.lang.IllegalStateException: Transaction is closed
[1.4.178/4]\"; SQL statement:\nSELECT
id,ntype,svalue,ivalue,dvalue,tvalue,bvalue,lang,ltype,createdAt FROM nodes
WHERE id IN(?,?) LIMIT 2 [50000-178]\n
org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:67)\n
org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:75)\n
org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl.query(SparqlServiceImpl.java:388)\n
org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl.query(SparqlServiceImpl.java:395)\n
org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl.access$600(SparqlServiceImpl.java:107)\n
org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl$5.call(SparqlServiceImpl.java:335)\n\t...
5 more\nCaused by: org.openrdf.sail.SailException:
org.h2.jdbc.JdbcSQLException: General error:
\"java.lang.IllegalStateException: Transaction is closed [1.4.178/4]\"; SQL
statement:\nSELECT
id,ntype,svalue,ivalue,dvalue,tvalue,bvalue,lang,ltype,createdAt FROM nodes
WHERE id IN(?,?) LIMIT 2 [50000-178]\n
org.apache.marmotta.kiwi.sparql.sail.KiWiSparqlSailConnection.evaluate(KiWiSparqlSailConnection.java:96)\n
org.openrdf.sail.helpers.SailConnectionWrapper.evaluate(SailConnectionWrapper.java:95)\n
org.openrdf.sail.helpers.SailConnectionWrapper.evaluate(SailConnectionWrapper.java:95)\n
org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:60)\n\t...
10 more\nCaused by: org.openrdf.query.QueryEvaluationException:
org.h2.jdbc.JdbcSQLException: General error:
\"java.lang.IllegalStateException: Transaction is closed [1.4.178/4]\"; SQL
statement:\nSELECT
id,ntype,svalue,ivalue,dvalue,tvalue,bvalue,lang,ltype,createdAt FROM nodes
WHERE id IN(?,?) LIMIT 2 [50000-178]\n
org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategyImpl.evaluateNative(KiWiEvaluationStrategyImpl.java:222)\n
org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategyImpl.evaluate(KiWiEvaluationStrategyImpl.java:187)\n
org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:589)\n
org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:197)\n
org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:662)\n
org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategyImpl.evaluate(KiWiEvaluationStrategyImpl.java:123)\n
org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:577)\n
org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:197)\n
org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:607)\n
org.openrdf.query.algebra.evaluation.impl.EvaluationStrategyImpl.evaluate(EvaluationStrategyImpl.java:197)\n
org.apache.marmotta.kiwi.sparql.sail.KiWiSparqlSailConnection.evaluate(KiWiSparqlSailConnection.java:93)\n\t...
13 more\nCaused by: org.h2.jdbc.JdbcSQLException: General error:
\"java.lang.IllegalStateException: Transaction is closed [1.4.178/4]\"; SQL
statement:\nSELECT
id,ntype,svalue,ivalue,dvalue,tvalue,bvalue,lang,ltype,createdAt FROM nodes
WHERE id IN(?,?) LIMIT 2 [50000-178]\n
org.h2.message.DbException.getJdbcSQLException(DbException.java:344)\n
org.h2.message.DbException.get(DbException.java:167)\n
org.h2.message.DbException.convert(DbException.java:294)\n
org.h2.command.Command.executeQuery(Command.java:209)\n
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:109)\n
org.apache.marmotta.kiwi.persistence.KiWiConnection.loadNodesByIds(KiWiConnection.java:497)\n
org.apache.marmotta.kiwi.sparql.persistence.KiWiSparqlConnection$2.apply(KiWiSparqlConnection.java:131)\n
org.apache.marmotta.kiwi.sparql.persistence.KiWiSparqlConnection$2.apply(KiWiSparqlConnection.java:117)\n
org.apache.marmotta.kiwi.persistence.util.ResultSetIteration.next(ResultSetIteration.java:115)\n
info.aduna.iteration.Iterations.addAll(Iterations.java:83)\n
info.aduna.iteration.Iterations.asList(Iterations.java:44)\n
org.apache.marmotta.kiwi.sparql.persistence.KiWiSparqlConnection.evaluateNative(KiWiSparqlConnection.java:174)\n
org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategyImpl.evaluateNative(KiWiEvaluationStrategyImpl.java:215)\n\t...
23 more\nCaused by: java.lang.IllegalStateException: Transaction is closed
[1.4.178/4]\n
org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:757)\n
org.h2.mvstore.db.TransactionStore$Transaction.checkNotClosed(TransactionStore.java:808)\n
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1165)\n
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1133)\n
org.h2.mvstore.db.TransactionStore$TransactionMap.containsKey(TransactionStore.java:1153)\n
org.h2.mvstore.db.TransactionStore$TransactionMap$2.fetchNext(TransactionStore.java:1468)\n
org.h2.mvstore.db.TransactionStore$TransactionMap$2.next(TransactionStore.java:1483)\n
org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.next(MVSecondaryIndex.java:509)\n
org.h2.index.IndexCursor.next(IndexCursor.java:278)\n
org.h2.table.TableFilter.next(TableFilter.java:361)\n
org.h2.command.dml.Select.queryFlat(Select.java:533)\n
org.h2.command.dml.Select.queryWithoutCache(Select.java:646)\n
org.h2.command.dml.Query.query(Query.java:323)\n
org.h2.command.dml.Query.query(Query.java:291)\n
org.h2.command.dml.Query.query(Query.java:37)\n
org.h2.command.CommandContainer.query(CommandContainer.java:91)\n
org.h2.command.Command.executeQuery(Command.java:197)\n\t... 32
more\n","type":"MarmottaException"}
hope it helps
Fabian
>>> Sebastian Schaffert <[email protected]> 23.09.2014 16:03 >>>
Hi Fabian,
I just checked, I cannot reproduce the bug, for me the query translates
just fine into SQL and gives the expected results:
SELECT P1.object AS V3, P1.predicate AS V2, P1.subject AS V1
FROM triples P1
INNER JOIN nodes AS P1_subject_V1 ON P1.subject = P1_subject_V1.id
INNER JOIN nodes AS P1_predicate_V2 ON P1.predicate =
P1_predicate_V2.id
INNER JOIN nodes AS P1_object_V3 ON P1.object = P1_object_V3.id
WHERE P1.deleted = false
There is one issue I discovered, though: in case your Marmotta database
user is not a PostgreSQL superuser you have to manually run
"CREATE EXTENSION pgcrypto" for the database you are using. Still thinking
about ways how to solve this (the extension is necessary for some SPARQL
functions like UUID and md5).
Greetings,
Sebastian
2014-09-23 15:57 GMT+02:00 Sebastian Schaffert <
[email protected]>:
> Hi Fabian,
>
> I will have a look, it might be an error in the translation.
>
> Greetings,
>
> Sebastian
>
> 2014-09-23 9:25 GMT+02:00 Fabian Cretton <[email protected]>:
>
>> Hi,
>>
>> I did upgrade my fork from Marmotta/develop yesterday, and I now have a
>> "error while evaluating query" on the squebi interface for a query as
>> "SELECT * WHERE {?subject ?property ?object} LIMIT 10"
>> But that one works (not using the *): "SELECT ?subject WHERE {?subject
>> ?property ?object} LIMIT 10"
>>
>> The sample query "select first 10 triples" gives the same error.
>>
>> Is it a bug you can reproduce or did I do something wrong during the
>> merge process ?
>>
>> Also my logging functionality seems to be altered:
>> each day a new "marmotta-security.log" is generated as expected, but
>> since the merge, no new "marmotta-main.log" was generated today.
>>
>> Thank you
>> Fabian
>>
>>
>>
>
>
