|
Problem IT33542
|
Status: Closed |
CDR CHECK FALSELY REPORTS MISSING ROWS AND HANGS
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
When running "cdr check repl -R" on certain replicates, it
falsely reports missing rows:
(14:59:07)-(informix)-(533)-> cdr check repl -R -r
tmplt_stores_gr_kingston_tab1 -m gr_kingston gr_budapest
Jul 06 2020 14:59:12 ------ Table scan for
tmplt_stores_gr_kingston_tab1 start --------
WARNING:node gr_kingston for tmplt_stores_gr_kingston_tab1 is
sendonly.
Skipping evaluation of all other sendonly nodes
Check contains send only nodes*
Node Rows Extra Missing Mismatch
Processed
---------------- --------- --------- --------- ---------
---------
gr_kingston* 778696 0 0 0
414
gr_budapest 778696 0 414 392
392
The repair operation completed. Validating the repaired rows ...
Validation of repaired rows failed.
WARNING: replicate is not in sync
Jul 06 2020 15:11:11 ------ Table scan for
tmplt_stores_gr_kingston_tab1 end ---------
command failed -- WARNING: replicate is not in sync (178)
Eventually facing cdr error 213 is also a possibility:
CDR operation check replset
'tmplt_stores_gr_kingston_tab1' failed: Set is out of sync
gr_kingston:681 N 2020-07-02 07:42:22 213
Changing the replicate to an update-anywhere fixes the problem,
if acceptable. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When running "cdr check repl -R" on certain replicates, it *
* falsely reports missing rows: *
* *
* (14:59:07)-(informix)-(533)-> cdr check repl -R -r *
* tmplt_stores_gr_kingston_tab1 -m gr_kingston gr_budapest *
* *
* Jul 06 2020 14:59:12 ------ Table scan for *
* tmplt_stores_gr_kingston_tab1 start -------- *
* *
* WARNING:node gr_kingston for tmplt_stores_gr_kingston_tab1 *
* is *
* sendonly. *
* *
* Skipping evaluation of all other sendonly nodes *
* *
* Check contains send only nodes* *
* *
* Node Rows Extra Missing Mismatch *
* Processed *
* ---------------- --------- --------- --------- --------- *
* --------- *
* gr_kingston* 778696 0 0 0 *
* 414 *
* gr_budapest 778696 0 414 392 *
* 392 *
* *
* The repair operation completed. Validating the repaired rows *
* ... *
* Validation of repaired rows failed. *
* WARNING: replicate is not in sync *
* *
* Jul 06 2020 15:11:11 ------ Table scan for *
* tmplt_stores_gr_kingston_tab1 end --------- *
* *
* command failed -- WARNING: replicate is not in sync (178) *
* *
* Eventually facing cdr error 213 is also a possibility: *
* CDR operation check replset *
* 'tmplt_stores_gr_kingston_tab1' failed: Set is out of sync *
* *
* gr_kingston:681 N 2020-07-02 07:42:22 213 *
* *
* *
* Changing the replicate to an update-anywhere fixes the *
* problem, *
* if acceptable. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC5. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When running "cdr check repl -R" on certain replicates, it *
* falsely reports missing rows: *
* *
* (14:59:07)-(informix)-(533)-> cdr check repl -R -r *
* tmplt_stores_gr_kingston_tab1 -m gr_kingston gr_budapest *
* *
* Jul 06 2020 14:59:12 ------ Table scan for *
* tmplt_stores_gr_kingston_tab1 start -------- *
* *
* WARNING:node gr_kingston for tmplt_stores_gr_kingston_tab1 *
* is *
* sendonly. *
* *
* Skipping evaluation of all other sendonly nodes *
* *
* Check contains send only nodes* *
* *
* Node Rows Extra Missing Mismatch *
* Processed *
* ---------------- --------- --------- --------- --------- *
* --------- *
* gr_kingston* 778696 0 0 0 *
* 414 *
* gr_budapest 778696 0 414 392 *
* 392 *
* *
* The repair operation completed. Validating the repaired rows *
* ... *
* Validation of repaired rows failed. *
* WARNING: replicate is not in sync *
* *
* Jul 06 2020 15:11:11 ------ Table scan for *
* tmplt_stores_gr_kingston_tab1 end --------- *
* *
* command failed -- WARNING: replicate is not in sync (178) *
* *
* Eventually facing cdr error 213 is also a possibility: *
* CDR operation check replset *
* 'tmplt_stores_gr_kingston_tab1' failed: Set is out of sync *
* *
* gr_kingston:681 N 2020-07-02 07:42:22 213 *
* *
* *
* Changing the replicate to an update-anywhere fixes the *
* problem, *
* if acceptable. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC5. *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.07.2020
28.01.2021
28.01.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
