Jena Time Out Does Not Work (Doc ID 1485241.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

The time out is specified to be 300seconds. When executing a long running query, the query runs for over those 300seconds and hangs there.

We expect the query to abort after 300seconds but this does not happen.
 
Current time-out configuration:

JAVA_OPTS="$JAVA_OPTS -Xms12g -Xmx12g -XX:MaxPermSize=512m -Djena.ext.queryTimeout=300000 -Djena.ext.queryTimeoutInUpdate=120000"
  
PREFIX ORACLE_SEM_FS_NS: <http://oracle.com/semtech#timeout=300,qid=123,degree=4,s2s=t,midtier_cache=t>

Select gives no response in 300 sec and thread is hanging on web server. Following queries create additional hanging threads.

The query executing is:

INFO [http-8080-58] (SPARQL.java:229) - Query:
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX : <http://sdca/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ns: <http://rdfs.org/sioc/ns#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wo: <http://purl.org/ontology/wo/core#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ert: <http://www.cisco.com/semantic/ert#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX fn: <http://www.w3.org/2005/xpath-functions#>
PREFIX ORACLE_SEM_FS_NS: <http://oracle.com/semtech#timeout=300,qid=123,degree=4,s2s=t,midtier_cache=t>
select * WHERE
{
{ Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
UNION { Let (?User := :pera) Let (?Y := <http://sdca/prf1050195387692695>) }
?X :profileOf ?User ; :profileStatus "Active"
FILTER (?Y != ?X) ?BNx :profile ?X
; :skillObject ?Sx .
?BN :profile ?Y ; :skillObject ?Sx .
}

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