June 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5962) Teiid locks many threads when Salesforce is disconnected

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5962?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5962: ---------------------------------- Fix Version/s: 15.0 > Teiid locks many threads when Salesforce is disconnected > -------------------------------------------------------- > > Key: TEIID-5962 > URL: https://issues.redhat.com/browse/TEIID-5962 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 12.3.1 > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0 > > Attachments: Снимок экрана от 2020-05-31 11-09-10.png > > > We had two incidents in our experimental service with teiid spring boot app. When Salesforce is down to 20min and service with teiid trying to call SQL from Salesforce we have many threads in tomcat server (in spring boot app). Then when 200 threads is activated service do not reply to requests because is "max threads" in tomcat of service. > Why teiid do not send response as "Salesforce is down - error" or connection timeout? > Micro schema: > HTTP Requests to REST api -> Teiid spring boot app -> {broken 20min}Salesforce -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5937) Union All followed by except returns wrong results

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?focusedWorklogId=12451396&pag... ] Steven Hawkins logged work on TEIID-5937: ----------------------------------------- Author: Steven Hawkins Created on: 09/Jun/20 6:25 PM Start Date: 09/Jun/20 6:25 PM Worklog Time Spent: 1 hour, 30 minutes Issue Time Tracking ------------------- Remaining Estimate: 0 minutes (was: 1 hour) Time Spent: 4 hours, 30 minutes (was: 3 hours) Worklog Id: (was: 12451396) > Union All followed by except returns wrong results > -------------------------------------------------- > > Key: TEIID-5937 > URL: https://issues.redhat.com/browse/TEIID-5937 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 15.0, 13.1.2, 14.0.1 > > Original Estimate: 4 hours > Time Spent: 4 hours, 30 minutes > Remaining Estimate: 0 minutes > > The following queries return wrong results: > {code:sql} > -- <null> though should return 1 > select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1 except select * from views.test2 ;; > > -- <null> though should return 1 > (select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1) except select * from views.test2 ;; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5937) Union All followed by except returns wrong results

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5937. ----------------------------------- Resolution: Done Updated the logic to not use the output columns, but instead look directly at the projected columns. > Union All followed by except returns wrong results > -------------------------------------------------- > > Key: TEIID-5937 > URL: https://issues.redhat.com/browse/TEIID-5937 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 15.0, 13.1.2, 14.0.1 > > Original Estimate: 4 hours > Time Spent: 3 hours > Remaining Estimate: 1 hour > > The following queries return wrong results: > {code:sql} > -- <null> though should return 1 > select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1 except select * from views.test2 ;; > > -- <null> though should return 1 > (select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1) except select * from views.test2 ;; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-197) Add a module for each external source

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-197?focusedWorklogId=12451395&pa... ] Ramesh Reddy logged work on TEIIDSB-197: ---------------------------------------- Author: Ramesh Reddy Created on: 09/Jun/20 3:25 PM Start Date: 09/Jun/20 3:25 PM Worklog Time Spent: 3 days Issue Time Tracking ------------------- Remaining Estimate: 0 minutes Time Spent: 3 days Worklog Id: (was: 12451395) > Add a module for each external source > ------------------------------------- > > Key: TEIIDSB-197 > URL: https://issues.redhat.com/browse/TEIIDSB-197 > Project: Teiid Spring Boot > Issue Type: Enhancement > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > Time Spent: 3 days > Remaining Estimate: 0 minutes > > To simplify the logic in the operator each external source should be represented by a maven artifact - org.teiid:spring-data-x. Any dependency management would be handled in that module and not in the operator - to remove the need for a config file containing driver versions. Additionally property handling should be moved into Teiid Spring Boot such that the operator does not need to know what property prefix is expected. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-197) Add a module for each external source

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-197?page=com.atlassian.jira.plug... ] Ramesh Reddy updated TEIIDSB-197: --------------------------------- Original Estimate: 3 days Sprint: DV Sprint 65 > Add a module for each external source > ------------------------------------- > > Key: TEIIDSB-197 > URL: https://issues.redhat.com/browse/TEIIDSB-197 > Project: Teiid Spring Boot > Issue Type: Enhancement > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > Original Estimate: 3 days > Time Spent: 3 days > Remaining Estimate: 0 minutes > > To simplify the logic in the operator each external source should be represented by a maven artifact - org.teiid:spring-data-x. Any dependency management would be handled in that module and not in the operator - to remove the need for a config file containing driver versions. Additionally property handling should be moved into Teiid Spring Boot such that the operator does not need to know what property prefix is expected. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-197) Add a module for each external source

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-197?page=com.atlassian.jira.plug... ] Work on TEIIDSB-197 started by Ramesh Reddy. -------------------------------------------- > Add a module for each external source > ------------------------------------- > > Key: TEIIDSB-197 > URL: https://issues.redhat.com/browse/TEIIDSB-197 > Project: Teiid Spring Boot > Issue Type: Enhancement > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > > To simplify the logic in the operator each external source should be represented by a maven artifact - org.teiid:spring-data-x. Any dependency management would be handled in that module and not in the operator - to remove the need for a config file containing driver versions. Additionally property handling should be moved into Teiid Spring Boot such that the operator does not need to know what property prefix is expected. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5968) enabled=true flag not visible in xa-datasource

by Manoj Majumdar (Jira)

Manoj Majumdar created TEIID-5968: ------------------------------------- Summary: enabled=true flag not visible in xa-datasource Key: TEIID-5968 URL: https://issues.redhat.com/browse/TEIID-5968 Project: Teiid Issue Type: Bug Components: AdminApi Affects Versions: 11.1.2 Reporter: Manoj Majumdar Assignee: Steven Hawkins While creating a XA-Datasource using admin Api, enabled="true" paramter is not set and is not visible in standalone-teiid.xml, have to add it manually. Because of this flag not set, connection pooling is not working and teiid is creating more connections than max-pool-size mentioned -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-209) NPE using salesforce connection

by Steven Hawkins (Jira)

Steven Hawkins created TEIIDSB-209: -------------------------------------- Summary: NPE using salesforce connection Key: TEIIDSB-209 URL: https://issues.redhat.com/browse/TEIIDSB-209 Project: Teiid Spring Boot Issue Type: Bug Components: datasource Reporter: Steven Hawkins Fix For: 1.6.0 The config is not being set appropriately and results in an npe. This is due to TEIIDSB-184 -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5937) Union All followed by except returns wrong results

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5937: ---------------------------------- Fix Version/s: 13.1.2 14.0.1 15.0 (was: 13.1) (was: 14.0) (was: 13.0.3) > Union All followed by except returns wrong results > -------------------------------------------------- > > Key: TEIID-5937 > URL: https://issues.redhat.com/browse/TEIID-5937 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 15.0, 13.1.2, 14.0.1 > > Original Estimate: 4 hours > Time Spent: 3 hours > Remaining Estimate: 1 hour > > The following queries return wrong results: > {code:sql} > -- <null> though should return 1 > select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1 except select * from views.test2 ;; > > -- <null> though should return 1 > (select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1) except select * from views.test2 ;; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5937) Union All followed by except returns wrong results

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?page=com.atlassian.jira.plugi... ] Steven Hawkins reopened TEIID-5937: ----------------------------------- > Union All followed by except returns wrong results > -------------------------------------------------- > > Key: TEIID-5937 > URL: https://issues.redhat.com/browse/TEIID-5937 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 13.1, 14.0, 13.0.3 > > Original Estimate: 4 hours > Time Spent: 3 hours > Remaining Estimate: 1 hour > > The following queries return wrong results: > {code:sql} > -- <null> though should return 1 > select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1 except select * from views.test2 ;; > > -- <null> though should return 1 > (select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1) except select * from views.test2 ;; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 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 2020