[JBoss JIRA] (TEIID-2605) Optimization substitutes wrong column in where clause
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2605?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2605.
---------------------------------
> Optimization substitutes wrong column in where clause
> -----------------------------------------------------
>
> Key: TEIID-2605
> URL: https://issues.jboss.org/browse/TEIID-2605
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.1
> Environment: z/OS
> Reporter: Jeff Hayes
> Assignee: Steven Hawkins
> Attachments: query_plan.txt, views.xml
>
>
> Optimization results in a query with a different column in the WHERE clause producing an empty result set.
> Full query plan is attached but the beginning and ending queries are shown below. Note that the subject column of the IN clause is SCOPEID but optimization changes it to AUTHID for some reason.
> USER COMMAND:
> SELECT * FROM SECURITY.SCPXREF AS CHORUS_B WHERE (CHORUS_B.SYSID = 'DE29') AND ((CHORUS_B.SCOPEID IN (SELECT SN5.SCOPEID FROM SECURI
> TY.SCPNEXT AS SN5 WHERE (SYSID = 'DE29') AND (NEXTREC IN (SELECT SN4.SCOPEID FROM SECURITY.SCPNEXT AS SN4 WHERE (SYSID = 'DE29') AND
> (NEXTREC IN (SELECT SN3.SCOPEID FROM SECURITY.SCPNEXT AS SN3 WHERE (SYSID = 'DE29') AND (NEXTREC IN (SELECT SN2.SCOPEID FROM SECURI
> TY.SCPNEXT AS SN2 WHERE (SYSID = 'DE29') AND (NEXTREC = 'CHRDEPT1'))))))))) OR (CHORUS_B.SCOPEID IN (SELECT SN4.SCOPEID FROM SECURIT
> Y.SCPNEXT AS SN4 WHERE (SYSID = 'DE29') AND (NEXTREC IN (SELECT SN3.SCOPEID FROM SECURITY.SCPNEXT AS SN3 WHERE (SYSID = 'DE29') AND
> (NEXTREC IN (SELECT SN2.SCOPEID FROM SECURITY.SCPNEXT AS SN2 WHERE (SYSID = 'DE29') AND (NEXTREC = 'CHRDEPT1'))))))) OR (CHORUS_B.SC
> OPEID IN (SELECT SN3.SCOPEID FROM SECURITY.SCPNEXT AS SN3 WHERE (SYSID = 'DE29') AND (NEXTREC IN (SELECT SN2.SCOPEID FROM SECURITY.S
> CPNEXT AS SN2 WHERE (SYSID = 'DE29') AND (NEXTREC = 'CHRDEPT1'))))) OR (CHORUS_B.SCOPEID IN (SELECT SN2.SCOPEID FROM SECURITY.SCPNEX
> T AS SN2 WHERE (SYSID = 'DE29') AND (NEXTREC = 'CHRDEPT1'))) OR (CHORUS_B.SCOPEID = 'CHRDEPT1'))
> OPTIMIZATION COMPLETE:
> PROCESSOR PLAN:
> AccessNode(10) output=[x.sysid AS sysid, x.scopeid AS authid, x.authid AS scopeid, x.authtype AS authtype] SELECT g_0.SYSID, g_0.SCO
> PEID, g_0.AUTHID, g_0.AUTHTYPE FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPXREF AS g_0 WHERE (g_0.SYSID = 'DE29') AND ((g_0.AUTHID IN
> (SELECT g_1.SCOPEID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_1 WHERE (g_1.SYSID = 'DE29') AND (g_1.NEXTREC IN (SELECT g_2
> .SCOPEID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_2 WHERE (g_2.SYSID = 'DE29') AND (g_2.NEXTREC IN (SELECT g_3.SCOPEID FR
> OM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_3 WHERE (g_3.SYSID = 'DE29') AND (g_3.NEXTREC IN (SELECT g_4.SCOPEID FROM SECURITY
> _CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_4 WHERE (g_4.SYSID = 'DE29') AND (g_4.NEXTREC = 'CHRDEPT1'))))))))) OR (g_0.AUTHID IN (SELECT
> g_5.SCOPEID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_5 WHERE (g_5.SYSID = 'DE29') AND (g_5.NEXTREC IN (SELECT g_6.SCOPEI
> D FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_6 WHERE (g_6.SYSID = 'DE29') AND (g_6.NEXTREC IN (SELECT g_7.SCOPEID FROM SECU
> RITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_7 WHERE (g_7.SYSID = 'DE29') AND (g_7.NEXTREC = 'CHRDEPT1'))))))) OR (g_0.AUTHID IN (SELE
> CT g_8.SCOPEID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_8 WHERE (g_8.SYSID = 'DE29') AND (g_8.NEXTREC IN (SELECT g_9.SCOP
> EID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_9 WHERE (g_9.SYSID = 'DE29') AND (g_9.NEXTREC = 'CHRDEPT1'))))) OR (g_0.AUTH
> ID IN (SELECT g_10.SCOPEID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_10 WHERE (g_10.SYSID = 'DE29') AND (g_10.NEXTREC = 'C
> HRDEPT1'))) OR (g_0.AUTHID = 'CHRDEPT1'))
> The view definitions are shown below:
> <view name="SCPNEXT">
> <columns>
> <column name="sysid" type="varchar"/>
> <column name="scopeid" type="varchar"/>
> <column name="nextrec" type="varchar"/>
> </columns>
> <definition>
> #if ($db.count("select count(*) from sys.tables where Name='config' and SchemaName = 'security_db'") > 0)
> #set ($count = 0)
> #foreach($t in $db.query("select DB_TYPE, DB_LOC, DB_QUAL from security_db.config WHERE TYPE = 'CIA'"))
> #if ($db.count("select count(*) from sys.tables where SchemaName = 'SECURITY_CIA_${t.DB_TYPE}_${t.DB_LOC}_${t.DB_QUAL}'") == 0)
> #set ($count = $count + 1)
> #end
> #end
> #if ($count == 0)
> SELECT t.sysid, t.scopeid, t.nextrec
> FROM (
> #foreach($t in $db.query("select DB_TYPE, DB_LOC, DB_QUAL from security_db.config WHERE TYPE = 'CIA'"))
> SELECT n.sysid, n.scopeid, n.nextrec
> FROM SECURITY_CIA_${t.DB_TYPE}_${t.DB_LOC}_${t.DB_QUAL}.SCPNEXT n
> #if( $velocityHasNext ) UNION #end
> #end
> ) AS t
> #end
> #end
> </definition>
> </view>
> <view name="SCPXREF">
> <columns>
> <column name="sysid" type="varchar"/>
> <column name="authid" type="varchar"/>
> <column name="scopeid" type="varchar"/>
> <column name="authtype" type="varchar"/>
> </columns>
> <definition>
> #if ($db.count("select count(*) from sys.tables where Name='config' and SchemaName = 'security_db'") > 0)
> #set ($count = 0)
> #foreach($t in $db.query("select DB_TYPE, DB_LOC, DB_QUAL from security_db.config WHERE TYPE = 'CIA'"))
> #if ($db.count("select count(*) from sys.tables where SchemaName = 'SECURITY_CIA_${t.DB_TYPE}_${t.DB_LOC}_${t.DB_QUAL}'") == 0)
> #set ($count = $count + 1)
> #end
> #end
> #if ($count == 0)
> SELECT sysid, scopeid, authid, authtype
> FROM (
> #foreach($t in $db.query("select DB_TYPE, DB_LOC, DB_QUAL from security_db.config WHERE TYPE = 'CIA'"))
> SELECT x.sysid, x.scopeid, x.authid, x.authtype
> FROM SECURITY_CIA_${t.DB_TYPE}_${t.DB_LOC}_${t.DB_QUAL}.SCPXREF x
> #if( $velocityHasNext ) UNION #end
> #end
> ) AS t
> #end
> #end
> </definition>
> </view>
> I guess the best way to test this is to define these views and run the input query with SHOWPLAN=DEBUG and see if the AUTHID substitution is occurring.
> Thanks!
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
6 days, 6 hours
[JBoss JIRA] (TEIID-3055) Querying JDG local cache using greater than value cause exception
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3055?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3055.
-----------------------------------
Resolution: Done
Applied Van's patch
> Querying JDG local cache using greater than value cause exception
> -----------------------------------------------------------------
>
> Key: TEIID-3055
> URL: https://issues.jboss.org/browse/TEIID-3055
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1, 8.9
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.7.1, 8.9
>
>
> Issuing query: select nss, valor_inicial, valor_final from CacheView.Resumen where valor_inicial > 950.0
> produces the following in the query plan:
> USER COMMAND:
> SELECT nss, valor_inicial, valor_final FROM CacheView.Resumen WHERE nss > '950.0'
> request=/1MuNPfoG76j.0.0.5: org.hibernate.search.SearchException: Cannot create numeric range query for field saldo.valorInicial, since values are not numeric (int,long, short or double)
> at org.hibernate.search.bridge.util.impl.NumericFieldUtils.createNumericRangeQuery(NumericFieldUtils.java:69)
> at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:107)
> at org.hibernate.search.query.dsl.impl.ConnectedMultiFieldsRangeQueryBuilder.createQuery(ConnectedMultiFieldsRangeQueryBuilder.java:83)
> at org.teiid.translator.object.infinispan.LuceneSearch.createRangeAboveQuery(LuceneSearch.java:349)
> at org.teiid.translator.object.infinispan.LuceneSearch.visit(LuceneSearch.java:217)
> at org.teiid.translator.object.infinispan.LuceneSearch.buildQueryFromWhereClause(LuceneSearch.java:145)
> at org.teiid.translator.object.infinispan.LuceneSearch.performSearch(LuceneSearch.java:66)
> at org.teiid.translator.object.infinispan.InfinispanExecutionFactory.search(InfinispanExecutionFactory.java:119)
> at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:102)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:312) [te
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIID-3057) Kerberos ODBC connection on Teiid 8.8.0
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3057?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3057:
-------------------------------------
ODBC was one weak spot, I never tested with recent changes. Cristiano, can you tell what configuration you did you enable the kerberoes with ODBC driver?
> Kerberos ODBC connection on Teiid 8.8.0
> ---------------------------------------
>
> Key: TEIID-3057
> URL: https://issues.jboss.org/browse/TEIID-3057
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.8
> Environment: Teiid 8.8.0
> EAP 6.1.1
> Reporter: Cristiano Nicolai
> Assignee: Steven Hawkins
> Priority: Blocker
>
> After upgrading from version 8.7.0.Final to version 8.8.0.Final connections via ODBC using Kerberos/GSS stopped working.
> When I try to connect with the new version, on the server I get the following error:
>
> 12:24:31,755 ERROR [org.teiid.ODBC] (New I/O worker #2) TEIID40015 Unexpected error occurred: java.lang.NullPointerException
> at java.util.Hashtable.put(Hashtable.java:514) [rt.jar:1.7.0_55]
> at org.teiid.odbc.ODBCServerRemoteImpl.logon(ODBCServerRemoteImpl.java:244) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_55]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_55]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_55]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_55]
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
>
> From the client I get the following message: psql: duplicate GSS authentication request
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIID-3057) Kerberos ODBC connection on Teiid 8.8.0
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3057?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3057:
---------------------------------------
I'm not failure enough to say for sure. I think that it would be part of the configuration of the underlying kerberos service.
> Kerberos ODBC connection on Teiid 8.8.0
> ---------------------------------------
>
> Key: TEIID-3057
> URL: https://issues.jboss.org/browse/TEIID-3057
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.8
> Environment: Teiid 8.8.0
> EAP 6.1.1
> Reporter: Cristiano Nicolai
> Assignee: Steven Hawkins
> Priority: Blocker
>
> After upgrading from version 8.7.0.Final to version 8.8.0.Final connections via ODBC using Kerberos/GSS stopped working.
> When I try to connect with the new version, on the server I get the following error:
>
> 12:24:31,755 ERROR [org.teiid.ODBC] (New I/O worker #2) TEIID40015 Unexpected error occurred: java.lang.NullPointerException
> at java.util.Hashtable.put(Hashtable.java:514) [rt.jar:1.7.0_55]
> at org.teiid.odbc.ODBCServerRemoteImpl.logon(ODBCServerRemoteImpl.java:244) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_55]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_55]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_55]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_55]
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
>
> From the client I get the following message: psql: duplicate GSS authentication request
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIID-3057) Kerberos ODBC connection on Teiid 8.8.0
by Cristiano Nicolai (JIRA)
[ https://issues.jboss.org/browse/TEIID-3057?page=com.atlassian.jira.plugin... ]
Cristiano Nicolai commented on TEIID-3057:
------------------------------------------
How exactly I do that? Some property on login module?
> Kerberos ODBC connection on Teiid 8.8.0
> ---------------------------------------
>
> Key: TEIID-3057
> URL: https://issues.jboss.org/browse/TEIID-3057
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.8
> Environment: Teiid 8.8.0
> EAP 6.1.1
> Reporter: Cristiano Nicolai
> Assignee: Steven Hawkins
> Priority: Blocker
>
> After upgrading from version 8.7.0.Final to version 8.8.0.Final connections via ODBC using Kerberos/GSS stopped working.
> When I try to connect with the new version, on the server I get the following error:
>
> 12:24:31,755 ERROR [org.teiid.ODBC] (New I/O worker #2) TEIID40015 Unexpected error occurred: java.lang.NullPointerException
> at java.util.Hashtable.put(Hashtable.java:514) [rt.jar:1.7.0_55]
> at org.teiid.odbc.ODBCServerRemoteImpl.logon(ODBCServerRemoteImpl.java:244) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_55]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_55]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_55]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_55]
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
>
> From the client I get the following message: psql: duplicate GSS authentication request
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIID-3057) Kerberos ODBC connection on Teiid 8.8.0
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3057?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3057:
---------------------------------------
Can you turn credential delegation on as a workaround?
Also it looks like there may be a bit of a protocol issue in the exception case as we'd expect something more meaningful than that message from psql.
> Kerberos ODBC connection on Teiid 8.8.0
> ---------------------------------------
>
> Key: TEIID-3057
> URL: https://issues.jboss.org/browse/TEIID-3057
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.8
> Environment: Teiid 8.8.0
> EAP 6.1.1
> Reporter: Cristiano Nicolai
> Assignee: Steven Hawkins
> Priority: Blocker
>
> After upgrading from version 8.7.0.Final to version 8.8.0.Final connections via ODBC using Kerberos/GSS stopped working.
> When I try to connect with the new version, on the server I get the following error:
>
> 12:24:31,755 ERROR [org.teiid.ODBC] (New I/O worker #2) TEIID40015 Unexpected error occurred: java.lang.NullPointerException
> at java.util.Hashtable.put(Hashtable.java:514) [rt.jar:1.7.0_55]
> at org.teiid.odbc.ODBCServerRemoteImpl.logon(ODBCServerRemoteImpl.java:244) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_55]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_55]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_55]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_55]
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
>
> From the client I get the following message: psql: duplicate GSS authentication request
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIID-3057) Kerberos ODBC connection on Teiid 8.8.0
by Cristiano Nicolai (JIRA)
Cristiano Nicolai created TEIID-3057:
----------------------------------------
Summary: Kerberos ODBC connection on Teiid 8.8.0
Key: TEIID-3057
URL: https://issues.jboss.org/browse/TEIID-3057
Project: Teiid
Issue Type: Bug
Security Level: Public (Everyone can see)
Affects Versions: 8.8
Environment: Teiid 8.8.0
EAP 6.1.1
Reporter: Cristiano Nicolai
Assignee: Steven Hawkins
Priority: Blocker
After upgrading from version 8.7.0.Final to version 8.8.0.Final connections via ODBC using Kerberos/GSS stopped working.
When I try to connect with the new version, on the server I get the following error:
12:24:31,755 ERROR [org.teiid.ODBC] (New I/O worker #2) TEIID40015 Unexpected error occurred: java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:514) [rt.jar:1.7.0_55]
at org.teiid.odbc.ODBCServerRemoteImpl.logon(ODBCServerRemoteImpl.java:244) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_55]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_55]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_55]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_55]
at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.8.0.Final.jar:8.8.0.Final]
>From the client I get the following message: psql: duplicate GSS authentication request
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIID-3050) allow for more incremental insert with iterator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3050?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3050:
---------------------------------------
Looking at this more, we do little in the way of parallel read/write in the current code anyway. As requests are sent to be executed we block on the results - without performing a prefetch. So I'll take a look at improving that as well.
> allow for more incremental insert with iterator
> -----------------------------------------------
>
> Key: TEIID-3050
> URL: https://issues.jboss.org/browse/TEIID-3050
> Project: Teiid
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors, Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> The current bulk insert logic assumes that it is avoiding a global transactions by fully reading the results before sending the tuplebuffer iterator to the source for processing, which can then just use a local transaction. However if we are already operating under a transaction or the user doesn't want a transaction (such as with a staging materialized view load) then the insert should happen more incrementally.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIID-3050) allow for more incremental insert with iterator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3050?page=com.atlassian.jira.plugin... ]
Work on TEIID-3050 started by Steven Hawkins.
> allow for more incremental insert with iterator
> -----------------------------------------------
>
> Key: TEIID-3050
> URL: https://issues.jboss.org/browse/TEIID-3050
> Project: Teiid
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors, Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> The current bulk insert logic assumes that it is avoiding a global transactions by fully reading the results before sending the tuplebuffer iterator to the source for processing, which can then just use a local transaction. However if we are already operating under a transaction or the user doesn't want a transaction (such as with a staging materialized view load) then the insert should happen more incrementally.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months