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

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13531940#comment-13531940 ] 

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)