IT33542: CDR CHECK FALSELY REPORTS MISSING ROWS AND HANGS

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