SAP Knowledge Base Article - Preview

3059886 - BCP OUT and SELECTs hang with status 'send sleep' - SAP ASE 16.0 on AIX 7.2 TL5 SP2

Symptom

  • After upgrading AIX to the patch 7200-05-02-2114 from the patch 7200-05-01-2038
  • Processes get the status "send sleep" that never clears. 
  • These processes run BCP OUTs or SELECTs. The same issue was also observed when the process ran "sp_sysmon diskio".
  • "dbcc stacktrace" for the process running BCP OUT shows the following functions:

upsleepgeneric()
ussflush()
sendbuffer()
sendhost()
sendichars()
LeSendRow::_sendColsToClient()
LeSendRow::sendRowToClient()
LeEmitSndOp::_LeOpNext()
LePlanNext+0x190()
exec_lava()
s_execute()
sequencer()
execproc()
s_execute()
sequencer()
tdsrecv_language()

  • "procstack" for the process running a SELECT via ISQL shows the following calls:

__fd_poll(??, ??, ??) + 0xb4
poll(??, ??, ??) + 0xc
sybnet__complete_io(??, ??, ??) + 0x2e4
sybnet_read(??, ??, ??, ??, ??, ??, ??) + 0x194
np_io_read(??, ??, ??, ??) + 0x450
ct__tds_recvpkt(??, ??, ??) + 0x134
ct__tds_get_bytes(??, ??, ??, ??) + 0x430
ct__tds_fetchcols(??, ??, ??) + 0x69c
ct__tds_readrow(??, ??, ??) + 0x4c0
ct__tds_readfetch(??, ??, ??) + 0x480
ct_tds_fetch(??) + 0x80
ct__api_fetch(??, ??, ??) + 0xb0

  • The monProcessNetIO.NetworkPacketSent counts for these processes are not increasing.
  • These processes can be killed using the regular 'kill' command.
  • Rebooting the ASE server doesn't help.
  • There is no issue in ASE running on AIX at the 7.2.5.1.2038 patch level. 
  • Also in Business Suite can be seen the process or during SWPM install we see hang install similar to : dipgntab -rwr40 -srctt DDNTT -srctf DDNTF -ds


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 
  • AIX 7.2 with patch 7200-05-02-2114 (7.2 TL5 SP2)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

IOCP, packet, socket, IBM, iocpdebug, ifix , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-OP-AIX , IBM AIX , Problem

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.