Osma, 3.4.0 introduces quite some changes in the SPARQL engine (mainly
about performance), which could be not complete (that's why the release is
taking that long). So please, report the details to Jira and we'll try to
deal with it. Thanks.
On Mon, Sep 26, 2016 at 8:38 AM, Osma Suominen <osma.suomi...@helsinki.fi>
wrote:
> Hi,
>
>
> I noticed that the following SPARQL query, used to count the number of
> triples in different graphs, fails on the current 3.4.0-SNAPSHOT (using
> PostgreSQL 9.5 as backend, starting from an empty database). It works on
> 3.3.0 using the same database.
>
>
> --cut--
> SELECT ?g (COUNT(*) AS ?c) {
> GRAPH ?g {
> ?s ?p ?o
> }
> }
> GROUP BY ?g
> ORDER BY DESC(?c)
> --cut--
>
> The error in the Tomcat log is:
>
>
> --cut--
> 09:32:30.101 ERROR - error while evaluating query: {}
> org.openrdf.query.QueryEvaluationException: org.postgresql.util.PSQLException:
> ERROR: aggregate functions are not allowed in GROUP BY
> Position: 183
> at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupl
> eQuery.java:67)
> at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupl
> eQuery.java:75)
> at org.apache.marmotta.platform.sparql.services.sparql.SparqlSe
> rviceImpl.query(SparqlServiceImpl.java:344)
> at org.apache.marmotta.platform.sparql.services.sparql.SparqlSe
> rviceImpl.query(SparqlServiceImpl.java:351)
> at org.apache.marmotta.platform.sparql.services.sparql.SparqlSe
> rviceImpl.access$700(SparqlServiceImpl.java:60)
> at org.apache.marmotta.platform.sparql.services.sparql.SparqlSe
> rviceImpl$5.call(SparqlServiceImpl.java:290)
> at org.apache.marmotta.platform.sparql.services.sparql.SparqlSe
> rviceImpl$5.call(SparqlServiceImpl.java:279)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.openrdf.sail.SailException: org.postgresql.util.PSQLException:
> ERROR: aggregate functions are not allowed in GROUP BY
> Position: 183
> at org.apache.marmotta.kiwi.sparql.sail.KiWiSparqlSailConnectio
> n.evaluate(KiWiSparqlSailConnection.java:101)
> at org.openrdf.sail.helpers.SailConnectionWrapper.evaluate(Sail
> ConnectionWrapper.java:95)
> at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupl
> eQuery.java:60)
> ... 10 common frames omitted
> Caused by: org.openrdf.query.QueryEvaluationException:
> org.postgresql.util.PSQLException: ERROR: aggregate functions are not
> allowed in GROUP BY
> Position: 183
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStr
> ategy.evaluateNative(KiWiEvaluationStrategy.java:398)
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStr
> ategy.evaluate(KiWiEvaluationStrategy.java:133)
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategy
> Impl.evaluate(EvaluationStrategyImpl.java:616)
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategy
> Impl.evaluate(EvaluationStrategyImpl.java:207)
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategy
> Impl.evaluate(EvaluationStrategyImpl.java:687)
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStr
> ategy.evaluate(KiWiEvaluationStrategy.java:108)
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategy
> Impl.evaluate(EvaluationStrategyImpl.java:589)
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategy
> Impl.evaluate(EvaluationStrategyImpl.java:207)
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategy
> Impl.evaluate(EvaluationStrategyImpl.java:621)
> at org.openrdf.query.algebra.evaluation.impl.EvaluationStrategy
> Impl.evaluate(EvaluationStrategyImpl.java:207)
> at org.apache.marmotta.kiwi.sparql.sail.KiWiSparqlSailConnectio
> n.evaluate(KiWiSparqlSailConnection.java:98)
> ... 12 common frames omitted
> Caused by: org.postgresql.util.PSQLException: ERROR: aggregate functions
> are not allowed in GROUP BY
> Position: 183
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons
> e(QueryExecutorImpl.java:2161)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer
> yExecutorImpl.java:1890)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut
> orImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract
> Jdbc2Statement.java:560)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags
> (AbstractJdbc2Statement.java:417)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abs
> tractJdbc2Statement.java:302)
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStr
> ategy$1.call(KiWiEvaluationStrategy.java:217)
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStr
> ategy$1.call(KiWiEvaluationStrategy.java:213)
> ... 4 common frames omitted
> --cut--
>
>
> Is this a known issue? I can of course open a JIRA ticket if necessary.
>
> -Osma
>
>
> --
> Osma Suominen
> D.Sc. (Tech), Information Systems Specialist
> National Library of Finland
> P.O. Box 26 (Kaikukatu 4)
> 00014 HELSINGIN YLIOPISTO
> Tel. +358 50 3199529
> osma.suomi...@helsinki.fi
> http://www.nationallibrary.fi
>
--
Sergio Fernández
Partner Technology Manager
Redlink GmbH
m: +43 6602747925
e: sergio.fernan...@redlink.co
w: http://redlink.co
