|
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) |
