org.teiid.jdbc.TeiidSQLException: java.util.concurrent.TimeoutException

[gaoiran]

This exception is being thrown when executing a select * query on a vdb which contains a series of 7 views.  It times out at ~5 minutes each time.  I've set the QueryTimeout to be 10 minutes.  Is there a different property I should be setting?

Thank you.

-Jo

org.teiid.jdbc.TeiidSQLException: java.util.concurrent.TimeoutException

    at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

    at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

    at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:546)

    at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:331)

Caused by: java.util.concurrent.ExecutionException: java.util.concurrent.TimeoutException

    at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:335)

    at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:539)

    ... 5 more

Caused by: java.util.concurrent.TimeoutException

    at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:270)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

    at java.lang.reflect.Method.invoke(Method.java:597)

    at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:110)

    at $Proxy1.read(Unknown Source)

    at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347)

    at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:333)

    ... 6 more

[shawkins]

What version of Teiid and the Teiid client are you using?  Do you have a server-side timeout set?  Is there a corresponding server-side exception in the log?

Steve

[gaoiran]

Thank you for replying.

I'm using v7.5 for both Teiid server and client.  There isn't a corresponding server-side exception in the log ($JBOSS_HOME/server/default/log/server.log).  I'm using default settings for both teiid and jboss (jboss v5.1).  Do you know which file the server-side timeout setting would be?  I'm looking at the .xml files in $JBOSS_HOME/server/default/conf, $JBOSS_HOME/server/default/deploy, $JBOSS_HOME/server/default/deploy/teiid.

-Jo

[shawkins]

Jo,

With default settings the server-side timeout won't come into play.  I believe there is a regression here from https://issues.jboss.org/browse/TEIID-1614.  The remote call is probably being treated as synchronous and is subject to the default timeout of 4 minutes.  A workaround is to change the value of org.teiid.sockets.synchronousttl in the teiid-client-settings.properties file.  You can put an edited version in the classpath ahead of the client jar to override the defaults.  I'll look into this more and log a JIRA as needed.

Thanks,

Steve

[shawkins]

Logged and worked under https://issues.jboss.org/browse/TEIID-1883.

Thanks,

Steve

[gaoiran]

Steve,

Modifying the teiid-client-settings.properties did the trick.

Thank you,

Joyce