[ https://issues.jboss.org/browse/TEIID-4013?page=com.atlassian.jira.plugin... ] Steve Tran commented on TEIID-4013: ----------------------------------- I know this ticket is closed, but here's more info. It looks like it creates new 3 new sessions (3 might be specific to my environment only because I have 3 DSN configured) whenever I see this error message. {code} [Server:cdtssoa126d-jdv-one] 11:32:21,042 TRACE [org.teiid.ODBC] (New I/O worker #7) invoking client method: authenticationSucess [-1109727455, -1109727455] [Server:cdtssoa126d-jdv-one] 11:32:21,042 TRACE [org.teiid.ODBC] (New I/O worker #7) invoking client method: ready [false, false] [Server:cdtssoa126d-jdv-one] 11:32:21,098 TRACE [org.teiid.ODBC] (New I/O worker #7) invoking server method: executeQuery [select oid, typbasetype from pg_type where typname = 'lo'] [Server:cdtssoa126d-jdv-one] 11:32:21,102 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9290) invoking client method: sendResults [select oid, typbasetype from pg_type where typname = 'lo', org.teiid.jdbc.ResultSetImpl@481ee1ea, [org.teiid.odbc.PGUtil$PgColInfo@6381eea3, org.teiid.odbc.PGUtil$PgColInfo@675a425e], org.teiid.client.util.ResultsFuture@56bb5e54, -1, true] [Server:cdtssoa126d-jdv-one] 11:32:21,104 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9290) invoking client method: ready [false, false] [Server:cdtssoa126d-jdv-one] 11:32:21,167 TRACE [org.teiid.ODBC] (New I/O worker #7) invoking server method: executeQuery [select gid from pg_prepared_xacts] [Server:cdtssoa126d-jdv-one] 11:32:21,168 WARN [org.teiid.PROCESSOR] (Worker24_QueryProcessorQueue9291) TEIID30020 Processing exception for request wNNOm0Bs6pFa.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace. [Server:cdtssoa126d-jdv-one] 11:32:21,168 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9291) invoking client method: errorOccurred [org.teiid.jdbc.TeiidSQLException: Group does not exist: pg_prepared_xacts] [Server:cdtssoa126d-jdv-one] 11:32:21,169 WARN [org.teiid.ODBC] (Worker24_QueryProcessorQueue9291) TEIID40020 Error occurred: org.teiid.jdbc.TeiidSQLException: Group does not exist: pg_prepared_xacts [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1001) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:556) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:352) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] 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] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [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.QueryResolverException: Group does not exist: pg_prepared_xacts [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:814) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.util.ResolverUtil.resolveGroup(ResolverUtil.java:893) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.isXMLQuery(QueryResolver.java:349) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.chooseResolver(QueryResolver.java:294) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:268) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:124) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:260) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:369) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:435) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:613) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] ... 8 more [Server:cdtssoa126d-jdv-one] [Server:cdtssoa126d-jdv-one] 11:32:21,170 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9291) invoking client method: ready [false, false] [Server:cdtssoa126d-jdv-one] 11:32:47,169 TRACE [org.teiid.ODBC] (New I/O worker #3) StartupMessage version 196608 ( 3 . 0 ) [Server:cdtssoa126d-jdv-one] 11:32:47,169 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking server method: initialize [{client_encoding=UTF8, extra_float_digits=2, user=teiidUser, default_transaction_isolation=read committed, version=196608, TimeZone=Eastern Standard Time, DateStyle=ISO, database=HSI, geqo=on}] [Server:cdtssoa126d-jdv-one] 11:32:47,170 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking client method: initialized [{client_encoding=UTF8, extra_float_digits=2, user=teiidUser, default_transaction_isolation=read committed, version=196608, TimeZone=Eastern Standard Time, DateStyle=ISO, database=HSI, geqo=on}] [Server:cdtssoa126d-jdv-one] 11:32:47,170 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking client method: useClearTextAuthentication null [Server:cdtssoa126d-jdv-one] 11:32:47,171 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking server method: logon [HSI, teiidUser, org.teiid.transport.PgFrontendProtocol$NullTerminatedStringDataInputStream@6d971c54, /162.44.148.158:56363] [Server:cdtssoa126d-jdv-one] 11:32:47,208 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession null [Server:cdtssoa126d-jdv-one] 11:32:47,209 DEBUG [org.teiid.SECURITY] (New I/O worker #3) authenticateUser teiidUser ODBC [Server:cdtssoa126d-jdv-one] 11:32:47,209 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful for " teiidUser " in security domain teiid-security [Server:cdtssoa126d-jdv-one] 11:32:47,209 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful, created session: sessionid=pzkND8mfq/FP; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Tue Mar 15 11:32:47 EDT 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Tue Mar 15 11:32:47 EDT 2016 [Server:cdtssoa126d-jdv-one] 11:32:47,210 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking client method: authenticationSucess [-2076166782, -2076166782] [Server:cdtssoa126d-jdv-one] 11:32:47,211 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking client method: ready [false, false] [Server:cdtssoa126d-jdv-one] 11:32:47,266 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking server method: executeQuery [select oid, typbasetype from pg_type where typname = 'lo'] [Server:cdtssoa126d-jdv-one] 11:32:47,272 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9292) invoking client method: sendResults [select oid, typbasetype from pg_type where typname = 'lo', org.teiid.jdbc.ResultSetImpl@414fb377, [org.teiid.odbc.PGUtil$PgColInfo@578f6b20, org.teiid.odbc.PGUtil$PgColInfo@8c22ec9], org.teiid.client.util.ResultsFuture@48d929d, -1, true] [Server:cdtssoa126d-jdv-one] 11:32:47,273 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9292) invoking client method: ready [false, false] [Server:cdtssoa126d-jdv-one] 11:32:47,336 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking server method: executeQuery [select gid from pg_prepared_xacts] [Server:cdtssoa126d-jdv-one] 11:32:47,338 WARN [org.teiid.PROCESSOR] (Worker24_QueryProcessorQueue9293) TEIID30020 Processing exception for request pzkND8mfq/FP.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace. [Server:cdtssoa126d-jdv-one] 11:32:47,338 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9293) invoking client method: errorOccurred [org.teiid.jdbc.TeiidSQLException: Group does not exist: pg_prepared_xacts] [Server:cdtssoa126d-jdv-one] 11:32:47,338 WARN [org.teiid.ODBC] (Worker24_QueryProcessorQueue9293) TEIID40020 Error occurred: org.teiid.jdbc.TeiidSQLException: Group does not exist: pg_prepared_xacts [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1001) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:556) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:352) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] 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] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [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.QueryResolverException: Group does not exist: pg_prepared_xacts [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:814) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.util.ResolverUtil.resolveGroup(ResolverUtil.java:893) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.isXMLQuery(QueryResolver.java:349) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.chooseResolver(QueryResolver.java:294) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:268) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:124) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:260) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:369) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:435) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:613) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] ... 8 more {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)