RSS does not apply logs
Posted in 2017
hello,
I have the following situation. I would be very pleased if somebody could put
a light into this.
Thanks a lot,
JUAN
Primary: amc1_rss
RSS server: amc4_rss
RSS DeLAY_APPLY 5M
Why does RSS secondary not apply logs up to 116024, having long past the 5
minutes delay configured?
Note that ACKed Log: 116024 Applied Log: 115941, logs in between are all at
LOG_STAGING_DIR directory.Start Log position remains the same (115941 0x5b65278), at both timestamps
00:17:02 and 11:14:14
onstat info:
------------
On the primary:
root@amcdb1:~# onstat -g cluster
IBM Informix Dynamic Server Version 12.10.FC6 -- On-Line (Prim) -- Up 7 days
16:24:14 -- 14906368 Kbytes
Primary Server:amc1_rss
Current Log Page:116024,10190
Index page logging status: Enabled
Index page logging was enabled at: 2013/10/14 14:17:18
Server ACKed Log Applied Log Supports Status
(log, page) (log, page) Updates
amc5_tcp 116024,10190 116024,10190 No ASYNC(HDR),Connected,On
amc4_rss 116024,10190 115941,30719 No ASYNC(RSS),Connected,Active
--------------------------------------------------------
On rss secondary:
root@amcdb4 # onstat -g cluster verbose
IBM Informix Dynamic Server Version 12.10.FC6 -- Read-Only (RSS) -- Up
09:03:05 -- 2199552 Kbytes
RSS Server control block: 0x110931a78
Local server type: RSS
Server Status : Active
Source server name: amc1_rss
Connection status: Connected
Last log page received(log id,page): 115942,1791
Sequence number of last buffer received: 4336
Sequence number of last buffer acked: 4336
Delay Apply: Configured (5)
Stop Apply: Not configured.
Delay or Stop Apply control block: 0x110907f38
Pending pages: 94059
Last page written: (116023:3690).
Next page to read: (115942:1792).
Delay or Stop Apply thread: Running.
-----------------------------------------------------------
server name: amc4_rss
type: ASYNC (RSS)
control block: 0x19d519e40
server status: Active
connection status: Connected
Last log page sent (log id, page): 116024,10318
Last log page acked (log id, page): 116024,10318
Approximate log page backlog: 0
SDS cycle not used
Delayed Apply Set To: 5M
Stop Apply Not Used
Time of last ack: 2017/11/27 09:37:15
Supports Updates: No
--------------------------------------------------------------
onstat -m (on the secondary timestamp 11/27/17 00:16:55)
root@amcdb4 # onstat -m
IBM Informix Dynamic Server Version 12.10.FC6 -- Read-Only (RSS) -- Up
09:18:02 -- 2199552 Kbytes
Message Log File: /u0/informix/LOGS/online.log11/27/17 00:16:55 B-tree scanner index compression level set to med.
11/27/17 00:16:55 Physical Recovery Started at Page (4:48106).
11/27/17 00:16:56 Physical Recovery Complete: 9685 Pages Examined, 9685 Pages
Restored.
11/27/17 00:17:02 smx creates 3 transports to server amc1_rss
11/27/17 00:17:02 Peer node amc1_rss has version 65538
11/27/17 00:17:02 RSS Server amc1_rss - state is now connected
11/27/17 00:17:02 setting version information for amc1_rss 65538
11/27/17 00:17:02 Dataskip is now OFF for all dbspaces
11/27/17 00:17:02 Restartable Restore has been ENABLED
11/27/17 00:17:02 Recovery Mode
11/27/17 00:17:02 Logical Recovery Started.
11/27/17 00:17:02 10 recovery worker threads will be started.
11/27/17 00:17:02 Start Logical Recovery - Start Log 115938, End Log ?
11/27/17 00:17:02 Starting Log Position - 115941 0x5b65278
11/27/17 00:17:02 B-tree scanners disabled.
11/27/17 00:17:03 DR: RSS secondary server operational
11/27/17 00:17:03 Secondary Delay or Stop Apply: Using the directory
/u0/informix/logstg/ifmxlog_4.
11/27/17 00:17:03 A Request to reset the log position to 116019:0 was sent to
the primary server.
11/27/17 00:17:05 Started processing open transactions on secondary during
startup
11/27/17 00:17:05 Finished processing open transactions on secondary during
startup.
------------------------------------------------------------------
onstat -m (on the secondary timestamp: 11/27/17 11:14:12)
root@amcdb4 # onstat -m
IBM Informix Dynamic Server Version 12.10.FC6 -- Read-Only (RSS) -- Up
01:38:40 -- 2199552 Kbytes
Message Log File: /u0/informix/LOGS/online.log
11/27/17 11:14:12 B-tree scanner range scan size set to -1.
11/27/17 11:14:12 B-tree scanner ALICE mode set to 6.11/27/17 11:14:12 B-tree scanner index compression level set to med.
11/27/17 11:14:12 Physical Recovery Started at Page (4:48106).
11/27/17 11:14:12 Physical Recovery Complete: 9685 Pages Examined, 9685 Pages
Restored.
11/27/17 11:14:13 smx creates 3 transports to server amc1_rss
11/27/17 11:14:14 Peer node amc1_rss has version 65538
11/27/17 11:14:14 RSS Server amc1_rss - state is now connected
11/27/17 11:14:14 setting version information for amc1_rss 65538
11/27/17 11:14:14 Dataskip is now OFF for all dbspaces
11/27/17 11:14:14 Restartable Restore has been ENABLED
11/27/17 11:14:14 Recovery Mode
11/27/17 11:14:14 Logical Recovery Started.
11/27/17 11:14:14 10 recovery worker threads will be started.
11/27/17 11:14:14 Start Logical Recovery - Start Log 115938, End Log ?
11/27/17 11:14:14 Starting Log Position - 115941 0x5b65278
11/27/17 11:14:14 B-tree scanners disabled.
11/27/17 11:14:15 DR: RSS secondary server operational
11/27/17 11:14:32 Started processing open transactions on secondary during
startup
11/27/17 11:14:32 Finished processing open transactions on secondary during
startup.