Server error with large truncated log
I have a query with some counts for statistics (only way I got them working)
{ SELECT ?ls_id (count(distinct ?pl_fi) as ?fi_count) WHERE {
GRAPH ?ls_id {
?c skos:prefLabel ?pl_fi FILTER(LANG(?pl_fi) = "fi")
}} GROUP BY ?ls_id }
OPTIONAL {
{ SELECT ?ls_id (count(distinct ?pl_en) as ?en_count)WHERE { GRAPH
?ls_id {
?c skos:prefLabel ?pl_en FILTER(LANG(?pl_en) = "en")
}} GROUP BY ?ls_id }
}
OPTIONAL {
{ SELECT ?ls_id (count(distinct ?pl_sv) as ?sv_count)WHERE { GRAPH
?ls_id {
?c skos:prefLabel ?pl_sv FILTER(LANG(?pl_sv) = "sv")
}} GROUP BY ?ls_id }
}
With en and fi languages this works, but adding sv it fails with Server
Error and 12000+ lines of log for one exception. Log is truncated so
beginning of the log is missing. How could I proceed with debugging
this? Jena is 4.6.1 and I'm running queries in Fuseki web GUI.
Last lines of exception log:
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:319)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:412)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:381)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:268)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:138)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:407)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:894)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1038)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: [2023-04-20 15:08:40]
Fuseki INFO [6607] 500 Server Error (40.263 s)
Apr 20 15:08:40 x.lingsoft.fi java[832674]: [2023-04-20 15:08:40]
Fuseki INFO [6606] 500 Server Error (40.279 s)
Re: Server error with large truncated log
On 20/04/2023 13:23, Mikael Pesonen wrote:
I have a query with some counts for statistics (only way I got them
working)
{ SELECT ?ls_id (count(distinct ?pl_fi) as ?fi_count) WHERE {
GRAPH ?ls_id {
?c skos:prefLabel ?pl_fi FILTER(LANG(?pl_fi) = "fi")
}} GROUP BY ?ls_id }
OPTIONAL {
{ SELECT ?ls_id (count(distinct ?pl_en) as ?en_count)WHERE { GRAPH
?ls_id {
?c skos:prefLabel ?pl_en FILTER(LANG(?pl_en) = "en")
}} GROUP BY ?ls_id }
}
OPTIONAL {
{ SELECT ?ls_id (count(distinct ?pl_sv) as ?sv_count)WHERE { GRAPH
?ls_id {
?c skos:prefLabel ?pl_sv FILTER(LANG(?pl_sv) = "sv")
}} GROUP BY ?ls_id }
}
With en and fi languages this works, but adding sv it fails with Server
Error and 12000+ lines of log for one exception.
Does en and sv work?
Log is truncated so
beginning of the log is missing. How could I proceed with debugging
this? Jena is 4.6.1 and I'm running queries in Fuseki web GUI.
Last lines of exception log:
No Jena code there.
What you are looking is the top of the stacktrace (back to the operation
in Jena) and also the top of the "caused by"
IF they are all the same, put one example on a gist.
Andy
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282) ~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:319) ~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53) ~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:412) ~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:381) ~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:268) ~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:138) ~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:407) ~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:894) ~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1038) ~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: [2023-04-20 15:08:40]
Fuseki INFO [6607] 500 Server Error (40.263 s)
Apr 20 15:08:40 x.lingsoft.fi java[832674]: [2023-04-20 15:08:40]
Fuseki INFO [6606] 500 Server Error (40.279 s)
Re: Server error with large truncated log
Removing fi section results same error and also when removing OPTIONAL
from en too. Query with all three languages work without OPTIONALs but
that doesn't capture graphs (?ls_id) without some language content
(returns only graphs that have all three languages).
https://gist.github.com/mikael1234/a0ed6b4947d392b5798ca29cdab69b1f
On 20/04/2023 15.36, Andy Seaborne wrote:
On 20/04/2023 13:23, Mikael Pesonen wrote:
I have a query with some counts for statistics (only way I got them
working)
{ SELECT ?ls_id (count(distinct ?pl_fi) as ?fi_count) WHERE {
GRAPH ?ls_id {
?c skos:prefLabel ?pl_fi FILTER(LANG(?pl_fi) = "fi")
}} GROUP BY ?ls_id }
OPTIONAL {
{ SELECT ?ls_id (count(distinct ?pl_en) as ?en_count)WHERE {
GRAPH ?ls_id {
?c skos:prefLabel ?pl_en FILTER(LANG(?pl_en) = "en")
}} GROUP BY ?ls_id }
}
OPTIONAL {
{ SELECT ?ls_id (count(distinct ?pl_sv) as ?sv_count)WHERE {
GRAPH ?ls_id {
?c skos:prefLabel ?pl_sv FILTER(LANG(?pl_sv) = "sv")
}} GROUP BY ?ls_id }
}
With en and fi languages this works, but adding sv it fails with
Server Error and 12000+ lines of log for one exception.
Does en and sv work?
Log is truncated so beginning of the log is missing. How could I
proceed with debugging this? Jena is 4.6.1 and I'm running queries in
Fuseki web GUI.
Last lines of exception log:
No Jena code there.
What you are looking is the top of the stacktrace (back to the
operation in Jena) and also the top of the "caused by"
IF they are all the same, put one example on a gist.
Andy
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:319)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:412)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:381)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:268)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:138)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:407)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:894)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: at
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1038)
~[fuseki-server.jar:4.6.1]
Apr 20 15:08:40 x.lingsoft.fi java[832674]: [2023-04-20 15:08:40]
Fuseki INFO [6607] 500 Server Error (40.263 s)
Apr 20 15:08:40 x.lingsoft.fi java[832674]: [2023-04-20 15:08:40]
Fuseki INFO [6606] 500 Server Error (40.279 s)
--
Lingsoft - 30 years of Leading Language Management
www.lingsoft.fi
Speech Applications - Language Management - Translation - Reader's and Writer's
Tools - Text Tools - E-books and M-books
Mikael Pesonen
Semantic Technologies
e-mail: mikael.peso...@lingsoft.fi
Tel. +358 2 279 3300
Time zone: GMT+2
Helsinki Office
Eteläranta 10
FI-00130 Helsinki
FINLAND
Turku Office
Kauppiaskatu 5 A
FI-20100 Turku
FINLAND
