数据库版本:MySQL8.0.38
OGG版本:OGG18
问题描述:
OGG登录数据库的时候提示如下错误:
GGSCI (xxxx) 2> dblogin sourcedb xxs@localhost:3306,userid ogg,password Bai_yun123
Source Context :
SourceModule : [ggdb.mysql.util]
SourceID : [/scratch/aime/adestore/views/aime_adc2280123/oggcore/OpenSys/src/gglib/ggdbmysql/mysqlutil.c]
SourceMethod : [MYSQLUTIL_check_err]
SourceLine : [513]
ThreadBacktrace : [17] elements
: [/data/ogg18/libgglog.so(CMessageContext::AddThreadContext())]
: [/data/ogg18/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/data/ogg18/libgglog.so(_MSG_String_UInt32_String(CSourceContext*, int, char const*, unsigned int, char const*, CMessageFactory::MessageDisposition))]
: [ggsci(MYSQLUTIL_check_err(short, char const*, ...))]
: [ggsci(MYSQLUTIL_get_database_charset())]
: [ggsci(DBUTIL_getDatabaseMetadata(ggs::gglib::ggunicode::UString const*, ggs::gglib::ggapp::CDatabaseMetadata const**, ggs::gglib::ggunicode::UString&))]
: [ggsci(gl_db_login(char const*, char const*, ggs::gglib::ggapp::CDBObjName<(DBObjType)11>&, ggs::gglib::ggapp::CDBObjName<(DBObjType)12>&, short, char (&) [2048]))]
: [ggsci()]
: [ggsci(GGSCIDB_get_command(char const*, char const*, char const*, short, char (&) [2048]))]
: [ggsci(do_cmd(char*, unsigned long, char*, unsigned long))]
: [ggsci()]
: [ggsci(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [ggsci(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [ggsci(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [ggsci(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [ggsci()]
2023-10-13 21:52:21 ERROR OGG-00768 Failed to Map database character to ULibCharSet. SQL error (0).
2023-10-13 21:52:21 ERROR OGG-01668 PROCESS ABENDING.
问题原因
OG for MYSQL, DBLOGIN FAILED WITH ERROR : OGG-00768 Failed To Map Database Character To ULibCharSet. SQL Error (0) (Doc ID 2872177.1)
根据MOS的提示查询数据库字符集与MOS描述一致
mysql> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘accs’;
±---------------------------±-----------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
±---------------------------±-----------------------+
| utf8mb3 | utf8mb3_general_ci |
±---------------------------±-----------------------+
1 row in set (0.01 sec)
问题解决
修复BUG