APAR status
Closed as program error.
Error 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.
Local fix
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. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
Temporary fix
Comments
APAR Information
APAR number
IT33542
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-07-14
Closed date
2021-01-28
Last modified date
2021-01-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
Document Information
Modified date:
29 January 2021