[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)
6 years, 3 months
[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)
6 years, 3 months
[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)
6 years, 3 months
[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)
6 years, 3 months
[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)
6 years, 3 months
[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)
6 years, 3 months
[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)
6 years, 3 months
[JBoss JIRA] (TEIID-5252) Teiid Wildfly Swarm Odata
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5252?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5252:
-------------------------------------
I found TEIID-5251 so I can't get past it, once that update is available I will re-test this.
> Teiid Wildfly Swarm Odata
> --------------------------
>
> Key: TEIID-5252
> URL: https://issues.jboss.org/browse/TEIID-5252
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Arvind Gopinath
> Assignee: Ramesh Reddy
> Priority: Minor
>
> Through Teiid Wildfly SWARM (examples code), I could able to run connecting below VDB and through SQL client, I could able to access my tables as well.
> To expose the same through Odata, in my pom.xml, I added below dependency.
> <dependency>
> <groupId>org.wildfly.swarm</groupId>
> <artifactId>odata</artifactId>
> <version>2018.1.0</version>
> </dependency>
> When my jar starts, I saw odata.war deployed and even my VDB added and through Sql client I could able to connect.
> 2018-02-08 15:30:31,119 INFO [org.jboss.as.server] (main) WFLYSRV0010: Deployed "odata.war" (runtime-name : "odata.war")
> 2018-02-08 15:30:31,493 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-2) TEIID40118 VDB sqlite.1 added to the repository
> 2018-02-08 15:30:31,497 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB sqlite.1 model "client" metadata is currently being loaded. Start Time: 8/02/18 3:30 PM
> But when I hit the URL,
> http://localhost:8080/odata4/sqlite.1/client.client
> I am getting error message below - Is it something I am missing?
> { "error": { "code": "38000", "message": "38000 TEIID10036 org.teiid.core.TeiidException: TEIID10036 org.teiid.core.TeiidRuntimeException: TEIID40067 javax.naming.NameNotFoundException: teiid\/queryengine\/odata -- service jboss.naming.context.java.teiid.queryengine.odata" } }
> Teiid Designer - Generated simple VDB.xml
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="sqlite" version="1">
> <description>SQLite VDB</description>
> <model name="client">
> <property name="importer.useFullSchemaName" value="false"/>
> <!-- https://access.redhat.com/documentation/en-us/red_hat_jboss_data_virtuali... -->
> <!-- <property name="importer.tableNamePattern" value="CLI%"/> -->
> <property name="importer.excludeTables" value="FIL.*|ORDER.*"/>
> <source name="sqlite-connector" translator-name="jdbc-simple" connection-jndi-name="java:jboss/datasources/demoDS"/>
> </model>
> </vdb>
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 3 months