Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2018-10-29 15:08:37 INFO OGG-03059 Operating system character set identified as UTF-8.
2018-10-29 15:08:37 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2018-10-29 15:08:37 INFO OGG-03528 The source database character set, as determined from the table definition file, is zhs16gbk.
2018-10-29 15:08:37 WARNING OGG-01187 Duplicate entry encountered for xxx.xx, Reloading definition.
REPLICAT rkfk_cs
sourcedefs /usr/local/ogg/dirdef/defgen1.def OVERRIDE
TARGETDB LIBFILE libggjava.so SET property=dirprm/kafka.props
2018-10-29 15:08:37 INFO OGG-15052 Using Java class path: ggjava/ggjava.jar:ggjava/resources/lib/optional/log4j-1.2.17.jar:ggjava/resources/lib/optional/slf4j-log4j12-1.7.25.jar.
Source Context :
SourceModule : [gglib.ggdal.adapter.java.jni]
SourceID : [/scratch/aime/adestore/views/aime_adc4150324/oggcore/OpenSys/src/gglib/ggdal/Adapter/Java/jni/JNIHelper.cpp]
SourceMethod : [CJavaVM]
SourceLine : [153]
ThreadBacktrace : [17] elements
: [/usr/local/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f7d076c054e]]
: [/usr/local/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x6ac) [0x7f7d076b0d4c]]
: [/usr/local/ogg/libgglog.so(_MSG_(CSourceContext*, int, CMessageFactory::MessageDisposition)+0x2d) [0x7f7d0769a31d]]
: [/usr/local/ogg/libggjava.so(CJavaVM::CJavaVM(bool, CJavaVMOption const&)+0xf5) [0x7f7cfe9ea7f5]]
: [/usr/local/ogg/libggjava.so(CJavaVM::Create(bool, CJavaVMOption const&)+0x54) [0x7f7cfe9ea9d4]]
: [/usr/local/ogg/libggjava.so(ggs::gglib::ggdal::CJavaAdapter::Open()+0x105) [0x7f7cfe9c03a5]]
: [/usr/local/ogg/replicat(ggs::gglib::ggdal::CDALAdapter::Open(ggs::gglib::ggunicode::UString const&)+0x20) [0x81d410]]
: [/usr/local/ogg/replicat(GenericImpl::Open(ggs::gglib::ggunicode::UString const&)+0x2c) [0x8068ec]]
: [/usr/local/ogg/replicat(odbc_param(char*, char*)+0xb1) [0x7fa451]]
: [/usr/local/ogg/replicat(get_infile_params(ggs::gglib::ggapp::ReplicationContextParams&, ggs::gglib::ggdatasource::DataSourceParams&, ggs::gglib::ggdatatarget::DataTargetParams&, ggs::gglib::ggmetadata::MetadataContext&)+0x9878) [0x5cfa68]]
: [/usr/local/ogg/replicat() [0x6d93dd]]
: [/usr/local/ogg/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x5e) [0x7d371e]]
: [/usr/local/ogg/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x173) [0x7d7ae3]]
: [/usr/local/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x140) [0x7d8350]]
: [/usr/local/ogg/replicat(main+0x3b) [0x6dca2b]]
: [/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f7d00dab445]]
: [/usr/local/ogg/replicat(__gxx_personality_v0+0x341) [0x54a409]]
2018-10-29 15:08:37 ERROR OGG-15050 Error loading Java VM runtime library: (2 No such file or directory).
2018-10-29 15:08:37 ERROR OGG-01668 PROCESS ABENDING.
ogg 测试ORACLE 同步到kafka,在同步到某些数据时总会出现 OGG-15050 Error loading Java VM runtime library: (2 No such file or directory). 的错误,而实际上java环境变量都是正常,且前面可以正常开启复制进程的。
看到前面的错误,发现怎么会有 Duplicate entry 的警告。
WARNING OGG-01187 Duplicate entry encountered for xxx.xx, Reloading definition.
【OGG-01187】 | |
Description: | Duplicate entry encountered for {0}, Reloading definition... |
Cause: |
A duplicate entry was found in the definitions file. |
Action: |
Edit the definitions file to remove the duplicate entry. |
于是我将OGG-01187的表先注释掉,重启复制进程,就出现了以下错误。
2018-10-29 17:12:34 ERROR OGG-01668 PROCESS ABENDING.
CACHE OBJECT MANAGER statistics
: [/usr/local/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x140) [0x7d8350]]
: [/usr/local/ogg/replicat(main+0x3b) [0x6dca2b]]
: [/usr/lib64/libc.so.6(__libc_start_main+0xf5) [0x7fb91818d445]]
: [/usr/local/ogg/replicat(__gxx_personality_v0+0x341) [0x54a409]]
2018-10-29 17:12:34 ERROR OGG-01161 Bad column index (74) specified for table xxxxx max columns = 74.
***********************************************************************
* ** Run Time Statistics ** *
看起来表结构定义文件确实有问题,重新生成定义文件再同步到目标端,重启复制进程,问题就解决了。记录一下。