July 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3020) Materialized View timeout on loading

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3020?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3020: --------------------------------------- It this still needed then? > Materialized View timeout on loading > ------------------------------------ > > Key: TEIID-3020 > URL: https://issues.jboss.org/browse/TEIID-3020 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Reporter: Mark Addleman > Assignee: Steven Hawkins > > Materialized view should timeout on loading if the translator/data source takes too long to respond. > Perhaps time out when the initiating JDBC statement times out or is cancelled? > See https://community.jboss.org/thread/242372 for more info -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3024) QueryTimeout not working for synchronous queries against Teiid

by gaurav singhal (JIRA)

[ https://issues.jboss.org/browse/TEIID-3024?page=com.atlassian.jira.plugin... ] gaurav singhal commented on TEIID-3024: --------------------------------------- We are actually using local connections for our platform as it runs within the same JBoss instance, could the local connections be made to work the same way as socked based connections? Also does teiid use a localconnection to materialize a view thats marked to be materialized? > QueryTimeout not working for synchronous queries against Teiid > --------------------------------------------------------------- > > Key: TEIID-3024 > URL: https://issues.jboss.org/browse/TEIID-3024 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: JDBC Driver > Affects Versions: 8.1, 8.7 > Reporter: gaurav singhal > Assignee: Steven Hawkins > Attachments: query timeout bug.zip > > > If i run a query with synchronous query with a timeout set using PreparedStatementImpl.setQueryTimeout() method, that timeout is not honored. But if i run the same query with all the same setup and execute the query asynchronously then a timeout happens and warning message like below is printed: > > Jul 02, 2014 10:19:21 AM org.teiid.jdbc.StatementImpl timeoutOccurred > WARNING: Timeout occurred in Statement. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3024) QueryTimeout not working for synchronous queries against Teiid

by gaurav singhal (JIRA)

[ https://issues.jboss.org/browse/TEIID-3024?page=com.atlassian.jira.plugin... ] gaurav singhal commented on TEIID-3024: --------------------------------------- ok I tried changing the test case to use socket connection and then the timeout happens for sync query as well. Thanks. > QueryTimeout not working for synchronous queries against Teiid > --------------------------------------------------------------- > > Key: TEIID-3024 > URL: https://issues.jboss.org/browse/TEIID-3024 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: JDBC Driver > Affects Versions: 8.1, 8.7 > Reporter: gaurav singhal > Assignee: Steven Hawkins > Attachments: query timeout bug.zip > > > If i run a query with synchronous query with a timeout set using PreparedStatementImpl.setQueryTimeout() method, that timeout is not honored. But if i run the same query with all the same setup and execute the query asynchronously then a timeout happens and warning message like below is printed: > > Jul 02, 2014 10:19:21 AM org.teiid.jdbc.StatementImpl timeoutOccurred > WARNING: Timeout occurred in Statement. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3024) QueryTimeout not working for synchronous queries against Teiid

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3024?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3024: --------------------------------------- What you are seeing affects local connections only. Socket based connections will work as expected as well. > QueryTimeout not working for synchronous queries against Teiid > --------------------------------------------------------------- > > Key: TEIID-3024 > URL: https://issues.jboss.org/browse/TEIID-3024 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: JDBC Driver > Affects Versions: 8.1, 8.7 > Reporter: gaurav singhal > Assignee: Steven Hawkins > Attachments: query timeout bug.zip > > > If i run a query with synchronous query with a timeout set using PreparedStatementImpl.setQueryTimeout() method, that timeout is not honored. But if i run the same query with all the same setup and execute the query asynchronously then a timeout happens and warning message like below is printed: > > Jul 02, 2014 10:19:21 AM org.teiid.jdbc.StatementImpl timeoutOccurred > WARNING: Timeout occurred in Statement. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3024) QueryTimeout not working for synchronous queries against Teiid

by gaurav singhal (JIRA)

gaurav singhal created TEIID-3024: ------------------------------------- Summary: QueryTimeout not working for synchronous queries against Teiid Key: TEIID-3024 URL: https://issues.jboss.org/browse/TEIID-3024 Project: Teiid Issue Type: Bug Security Level: Public (Everyone can see) Components: JDBC Driver Affects Versions: 8.7, 8.1 Reporter: gaurav singhal Assignee: Steven Hawkins Attachments: query timeout bug.zip If i run a query with synchronous query with a timeout set using PreparedStatementImpl.setQueryTimeout() method, that timeout is not honored. But if i run the same query with all the same setup and execute the query asynchronously then a timeout happens and warning message like below is printed: Jul 02, 2014 10:19:21 AM org.teiid.jdbc.StatementImpl timeoutOccurred WARNING: Timeout occurred in Statement. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3024) QueryTimeout not working for synchronous queries against Teiid

by gaurav singhal (JIRA)

[ https://issues.jboss.org/browse/TEIID-3024?page=com.atlassian.jira.plugin... ] gaurav singhal updated TEIID-3024: ---------------------------------- Attachment: query timeout bug.zip > QueryTimeout not working for synchronous queries against Teiid > --------------------------------------------------------------- > > Key: TEIID-3024 > URL: https://issues.jboss.org/browse/TEIID-3024 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: JDBC Driver > Affects Versions: 8.1, 8.7 > Reporter: gaurav singhal > Assignee: Steven Hawkins > Attachments: query timeout bug.zip > > > If i run a query with synchronous query with a timeout set using PreparedStatementImpl.setQueryTimeout() method, that timeout is not honored. But if i run the same query with all the same setup and execute the query asynchronously then a timeout happens and warning message like below is printed: > > Jul 02, 2014 10:19:21 AM org.teiid.jdbc.StatementImpl timeoutOccurred > WARNING: Timeout occurred in Statement. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3023) records lost when query by hiernate

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3023?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3023: --------------------------------------- Are you on Teiid 7.3? The first thing you should do is attempt to use a later version. > but from vdb query(projects with hibernate) can only get 10800+ records. Can you provide the query plan showing the hibernate query to Teiid and then relevant source queries from there? > Meanwhile, there's a set on maxSetSize = 1000, is there any affects? That would only come into play if you are using an IN predicate or a dependent join, and it should not affect the total number of results only how the source query is formed. > records lost when query by hiernate > ----------------------------------- > > Key: TEIID-3023 > URL: https://issues.jboss.org/browse/TEIID-3023 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Affects Versions: 7.3 > Environment: window7,eclipse Helios Service Release 2, Teiid v7.3.0 > Reporter: Lai Chao > Priority: Minor > > Recently, I get an issue when retrieve data from vdb that some records lost in the list. Fox example, from source table we can get 12100 records, but from vdb query(projects with hibernate) can only get 10800+ records. > Meanwhile, there's a set on maxSetSize = 1000, is there any affects? > Please advise. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3023) records lost when query by hiernate

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3023?page=com.atlassian.jira.plugin... ] Steven Hawkins moved TEIIDDES-2233 to TEIID-3023: ------------------------------------------------- Project: Teiid (was: Teiid Designer) Key: TEIID-3023 (was: TEIIDDES-2233) Issue Type: Bug (was: Feature Request) Affects Version/s: 7.3 (was: 7.3) Component/s: (was: VDB & Execution) > records lost when query by hiernate > ----------------------------------- > > Key: TEIID-3023 > URL: https://issues.jboss.org/browse/TEIID-3023 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Affects Versions: 7.3 > Environment: window7,eclipse Helios Service Release 2, Teiid v7.3.0 > Reporter: Lai Chao > Priority: Minor > > Recently, I get an issue when retrieve data from vdb that some records lost in the list. Fox example, from source table we can get 12100 records, but from vdb query(projects with hibernate) can only get 10800+ records. > Meanwhile, there's a set on maxSetSize = 1000, is there any affects? > Please advise. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2712) AdminAPI getDataSourceNames is returning the pool name instead of jndi name

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2712?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2712: ------------------------------------------------ Andrej Podhradsky <apodhrad(a)redhat.com> changed the Status of [bug 1023216|https://bugzilla.redhat.com/show_bug.cgi?id=1023216] from ON_QA to VERIFIED > AdminAPI getDataSourceNames is returning the pool name instead of jndi name > --------------------------------------------------------------------------- > > Key: TEIID-2712 > URL: https://issues.jboss.org/browse/TEIID-2712 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: AdminApi > Affects Versions: 8.4 > Reporter: Mark Drilling > Assignee: Ramesh Reddy > Fix For: 8.4.1, 8.6 > > > See related designer jira. The api call is returning the pool names. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2726) Query Issue with Hive 0.12 Driver

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2726?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2726. --------------------------------- > Query Issue with Hive 0.12 Driver > --------------------------------- > > Key: TEIID-2726 > URL: https://issues.jboss.org/browse/TEIID-2726 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.4 > Reporter: Mark Drilling > Assignee: Ramesh Reddy > Fix For: 8.6 > > Attachments: Hive0_12_Issue.txt > > > I set up the latest Hortonworks Sandbox for testing. The latest version uses Hive 0.12. > - I was able to get the hive0.12 driver set up and am able to query successfully from SquirrelSQL. > - Next, I set up the driver in Teiid Designer and was able to successfully import using the "Teiid Connection" importer. > But, when I attempt to query the teiid source the query fails. Query plan and exception are attached. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 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 July 2014