[
https://issues.jboss.org/browse/TEIID-5255?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5255:
---------------------------------------
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...
The plan would definitely be helpful as this exception is happening post planning. If
it's not consistent after a restart it is dependent on row counts.
> 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)