June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4183) MSSQL JDBC driver invalidates kerberos ticket on Connection.close()

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4183?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4183: ------------------------------------- What is root exception? > MSSQL JDBC driver invalidates kerberos ticket on Connection.close() > ------------------------------------------------------------------- > > Key: TEIID-4183 > URL: https://issues.jboss.org/browse/TEIID-4183 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.x, 8.7.5.6_2 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > MSSQL JDBC driver invalidate kerberos ticket on Connection.close() (related bugzilla \[1\]). > If user creates kerberos connection, driver invalidates ticket on closing connection (Connection.close()). Therefore ticket cannot be re-used. EAP team creates a workaround for this by adding module option *wrapGSSCredential=true* with additional setting *credentialLifetime=-1* \[2, 3, 4, 5\]. This works for static kerberos authentication. > However, passthrough authentication (org.teiid.jboss.PassthroughIdentityLoginModule) does not work, because passed ticket is not managed by EAP but by client. > \[1\] https://bugzilla.redhat.com/show_bug.cgi?id=1097276 > \[2\] https://bugzilla.redhat.com/show_bug.cgi?id=1097276#c58 > \[3\] https://issues.jboss.org/browse/SECURITY-905 > \[4\] https://issues.jboss.org/browse/JBEAP-843 > \[5\] https://github.com/wildfly-security/jboss-negotiation/commit/0c7e06f58a79... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3771) Teiid throws an NPE while executing query with nested subquery IN predicate

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3771?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3771: --------------------------------------- Without a full stacktrace I can't really say if this should be considered related. More than likely this should be captured as a separate issue. > Teiid throws an NPE while executing query with nested subquery IN predicate > --------------------------------------------------------------------------- > > Key: TEIID-3771 > URL: https://issues.jboss.org/browse/TEIID-3771 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Teiid throws an NPE while executing query with double IN predicate. Example query: > SELECT intkey FROM BQT1.SmallA AS A WHERE INTKEY IN (SELECT CONVERT(STRINGKEY, INTEGER) FROM BQT1.SMALLA AS A WHERE STRINGKEY IN (SELECT CONVERT(INTKEY, STRING) FROM BQT1.SMALLA AS B WHERE A.INTNUM = B.INTNUM)) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3770) HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3770?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3770: --------------------------------------- There's not much more we can do with this issue. We can either not pushdown correlated subqueries, or just accept that phoenix has bugs in this area and address it further if it becomes a customer issue. Since this produces as exception it's safe to just take the latter approach for now. > HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate > ------------------------------------------------------------------------------------ > > Key: TEIID-3770 > URL: https://issues.jboss.org/browse/TEIID-3770 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Query: > SELECT INTKEY, BIGDECIMALVALUE FROM BQT1.SMALLA AS A WHERE BIGDECIMALVALUE *IN (SELECT MAX(BIGDECIMALVALUE) FROM BQT1.SMALLA AS B WHERE _A_.INTKEY = B.INTKEY)* ORDER BY INTKEY > It seems like bug in Phoenix driver. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4145) JDG Local Cache Quickstart deployed configuration file name doesn't match the resource-adapter

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4145?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4145: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1327748|https://bugzilla.redhat.com/show_bug.cgi?id=1327748] from ASSIGNED to CLOSED > JDG Local Cache Quickstart deployed configuration file name doesn't match the resource-adapter > ----------------------------------------------------------------------------------------------- > > Key: TEIID-4145 > URL: https://issues.jboss.org/browse/TEIID-4145 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 9.x > > > The jdg local cache resource-adapter fails to start due to a missing file. > In the jdg-local-cache quickstart, the configuration file (infinispan_persistent_config.xml) that's deployed does not match the name of the "ConfigurationFilenamForLocalCache" property that's set in the example resource-adapter (docs/teiid/datasources/infinispan/infinispan-ds.xml). > Either, the property name in the resource-adapter can be changed or rename the config file. > I plan on renaming the file in the quickstart to be infinispan.xml. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4204) Examples dynamicvdb-restservice - rest client returns always empty body

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4204?page=com.atlassian.jira.plugin... ] Van Halbert reopened TEIID-4204: -------------------------------- > Examples dynamicvdb-restservice - rest client returns always empty body > ------------------------------------------------------------------------ > > Key: TEIID-4204 > URL: https://issues.jboss.org/browse/TEIID-4204 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Kylin Soong > Priority: Minor > Fix For: 9.0, 8.12.5 > > > Description of problem: > rest-client returns always empty body for every request like follows: > [jdurani@localhost resteasy-client]$ java -cp target/dependency/*:target/dynamicvdb-resteasy-client.jar org.jboss.teiid.quickstart.PortfolioClient > JAX-RS 2.0 Client API -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4204) Examples dynamicvdb-restservice - rest client returns always empty body

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4204?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4204: ------------------------------------ Now, client returns error instead of empty body. Command: mvn package exec:java Result: JAX-RS 2.0 Client API 400, Bad Request 400, Bad Request 400, Bad Request 400, Bad Request > Examples dynamicvdb-restservice - rest client returns always empty body > ------------------------------------------------------------------------ > > Key: TEIID-4204 > URL: https://issues.jboss.org/browse/TEIID-4204 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Kylin Soong > Priority: Minor > Fix For: 9.0, 8.12.5 > > > Description of problem: > rest-client returns always empty body for every request like follows: > [jdurani@localhost resteasy-client]$ java -cp target/dependency/*:target/dynamicvdb-resteasy-client.jar org.jboss.teiid.quickstart.PortfolioClient > JAX-RS 2.0 Client API -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3770) HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3770?page=com.atlassian.jira.plugin... ] Van Halbert reopened TEIID-3770: -------------------------------- > HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate > ------------------------------------------------------------------------------------ > > Key: TEIID-3770 > URL: https://issues.jboss.org/browse/TEIID-3770 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Query: > SELECT INTKEY, BIGDECIMALVALUE FROM BQT1.SMALLA AS A WHERE BIGDECIMALVALUE *IN (SELECT MAX(BIGDECIMALVALUE) FROM BQT1.SMALLA AS B WHERE _A_.INTKEY = B.INTKEY)* ORDER BY INTKEY > It seems like bug in Phoenix driver. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3770) HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3770?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3770: ------------------------------------ Now, Teiid throws different exception: 12:37:27,261 WARN [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue181) TEIID30020 Processing exception for request r7NYsl824ly1.8 'TEIID30504 Source: 602 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0, g_0.bigdecimalvalue AS c_1 FROM smalla AS g_0 WHERE g_0.bigdecimalvalue = SOME (SELECT MAX(g_1.bigdecimalvalue) FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey) ORDER BY c_0]'. Originally TeiidProcessingException PhoenixSQLParser.java:345.: org.teiid.core.TeiidProcessingException: TEIID30504 Source: 602 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0, g_0.bigdecimalvalue AS c_1 FROM smalla AS g_0 WHERE g_0.bigdecimalvalue = SOME (SELECT MAX(g_1.bigdecimalvalue) FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey) ORDER BY c_0] at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6] at > HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate > ------------------------------------------------------------------------------------ > > Key: TEIID-3770 > URL: https://issues.jboss.org/browse/TEIID-3770 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Query: > SELECT INTKEY, BIGDECIMALVALUE FROM BQT1.SMALLA AS A WHERE BIGDECIMALVALUE *IN (SELECT MAX(BIGDECIMALVALUE) FROM BQT1.SMALLA AS B WHERE _A_.INTKEY = B.INTKEY)* ORDER BY INTKEY > It seems like bug in Phoenix driver. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3771) Teiid throws an NPE while executing query with nested subquery IN predicate

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3771?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3771: ------------------------------------ Teiid still throws NPE. But this one is from different class in Teiid: 12:41:44,024 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue183) TEIID30019 Unexpected exception for request 4xUbUdDkdulW.0: java.lang.NullPointerException at org.teiid.query.optimizer.relational.rules.RuleMergeVirtual.doMerge(RuleMergeVirtual.java:218) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6] at > Teiid throws an NPE while executing query with nested subquery IN predicate > --------------------------------------------------------------------------- > > Key: TEIID-3771 > URL: https://issues.jboss.org/browse/TEIID-3771 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Teiid throws an NPE while executing query with double IN predicate. Example query: > SELECT intkey FROM BQT1.SmallA AS A WHERE INTKEY IN (SELECT CONVERT(STRINGKEY, INTEGER) FROM BQT1.SMALLA AS A WHERE STRINGKEY IN (SELECT CONVERT(INTKEY, STRING) FROM BQT1.SMALLA AS B WHERE A.INTNUM = B.INTNUM)) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3771) Teiid throws an NPE while executing query with nested subquery IN predicate

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3771?page=com.atlassian.jira.plugin... ] Van Halbert reopened TEIID-3771: -------------------------------- > Teiid throws an NPE while executing query with nested subquery IN predicate > --------------------------------------------------------------------------- > > Key: TEIID-3771 > URL: https://issues.jboss.org/browse/TEIID-3771 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Teiid throws an NPE while executing query with double IN predicate. Example query: > SELECT intkey FROM BQT1.SmallA AS A WHERE INTKEY IN (SELECT CONVERT(STRINGKEY, INTEGER) FROM BQT1.SMALLA AS A WHERE STRINGKEY IN (SELECT CONVERT(INTKEY, STRING) FROM BQT1.SMALLA AS B WHERE A.INTNUM = B.INTNUM)) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016