2000952 - Application and spid hangs with sp_who status in "send sleep" - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2000952 - Application and spid hangs with sp_who status in "send sleep" - SAP ASE

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) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.