Informix - Problem description
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) |