Extract Configured For MySQL Abended With Error OGG-00146

(Doc ID 2334549.1)

Last updated on DECEMBER 07, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2.1.0 version, 2 - Non Oracle DB backend

OGG-00146 MySQL cahce contains error

There was no disk space in the server. When the extract process is restarted on mysql side, Extract abends with below error:

2016-01-28 11:10:07 INFO OGG-00993 Oracle GoldenGate Capture for MySQL, extmysql.prm: EXTRACT EXTMYSQL started.
2016-01-28 11:10:07 INFO OGG-01055 Oracle GoldenGate Capture for MySQL, extmysql.prm: Recovery initialization completed for target file /root/mysqlggs/dirdat/my000640, at RBA 1008.
2016-01-28 11:10:07 INFO OGG-01478 Oracle GoldenGate Capture for MySQL, extmysql.prm: Output file /root/mysqlggs/dirdat/my is using format LEVEL 3.
2016-01-28 11:10:07 INFO OGG-01026 Oracle GoldenGate Capture for MySQL, extmysql.prm: Rolling over remote file /root/mysqlggs/dirdat/my000640.
2016-01-28 11:10:07 INFO OGG-01053 Oracle GoldenGate Capture for MySQL, extmysql.prm: Recovery completed for target file /root/mysqlggs/dirdat/my000641, at RBA 1008.
2016-01-28 11:10:07 INFO OGG-01057 Oracle GoldenGate Capture for MySQL, extmysql.prm: Recovery completed for all targets.
2016-01-28 11:10:07 INFO OGG-00182 Oracle GoldenGate Capture for MySQL, extmysql.prm: VAM API running in single-threaded mode.
2016-01-28 11:10:07 INFO OGG-01513 Oracle GoldenGate Capture for MySQL, extmysql.prm: Positioning to Log Number: 2054
  Record Offset: 607043234.
2016-01-28 11:10:07 INFO OGG-01516 Oracle GoldenGate Capture for MySQL, extmysql.prm: Positioned to LogNum - 2054
  Record Offset - 607043234, Jan 22, 2016 1:29:51 PM.
2016-01-28 11:10:08 ERROR OGG-00146 Oracle GoldenGate Capture for MySQL, extmysql.prm: Call to VAMRead returned with error status 600: VAM Client Report WHEN FAILED : While reading event
WHERE FAILED : MySQLBinLog Reader Module
CONTEXT OF FAILURE : No Information Available!>.
2016-01-28 11:10:08 ERROR OGG-01668 Oracle GoldenGate Capture for MySQL, extmysql.prm: PROCESS ABENDING.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms