[JBoss JIRA] (TEIID-4013) ODBC sessions never release
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4013?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4013:
---------------------------------------
This seems more like a question than a bug, unless you have determined that your clients are no longer attached. Perhaps you have pooling configured.
Unlike JDBC there is no ping mechanism for the ODBC connections since they are 1-1 with their client. There is the session property sessions-expiration-timelimit to define a max session age, but by default it's unlimited.
> ODBC sessions never release
> ---------------------------
>
> Key: TEIID-4013
> URL: https://issues.jboss.org/browse/TEIID-4013
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Attachments: Capture.PNG, Capture2.PNG, Capture3.PNG
>
>
> I have 3 ODBC System DSNs on a Windows server. When I'm viewing the Deployed VDBs and looking at the Sessions tab, the ODBC connections never seem to time out or release. Not really sure if/when they should release, but they continue to multiply. See screenshots.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4013) ODBC sessions never release
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4013?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4013:
------------------------------
Description: I have 3 ODBC System DSNs on a Windows server. When I'm viewing the Deployed VDBs and looking at the Sessions tab, the ODBC connections never seem to time out or release. Not really sure if/when they should release, but they continue to multiply. See screenshots. (was: Strange error keeps popping up in my logs. Seems to be ODBC related, but unsure how to consistently reproduce.
Here's the log.
{code}
23:42:51,012 WARN [org.teiid.SECURITY] (New I/O worker #6) TEIID40011 Processing exception 'TEIID40042 Invalid Session QgVmoyR4CiPk. Session may have already been terminated.' for session QgVmoyR4CiPk. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session QgVmoyR4CiPk. Session may have already been terminated.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
23:42:51,242 DEBUG [org.teiid.SECURITY] (New I/O worker #6) closeSession QgVmoyR4CiPk
23:42:51,906 DEBUG [org.teiid.SECURITY] (New I/O worker #2) authenticateUser soamgr JDBC
23:42:51,907 DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful for " soamgr " in security domain teiid-security
23:42:51,907 DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful, created session: sessionid=l/84mvfVB/u+; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:51 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:51 EST 2016
23:42:52,676 DEBUG [org.teiid.SECURITY] (New I/O worker #2) closeSession l/84mvfVB/u+
23:42:52,988 WARN [org.teiid.SECURITY] (New I/O worker #2) TEIID40011 Processing exception 'TEIID40042 Invalid Session l/84mvfVB/u+. Session may have already been terminated.' for session l/84mvfVB/u+. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session l/84mvfVB/u+. Session may have already been terminated.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
23:42:53,223 DEBUG [org.teiid.SECURITY] (New I/O worker #2) closeSession l/84mvfVB/u+
23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) authenticateUser soamgr JDBC
23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful for " soamgr " in security domain teiid-security
23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful, created session: sessionid=WXPcvzMuqK9I; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:53 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:53 EST 2016
23:42:54,370 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession WXPcvzMuqK9I
23:42:54,801 WARN [org.teiid.SECURITY] (New I/O worker #3) TEIID40011 Processing exception 'TEIID40042 Invalid Session WXPcvzMuqK9I. Session may have already been terminated.' for session WXPcvzMuqK9I. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session WXPcvzMuqK9I. Session may have already been terminated.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
23:42:55,031 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession WXPcvzMuqK9I
23:42:55,705 DEBUG [org.teiid.SECURITY] (New I/O worker #5) authenticateUser soamgr JDBC
23:42:55,705 DEBUG [org.teiid.SECURITY] (New I/O worker #5) Logon successful for " soamgr " in security domain teiid-security
23:42:55,706 DEBUG [org.teiid.SECURITY] (New I/O worker #5) Logon successful, created session: sessionid=8KudIKsWRvMU; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:55 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:55 EST 2016
23:42:56,166 DEBUG [org.teiid.SECURITY] (New I/O worker #5) closeSession 8KudIKsWRvMU
23:42:57,612 DEBUG [org.teiid.SECURITY] (New I/O worker #5) closeSession 8KudIKsWRvMU
23:42:57,612 DEBUG [org.teiid.SECURITY] (New I/O worker #6) closeSession AC4JdNVB7ACV
23:46:49,479 DEBUG [org.teiid.SECURITY] (New I/O worker #8) closeSession null
23:46:49,479 DEBUG [org.teiid.SECURITY] (New I/O worker #8) authenticateUser teiidUser ODBC
23:46:49,480 DEBUG [org.teiid.SECURITY] (New I/O worker #8) Logon successful for " teiidUser " in security domain teiid-security
23:46:49,480 DEBUG [org.teiid.SECURITY] (New I/O worker #8) Logon successful, created session: sessionid=Yrgeys4o4Q80; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:46:49 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:46:49 EST 2016
23:46:49,619 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57063) TEIID30020 Processing exception for request Yrgeys4o4Q80.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) closeSession null
23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) authenticateUser teiidUser ODBC
23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) Logon successful for " teiidUser " in security domain teiid-security
23:47:34,752 DEBUG [org.teiid.SECURITY] (New I/O worker #1) Logon successful, created session: sessionid=nHV7WzgpZHN+; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:34 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:34 EST 2016
23:47:34,876 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57065) TEIID30020 Processing exception for request nHV7WzgpZHN+.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
23:47:39,526 DEBUG [org.teiid.SECURITY] (New I/O worker #4) closeSession null
23:47:39,527 DEBUG [org.teiid.SECURITY] (New I/O worker #4) authenticateUser teiidUser ODBC
23:47:39,527 DEBUG [org.teiid.SECURITY] (New I/O worker #4) Logon successful for " teiidUser " in security domain teiid-security
23:47:39,528 DEBUG [org.teiid.SECURITY] (New I/O worker #4) Logon successful, created session: sessionid=UkOUFAafsE0W; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:39 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:39 EST 2016
23:47:39,657 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57067) TEIID30020 Processing exception for request UkOUFAafsE0W.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
23:47:44,380 DEBUG [org.teiid.SECURITY] (New I/O worker #7) closeSession null
23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) authenticateUser teiidUser ODBC
23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) Logon successful for " teiidUser " in security domain teiid-security
23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) Logon successful, created session: sessionid=x12OlpeowbQH; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:44 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:44 EST 2016
23:47:44,502 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57069) TEIID30020 Processing exception for request x12OlpeowbQH.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
{code})
> ODBC sessions never release
> ---------------------------
>
> Key: TEIID-4013
> URL: https://issues.jboss.org/browse/TEIID-4013
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Attachments: Capture.PNG, Capture2.PNG, Capture3.PNG
>
>
> I have 3 ODBC System DSNs on a Windows server. When I'm viewing the Deployed VDBs and looking at the Sessions tab, the ODBC connections never seem to time out or release. Not really sure if/when they should release, but they continue to multiply. See screenshots.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4013) ODBC sessions never release
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4013?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4013:
------------------------------
Attachment: Capture3.PNG
Capture2.PNG
Capture.PNG
> ODBC sessions never release
> ---------------------------
>
> Key: TEIID-4013
> URL: https://issues.jboss.org/browse/TEIID-4013
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Attachments: Capture.PNG, Capture2.PNG, Capture3.PNG
>
>
> I have 3 ODBC System DSNs on a Windows server. When I'm viewing the Deployed VDBs and looking at the Sessions tab, the ODBC connections never seem to time out or release. Not really sure if/when they should release, but they continue to multiply. See screenshots.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4013) ODBC sessions never release
by Steve Tran (JIRA)
Steve Tran created TEIID-4013:
---------------------------------
Summary: ODBC sessions never release
Key: TEIID-4013
URL: https://issues.jboss.org/browse/TEIID-4013
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1.6_2
Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5,
JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
64-bit Windows 7 environment
Reporter: Steve Tran
Assignee: Steven Hawkins
Strange error keeps popping up in my logs. Seems to be ODBC related, but unsure how to consistently reproduce.
Here's the log.
{code}
23:42:51,012 WARN [org.teiid.SECURITY] (New I/O worker #6) TEIID40011 Processing exception 'TEIID40042 Invalid Session QgVmoyR4CiPk. Session may have already been terminated.' for session QgVmoyR4CiPk. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session QgVmoyR4CiPk. Session may have already been terminated.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
23:42:51,242 DEBUG [org.teiid.SECURITY] (New I/O worker #6) closeSession QgVmoyR4CiPk
23:42:51,906 DEBUG [org.teiid.SECURITY] (New I/O worker #2) authenticateUser soamgr JDBC
23:42:51,907 DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful for " soamgr " in security domain teiid-security
23:42:51,907 DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful, created session: sessionid=l/84mvfVB/u+; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:51 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:51 EST 2016
23:42:52,676 DEBUG [org.teiid.SECURITY] (New I/O worker #2) closeSession l/84mvfVB/u+
23:42:52,988 WARN [org.teiid.SECURITY] (New I/O worker #2) TEIID40011 Processing exception 'TEIID40042 Invalid Session l/84mvfVB/u+. Session may have already been terminated.' for session l/84mvfVB/u+. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session l/84mvfVB/u+. Session may have already been terminated.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
23:42:53,223 DEBUG [org.teiid.SECURITY] (New I/O worker #2) closeSession l/84mvfVB/u+
23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) authenticateUser soamgr JDBC
23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful for " soamgr " in security domain teiid-security
23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful, created session: sessionid=WXPcvzMuqK9I; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:53 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:53 EST 2016
23:42:54,370 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession WXPcvzMuqK9I
23:42:54,801 WARN [org.teiid.SECURITY] (New I/O worker #3) TEIID40011 Processing exception 'TEIID40042 Invalid Session WXPcvzMuqK9I. Session may have already been terminated.' for session WXPcvzMuqK9I. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session WXPcvzMuqK9I. Session may have already been terminated.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
23:42:55,031 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession WXPcvzMuqK9I
23:42:55,705 DEBUG [org.teiid.SECURITY] (New I/O worker #5) authenticateUser soamgr JDBC
23:42:55,705 DEBUG [org.teiid.SECURITY] (New I/O worker #5) Logon successful for " soamgr " in security domain teiid-security
23:42:55,706 DEBUG [org.teiid.SECURITY] (New I/O worker #5) Logon successful, created session: sessionid=8KudIKsWRvMU; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:55 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:55 EST 2016
23:42:56,166 DEBUG [org.teiid.SECURITY] (New I/O worker #5) closeSession 8KudIKsWRvMU
23:42:57,612 DEBUG [org.teiid.SECURITY] (New I/O worker #5) closeSession 8KudIKsWRvMU
23:42:57,612 DEBUG [org.teiid.SECURITY] (New I/O worker #6) closeSession AC4JdNVB7ACV
23:46:49,479 DEBUG [org.teiid.SECURITY] (New I/O worker #8) closeSession null
23:46:49,479 DEBUG [org.teiid.SECURITY] (New I/O worker #8) authenticateUser teiidUser ODBC
23:46:49,480 DEBUG [org.teiid.SECURITY] (New I/O worker #8) Logon successful for " teiidUser " in security domain teiid-security
23:46:49,480 DEBUG [org.teiid.SECURITY] (New I/O worker #8) Logon successful, created session: sessionid=Yrgeys4o4Q80; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:46:49 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:46:49 EST 2016
23:46:49,619 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57063) TEIID30020 Processing exception for request Yrgeys4o4Q80.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) closeSession null
23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) authenticateUser teiidUser ODBC
23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) Logon successful for " teiidUser " in security domain teiid-security
23:47:34,752 DEBUG [org.teiid.SECURITY] (New I/O worker #1) Logon successful, created session: sessionid=nHV7WzgpZHN+; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:34 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:34 EST 2016
23:47:34,876 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57065) TEIID30020 Processing exception for request nHV7WzgpZHN+.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
23:47:39,526 DEBUG [org.teiid.SECURITY] (New I/O worker #4) closeSession null
23:47:39,527 DEBUG [org.teiid.SECURITY] (New I/O worker #4) authenticateUser teiidUser ODBC
23:47:39,527 DEBUG [org.teiid.SECURITY] (New I/O worker #4) Logon successful for " teiidUser " in security domain teiid-security
23:47:39,528 DEBUG [org.teiid.SECURITY] (New I/O worker #4) Logon successful, created session: sessionid=UkOUFAafsE0W; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:39 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:39 EST 2016
23:47:39,657 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57067) TEIID30020 Processing exception for request UkOUFAafsE0W.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
23:47:44,380 DEBUG [org.teiid.SECURITY] (New I/O worker #7) closeSession null
23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) authenticateUser teiidUser ODBC
23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) Logon successful for " teiidUser " in security domain teiid-security
23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) Logon successful, created session: sessionid=x12OlpeowbQH; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:44 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:44 EST 2016
23:47:44,502 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57069) TEIID30020 Processing exception for request x12OlpeowbQH.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4012) TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4012?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4012:
------------------------------
Description:
Strange error keeps popping up in my logs. Seems to be ODBC related, but unsure how to consistently reproduce.
Here's the log.
{code}
23:42:51,012 WARN [org.teiid.SECURITY] (New I/O worker #6) TEIID40011 Processing exception 'TEIID40042 Invalid Session QgVmoyR4CiPk. Session may have already been terminated.' for session QgVmoyR4CiPk. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session QgVmoyR4CiPk. Session may have already been terminated.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
23:42:51,242 DEBUG [org.teiid.SECURITY] (New I/O worker #6) closeSession QgVmoyR4CiPk
23:42:51,906 DEBUG [org.teiid.SECURITY] (New I/O worker #2) authenticateUser soamgr JDBC
23:42:51,907 DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful for " soamgr " in security domain teiid-security
23:42:51,907 DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful, created session: sessionid=l/84mvfVB/u+; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:51 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:51 EST 2016
23:42:52,676 DEBUG [org.teiid.SECURITY] (New I/O worker #2) closeSession l/84mvfVB/u+
23:42:52,988 WARN [org.teiid.SECURITY] (New I/O worker #2) TEIID40011 Processing exception 'TEIID40042 Invalid Session l/84mvfVB/u+. Session may have already been terminated.' for session l/84mvfVB/u+. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session l/84mvfVB/u+. Session may have already been terminated.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
23:42:53,223 DEBUG [org.teiid.SECURITY] (New I/O worker #2) closeSession l/84mvfVB/u+
23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) authenticateUser soamgr JDBC
23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful for " soamgr " in security domain teiid-security
23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful, created session: sessionid=WXPcvzMuqK9I; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:53 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:53 EST 2016
23:42:54,370 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession WXPcvzMuqK9I
23:42:54,801 WARN [org.teiid.SECURITY] (New I/O worker #3) TEIID40011 Processing exception 'TEIID40042 Invalid Session WXPcvzMuqK9I. Session may have already been terminated.' for session WXPcvzMuqK9I. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session WXPcvzMuqK9I. Session may have already been terminated.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
23:42:55,031 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession WXPcvzMuqK9I
23:42:55,705 DEBUG [org.teiid.SECURITY] (New I/O worker #5) authenticateUser soamgr JDBC
23:42:55,705 DEBUG [org.teiid.SECURITY] (New I/O worker #5) Logon successful for " soamgr " in security domain teiid-security
23:42:55,706 DEBUG [org.teiid.SECURITY] (New I/O worker #5) Logon successful, created session: sessionid=8KudIKsWRvMU; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:55 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:55 EST 2016
23:42:56,166 DEBUG [org.teiid.SECURITY] (New I/O worker #5) closeSession 8KudIKsWRvMU
23:42:57,612 DEBUG [org.teiid.SECURITY] (New I/O worker #5) closeSession 8KudIKsWRvMU
23:42:57,612 DEBUG [org.teiid.SECURITY] (New I/O worker #6) closeSession AC4JdNVB7ACV
23:46:49,479 DEBUG [org.teiid.SECURITY] (New I/O worker #8) closeSession null
23:46:49,479 DEBUG [org.teiid.SECURITY] (New I/O worker #8) authenticateUser teiidUser ODBC
23:46:49,480 DEBUG [org.teiid.SECURITY] (New I/O worker #8) Logon successful for " teiidUser " in security domain teiid-security
23:46:49,480 DEBUG [org.teiid.SECURITY] (New I/O worker #8) Logon successful, created session: sessionid=Yrgeys4o4Q80; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:46:49 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:46:49 EST 2016
23:46:49,619 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57063) TEIID30020 Processing exception for request Yrgeys4o4Q80.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) closeSession null
23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) authenticateUser teiidUser ODBC
23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) Logon successful for " teiidUser " in security domain teiid-security
23:47:34,752 DEBUG [org.teiid.SECURITY] (New I/O worker #1) Logon successful, created session: sessionid=nHV7WzgpZHN+; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:34 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:34 EST 2016
23:47:34,876 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57065) TEIID30020 Processing exception for request nHV7WzgpZHN+.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
23:47:39,526 DEBUG [org.teiid.SECURITY] (New I/O worker #4) closeSession null
23:47:39,527 DEBUG [org.teiid.SECURITY] (New I/O worker #4) authenticateUser teiidUser ODBC
23:47:39,527 DEBUG [org.teiid.SECURITY] (New I/O worker #4) Logon successful for " teiidUser " in security domain teiid-security
23:47:39,528 DEBUG [org.teiid.SECURITY] (New I/O worker #4) Logon successful, created session: sessionid=UkOUFAafsE0W; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:39 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:39 EST 2016
23:47:39,657 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57067) TEIID30020 Processing exception for request UkOUFAafsE0W.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
23:47:44,380 DEBUG [org.teiid.SECURITY] (New I/O worker #7) closeSession null
23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) authenticateUser teiidUser ODBC
23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) Logon successful for " teiidUser " in security domain teiid-security
23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) Logon successful, created session: sessionid=x12OlpeowbQH; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:44 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:44 EST 2016
23:47:44,502 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57069) TEIID30020 Processing exception for request x12OlpeowbQH.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
{code}
was:Strange error keeps popping up in my
> TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-4012
> URL: https://issues.jboss.org/browse/TEIID-4012
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> Strange error keeps popping up in my logs. Seems to be ODBC related, but unsure how to consistently reproduce.
> Here's the log.
> {code}
> 23:42:51,012 WARN [org.teiid.SECURITY] (New I/O worker #6) TEIID40011 Processing exception 'TEIID40042 Invalid Session QgVmoyR4CiPk. Session may have already been terminated.' for session QgVmoyR4CiPk. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session QgVmoyR4CiPk. Session may have already been terminated.
> at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> 23:42:51,242 DEBUG [org.teiid.SECURITY] (New I/O worker #6) closeSession QgVmoyR4CiPk
> 23:42:51,906 DEBUG [org.teiid.SECURITY] (New I/O worker #2) authenticateUser soamgr JDBC
> 23:42:51,907 DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful for " soamgr " in security domain teiid-security
> 23:42:51,907 DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful, created session: sessionid=l/84mvfVB/u+; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:51 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:51 EST 2016
> 23:42:52,676 DEBUG [org.teiid.SECURITY] (New I/O worker #2) closeSession l/84mvfVB/u+
> 23:42:52,988 WARN [org.teiid.SECURITY] (New I/O worker #2) TEIID40011 Processing exception 'TEIID40042 Invalid Session l/84mvfVB/u+. Session may have already been terminated.' for session l/84mvfVB/u+. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session l/84mvfVB/u+. Session may have already been terminated.
> at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> 23:42:53,223 DEBUG [org.teiid.SECURITY] (New I/O worker #2) closeSession l/84mvfVB/u+
> 23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) authenticateUser soamgr JDBC
> 23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful for " soamgr " in security domain teiid-security
> 23:42:53,887 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful, created session: sessionid=WXPcvzMuqK9I; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:53 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:53 EST 2016
> 23:42:54,370 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession WXPcvzMuqK9I
> 23:42:54,801 WARN [org.teiid.SECURITY] (New I/O worker #3) TEIID40011 Processing exception 'TEIID40042 Invalid Session WXPcvzMuqK9I. Session may have already been terminated.' for session WXPcvzMuqK9I. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session WXPcvzMuqK9I. Session may have already been terminated.
> at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:339) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.services.SessionServiceImpl.pingServer(SessionServiceImpl.java:307) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.LogonImpl.ping(LogonImpl.java:248) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.7.0_75]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:222) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:208) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1]
> at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> 23:42:55,031 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession WXPcvzMuqK9I
> 23:42:55,705 DEBUG [org.teiid.SECURITY] (New I/O worker #5) authenticateUser soamgr JDBC
> 23:42:55,705 DEBUG [org.teiid.SECURITY] (New I/O worker #5) Logon successful for " soamgr " in security domain teiid-security
> 23:42:55,706 DEBUG [org.teiid.SECURITY] (New I/O worker #5) Logon successful, created session: sessionid=8KudIKsWRvMU; userName=soamgr@teiid-security; vdbName=BDF_CorrectionsVDB_SIT; vdbVersion=1; createdTime=Wed Mar 02 23:42:55 EST 2016; applicationName=JDBC; clientHostName=BLRW3005061.internal.imsglobal.com; clientHardwareAddress=D05349B87F6E; IPAddress=10.205.51.156; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:42:55 EST 2016
> 23:42:56,166 DEBUG [org.teiid.SECURITY] (New I/O worker #5) closeSession 8KudIKsWRvMU
> 23:42:57,612 DEBUG [org.teiid.SECURITY] (New I/O worker #5) closeSession 8KudIKsWRvMU
> 23:42:57,612 DEBUG [org.teiid.SECURITY] (New I/O worker #6) closeSession AC4JdNVB7ACV
> 23:46:49,479 DEBUG [org.teiid.SECURITY] (New I/O worker #8) closeSession null
> 23:46:49,479 DEBUG [org.teiid.SECURITY] (New I/O worker #8) authenticateUser teiidUser ODBC
> 23:46:49,480 DEBUG [org.teiid.SECURITY] (New I/O worker #8) Logon successful for " teiidUser " in security domain teiid-security
> 23:46:49,480 DEBUG [org.teiid.SECURITY] (New I/O worker #8) Logon successful, created session: sessionid=Yrgeys4o4Q80; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:46:49 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:46:49 EST 2016
> 23:46:49,619 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57063) TEIID30020 Processing exception for request Yrgeys4o4Q80.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
> 23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) closeSession null
> 23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) authenticateUser teiidUser ODBC
> 23:47:34,751 DEBUG [org.teiid.SECURITY] (New I/O worker #1) Logon successful for " teiidUser " in security domain teiid-security
> 23:47:34,752 DEBUG [org.teiid.SECURITY] (New I/O worker #1) Logon successful, created session: sessionid=nHV7WzgpZHN+; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:34 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:34 EST 2016
> 23:47:34,876 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57065) TEIID30020 Processing exception for request nHV7WzgpZHN+.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
> 23:47:39,526 DEBUG [org.teiid.SECURITY] (New I/O worker #4) closeSession null
> 23:47:39,527 DEBUG [org.teiid.SECURITY] (New I/O worker #4) authenticateUser teiidUser ODBC
> 23:47:39,527 DEBUG [org.teiid.SECURITY] (New I/O worker #4) Logon successful for " teiidUser " in security domain teiid-security
> 23:47:39,528 DEBUG [org.teiid.SECURITY] (New I/O worker #4) Logon successful, created session: sessionid=UkOUFAafsE0W; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:39 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:39 EST 2016
> 23:47:39,657 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57067) TEIID30020 Processing exception for request UkOUFAafsE0W.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
> 23:47:44,380 DEBUG [org.teiid.SECURITY] (New I/O worker #7) closeSession null
> 23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) authenticateUser teiidUser ODBC
> 23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) Logon successful for " teiidUser " in security domain teiid-security
> 23:47:44,381 DEBUG [org.teiid.SECURITY] (New I/O worker #7) Logon successful, created session: sessionid=x12OlpeowbQH; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Wed Mar 02 23:47:44 EST 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Wed Mar 02 23:47:44 EST 2016
> 23:47:44,502 WARN [org.teiid.PROCESSOR] (Worker98_QueryProcessorQueue57069) TEIID30020 Processing exception for request x12OlpeowbQH.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4012) TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4012?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4012:
------------------------------
Environment:
Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5,
JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
64-bit Windows 7 environment
was:
Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
64-bit Windows 7 environment
> TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-4012
> URL: https://issues.jboss.org/browse/TEIID-4012
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> Strange error keeps popping up in my
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4012) TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4012?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4012:
------------------------------
Description: Strange error keeps popping up in my
> TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-4012
> URL: https://issues.jboss.org/browse/TEIID-4012
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> Strange error keeps popping up in my
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4012) TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4012?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4012:
------------------------------
Fix Version/s: (was: 8.13)
> TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-4012
> URL: https://issues.jboss.org/browse/TEIID-4012
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4012) TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4012?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4012:
------------------------------
Component/s: (was: ODBC)
> TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-4012
> URL: https://issues.jboss.org/browse/TEIID-4012
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4012) TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4012?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4012:
------------------------------
Description: (was: Getting an error when attempting to update an Oracle Table that was virtualized in JDV.
Here's the query
update A
set do_not_use = 1
FROM OPENQUERY(HSI, 'SELECT * FROM hsi_DW_ebl.hsi_tm_pd where do_not_use is null') A
where do_not_use is null;
{code}
[Server:cdtssoa126d-jdv-one] 21:14:35,311 WARN [org.teiid.ODBC] (Worker975_QueryProcessorQueue8734224) TEIID40020 Error occurred: org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" at line 1, column 1.
[Server:cdtssoa126d-jdv-one] Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
[Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1001) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:556) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:352) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
[Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
[Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
[Server:cdtssoa126d-jdv-one] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" at line 1, column 1.
[Server:cdtssoa126d-jdv-one] Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
[Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:164) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:140) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:279) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:363) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:435) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:613) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
[Server:cdtssoa126d-jdv-one] ... 8 more
{code})
> TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-4012
> URL: https://issues.jboss.org/browse/TEIID-4012
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
- 1
- 0