JR65322: IDR FOR MYSQL SOURCE FAILS WITH "COM.DATAMIRROR.TS.ASSERTION.NECESSITYEXCEPTION THE ERROR VALUE IS UNEXPECTED OPCODE X" WHEN TH

APAR status

• Closed as program error.

Error description

• SHAREDSCRAPE LOG PARSER{3130}
  com.datamirror.ts.eventlog.EventLogger
  logActualEvent()              Event logged: ID=2903 MSG=An
  exception has occurred in the log parser. An error occurred
  while parsing the log record  txid:
  com.datamirror.ts.scrapers.MySQLTransactionId@2a1a5c07
  currLogPosition:
  27e1360216df3cb50000000006865f0f000000000589db5500000000
  prevLogPosition:
  27e1360216df3cb50000000006865f0f000000000589db0900000000
  operation: x object id: 0 journal id: 0 tablename: dbname.table
  imageLength: 0 User Name {null} Program name {null} Time in
  milliseconds {1689324731000} Fractional nanoseconds {0}
  CommitCycleId {2463495689}   with commit entry  txid:
  com.datamirror.ts.scrapers.MySQLTransactionId@2a1a5c07
  currLogPosition:
  27e1360216df3cb50000000006865f0f00000000059a57ea00000000
  prevLogPosition:
  27e1360216df3cb50000000006865f0f00000000059a480500000000
  operation: C object id: 0 journal id: 0 tablename: dbname.table
  imageLength: 0 User Name {null} Program name {null} Time in
  milliseconds {1689324731000} Fractional nanoseconds {0}
  CommitCycleId {2463495689}   for table .|Error: The error value
  is "Unexpected opCode x"
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you are using IDR             *
  * 11.4.0.4-5686 or older for MariaDB or for MySQL source.      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Not available                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5693 or newer for MariaDB or for     *
  * MySQL source                                                 *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.4-5693 or newer for MariaDB or 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

  IS DATA REPLICA

• Fixed component ID

  5725E3000

Applicable component levels