2188555 - Timeslice error when killing a nested UDF - SAP ASE

• Killing a process running nested user defined function (UDF) may cause a timeslice error in routine LeExecSqlFunc
• This can result in a phantom spid
• Messages in ASE errorlog will include error sequence that includes the spid of the killed process :

00:0006:00000:00014:2020/12/08 16:22:37.56 server Process id 15 killed by Hostname redhead, Host process id 26062.
00:0006:00000:00015:2020/12/08 16:22:42.96 kernel timeslice -501, current process infected at 0x20c4a4e (LeExecSqlFunc+0x292)

Showing SQL Text referring to a UDF:

Current Procedure: udf_get_sysdate

And with a stack trace including (the key ones are further down the stack sequence)

(null)
...
...
LeExecSqlFuncMain
LeExecSqlFunc

• A phantom spids holding unkillable locks may appear if the session has created temporary table and ASE gets another signal 11 stack trace during drop table
• Further log messages printed will include, also for same spid :

00:0006:00000:00015:2020/12/08 16:22:42.98 kernel Address 0x0x0000000001ee1ce4 (ptn__pdes_opencount+0x64)...

with a stack trace including routines

ptn__pdes_opencount
ptn__markdrop
ptn_delete_row
ptn_delete_all
dropo

• SAP Adaptive Server Enterprise (ASE) 16.0

user-defined function, CR823700,  CR#823700,  CR 823700, 823700, stacktrace, endless, loop, LeExecSqlFunc(), LeExecSqlFunc, sqlfExHandler , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed