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