May 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5740) Create tables/procedures for query plans and vdb info

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5740: ------------------------------------- Summary: Create tables/procedures for query plans and vdb info Key: TEIID-5740 URL: https://issues.jboss.org/browse/TEIID-5740 Project: Teiid Issue Type: Sub-task Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 12.3 We need another mechanism for viewing plans - either a procedure or a table. We also have a lot of vdb information that is not exposed via system metadata. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5619) Provide tables representing admin information

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5619?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5619: --------------------------------------- Adding requests and transactions are straight-forward. Adding sessions is trickier given the relationship between dqpcore and the sessionservice. The current design effectively makes the session service the primary object and has the dqp injected there (due to the legacy of supporting many session services). Usages of both together is done only by higher level constructs (at the EmbeddedServer and TeiidAdd level). There is a hack to set the session service on the buffermanager, so for now I'll leverage something like that, but then circle back to make the session service a dependent object of the core. > Provide tables representing admin information > --------------------------------------------- > > Key: TEIID-5619 > URL: https://issues.jboss.org/browse/TEIID-5619 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.2 > > > Information provided over the admin api about sessions, requests, transactions, etc. should also be available via system tables. > Similarly many of the admin operations could be provided as system procedures - kill session, flush cache, etc. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5739) Procedure does not get executed (without error) when comment and variable declaration are present

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5739?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5739. ----------------------------------- Fix Version/s: 12.2 12.1.2 Resolution: Done Two changes were needed. First expanded handling of the preceding comment, and adding EOF as expected for later parsing of a procedure body - this ensures that an exception would have been thrown in this situation. > Procedure does not get executed (without error) when comment and variable declaration are present > ------------------------------------------------------------------------------------------------- > > Key: TEIID-5739 > URL: https://issues.jboss.org/browse/TEIID-5739 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 12.0 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 12.2, 12.1.2 > > > Using the below definition, it should delete the data from the table. It will do it if you either remove the comment or the variable declaration. Interestingly, it looks like the proc is executed, but the data is still present in the test table: > {code:sql} > create virtual procedure deleteTableTest ( > ) AS > -- > begin > declare string v; > execute immediate 'DELETE from dwh.testRemove' without return ; > end > {code} -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5738) Upgrade to WildFly 16

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5738?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5738: ---------------------------------- Component/s: Server Description: Upgrade to the latest WildFly for the next Teiid minor release. Note that it has not been tested if Teiid 12.2 is compatible with WildFly 16, so that could be an initial workaround. See the forum https://developer.jboss.org/thread/280075 for a discussion of managing the overlay separately from WildFly. was: Is it possible to use Wildfly 16.0 to launch the Teiid runtime or does it require WildFly 15.0? I would like to Upgrade Wildfly to latest version 16.0, So can we launched from Wildfly 16 separately? https://developer.jboss.org/thread/280075 Thanks Fix Version/s: 12.3 Summary: Upgrade to WildFly 16 (was: want to upgarde Wildfly to 16.0. Does the latest Teiid 12.1.1 contains WildFly 16.0 ? ) Forum Reference: https://developer.jboss.org/thread/280075 > Upgrade to WildFly 16 > --------------------- > > Key: TEIID-5738 > URL: https://issues.jboss.org/browse/TEIID-5738 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Shwetha vr > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.3 > > > Upgrade to the latest WildFly for the next Teiid minor release. > Note that it has not been tested if Teiid 12.2 is compatible with WildFly 16, so that could be an initial workaround. See the forum https://developer.jboss.org/thread/280075 for a discussion of managing the overlay separately from WildFly. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5739) Procedure does not get executed (without error) when comment and variable declaration are present

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5739?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5739: --------------------------------------- This is due to parser logic that is preserving hints that appear before the procedure body definition. In the case of a line comment it is not preserving the newline, so it's effectively saving the definition as: -- begin declare string v; execute immediate 'DELETE from dwh.testRemove' without return ; end On the next parsing it will just capture the first statement as the procedure as the block is effectively commented out. > Procedure does not get executed (without error) when comment and variable declaration are present > ------------------------------------------------------------------------------------------------- > > Key: TEIID-5739 > URL: https://issues.jboss.org/browse/TEIID-5739 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 12.0 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > > Using the below definition, it should delete the data from the table. It will do it if you either remove the comment or the variable declaration. Interestingly, it looks like the proc is executed, but the data is still present in the test table: > {code:sql} > create virtual procedure deleteTableTest ( > ) AS > -- > begin > declare string v; > execute immediate 'DELETE from dwh.testRemove' without return ; > end > {code} -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5739) Procedure does not get executed (without error) when comment and variable declaration are present

by Dmitrii Pogorelov (Jira)

Dmitrii Pogorelov created TEIID-5739: ---------------------------------------- Summary: Procedure does not get executed (without error) when comment and variable declaration are present Key: TEIID-5739 URL: https://issues.jboss.org/browse/TEIID-5739 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 12.0 Reporter: Dmitrii Pogorelov Assignee: Steven Hawkins Using the below definition, it should delete the data from the table. It will do it if you either remove the comment or the variable declaration. Interestingly, it looks like the proc is executed, but the data is still present in the test table: {code:sql} create virtual procedure deleteTableTest ( ) AS -- begin declare string v; execute immediate 'DELETE from dwh.testRemove' without return ; end {code} -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5711) isolate references to JEE concerns, such as jca

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5711?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5711. ----------------------------------- Resolution: Done Added the initial commits for this. As much as possible pages and content was excluded that used jee terms or referenced WildFly in general. > isolate references to JEE concerns, such as jca > ----------------------------------------------- > > Key: TEIID-5711 > URL: https://issues.jboss.org/browse/TEIID-5711 > Project: Teiid > Issue Type: Sub-task > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.2 > > > We refer to JCA resource adapters even in the reference guide. This and other JEE concepts should be isolated to the wildfly docs. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5738) want to upgarde Wildfly to 16.0. Does the latest Teiid 12.1.1 contains WildFly 16.0 ?

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5738?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5738: ---------------------------------- Security: (was: Red Hat Internal) > want to upgarde Wildfly to 16.0. Does the latest Teiid 12.1.1 contains WildFly 16.0 ? > --------------------------------------------------------------------------------------- > > Key: TEIID-5738 > URL: https://issues.jboss.org/browse/TEIID-5738 > Project: Teiid > Issue Type: Feature Request > Reporter: Shwetha vr > Assignee: Steven Hawkins > Priority: Major > > Is it possible to use Wildfly 16.0 to launch the Teiid runtime or does it require WildFly 15.0? > I would like to Upgrade Wildfly to latest version 16.0, So can we launched from Wildfly 16 separately? > https://developer.jboss.org/thread/280075 > Thanks -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-23) Document image generation options

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-23?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIIDSB-23: -------------------------------- Fix Version/s: (was: Q119) > Document image generation options > --------------------------------- > > Key: TEIIDSB-23 > URL: https://issues.jboss.org/browse/TEIIDSB-23 > Project: Teiid Spring Boot > Issue Type: Task > Reporter: Steven Hawkins > Priority: Major > > We need to document / validate all relevant image options: > - inclusion of agent bond or other mechanism for jmx exposure to prometheus. There may also be related service annotations > - annotations for 3scale for rest and openapi exposure of odata > - any common config options - disk buffer memory, max active plans / engine threads / connection pool sizes. Ideally the buffer manager heap should auto-configure and we should probably always use off-heap for the fixed memory buffer. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-45) Develop OpenShift Operator for deploying VDBs

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-45?page=com.atlassian.jira.plugin... ] Work on TEIIDSB-45 started by Ramesh Reddy. ------------------------------------------- > Develop OpenShift Operator for deploying VDBs > --------------------------------------------- > > Key: TEIIDSB-45 > URL: https://issues.jboss.org/browse/TEIIDSB-45 > Project: Teiid Spring Boot > Issue Type: Feature Request > Components: OpenShift > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 1.1.0 > > > Need to develop a GO lang based Operator for deploying the VDBs and its configuration. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 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 May 2019