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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content