[JBoss JIRA] (TEIID-4015) Error or incorrect value when there is a conflict between local and correlated names
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4015?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4015:
----------------------------------
Priority: Critical (was: Major)
> Error or incorrect value when there is a conflict between local and correlated names
> ------------------------------------------------------------------------------------
>
> Key: TEIID-4015
> URL: https://issues.jboss.org/browse/TEIID-4015
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 9.0, 8.12.5, 8.13.2
>
>
> With a query such as:
> select e1, (select e1 from (select t1.e1 from pm1.g1 as t1) as t2 where t2.e1 = t1.e1) from pm2.g1 as t1
> The correlated reference to t1.e1 will get evaulated as if it were a local value from pm1.g1 as t1 instead. This is because the evaluator doesn't immediately look for the context value, but rather calls to internalEvaluate.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-4015) Error or incorrect value when there is a conflict between local and correlated names
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4015?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4015.
-----------------------------------
Resolution: Done
Corrected the reference evaluation to look immediately in the context.
> Error or incorrect value when there is a conflict between local and correlated names
> ------------------------------------------------------------------------------------
>
> Key: TEIID-4015
> URL: https://issues.jboss.org/browse/TEIID-4015
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 9.0, 8.12.5, 8.13.2
>
>
> With a query such as:
> select e1, (select e1 from (select t1.e1 from pm1.g1 as t1) as t2 where t2.e1 = t1.e1) from pm2.g1 as t1
> The correlated reference to t1.e1 will get evaulated as if it were a local value from pm1.g1 as t1 instead. This is because the evaluator doesn't immediately look for the context value, but rather calls to internalEvaluate.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-4016) Teiid parser fails to address co-existence of SQL comment and cache hint prior to rest of SQL string
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4016?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4016:
----------------------------------
Issue Type: Enhancement (was: Bug)
Our general expectation was to look only at the initial comment, so I'm modifying this as an enhancement. We'll update the docs as well.
> Teiid parser fails to address co-existence of SQL comment and cache hint prior to rest of SQL string
> ----------------------------------------------------------------------------------------------------
>
> Key: TEIID-4016
> URL: https://issues.jboss.org/browse/TEIID-4016
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 8.12.4
> Reporter: Paul Richardson
> Assignee: Steven Hawkins
>
> Please review analysis of the issue in TEIIDDES-2802.
> In summary, when a comment is located in front of the cache hint in an sql string, the cache hint is dropped from the resulting language objects. This is due to the regular expression used for finding cache hints in the parser template.
> For Designer to fix this issue, Teiid needs to fix it as well since the results of the parsers should match, ie. there is no point in Designer retaining the cache hint if Teiid does not.
> The following unit test demonstrates this issue:
> {code}
> String sql = "/* HELLO */ /*+ cache(ttl:180000) */ SELECT col1 FROM tbl WHERE col2 IN /*+ MJ */ (SELECT col1 FROM tbl2) /* trailing comment */ ";
> String expSql = "/*+ cache(ttl:180000) */ SELECT col1 FROM tbl WHERE col2 IN /*+ MJ */ (SELECT col1 FROM tbl2) /* trailing comment */ ";
> Command command = QueryParser.getQueryParser().parseCommand(sql, new ParseInfo());
> assertEquals(expSql, command.toString()); // this will fail due to no cache hint
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-4016) Teiid parser fails to address co-existence of SQL comment and cache hint prior to rest of SQL string
by Paul Richardson (JIRA)
Paul Richardson created TEIID-4016:
--------------------------------------
Summary: Teiid parser fails to address co-existence of SQL comment and cache hint prior to rest of SQL string
Key: TEIID-4016
URL: https://issues.jboss.org/browse/TEIID-4016
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.12.4
Reporter: Paul Richardson
Assignee: Steven Hawkins
Please review analysis of the issue in TEIIDDES-2802.
In summary, when a comment is located in front of the cache hint in an sql string, the cache hint is dropped from the resulting language objects. This is due to the regular expression used for finding cache hints in the parser template.
For Designer to fix this issue, Teiid needs to fix it as well since the results of the parsers should match, ie. there is no point in Designer retaining the cache hint if Teiid does not.
The following unit test demonstrates this issue:
{code}
String sql = "/* HELLO */ /*+ cache(ttl:180000) */ SELECT col1 FROM tbl WHERE col2 IN /*+ MJ */ (SELECT col1 FROM tbl2) /* trailing comment */ ";
String expSql = "/*+ cache(ttl:180000) */ SELECT col1 FROM tbl WHERE col2 IN /*+ MJ */ (SELECT col1 FROM tbl2) /* trailing comment */ ";
Command command = QueryParser.getQueryParser().parseCommand(sql, new ParseInfo());
assertEquals(expSql, command.toString()); // this will fail due to no cache hint
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-2820) Support Couchbase as a resource
by Jason Marley (JIRA)
[ https://issues.jboss.org/browse/TEIID-2820?page=com.atlassian.jira.plugin... ]
Jason Marley commented on TEIID-2820:
-------------------------------------
The couchbase translator is in the 8.12.x branch and currenlty in the sandbox folder. The resource adapter is working. The next step for us to create add the basic select functionality. As part of this project, I am standing up a couchbase docker container, you can follow and contribute and/or setup your own environment to test it out by getting instructiions from my project. https://github.com/jmarley/dv-couchbase
> Support Couchbase as a resource
> -------------------------------
>
> Key: TEIID-2820
> URL: https://issues.jboss.org/browse/TEIID-2820
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors
> Reporter: Kim Palko
> Priority: Minor
> Labels: data_source
> Fix For: Open To Community
>
>
> Support Couchbase as a data source in Teiid. This requires resource adapter and translater development
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-4015) Error or incorrect value when there is a conflict between local and correlated names
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-4015:
-------------------------------------
Summary: Error or incorrect value when there is a conflict between local and correlated names
Key: TEIID-4015
URL: https://issues.jboss.org/browse/TEIID-4015
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.0, 8.12.5, 8.13.2
With a query such as:
select e1, (select e1 from (select t1.e1 from pm1.g1 as t1) as t2 where t2.e1 = t1.e1) from pm2.g1 as t1
The correlated reference to t1.e1 will get evaulated as if it were a local value from pm1.g1 as t1 instead. This is because the evaluator doesn't immediately look for the context value, but rather calls to internalEvaluate.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-4014) remove oid from system tables
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-4014:
-------------------------------------
Summary: remove oid from system tables
Key: TEIID-4014
URL: https://issues.jboss.org/browse/TEIID-4014
Project: Teiid
Issue Type: Task
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.0
The oid column on system tables is unused and should be removed.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-4012) TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts'
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4012?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4012:
---------------------------------------
TEIID-3697 covers minimizing the logging of the invalid session as even the warn level can be too high. The only reason these would be indicative of an issue is if you are seeing issues with your clients - note that this would only be happening from JDBC connections.
pg_prepared_xacts is a pg system table that we do not currently emulate - http://www.postgresql.org/docs/8.2/static/view-pg-prepared-xacts.html
Teiid ODBC currently only supports local transactions. An enhancement would be needed to support XA transactions.
> 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