Unexplained occurrences of the error TEIID30160 The request XXXXXXXXXXXX.0 has been cancelled

Solution Verified - Updated -

Issue

Long-running JDV queries return the following error to the client:

org.teiid.jdbc.TeiidSQLException: 57014 TEIID30160 The request FIw3JWxmijBk.0 has been cancelled.
     at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)

In the server logs, log entries similar to these are present:

06:02:48,578 INFO  [org.teiid.COMMAND_LOG] (New I/O worker #9)  START USER COMMAND: startTime=2019-01-21 06:02:48.578   requestID=FIw3JWxmijBk.0    txID=null   sessionID=FIw3JWxmijBk  applicationName=JDBC    principal=*******@teiid-security    vdbName=********    vdbVersion=1    sql=SELECT * FROM ********
06:13:51,271 INFO  [org.teiid.SECURITY] (SessionMonitor) TEIID40007 Keepalive failed for session FIw3JWxmijBk
06:13:51,276 INFO  [org.teiid.COMMAND_LOG] (SessionMonitor)     CANCEL USER COMMAND:    endTime=2019-01-21 06:13:51.276 requestID=FIw3JWxmijBk.0    txID=null   sessionID=null  principal=null  vdbName=null    vdbVersion=0    finalRowCount=null
06:13:51,293 INFO  [org.teiid.COMMAND_LOG] (Worker14_QueryProcessorQueue241135)     END USER COMMAND:   endTime=2019-01-21 06:13:51.293 requestID=FIw3JWxmijBk.0    txID=null   sessionID=null  principal=null  vdbName=null    vdbVersion=0    finalRowCount=56236032
06:13:51,293 WARN  [org.teiid.PROCESSOR] (New I/O worker #9) TEIID40011 Processing exception 'TEIID40042 Invalid Session FIw3JWxmijBk. Session may have already been terminated.' for session null.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.jboss.TransportService$2.invoke(TransportService.java:239).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session FIw3JWxmijBk. Session may have already been terminated.
        at org.teiid.jboss.TransportService$2.invoke(TransportService.java:239) [teiid-jboss-integration-8.12.14.6_4-redhat-64-3.jar:8.12.14.6_4-redhat-64-3]
        at com.sun.proxy.$Proxy32.processCursorRequest(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source) [:1.8.0_171]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
        at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
        at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.12.14.6_4-redhat-64-3.jar:8.12.14.6_4-redhat-64-3]
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284) [teiid-engine-8.12.14.6_4-redhat-64-3.jar:8.12.14.6_4-redhat-64-3]
        at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:231) [teiid-runtime-8.12.14.6_4-redhat-64-3.jar:8.12.14.6_4-redhat-64-3]
        at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:217) [teiid-runtime-8.12.14.6_4-redhat-64-3.jar:8.12.14.6_4-redhat-64-3]
        at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:216) [teiid-runtime-8.12.14.6_4-redhat-64-3.jar:8.12.14.6_4-redhat-64-3]

Environment

Red Hat JBoss Data Virtualization (JDV)
- 6.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In