JR63347: AN OUT-OF-ORDER PROGRESS MESSAGE SENT FOR POSTGRESQL SOURCE

APAR status

• Closed as program error.

Error description

• IDR CDC for PostgreSQL Source reports an incorrect out-of-order
  progress message.
  
  Event logged: ID=9700 MSG=An internal error
  has occurred. IBM InfoSphere Data Replication (PostgreSQL) will
  continue processing. The error value is "Current bookmark:
  <bookmark> that will be sent in REPORT_POSITION_ID is before
  the previous bookmark: <bookmark> that was sent in
  REPORT_POSITION_ID for subscription <subscription name>. If CDC
  stops shortly after issuing this event, before restarting check
  if the bookmark in the bookmark table equals the previous
  bookmark. If so, refresh all tables, otherwise data loss may
  occur since CDC may think it has replicated farther than it
  actually has."
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you use IDR 11.4.0.3-5587 or    *
  * older for PostgreSQL, and you have more than one             *
  * subscription configured.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The replication engine was not updating the internal         *
  * bookmark correctly, and as a result, it was reserving WAL    *
  * files that were no longer needed for replication.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.3-5590 or newer for PostgreSQL.        *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5590 or newer for PostgreSQL resolves
  this issue.
  

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

  IDR CDC POSTGRE

• Fixed component ID

  5725E30PS

Applicable component levels