- 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)
- 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
- 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
About this pageThis 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.