The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Oracle GoldenGate cannot Extract Mariadb 10.2.9 binlog to Oracle 12c

Dear

I use OGG 12c for CDC of MySQL 5.5.6 source to Oracle target It worked well. But I configure for MariaDB 10.2.9 source to Oracle taget with same config (binlog_format=ROW). The Extract raised Error: ---> ERROR OGG-00146 Oracle GoldenGate Capture for MySQL, ecdc_bde.prm: Call to VAMControl returned with error status 600: VAM Client Report <CAUSE OF FAILURE : Sanity Check Failed for events WHEN FAILED : While reading log event from binary log WHERE FAILED : MySQLBinLog Reader Module CONTEXT OF FAILURE : No Information Available!>. ERROR OGG-01668 Oracle GoldenGate Capture for MySQL, ecdc_bde.prm: PROCESS ABENDING. <---

Maybe, MariaDB's binlog change campared MySQL 5.5.6.

Have you ever face this issue and any solution to fix it. Plz share to me. Thank you!

Answer Answered by Chris Calender in this comment.

To be clear, you should have all of the following set:

log-bin
binlog-format=ROW
binlog-row-image=FULL
binlog-annotate-row-events=OFF
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.