Symptom
- These warnings would appear frequently in the active SRS in HADR setup, or in the DR SRS HADR setup with third node despite the fact that the configuration parameter 'memory_limit' is set to a very large value:
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 'RDS2' as user 'SID_maint' has been faded out (closed).
WARNING #7038 RSI USER(MYRS) - 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) RDS2.db) - 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 RDS2.db - "admin stats,mem_detail_stats" outputs show the affected thread is DSIS:
Object(State) Memory_Consumed Memory_Consumed_Mb Max_Memory_Consumed_Mb Avg_Memory_Consumed_Mb Memory_Threshold_Mb Memory_Ctrl_Time(s)
-------------- ------------------- ------------------- ------------------------ ------------------------ ------------------- -------------------
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 transactions in the SQT cache around same time.
Read more...
Environment
SAP Replication Server (SAP SRS) 16.0 SP04 PL01
Product
SAP Replication Server 16.0
Keywords
hang, CR826327, 826327, CR#826327, #5245, 5245, Scheduler, stop, populating , 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.