SAP Knowledge Base Article - Preview

2515217 - DSI EXEC thread may hang and replication may stop while processing a large transaction - SAP Replication Server

Symptom

  • A transaction contains the larger number of commands than a value specified by dsi_large_xact_size (100 by default).
  • When dsi_bulk_copy option is enabled, a DSI EXEC thread hangs and replication stops while processing the transaction as a large transaction.
  • There is no error message in the errorlog.
  • admin who does not show any suspicious status for DSI threads.

1> admin who
2> go
 Spid Name            State                Info
 ---- --------------- -------------------- ------------------------------------------------------------
.......
   31 DSI EXEC        Awaiting Command     103(1) ASE2.RDB
   20 DSI             Awaiting Message     103 ASE2.RDB
   17 SQM             Awaiting Message     103:0 ASE2.RDB

  • On Linux, pstack command against the repserver process may show the following call stack of DSI EXEC waiting for a new message in dsie__ProcessGroup().

#0  0x000000380ce0b68c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000ed6094 in comn_waitfor_event ()
#2  0x0000000000d1ef6b in srv__obj_sleep ()
#3  0x0000000000d1cd79 in mqueue_get_message ()
#4  0x0000000000d1ccc2 in srv_getmsgq ()
#5  0x00000000005cb9a1 in _sync_getmsgq ()
#6  0x0000000000825a0c in dsie_CheckForMsg ()
#7  0x000000000081f944 in dsie__ProcessGroup ()
#8  0x0000000000829cab in dsie_ProcessMsgFromSched ()
#9  0x000000000081c019 in dsie__main ()
#10 0x000000000081bb54 in dsie__wrap ()
#11 0x0000000000d59a01 in srv__start_function ()
#12 0x000000380ce07aa1 in start_thread () from /lib64/libpthread.so.0
#13 0x000000380cae8bcd in clone () from /lib64/libc.so.6


Read more...

Environment

  • SAP Replication Server 15.7.1

Product

SAP Replication Server 15.7

Keywords

Replication, DSI, dsie__ProcessGroup, dsi_bulk_copy, dsi_large_xact_size, hang, stop , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , 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.