3018577 - ASE report stack overflow first chance handler without meaningful stack functions - SAP ASE

• ASE reports a "Stack overflow detected" error and no meaningful functions in the stack trace when running a complex select query.
• Note: Functions kisignal, ucstackcrash, ucbacktrace, ucstkgentrace, and pcstkwalk are common error handling routines that aren't predicitive of the root cause.
• ASE terminates after the error.

kernel stack overflow first chance handler for task 1552623724 at line 1040 in file /tmp/EBF29367_ws270/porttree/svr/sql/generic/source/useful/ex_print.c, current top of stack: 0x2aadb8465938. Cleanup will be attempted

Stack overflow detected: limit: 0x0x00002aacfbe6d510, guardpage: 0x0x00002aacfbe74510, sp: 0x0x00002aacfbef0a24
*** Stack guardword corrupted.
kernel pc: 0x00000000012f12c0 pcstkwalk+0x482()
kernel pc: 0x00000000012f0c7f ucstkgentrace+0x20f()
kernel pc: 0x00000000012edce2 ucbacktrace+0x54()
kernel pc: 0x00000000012ef4ef ucstackcrash+0xa1()
pc: 0x000000000131df61 kisignal+0xbb()
end of stack trace, spid 10121, kpid 1842024985, suid 236
*** Stack corrupted, server aborting.
kernel pc: 0x00000000012f12c0 pcstkwalk+0x482()
kernel pc: 0x00000000012f0c7f ucstkgentrace+0x20f()
kernel pc: 0x00000000012edce2 ucbacktrace+0x54()
kernel pc: 0x00000000012ef917 keipanic+0x10f()
kernel pc: 0x00000000012ef4fb ucstackcrash+0xad()
kernel pc: 0x000000000131df61 kisignal+0xbb()
kernel end of stack trace, spid 10121, kpid 1842024985, suid 236
kernel ueshutdown: exiting
kernel Main thread performing final shutdown.
kernel Blocking call queue shutdown.
kernel bucket manager consolidator terminating

• When above error reported in the ASE, ASE may also leave phamtom locks and not terminated with the following errors reported: 

Error: 1265, Severity: 20, State: 1 An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr=0x0x2ab10aa57dd0, lrmagic=r).
Error: 941, Severity: 20, State: 1
Error: 925, Severity: 16, State: 1

SAP Adaptive Server Enterprise 16.0

CR823670, CR 816960, 9733, stack overflow, last chance , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed