JR62751: IDR ENCOUNTERED AN UNKNOWN MYSQL LOG EVENT TYPE WHILE READING LATEST BINARY LOG

APAR status

• Closed as program error.

Error description

• IDR for MySQL Source fails with "IBM InfoSphere Data
  Replication has encountered an unknown MySQL log event type"
  whenever IDR is reading a latest binary log event form the
  binary log and the event is not yet fully written to the binary
  log.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you use CDC for MySQL as a      *
  * source engine.                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Subscriptions were ending on error when the log parser could *
  * not fully read an event. Now the engine re-reads the log in  *
  * such situations.                                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5567 or newer for MySQL source
  resolves the 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 MYSQL

• Fixed component ID

  5725E30MY

Applicable component levels