Informix - Problem description
Problem IT35093 | Status: Closed |
ONSTAT -G DRI ON HDR SECONDARY SHOWS LAST LOG PAGE APPLIED 0,0 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
onstat -g dri output shows correctly in the primary node: IBM Informix Dynamic Server Version 12.10.FC14AEE -- On-Line (Prim) -- Up 5 days 00:58:43 -- 199348 Kbytes Data Replication at 0x47427028: Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes primary on sao_eas_tcp 22 / 3484 NA DRINTERVAL 0 DRTIMEOUT 30 HDR_TXN_SCOPE NEAR_SYNC DRAUTO 0 DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound DRIDXAUTO 0 ENCRYPT_HDR 0 Backlog 0 Last Send 2020/11/30 14:37:55 Last Receive 2020/11/30 14:37:55 Last Ping 2020/11/30 14:37:28 Last log page applied(log id,page): 23,2792 But it shows zeroed in the secondary node: IBM Informix Dynamic Server Version 12.10.FC14AEE -- Read-Only (Sec) -- Up 5 days 00:57:38 -- 191156 Kbytes Data Replication at 0x47427028: Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes HDR Secondary on rio_eas_tcp 22 / 3484 N DRINTERVAL 0 DRTIMEOUT 30 HDR_TXN_SCOPE NEAR_SYNC DRAUTO 0 DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound DRIDXAUTO 0 ENCRYPT_HDR 0 Backlog 0 Last Send 2020/11/30 14:37:51 Last Receive 2020/11/30 14:37:51 Last Ping 2020/11/30 14:37:27 Last log page applied(log id,page): 0,0 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * onstat -g dri output shows correctly in the primary node: * * * * IBM Informix Dynamic Server Version 12.10.FC14AEE -- On-Line * * (Prim) -- Up 5 days 00:58:43 -- 199348 Kbytes * * * * Data Replication at 0x47427028: * * Type State Paired server Last DR * * CKPT * * (id/pg) Supports Proxy Writes * * primary on sao_eas_tcp * * 22 / * * 3484 NA * * * * DRINTERVAL 0 * * DRTIMEOUT 30 * * HDR_TXN_SCOPE NEAR_SYNC * * DRAUTO 0 * * DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound * * DRIDXAUTO 0 * * ENCRYPT_HDR 0 * * Backlog 0 * * Last Send 2020/11/30 14:37:55 * * Last Receive 2020/11/30 14:37:55 * * Last Ping 2020/11/30 14:37:28 * * Last log page applied(log id,page): 23,2792 * * * * But it shows zeroed in the secondary node: * * IBM Informix Dynamic Server Version 12.10.FC14AEE -- * * Read-Only * * (Sec) -- Up 5 days 00:57:38 -- 191156 Kbytes * * * * Data Replication at 0x47427028: * * Type State Paired server Last DR * * CKPT * * (id/pg) Supports Proxy Writes * * HDR Secondary on rio_eas_tcp * * 22 / * * 3484 N * * * * DRINTERVAL 0 * * DRTIMEOUT 30 * * HDR_TXN_SCOPE NEAR_SYNC * * DRAUTO 0 * * DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound * * DRIDXAUTO 0 * * ENCRYPT_HDR 0 * * Backlog 0 * * Last Send 2020/11/30 14:37:51 * * Last Receive 2020/11/30 14:37:51 * * Last Ping 2020/11/30 14:37:27 * * Last log page applied(log id,page): 0,0 * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * onstat -g dri output shows correctly in the primary node: * * * * IBM Informix Dynamic Server Version 12.10.FC14AEE -- On-Line * * (Prim) -- Up 5 days 00:58:43 -- 199348 Kbytes * * * * Data Replication at 0x47427028: * * Type State Paired server Last DR * * CKPT * * (id/pg) Supports Proxy Writes * * primary on sao_eas_tcp * * 22 / * * 3484 NA * * * * DRINTERVAL 0 * * DRTIMEOUT 30 * * HDR_TXN_SCOPE NEAR_SYNC * * DRAUTO 0 * * DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound * * DRIDXAUTO 0 * * ENCRYPT_HDR 0 * * Backlog 0 * * Last Send 2020/11/30 14:37:55 * * Last Receive 2020/11/30 14:37:55 * * Last Ping 2020/11/30 14:37:28 * * Last log page applied(log id,page): 23,2792 * * * * But it shows zeroed in the secondary node: * * IBM Informix Dynamic Server Version 12.10.FC14AEE -- * * Read-Only * * (Sec) -- Up 5 days 00:57:38 -- 191156 Kbytes * * * * Data Replication at 0x47427028: * * Type State Paired server Last DR * * CKPT * * (id/pg) Supports Proxy Writes * * HDR Secondary on rio_eas_tcp * * 22 / * * 3484 N * * * * DRINTERVAL 0 * * DRTIMEOUT 30 * * HDR_TXN_SCOPE NEAR_SYNC * * DRAUTO 0 * * DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound * * DRIDXAUTO 0 * * ENCRYPT_HDR 0 * * Backlog 0 * * Last Send 2020/11/30 14:37:51 * * Last Receive 2020/11/30 14:37:51 * * Last Ping 2020/11/30 14:37:27 * * Last log page applied(log id,page): 0,0 * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC6. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.11.2020 25.01.2021 25.01.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |