February 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5257) Sysadmin Usage table doesn't track column-level usage by a virtual procedure

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5257: ---------------------------------- Summary: Sysadmin Usage table doesn't track column-level usage by a virtual procedure Key: TEIID-5257 URL: https://issues.jboss.org/browse/TEIID-5257 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Steven Hawkins There are not column-level dependencies in relation 'Virtual procedure column -> View/table column'. For this vdb: {code:xml|title=vdb} <model name="insideVirtualModel" type="VIRTUAL"> <metadata type="DDL"> <![CDATA[ CREATE VIEW v1 (v1col string) AS SELECT 'a' UNION ALL SELECT 'b'; CREATE VIEW v2 (v2col string) AS SELECT v1col||'b' FROM v1; CREATE VIRTUAL PROCEDURE p1() RETURNS (p1col string) AS BEGIN SELECT v2col FROM v2; END CREATE VIEW v7 (v7col string) AS SELECT p1.p1col FROM (CALL p1())AS p1; ]]> </metadata> </model> <model name="dependentOnPhysicalModel" type="VIRTUAL"> <metadata type="DDL"> <![CDATA[ CREATE VIEW v3 (v3col string) AS SELECT t1col||'b' FROM t1; CREATE VIEW v4 (v4col string) AS SELECT p.p2col FROM (CALL p2(1)) AS p; ]]> </metadata> </model> {code} Following query: {code:sql|title=SYSADMIN.Usage query} SELECT * FROM SYSADMIN.Usage WHERE VDBName='vdbname' AND SchemaName='insideVirtualModel' AND Name='p1' AND object_type='Column' AND Uses_object_type='Column' {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5256) Sysadmin Usage table doesn't track usage of procedures

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5256: ---------------------------------- Summary: Sysadmin Usage table doesn't track usage of procedures Key: TEIID-5256 URL: https://issues.jboss.org/browse/TEIID-5256 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Steven Hawkins I can't see a dependency of a view on either foreign or virtual procedures. {code:xml|title=vdb} <model name="insideVirtualModel" type="VIRTUAL"> <metadata type="DDL"> <![CDATA[ CREATE VIEW v1 (v1col string) AS SELECT 'a' UNION ALL SELECT 'b'; CREATE VIEW v2 (v2col string) AS SELECT v1col||'b' FROM v1; CREATE VIRTUAL PROCEDURE p1() RETURNS (p1col string) AS BEGIN SELECT v2col FROM v2; END CREATE VIEW v7 (v7col string) AS SELECT p1.p1col FROM (CALL p1())AS p1; ]]> </metadata> </model> <model name="dependentOnPhysicalModel" type="VIRTUAL"> <metadata type="DDL"> <![CDATA[ CREATE VIEW v3 (v3col string) AS SELECT t1col||'b' FROM t1; CREATE VIEW v4 (v4col string) AS SELECT p.p2col FROM (CALL p2(1)) AS p; ]]> </metadata> </model> {code} I don't get any entries in SYSADMIN.Usage for both v4 and v7 views. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5255) Assertion failed in MergeJoinStrategy.setProcessingSortRight

by Bram Gadeyne (JIRA)

Bram Gadeyne created TEIID-5255: ----------------------------------- Summary: Assertion failed in MergeJoinStrategy.setProcessingSortRight Key: TEIID-5255 URL: https://issues.jboss.org/browse/TEIID-5255 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 10.1 Reporter: Bram Gadeyne Assignee: Steven Hawkins 2018-02-12 09:10:44,905 ERROR [org.teiid.PROCESSOR] (Worker35_QueryProcessorQueue538707) Jtb6gbxGtFZG TEIID30019 Unexpected exception for request Jtb6gbxGtFZG.42: java.lang.AssertionError: Assertion failed. at org.teiid.core.util.Assertion.failed(Assertion.java:69) at org.teiid.core.util.Assertion.assertTrue(Assertion.java:64) at org.teiid.core.util.Assertion.assertTrue(Assertion.java:56) at org.teiid.query.processor.relational.MergeJoinStrategy.setProcessingSortRight(MergeJoinStrategy.java:381) ... In the code for this I see this comment: //it is possible that a delayed open will be called after the parent open //for now we'll just throw an assertion The exception occurs while executing this query: {code:sql} insert into rep38_results(admissionid, vargroup, vartype, vartime, varenttime, varstrvalue, vardoublevalue, vartimevalue,validated) select patientid, Labogroep, v.name, sampletime, entertime, stringvalue, varvalue,null,false from ( select lc.patientid, lm.Labogroep, lm.name, lc.sampletime, lc.entertime, lc.stringvalue, lc.varvalue, lc.resultid, lc.ResultNo, row_number() over(partition by lc.patientid, lc.variableid_nieuw, lc.SampleTime order by lc.ResultID, lc.ResultNo desc) as rang from rep38_cohort coh join izisprod.P_GeneralData gd on gd.PatientID = cast(coh.admissionid as integer) and gd.Status >= 4 and gd.status <> 5 join izisprod.U_PV_LabCorrectValues lc on lc.PatientID = gd.patientid and BITAND(lc.status, 8) = 8 and BITAND(lc.status, 2) <> 2 and lc.sampletime > PARSETIMESTAMP('2013-01-01','yyyy-MM-dd') and lc.sampletime between coh.studystart and coh.studyend join izisprod.U_P_LabMapping lm on lm.labogroep in ('WBC-b','INR','crp-s','Thrombocyten','Lactaat-s') and lm.VariableID = lc.variableid_oud UNION ALL select lc.patientid, lm.Labogroep, lm.name, lc.sampletime, lc.entertime, lc.stringvalue, lc.varvalue, lc.resultid, lc.ResultNo, row_number() over(partition by lc.patientid, lc.variableid_nieuw, lc.SampleTime order by lc.ResultID, lc.ResultNo desc) as rang from rep38_cohort coh join iziswh.P_GeneralData gd on gd.PatientID = cast(coh.admissionid as integer) join iziswh.U_PV_LabCorrectValues lc on lc.PatientID = gd.patientid and BITAND(lc.status, 8) = 8 and BITAND(lc.status, 2) <> 2 and lc.sampletime > PARSETIMESTAMP('2013-01-01','yyyy-MM-dd') and lc.sampletime between coh.studystart and coh.studyend join izisprod.U_P_LabMapping lm on lm.labogroep in ('WBC-b','INR','crp-s','Thrombocyten','Lactaat-s') and lm.VariableID = lc.variableid_oud ) v where v.rang = 1 order by patientid, Labogroep, SampleTime; {code} While writing down this issue, I restarted our server and the issue is now gone so I can't reproduce it at this time. I was also planning on retrieving the SHOWPLAN contents... -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5254) Unhandled exception when making a multipart post to a rest varbinary value

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5254?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5254. ----------------------------------- Fix Version/s: 10.1.1 10.0.4 Resolution: Done There are two issues here. The first is that it was possible to pass a null inputstream to the write method, which caused an npe. The other is that we were closing the outputstream, which commits the response - and the user doesn't receive an exception. > Unhandled exception when making a multipart post to a rest varbinary value > -------------------------------------------------------------------------- > > Key: TEIID-5254 > URL: https://issues.jboss.org/browse/TEIID-5254 > Project: Teiid > Issue Type: Bug > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.1.1, 10.0.4, 10.2 > > > In the running of IntegrationTestRestWebserviceGeneration.testMultipartPostOperation the log reports an NPE due to an unhandled exception. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5254) Unhandled exception when making a multipart post to a rest varbinary value

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5254: ------------------------------------- Summary: Unhandled exception when making a multipart post to a rest varbinary value Key: TEIID-5254 URL: https://issues.jboss.org/browse/TEIID-5254 Project: Teiid Issue Type: Bug Components: Server Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 10.2 In the running of IntegrationTestRestWebserviceGeneration.testMultipartPostOperation the log reports an NPE due to an unhandled exception. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5253) Timing issue in domain mode with materialization

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5253?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5253. ----------------------------------- Fix Version/s: 10.0.4 Resolution: Done Changed the addListener method to return a list of currently active vdbs so that the caller can determine what action can be taken. Both the resteasy enablement and the materialization manager use this to make sure no vdbs were missed. > Timing issue in domain mode with materialization > ------------------------------------------------ > > Key: TEIID-5253 > URL: https://issues.jboss.org/browse/TEIID-5253 > Project: Teiid > Issue Type: Bug > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0.4, 10.2, 9.3.7, 10.1.1 > > > In domain mode with a vdb that has materialized views, issuing a restart of the servers will trigger a load that utilizes the cached metadata. This can mark the vdbs as active before the MaterializationManager has been installed - so it is never notified of finished deployment. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3042) expose dependency information in system tables

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-3042?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-3042: ------------------------------------ Plus I don't get anything for query: {code:sql} SELECT * FROM SYSADMIN.Usage WHERE VDBName='vdbname' AND SchemaName='insideVirtualModel' AND Name='p1' AND object_type='Column' AND Uses_object_type='Column' {code} meaning that, there are not column-level dependencies in relation 'Virtual procedure column -> View column'. Relation 'Virtual procedure -> View column' is tracked correctly. > expose dependency information in system tables > ---------------------------------------------- > > Key: TEIID-3042 > URL: https://issues.jboss.org/browse/TEIID-3042 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > We should expose additional view/procedure and even column information in terms of their dependencies. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3042) expose dependency information in system tables

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-3042?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-3042: ------------------------------------ [~shawkins] I can't see a dependency of a view on either foreign or virtual procedures. For models like: {code:xml} <model name="source" type="PHYSICAL"> <source name="source" translator-name="h2" connection-jndi-name="java:/h2-ds"/> <metadata type="DDL"> <![CDATA[ CREATE FOREIGN TABLE t1 (t1col string); CREATE FOREIGN PROCEDURE p2(id integer) returns table (p2col string); ]]> </metadata> </model> <model name="insideVirtualModel" type="VIRTUAL"> <metadata type="DDL"> <![CDATA[ CREATE VIEW v1 (v1col string) AS SELECT 'a' UNION ALL SELECT 'b'; CREATE VIEW v2 (v2col string) AS SELECT v1col||'b' FROM v1; CREATE VIRTUAL PROCEDURE p1() RETURNS (p1col string) AS BEGIN SELECT v2col FROM v2; END CREATE VIEW v7 (v7col string) AS SELECT p1.p1col FROM (CALL p1())AS p1; ]]> </metadata> </model> <model name="dependentOnPhysicalModel" type="VIRTUAL"> <metadata type="DDL"> <![CDATA[ CREATE VIEW v3 (v3col string) AS SELECT t1col||'b' FROM t1; CREATE VIEW v4 (v4col string) AS SELECT p.p2col FROM (CALL p2(1)) AS p; ]]> </metadata> </model> {code} I don't get any entries in SYSADMIN.Usage for both v4 and v7 views. Shouldn't this be tracked also? The reverse relationship is tracked, I get entries for p1, referencing v2 view and column. > expose dependency information in system tables > ---------------------------------------------- > > Key: TEIID-3042 > URL: https://issues.jboss.org/browse/TEIID-3042 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > We should expose additional view/procedure and even column information in terms of their dependencies. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5253) Timing issue in domain mode with materialization

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5253?page=com.atlassian.jira.plugin... ] Work on TEIID-5253 started by Steven Hawkins. --------------------------------------------- > Timing issue in domain mode with materialization > ------------------------------------------------ > > Key: TEIID-5253 > URL: https://issues.jboss.org/browse/TEIID-5253 > Project: Teiid > Issue Type: Bug > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.2, 9.3.7, 10.1.1 > > > In domain mode with a vdb that has materialized views, issuing a restart of the servers will trigger a load that utilizes the cached metadata. This can mark the vdbs as active before the MaterializationManager has been installed - so it is never notified of finished deployment. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5253) Timing issue in domain mode with materialization

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5253: ------------------------------------- Summary: Timing issue in domain mode with materialization Key: TEIID-5253 URL: https://issues.jboss.org/browse/TEIID-5253 Project: Teiid Issue Type: Bug Components: Server Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 10.2, 9.3.7, 10.1.1 In domain mode with a vdb that has materialized views, issuing a restart of the servers will trigger a load that utilizes the cached metadata. This can mark the vdbs as active before the MaterializationManager has been installed - so it is never notified of finished deployment. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2018