SAP Knowledge Base Article - Preview

1966851 - [SAP IQ] IQ aborted at "dfo::CheckMarkInvariant".

Symptom

A Query (which used a Nested loop pushdown (NLPD) join with more than one uncorrelated IN subquery) leads to server crash.

[iqmsg]

SELECT a11.KEY_COL001 k1,
....
WHERE (((a11.KEY_COL001) in ( SELECT c22.KEY_COL002
FROM ONWER.TAB002 c21
JOIN ONWER.TAB001 c22
on (c21.KEY_COL003 = c22.KEY_COL004)
WHERE c21.KEY_COL003 not in ('Y')))
AND ((a11.KEY_COL001) in ( SELECT c22.KEY_COL005
FROM ONWER.TAB003 c21
JOIN ONWER.TAB004 c22
on (c21.KEY_COL006 = c22.KEY_COL007)
...
GROUP by a11.KEY_COL001

  Dump all thread stacks at st_server.cxx:1412 for PID: 24707566
 
  ***************** This is the STACKTRACE ***************
 
  ===== Thread Number 36752 (IQ connID: 0000156739) =====
  ...pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x170()
  ...ucstkgentrace(int,int)+0xb0()
  ...DumpAllThreads(const char*,unsigned int,int)+0x1bc()
  ...hos_ABORT(const char*,unsigned int,const char*,char*,char*)+0x160()
  ...SigHndlr+0x54()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()
  ...dfo_Join::CheckMarkInvariant(const hos_vector_noerror&,int)+0x1a4()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()
  ...dfo_SubQuery::CheckMarkInvariant(const hos_vector_noerror&,int)+0xb4()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()


Read more...

Environment

SAP IQ15.2, IQ15.4

Product

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

CheckMarkInvariant, Nested loop pushdown, st_server.cxx:1412, uncorrelated subquery, IQ, CR #705510, CR 705510, 705510 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.