SAP Knowledge Base Article - Preview

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

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.