Symptom
- Connection hangs and cannot be killed.
- sp_who output show (many) processes in "maintanance token"
- This connection was assigned to a specific thread pool and re-assigned to another thread pool while active.
- A "dbcc stacktrace" on a problem spid shows the connection in upsleepgeneric with functions csimtx_lock & csi_aes_cipher
- The full stack is likely the following. However, stack patterns can vary and may be different
upsleepgeneric
csimtx_lock
csi_aes_cipher
syb_get_sess_pwd
lt_extend_beginxact
xact__beginxact
xact__begin_local
xact_begin
Read more...
Product
SAP Adaptive Server Enterprise 16.0
Keywords
create thread pool, sp_bindexeclass, sp_addexeclass, hang, sleep, stuck , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.
SAP Knowledge Base Article - Preview