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

• 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

SAP Replication Server 15.7.1

Replication, DSI, dsie__ProcessGroup, dsi_bulk_copy, dsi_large_xact_size, hang, stop , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed