Unexplained occurrences of the error TEIID30160 The request XXXXXXXXXXXX.0 has been cancelled
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.