Informix - Problem description
Problem IT45413 | Status: Closed |
A PRIMARY & RSS CAN STOP TRANSMITTING DATA AND STATUS SHOWS BLOCKED OR BLOCKLOGXMIT | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
After the RSS has been running for a time, it is possible to see, on the primary, that the buffers are no longer advancing and you will see a status of either Blocked or BlockLogXmit ... An onstat -g rss verbose report will show something like the following ... Local server type: Primary Index page logging status: Enabled Index page logging was enabled at: 2023/10/10 12:41:31 Number of RSS servers: 1 RSS Server information: RSS Server control block: 0x700040000411028 RSS server name: name RSS server status: Active RSS connection status: Connected RSS flow control:0/0 Log transmission status: Blocked Next log page to send(log id,page): 98933,1620 Last log page acked(log id,page): 98926,1658 Last log page applied(log id,page): 98926,1657 Time of Last Acknowledgement: 2024-02-05.16:12:00 Pending Log Pages to be ACKed: 13961 Approximate Log Page Backlog:15077 Sequence number of next buffer to send: 21789 Sequence number of last buffer acked: 15388 Supports Proxy Writes: N Total number of delay(s): 0 Time of last delay: N/A The gap between buffers send and acked will be 6401. or an onstat -g rss report will show something like the following ... RSS Srv RSS Srv Connection Next LPG to send Supports name status status (log id,page) Proxy Writes name BlockLogXmit Connected 98933,1620 N The RSS node needs to be bounced. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC11. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.02.2024 07.06.2024 07.06.2024 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |