【环境】
CentOS 7.9
MySQL 8.0
GoldenGate 19.1.0.0.3
【问题】
执行命令“./defgen paramfile ./dirprm/defgen.prm”,报错如下:
Source Context :
SourceModule : [ggdb.mysql.util]
SourceID : [../gglib/ggdbmysql/mysqlutil.c]
SourceMethod : [MYSQLUTIL_check_err]
SourceLine : [560]
ThreadBacktrace : [15] elements
: [/ogg/libgglog.so(CMessageContext::AddThreadContext())]
: [/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/ogg/libgglog.so(_MSG_String_UInt32_String(CSourceContext*, int, char const*, unsigned int, char const*, CMessageFactory::MessageDisposition))]
: [./defgen(MYSQLUTIL_check_err(short, char const*, ...))]
: [./defgen(MYSQLUTIL_get_database_charset())]
: [./defgen(DBUTIL_getDatabaseMetadata(ggs::gglib::ggunicode::UString const*, ggs::gglib::ggapp::CDatabaseMetadata const**, ggs::gglib::ggunicode::UString&))]
: [./defgen(gl_odbc_param(char const*, char const*, char (&) [2048]))]
: [./defgen(get_infile_params())]
: [./defgen()]
: [./defgen(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [./defgen(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [./defgen(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [./defgen(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [./defgen()]
2021-12-09 09:28:24 ERROR OGG-00768 Failed to Map database character to ULibCharSet. SQL error (0).
2021-12-09 09:28:24 ERROR OGG-01668 PROCESS ABENDING.
mysql> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'mytestdb';
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8 | utf8_general_ci |
+----------------------------+------------------------+
1 row in set (0.01 sec)
根据文章 (Doc ID 2283833.1)的描述,OGG 19.1 应该是支持 utf8的,为什么还会报这个错?