3168911 - Stack overflow occurs when interrupting a stored proc using a UDF and a temp table - SAP ASE 16.0

• The message, "stack_tracer: stack overflow last chance handler. Task <kpid_value> has completely exhausted stack ...", may be reported in the SAP ASE error log when a stored procedure calling a user defined function and using a temporary table:
  
  kernel  stack_tracer: stack overflow last chance handler. Task <kpid_value> has completely exhausted stack at line xxxx in file /<full path name>/exception.c. Cleanup is no longer possible and task will be killed
  
  kernel  task xxxxxx topofstack: 0xXXXXXXXX prstack: 0xXXXXXXXX prstackbound: 0xXXXXXXXX prguardbound: 0xXXXXXXXX
  kernel  suid: x spid: <spid value> hostname: 'hostname' application: 'application_name'

• The error may be accompanied by a stack trace referencing the following functions:
  
  stack_abort
  ex_testhandle
  ex_subhandle
  getntextcols
  attrib_delrows
  delattrib
  dropo
  drop_with_retry
  tmp_alldrop
  s_free
  s_pop
  s_cleanframe
  s_handle
  exc__raise
  exc_raise
  quitfn
  ....repteated....
  drop_with_retry
  tmp_alldrop
  s_free
  s_pop
  s_cleanframe
  s_handle
  exc__raise
  exc_raise
  s_runtime_compile
  s_execute
  sequencer
  LeExecSqlFuncMain
  LeExecSqlFunc
  LeRun

• Please note that the stack trace due to a stack overflow is not always printed.

SAP Adaptive Server Enterprise (ASE) 16.0

826348 , CR#826348 , CR826348 , compile, recompile, s_compile, stacktrace, UDF, temp , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem