December 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3206: ------------------------------------- The easiest is to submit a pull request, then we can merge it in. > EAP 6.3 - JDBC Datasources Test Connection > ------------------------------------------ > > Key: TEIID-3206 > URL: https://issues.jboss.org/browse/TEIID-3206 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.9, 8.10 > Reporter: Tom Arnold > Assignee: Steven Hawkins > > Using `Test Connection` for JDBC Datasources seems to be broken in the standalone server built from 8.9.x and master. This is an issue with EAP 6.3 Alpha1. > This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid. This also happens with Oracle and PostgreSQL datasources. > The datasources seem to work despite this, but it would be good to understand the root cause and get it fixed if possible. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ] Tom Arnold edited comment on TEIID-3206 at 12/1/14 4:16 PM: ------------------------------------------------------------ Any takers? This needs to be done by someone on the team because I can't upload files to the Teiid sourceforge project. was (Author: tom9729): Any takers? I think this needs to be done by someone on the team because I can't upload files to the Teiid sourceforge project. > EAP 6.3 - JDBC Datasources Test Connection > ------------------------------------------ > > Key: TEIID-3206 > URL: https://issues.jboss.org/browse/TEIID-3206 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.9, 8.10 > Reporter: Tom Arnold > Assignee: Steven Hawkins > > Using `Test Connection` for JDBC Datasources seems to be broken in the standalone server built from 8.9.x and master. This is an issue with EAP 6.3 Alpha1. > This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid. This also happens with Oracle and PostgreSQL datasources. > The datasources seem to work despite this, but it would be good to understand the root cause and get it fixed if possible. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ] Tom Arnold commented on TEIID-3206: ----------------------------------- Any takers? I think this needs to be done by someone on the team because I can't upload files to the Teiid sourceforge project. > EAP 6.3 - JDBC Datasources Test Connection > ------------------------------------------ > > Key: TEIID-3206 > URL: https://issues.jboss.org/browse/TEIID-3206 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.9, 8.10 > Reporter: Tom Arnold > Assignee: Steven Hawkins > > Using `Test Connection` for JDBC Datasources seems to be broken in the standalone server built from 8.9.x and master. This is an issue with EAP 6.3 Alpha1. > This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid. This also happens with Oracle and PostgreSQL datasources. > The datasources seem to work despite this, but it would be good to understand the root cause and get it fixed if possible. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3237) Prevent processing cross joins with unknown cardinalities

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3237: ------------------------------------- Summary: Prevent processing cross joins with unknown cardinalities Key: TEIID-3237 URL: https://issues.jboss.org/browse/TEIID-3237 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.10 The optimizer will select plans with cross joins (particularly with a parent dependent join) when the join is to be processed in Teiid and the cardinality of both sides of the join are unknown. We should prefer non cross join plans in these scenarios. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3235) IndexOutOfBoundsException when using GROUP BY

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3235?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3235. --------------------------------- Labels: Alpha1 (was: ) Fix Version/s: 8.7.1 8.10 Resolution: Done Fixed and also added assert to make sure projected column count matches with project column names. > IndexOutOfBoundsException when using GROUP BY > --------------------------------------------- > > Key: TEIID-3235 > URL: https://issues.jboss.org/browse/TEIID-3235 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Labels: Alpha1 > Fix For: 8.7.1, 8.10 > > Attachments: mongo-vdb.xml > > > Issuing the following queries that cause the IndexOutofBoundsException: > SELECT IntKey, SUM(IntNum) FROM BQT1.SmallA GROUP BY intKey > SELECT IntKey, IntNum FROM BQT1.SmallA GROUP BY IntKey, IntNum > Will attach VDB. > 0:07:04,905 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue14) Connector worker process failed for atomic-request=XEIlvkzunTej.7.1.0: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1 > at java.util.ArrayList.rangeCheck(ArrayList.java:604) [rt.jar:1.7.0_25] > at java.util.ArrayList.get(ArrayList.java:382) [rt.jar:1.7.0_25] > at org.teiid.translator.mongodb.MongoDBQueryExecution.next(MongoDBQueryExecution.java:124) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:384) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:202) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5] > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5] > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25] > at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25] > at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25] -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3208) Remove outer join based solely on join predicates

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3208?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3208. ----------------------------------- Resolution: Done Added logic to rule push non-join criteria to look for situations where a join is over an outer join and a generated is not null criteria can be pushed. > Remove outer join based solely on join predicates > ------------------------------------------------- > > Key: TEIID-3208 > URL: https://issues.jboss.org/browse/TEIID-3208 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > We currently remove outer joins based upon where clause predicates, but won't necessarily detect when to remove the the outer join based solely on join predicates: > SELECT * from pm1.g1 inner join (pm1.g2 left outer join pm1.g3 on pm1.g2.e1=pm1.g3.e1) on pm1.g1.e1=pm1.g3.e1 -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3232) Embedded dist zip for 8.9.0 is missing from repo

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3232?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3232. ----------------------------------- Resolution: Migrated to another ITS Based upon the blog post, I'm marking this as resolved. Thanks David. > Embedded dist zip for 8.9.0 is missing from repo > ------------------------------------------------ > > Key: TEIID-3232 > URL: https://issues.jboss.org/browse/TEIID-3232 > Project: Teiid > Issue Type: Bug > Components: Build/Kits, Embedded > Affects Versions: 8.9 > Environment: Java version: 1.7.0_71, vendor: Oracle Corporation > Java home: C:\Program Files\Java\jdk1.7.0_71\jre > Default locale: en_US, platform encoding: Cp1252 > OS name: "windows 7", version: "6.1", arch: "amd64", family: "windows" > Ant 1.9.4 > Ivy 2.3.0 > Reporter: Gary Gregory > Assignee: Steven Hawkins > Priority: Blocker > > For version 8.8.1, our build uses > https://repository.jboss.org/org/jboss/teiid/teiid/8.8.1/teiid-8.8.1-embe... > There is no such zip for 8.9.0. > In fact there are no useful files in https://repository.jboss.org/org/jboss/teiid/teiid/8.9.0.Final > Help! -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3236) Copy criteria within a left outer join removes predicates

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3236?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3236. ----------------------------------- Resolution: Done Changed the logic to retain the non-join criteria, which will preserve them in left outer joins. > Copy criteria within a left outer join removes predicates > --------------------------------------------------------- > > Key: TEIID-3236 > URL: https://issues.jboss.org/browse/TEIID-3236 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > With a query such as: > select bqt1.smalla.intkey from bqt1.smalla inner join (select bqt3.smalla.intkey from bqt2.smalla left outer join bqt3.smalla on bqt2.smalla.intkey = bqt3.smalla.intkey and bqt3.smalla.intkey = 1) foo on bqt1.smalla.intkey = foo.intkey > where the left outer join is not pushed to the source, we will process it as if bqt2.smalla.intkey = bqt3.smalla.intkey doesn't exist. > This is somewhat unlikely to occur for user queries as the join predicates are not likely to occur and could easily be simplified. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 3 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2014