My Oracle Support Banner

MySQL: ERROR Failed Creating Checkpoint Table GGuser.GGcheckpointTT (Doc ID 2940906.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

While adding a checkpoint table on MySQL side fails with below errors:

[oracle@primary ggmysql]$ ./ggsci

Oracle GoldenGate Command Interpreter for MySQL
Version 19.1.0.0.3 OGGCORE_19.1.0.0.0_PLATFORMS_190907.0144
Linux, x64, 64bit (optimized), MySQL Enterprise on Sep  7 2019 08:41:32
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.

GGSCI (primary.localdomain DBLOGIN as ggate) 3> view param ./GLOBALS

GGSCHEMA gguser

GGSCI (primary.localdomain) 1> dblogin sourcedb <testdb> userid <gguser> password <password>
Successfully logged into database.

GGSCI (primary.localdomain DBLOGIN as gguser) 2> ADD CHECKPOINTTABLE gguser.ggcheckpointTT
ERROR: Failed creating checkpoint table `gguser`.`ggcheckpointTT`.

<NIL>.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.