Timeout In Long Running Query In Joseki Endpoint (Doc ID 1621875.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

A timeout is triggered in the jena adapter while executing a query:
"2013-12-19 10:12:09,911 [Timer-3] DEBUG oracle.spatial.rdf.client.jena.OracleLeanQueryIter []: requestCancel: called"

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX ORACLE_SEM_FS_NS:
<http://oracle.com/semtech#ALLOW_DUP=t,s2s=f,BEST_EFFORT_QUERY=t,qid=12345>

SELECT ?act ?cid ?oj ?ojid ?pf ?pl {
?act <http://xxx#resource_legal_published_in_official-journal> ?oj.
?oj <http://xxx#work_id_document> ?ojid.
?oj <http://xxx#official-journal_year> "2013"^^xsd:gYear.
?oj <http://xxx#date_publication> ?date_pub.
?e <http://xxx#expression_belongs_to_work> ?act.
?e <http://xxx#expression_uses_language> <http://publications.europa.eu/resource/authority/language/ENG>.
?m <http://xxx#manifests> ?e.
?m <http://xxx#manifestation_type> "print"^^xsd:string.
?m <http://xxx#page_first> ?pf.
?m <http://xxx#page_last> ?pl.
FILTER (?date_pub >= "1900-01-01"^^xsd:date)
FILTER (?date_pub <= "9999-12-31"^^xsd:date)
FILTER regex(?ojid, "^oj:", "i")
OPTIONAL{?act <http://xxx#id_celex> ?cid}
}

After setting the following JVM property:

-Djena.ext.queryTimeout=1000000

some queries will complete execution but others still time out

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms