Symptom
- 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.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
826348 , CR#826348 , CR826348 , compile, recompile, s_compile, stacktrace, UDF, temp , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.