3216684 - Complex query fatally crashes server with error "Query rejected because plan exceeds stack space" - SAP IQ

Symptom

Complex query fatally crashes server with error.
In case of plan exceeding stack trace, IQ server should have rollbacked query rather than fatally crashing.
---------------------------------------------------------
I. 05/20 09:50:19. 0000044215 [20536]: Query rejected because plan exceeds stack space -- (dflib/dfp.cxx 1925)
I. 05/20 09:50:19. 0000044215
I. 05/20 09:50:19. 0000044215
I. 05/20 09:50:19. 0000044215 **************************************************
I. 05/20 09:50:19. 0000044215 *** SAP IQ Abort:
I. 05/20 09:50:19. 0000044215 *** From: oslib/hos_lwtask.cxx:637
I. 05/20 09:50:19. 0000044215 *** PID: 3736478
I. 05/20 09:50:19. 0000044215 *** Message: Thread stack ran past its allocated stack space
I. 05/20 09:50:19. 0000044215 *** Thread: 75560 (TID: 13)
I. 05/20 09:50:19. 0000044215 **************************************************
I. 05/20 09:50:19. 0000044215
I. 05/20 09:50:19. 0000044215 0000075560 Stacktrace requested from oslib/hos_lwtask.cxx:637 on thread 75560 (TID 13) start stacktrace
I. 05/20 09:50:19. 0000044215 While handling one abort, encountered another abort from the same thread.
I. 05/20 09:50:19. 0000044215 Calling emergency shutdown.

Environment

SAP IQ 16.1 SP04 and above

Product

SAP IQ 16.0

Keywords

Thread stack ran past its allocated stack space , -iqtss , emergency shutdown , KBA , BC-SYB-IQ , Sybase IQ , Known Error

About this page

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

Search for additional results

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