OMS 数据迁移失败

OceanBase
#1

【 使用环境 】测试环境
【 OB or 其他组件 】OMS
【 使用版本 】feature 4.2.0
【问题描述】通过oms 迁移数据（源端和目标端都是ob而且是同一个集群），
【复现路径】重启组件 Store 增量拉取组件 后仍提示异常。

【附件及日志】
【OMS迁移页面报错信息】SOURCE_CRAWLER_START_FAILED
为子主题 OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-0 启动增量日志抓取失败。

【store.log】
2024-07-16 16:44:09 (ConnectionManager.cpp:77): default buf size is: 1048576, Msg split size is: 131072, Force Use Encrypt: false, Using ThreadPool true2024-07-16 16:44:09 (ConnectionManager.cpp:139): listen info is: 170012024-07-16 16:44:09 (Epoll.cpp:94): Epoll start, use FD: 102024-07-16 16:44:09 (Epoll.cpp:94): Epoll start, use FD: 11

【congo.log】
2024-07-16 16:44:07 [NOTICE] [StoresManager.cpp:251 11064,1981475008] Create scheduler with file size 16MB, cache 10MB and flush limit 32MB, compressed 2, , read wait number 0, enable index true, read thread number 2, index arena size 2562024-07-16 16:44:09 [NOTICE] [StoreCommandsProcessor.cpp:107 11064,1811113728] Get Request GET /start?subTopic=OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-0&subId=0000000007&store.conf=%2Fhome%2Fds%2Fstore%2Fstore7101%2Fconf%2Fcrawler.conf&master=true HTTP/1.12024-07-16 16:44:09 [NOTICE] [StoreCommandsProcessor.cpp:112 11064,1811113728] Request params: master = true2024-07-16 16:44:09 [NOTICE] [StoreCommandsProcessor.cpp:112 11064,1811113728] Request params: store.conf = /home/ds/store/store7101/conf/crawler.conf2024-07-16 16:44:09 [NOTICE] [StoreCommandsProcessor.cpp:112 11064,1811113728] Request params: subId = 00000000072024-07-16 16:44:09 [NOTICE] [StoreCommandsProcessor.cpp:112 11064,1811113728] Request params: subTopic = OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-02024-07-16 16:44:09 [NOTICE] [StoresManager.cpp:343 11064,1811113728] Starting store OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-0.0000000007 with config /home/ds/store/store7101/conf/crawler.conf2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:561 11064,1811113728] sectionnames size:132024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:577 11064,1811113728] load 0th sectionnames:global2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:config.version value:32024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:running.mode value:strict2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:mysql2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:store2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:577 11064,1811113728] load 3th sectionnames:ob2store2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:collect_ddl value:true2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:dbtype value:oceanbase2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:error.level value:WARN2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:master.binlog value:2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:master.host value:1.1.1.12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:master.offset value:2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:master.port value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:master.timestamp value:17211188442024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:parallelism value:10242024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:pipeline value:reset,read,parse,filter|consume2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:serialize_pool_size value:42024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:subId value:00000000072024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:subTopic value:OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-02024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:topic value:OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:577 11064,1811113728] load 4th sectionnames:store2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:clearer.outdated value:4320002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:clearer.period value:36002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:client.wait value:432002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:connection.numLimit value:10002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:drcnet.threadPoolSize value:22024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:drcnetListenPort value:170012024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:listeningPort value:170002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:queue.forceIndexIter value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:queue.threadPoolSize value:42024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:reader value:on2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:repStatus value:master2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:useThreadPool value:true2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:writer.threshold value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:writer.type value:message2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:577 11064,1811113728] load 5th sectionnames:liboblog2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:cluster_appname value:pre2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:cluster_db_name value:oceanbase2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:cluster_password value:12qwaszx!@QW2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:cluster_url value:http://199.16.3.53:8080/services?Action=ObRootServiceInfo&ObCluster=pre2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:cluster_user value:root2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:enable_output_hidden_primary_key value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:enable_output_invisible_column value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:enable_output_trans_order_by_sql_operation value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:first_start_timestamp value:17211182690002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:history_schema_version_count value:162024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:instance_index value:02024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:instance_num value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:progress_limit_sec_for_ddl value:36002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:region value:ningbo_cn2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:sort_trans_participants value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:target_ob_region value:ningbo2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:tb_white_list value:pre.jiuyang_system.sys_enterprise|pre.jiuyang_system.sys_store2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:timezone value:+08:002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:partition is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:hbase2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:oracle2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:deliver2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:unit is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:db2tostore is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:logproxy2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:823 11064,1811113728] succeed to init record sent log with log.sent.record=0, log.sent.record.users=, log.sent.max.files=502024-07-16 16:44:09 [WARN] [StoreManager.cpp:669 11064,1811113728] Load Rule Library : library Name not found, FilterRule not work2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:1369 11064,1811113728] drcnet server buf size: 10485762024-07-16 16:44:09 [WARN] [StoreManager.cpp:1380 11064,1811113728] drcnet http listen port is 170012024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:1473 11064,1811113728] Store Start use thread pool mode2024-07-16 16:44:09 [NOTICE] [Reader.cpp:128 11064,1501538048] Drc Frame OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-0.0000000007 started2024-07-16 16:44:09 [NOTICE] [StoresManager.cpp:414 11064,1811113728] Store OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-0.0000000007 first start2024-07-16 16:44:09 [NOTICE] [StoresManager.cpp:424 11064,1811113728] Store quota remains 9 out of 10 after start, 1 store instance in memory2024-07-16 16:44:09 [NOTICE] [Reader.cpp:90 11064,1501538048] register module ob2store ok2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: clearer.outdated=>4320002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: clearer.period=>36002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: client.wait=>432002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: connection.numLimit=>10002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: drcnet.threadPoolSize=>22024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: drcnetListenPort=>170012024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: listeningPort=>170002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: queue.forceIndexIter=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: queue.threadPoolSize=>42024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: reader=>on2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: repStatus=>master2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: storesManager.port=>71012024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: useThreadPool=>true2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: writer.threshold=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: writer.type=>message2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: cluster_appname=>pre2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: cluster_db_name=>oceanbase2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: cluster_password=>12qwaszx!@QW2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: cluster_url=>http://199.16.3.53:8080/services?Action=ObRootServiceInfo&ObCluster=pre2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: cluster_user=>root2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: enable_output_hidden_primary_key=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: enable_output_invisible_column=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: enable_output_trans_order_by_sql_operation=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: first_start_timestamp=>17211182690002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: history_schema_version_count=>162024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: instance_index=>02024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: instance_num=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: progress_limit_sec_for_ddl=>36002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: region=>ningbo_cn2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: sort_trans_participants=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: target_ob_region=>ningbo2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: tb_white_list=>pre.jiuyang_system.sys_enterprise|pre.jiuyang_system.sys_store2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: timezone=>+08:002024-07-16 16:44:09 [WARN] [DrcModRunner.cpp:138 11064,1459574528] got empty config for partition2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: collect_ddl=>true2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: dbtype=>oceanbase2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: error.level=>WARN2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: master.binlog=>2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: master.host=>1.1.1.12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: master.offset=>2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: master.port=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: master.timestamp=>17211188442024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: parallelism=>10242024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: pipeline=>reset,read,parse,filter|consume2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: serialize_pool_size=>42024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: subId=>00000000072024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: subTopic=>OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-02024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: topic=>OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: stores.listen.port=>71012024-07-16 16:44:09 [NOTICE] [DrcModRunner.cpp:166 11064,1459574528] pipeline diagnose off2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:285 11064,1459574528] OB Store: start with tm: 1721118844, cp: , safe-timestamp: 17211188442024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:290 11064,1459574528] OB Store: DDL handling: collect2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:293 11064,1459574528] OB Store: liboblog construct2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:304 11064,1459574528] OB Store: liboblog init2024-07-16 16:44:10 [ERROR] [ob2storeMod.cpp:306 11064,1459574528] OB Store: failed to init log from 2024-07-16 16:44:10 [WARN] [DrcModRunner.cpp:195 11064,1459574528] IDrcModule_m::initModule failed

【libobcdc.log】
2024-07-16 16:44:07 [NOTICE] [StoresManager.cpp:251 11064,1981475008] Create scheduler with file size 16MB, cache 10MB and flush limit 32MB, compressed 2, , read wait number 0, enable index true, read thread number 2, index arena size 2562024-07-16 16:44:09 [NOTICE] [StoreCommandsProcessor.cpp:107 11064,1811113728] Get Request GET /start?subTopic=OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-0&subId=0000000007&store.conf=%2Fhome%2Fds%2Fstore%2Fstore7101%2Fconf%2Fcrawler.conf&master=true HTTP/1.12024-07-16 16:44:09 [NOTICE] [StoreCommandsProcessor.cpp:112 11064,1811113728] Request params: master = true2024-07-16 16:44:09 [NOTICE] [StoreCommandsProcessor.cpp:112 11064,1811113728] Request params: store.conf = /home/ds/store/store7101/conf/crawler.conf2024-07-16 16:44:09 [NOTICE] [StoreCommandsProcessor.cpp:112 11064,1811113728] Request params: subId = 00000000072024-07-16 16:44:09 [NOTICE] [StoreCommandsProcessor.cpp:112 11064,1811113728] Request params: subTopic = OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-02024-07-16 16:44:09 [NOTICE] [StoresManager.cpp:343 11064,1811113728] Starting store OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-0.0000000007 with config /home/ds/store/store7101/conf/crawler.conf2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:561 11064,1811113728] sectionnames size:132024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:577 11064,1811113728] load 0th sectionnames:global2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:config.version value:32024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:running.mode value:strict2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:mysql2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:store2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:577 11064,1811113728] load 3th sectionnames:ob2store2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:collect_ddl value:true2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:dbtype value:oceanbase2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:error.level value:WARN2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:master.binlog value:2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:master.host value:1.1.1.12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:master.offset value:2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:master.port value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:master.timestamp value:17211188442024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:parallelism value:10242024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:pipeline value:reset,read,parse,filter|consume2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:serialize_pool_size value:42024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:subId value:00000000072024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:subTopic value:OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-02024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:topic value:OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:577 11064,1811113728] load 4th sectionnames:store2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:clearer.outdated value:4320002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:clearer.period value:36002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:client.wait value:432002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:connection.numLimit value:10002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:drcnet.threadPoolSize value:22024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:drcnetListenPort value:170012024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:listeningPort value:170002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:queue.forceIndexIter value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:queue.threadPoolSize value:42024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:reader value:on2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:repStatus value:master2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:useThreadPool value:true2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:writer.threshold value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:writer.type value:message2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:577 11064,1811113728] load 5th sectionnames:liboblog2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:cluster_appname value:pre2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:cluster_db_name value:oceanbase2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:cluster_password value:12qwaszx!@QW2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:cluster_url value:http://199.16.3.53:8080/services?Action=ObRootServiceInfo&ObCluster=pre2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:cluster_user value:root2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:enable_output_hidden_primary_key value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:enable_output_invisible_column value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:enable_output_trans_order_by_sql_operation value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:first_start_timestamp value:17211182690002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:history_schema_version_count value:162024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:instance_index value:02024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:instance_num value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:progress_limit_sec_for_ddl value:36002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:region value:ningbo_cn2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:sort_trans_participants value:12024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:target_ob_region value:ningbo2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:tb_white_list value:pre.jiuyang_system.sys_enterprise|pre.jiuyang_system.sys_store2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:581 11064,1811113728] load config key:timezone value:+08:002024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:partition is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:hbase2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:oracle2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:deliver2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:unit is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:db2tostore is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:567 11064,1811113728] Config of sectionnames:logproxy2store is empty2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:823 11064,1811113728] succeed to init record sent log with log.sent.record=0, log.sent.record.users=, log.sent.max.files=502024-07-16 16:44:09 [WARN] [StoreManager.cpp:669 11064,1811113728] Load Rule Library : library Name not found, FilterRule not work2024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:1369 11064,1811113728] drcnet server buf size: 10485762024-07-16 16:44:09 [WARN] [StoreManager.cpp:1380 11064,1811113728] drcnet http listen port is 170012024-07-16 16:44:09 [NOTICE] [StoreManager.cpp:1473 11064,1811113728] Store Start use thread pool mode2024-07-16 16:44:09 [NOTICE] [Reader.cpp:128 11064,1501538048] Drc Frame OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-0.0000000007 started2024-07-16 16:44:09 [NOTICE] [StoresManager.cpp:414 11064,1811113728] Store OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-0.0000000007 first start2024-07-16 16:44:09 [NOTICE] [StoresManager.cpp:424 11064,1811113728] Store quota remains 9 out of 10 after start, 1 store instance in memory2024-07-16 16:44:09 [NOTICE] [Reader.cpp:90 11064,1501538048] register module ob2store ok2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: clearer.outdated=>4320002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: clearer.period=>36002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: client.wait=>432002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: connection.numLimit=>10002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: drcnet.threadPoolSize=>22024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: drcnetListenPort=>170012024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: listeningPort=>170002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: queue.forceIndexIter=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: queue.threadPoolSize=>42024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: reader=>on2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: repStatus=>master2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: storesManager.port=>71012024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: useThreadPool=>true2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: writer.threshold=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: writer.type=>message2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: cluster_appname=>pre2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: cluster_db_name=>oceanbase2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: cluster_password=>12qwaszx!@QW2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: cluster_url=>http://199.16.3.53:8080/services?Action=ObRootServiceInfo&ObCluster=pre2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: cluster_user=>root2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: enable_output_hidden_primary_key=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: enable_output_invisible_column=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: enable_output_trans_order_by_sql_operation=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: first_start_timestamp=>17211182690002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: history_schema_version_count=>162024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: instance_index=>02024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: instance_num=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: progress_limit_sec_for_ddl=>36002024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: region=>ningbo_cn2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: sort_trans_participants=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: target_ob_region=>ningbo2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: tb_white_list=>pre.jiuyang_system.sys_enterprise|pre.jiuyang_system.sys_store2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: timezone=>+08:002024-07-16 16:44:09 [WARN] [DrcModRunner.cpp:138 11064,1459574528] got empty config for partition2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: collect_ddl=>true2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: dbtype=>oceanbase2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: error.level=>WARN2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: master.binlog=>2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: master.host=>1.1.1.12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: master.offset=>2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: master.port=>12024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: master.timestamp=>17211188442024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: parallelism=>10242024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: pipeline=>reset,read,parse,filter|consume2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: serialize_pool_size=>42024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: subId=>00000000072024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: subTopic=>OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk-1-02024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: topic=>OB_MYSQL_np_5wo9bihnd04g_5wo9gpcwx8jk2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:100 11064,1459574528] OB Store: config ob2store: stores.listen.port=>71012024-07-16 16:44:09 [NOTICE] [DrcModRunner.cpp:166 11064,1459574528] pipeline diagnose off2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:285 11064,1459574528] OB Store: start with tm: 1721118844, cp: , safe-timestamp: 17211188442024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:290 11064,1459574528] OB Store: DDL handling: collect2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:293 11064,1459574528] OB Store: liboblog construct2024-07-16 16:44:09 [NOTICE] [ob2storeMod.cpp:304 11064,1459574528] OB Store: liboblog init2024-07-16 16:44:10 [ERROR] [ob2storeMod.cpp:306 11064,1459574528] OB Store: failed to init log from 2024-07-16 16:44:10 [WARN] [DrcModRunner.cpp:195 11064,1459574528] IDrcModule_m::initModule failed

#3

你查看一下 组件监控

image
image1138×229 72.1 KB

#4

image
image2908×1778 229 KB

#5

OMS 版本是否是4.2.0 ce，如果是不要使用这个版本了，官网已经下掉了，请使用OMS最新版4.2.4 CE 测试

#6

image
image924×292 2.84 KB

之前官方给的企业版的oms

#7

oms.feature_4.2.0.202308171500.tar.gz

#8

这个oms 之前部署起来同步是没问题的。两个ob集群数据迁移。现在是同一个ob 集群不同数据库 内数据迁移。
重启了oms 也没用。

#9

你好，你提的这个技术问题牵涉到OceanBase企业版范围内的功能细节；针对此类问题，建议你通过以下方式寻求帮助：

  1. 如你所在的企业客户已签署OceanBase企业版销售合同，请你联系客户经理；
  2. 如你所在的企业客户尚未签署OceanBase企业版销售合同，你可通过OceanBase官网商务咨询页面留下你的联系方式，OceanBase企业版的业务顾问会在一个工作日内与你联系。
    另外，我们欢迎你使用社区版，并在论坛/社群中分享你对社区版本的想法、经验和问题，与其他社区成员共同交流。
#10

已重装 社区版4.2.4-ce，问题解决。

#11

社区版ob需要使用社区版的oms，不可以混用商业版的oms