SAP Knowledge Base Article - Preview

3224503 - DSI-S thread runs into memory control status frequently - SRS

Symptom

  • Below errors would appear frequently in the active SRS in HADR setup, or in the DR SRS in HADR setup with third node, despite the fact that you configure a very large value of memory_limit:
    WARNING #24070 dALARM( ) - generic/sqt/sqtint.c(9736)
                   SQT(114:0 site2.SID): A timeout has occurred while a large transaction ( '00020005dfe1' ? 'a800' .xxx '000000' l '00000000') was waiting for the next message to be read.
    Connection to server 'site2' as user 'SID_maint' has been faded out (closed). 
    WARNING #24070 dALARM( ) - generic/sqt/sqtint.c(9736)
                   SQT(114:0 site2.SID): A timeout has occurred while a large transaction ( '00020005e1' + 'ec' ' '00' +xxx '000000' l '00000000') was waiting for the next message to be read.
    Connection to server 'site2' as user 'SID_maint' has been faded out (closed). 
    Connection to server 'site2' as user 'SID_maint' has been faded out (closed). 
    WARNING #7038 RSI USER(GTP_REP_EAST1B) - de/generic/mem/mem.c(2912)
    WARNING: Memory usage is above 80 percent. Increase 'memory_limit' or reduce cache sizes to avoid repserver threads from sleeping due to lack of memory.
    WARNING #7039 DSI EXEC(114(3) site2.SID) - de/generic/mem/mem.c(2912)
    WARNING CANCEL: Memory usage is below 80 percent.
    WARNING #7038 DSI(114 site2.SID) - de/generic/mem/mem.c(2912)
    WARNING: Memory usage is above 80 percent. Increase 'memory_limit' or reduce cache sizes to avoid repserver threads from sleeping due to lack of memory.
    WARNING #7039 SQM(114:0 site2.SID) - de/generic/mem/mem.c(2912)
    WARNING CANCEL: Memory usage is below 80 percent.
    WARNING #7038 DSI(114 site2.SID) - de/generic/mem/mem.c(2912)
    WARNING: Memory usage is above 80 percent. Increase 'memory_limit' or reduce cache sizes to avoid repserver threads from sleeping due to lack of memory.
    WARNING #7039 DSI EXEC(114(3) site2.SID) - de/generic/mem/mem.c(2912)
    WARNING CANCEL: Memory usage is below 80 percent. 
  • admin who outputs show that the affected thread is in memory controlling state:
    22 DSI       Controlling Mem     114 site2.SID
  • admin stats,mem_detail_stats outputs show the affected thread is DSIS:
    admin stats,mem_detail_stats
    go
    Object(State)  Memory_Consumed     Memory_Consumed_Mb  Max_Memory_Consumed_Mb   Avg_Memory_Consumed_Mb   Memory_Threshold_Mb Memory_Ctrl_Time(s)
    -------------- ------------------- ------------------- ------------------------ ------------------------ ------------------- -------------------
    omitted...
    omitted...
    DSIS (Ctrl)    11245474000         10724               13039                    10730                    3266                22659
    DSIE (Norm)    27215408            25                  1075                     40                       4410                0
    Total(Norm)    12199245766         11634               13339                    N/A                      16334               0
  • There can be some large open tran in SQT cache around same time.


Read more...

Environment

SAP Replication Server (SAP SRS) 16.0 SP04 PL01 

Keywords

memory control, hang, DSI, memory_limit, WARNING #7039, WARNING #7038, CR 826327, 826327, CR#826327 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Known Error

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.