Symptom
- User application hangs (typically Java jConnect) during large batch insert.
- spid remains stuck with status "send sleep" in sp_who
- dbcc stacktace(<hung_spid>) shows:
Start dbcc stacktrace... upsleepgeneric() ussflush() sendbuffer() sendhost() s_i2Swap() send_done() senddone() s_estmt_loopend() s_xoltp_dml() sequencer() tdsrecv__process_batchparam() tdsrecv__dynexec_batch() tdsrecv__dynexec() tdsrecv_dynamic() conn_hdlr() dbcc stacktrace finished.
Simllarly on AIX , a spid sending results to a client is hung in 'send sleep'
pthread_self
kpsuspend
upsleepgeneric
ussflush
sendbuffer
sendhost
sendichars
LeSendRow::_sendColsToClient
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) All Versions
IBM AIX Operating System only
Product
SAP Adaptive Server Enterprise all versions
Keywords
CR790982, CR#790982, 788690, CR#788690, 788690 , KBA , preparedstatement , statement.execute() , 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.