Server 'completed' while running query (aka crashed)

[valentinedwv]

We run a qlever (or three) in docker using portainer to manage the container stacks.ar
When server is started (and restarted), the server rebuilds itself (aka get-data, index, start)

Occasionally when running a query in the UI, it will say after a period, the UI says cannot connect to the server.
When we look into the portainer, the log says that the server 'completed' and a new instance is starting up.

The logs in the completed are terse. No idea why the server stopped.
Is there are way to up the logging so we can figure out how?

Same dataset as: #2243

tail of log from 'completed' container

2025-07-28 22:44:47.327 - INFO: Requested media types of the result are: "application/qlever-results+json"
2025-07-28 22:44:47.359 - INFO: Query planning done in 41 ms
2025-07-28 22:44:48.020 - WARN: No timeout check has been performed for at least 91ms, should be at most 50ms. Checked at AddCombinedRowToTable.h:245.
2025-07-28 22:44:48.342 - WARN: No timeout check has been performed for at least 162ms, should be at most 50ms. Checked at AddCombinedRowToTable.h:245.
2025-07-28 22:44:48.988 - WARN: No timeout check has been performed for at least 359ms, should be at most 50ms. Checked at AddCombinedRowToTable.h:245.
2025-07-28 22:44:50.277 - WARN: No timeout check has been performed for at least 696ms, should be at most 50ms. Checked at AddCombinedRowToTable.h:245.
2025-07-28 22:44:52.876 - WARN: No timeout check has been performed for at least 1,542ms, should be at most 50ms. Checked at AddCombinedRowToTable.h:245.
2025-07-28 22:44:54.697 - WARN: No timeout check has been performed for at least 57ms, should be at most 50ms. Checked at AddCombinedRowToTable.h:245.

sparql query that crashed it, this time.

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix schema: <http://schema.org/>
prefix sschema: <https://schema.org/>
PREFIX ql: <http://qlever.cs.uni-freiburg.de/builtin-functions/>
SELECT distinct ?subj ?pubname (GROUP_CONCAT(DISTINCT ?placename; SEPARATOR=", ") AS ?placenames)
    (GROUP_CONCAT(DISTINCT ?kwu; SEPARATOR=", ") AS ?kw)
    ?datep  (GROUP_CONCAT(DISTINCT ?url; SEPARATOR=", ") AS ?disurl)
    (COUNT(?text) AS ?score) (SAMPLE(?text) AS ?example_text)
    ?name ?description (GROUP_CONCAT(DISTINCT ?resourceType_u; SEPARATOR=", ") as ?resourceType )  ?type ?g   (MAX(?lat) as ?maxlat) (Min(?lat) as ?minlat) (MAX(?lon) as ?maxlon) (Min(?lon) as ?minlon)
    ?maxDepth ?minDepth ?temporalCoverage (GROUP_CONCAT(DISTINCT ?variableMeasured_a; SEPARATOR=", ") as ?variableMeasured  )
    ?bbox
WHERE {
    ?subj ?o ?item .

    ?text ql:contains-entity ?item .
    ?text ql:contains-word "water"
    graph ?g {
        values ?sosType {
            sschema:Dataset
            #               sschema:DataCatalog
            schema:Dataset
            #               schema:DataCatalog
        }
        ?subj    a    ?sosType .
        ?subj schema:name|sschema:name ?name .
        ?subj schema:description|sschema:description ?description . }
    values (?type ?resourceType_u) {
        (schema:Dataset "data")
        (sschema:Dataset "data")
        (schema:ResearchProject "researchProject") #BCODMO- project
        (sschema:ResearchProject  "researchProject")
        (schema:SoftwareApplication  "tool")
        (sschema:SoftwareApplication  "tool")
        (schema:Person  "person") #BCODMO- Person
        (sschema:Person  "person")
        (schema:Event  "event") #BCODMO- deployment
        (sschema:Event  "event")
        (schema:Award  "award") #BCODMO- Award
        (sschema:Award  "award")
        (schema:DataCatalog  "DataCatalog")
        (sschema:DataCatalog  "DataCatalog")
        #(UNDEF "other")  # assume it's data. At least we should get  name.
    } ?subj a ?type .
    optional {?subj sschema:distribution/sschema:url|sschema:subjectOf/sschema:url|schema:distribution/schema:url|schema:subjectOf/schema:url ?url1 .}
    OPTIONAL { ?subj schema:datePublished|sschema:datePublished ?datep1 . }
    OPTIONAL { ?subj schema:dateCreated|sschema:dateCreated ?datec . }
    OPTIONAL { ?subj schema:dateModified|sschema:dateModified ?datem . }
    OPTIONAL { ?subj schema:temporalCoverage|sschema:temporalCoverage ?temporalCoverage . }
    OPTIONAL { ?subj schema:publisher/schema:name|sschema:publisher/sschema:name|schema:publisher/schema:legalName|sschema:publisher/sschema:legalName  ?pub_name . }
    OPTIONAL { ?subj schema:spatialCoverage/schema:name|sschema:spatialCoverage/sschema:name|sschema:sdPublisher ?place_name . }
    # OPTIONAL { ?subj schema:spatialCoverage/schema:geo/schema:latitude|sschema:spatialCoverage/sschema:geo/sschema:latitude ?lat . }
    # OPTIONAL { ?subj sschema:spatialCoverage/sschema:geo ?geo .
    #         ?geo a sschema:GeoCoordinates .
    #		 ?geo sschema:longitude ?lon .
    #		 ?geo sschema:llatitude ?lat . }

    #OPTIONAL { ?subj sschema:spatialCoverage/sschema:geo ?geo .
    #         ?geo a sschema:GeoShape .
    #		 ?geo sschema:box ?box . }
    #     bind ( COALESCE(?box) As ?bbox)
    OPTIONAL { ?subj schema:keywords|sschema:keywords ?kw1 . }
    OPTIONAL { ?subj sschema:variableMeasured ?vm .
        ?vm a sschema:PropertyValue .
        ?vm sschema:name ?variableMeasured_a .
 }
    # if there is more than one location, then coallese to get the versions.
    OPTIONAL { ?subj sschema:variableMeasured ?vm .
              ?vm a  sschema:PropertyValue  .
              ?vm sschema:name ?namedepth  .
              FILTER (?namedepth IN ("depth", "CmpDep") ) .
              ?vm sschema:maxValue ?maxDepth_d .
              ?vm sschema:minValue ?minDepth_d
 }
    bind ( COALESCE(?maxDepth_d) As ?maxDepth)
    bind ( COALESCE(?minDepth_d) As ?minDepth)

    # temporal coverage.
    bind ( COALESCE(?kw1, "") As ?kwu)
    bind ( COALESCE(?url1) As ?url)
    # pick one date
    bind ( COALESCE(?datec,?datem,?datep1) As ?datep)
    BIND ( IF ( BOUND(?pub_name), ?pub_name, "No Publisher") as ?pubname ) .
    BIND ( IF ( BOUND(?place_name), ?place_name, "No Placenames") as ?placename ) .
}
GROUP BY ?subj ?pubname ?placename  ?datep ?url  ?name ?description ?type ?maxDepth ?minDepth ?temporalCoverage ?bbox ?g
ORDER BY DESC(?score)
LIMIT 100

[ktk]

Sorry I don't understand what you wrote here, can you try to rephrase?

[valentinedwv]

Tried to better clarify,
Some queries appear to cause the server to stop. No results returned, and UI says cannot contact server.
Because it stopped, docker restarts a new container.

The evidence for this is in the manager we use (portainer).
A container is flagged a 'completed' and a new container shows 'starting' or 'running'
No details in the logs of the completed server.

[valentinedwv]

Closing. This works on the docker container tagged: adfreiburg/qlever:pr-2271