[2025-05-15 16:39:24.432] [DEBUG] - cmd: ['obbinlog'] [2025-05-15 16:39:24.433] [DEBUG] - opts: {'servers': None, 'components': None, 'force_delete': None, 'strict_check': None, 'without_parameter': None} [2025-05-15 16:39:24.433] [DEBUG] - mkdir /root/.obd/lock/ [2025-05-15 16:39:24.433] [DEBUG] - unknown lock mode [2025-05-15 16:39:24.433] [DEBUG] - try to get share lock /root/.obd/lock/global [2025-05-15 16:39:24.433] [DEBUG] - share lock `/root/.obd/lock/global`, count 1 [2025-05-15 16:39:24.433] [DEBUG] - Get Deploy by name [2025-05-15 16:39:24.433] [DEBUG] - mkdir /root/.obd/cluster/ [2025-05-15 16:39:24.434] [DEBUG] - mkdir /root/.obd/config_parser/ [2025-05-15 16:39:24.434] [DEBUG] - try to get exclusive lock /root/.obd/lock/deploy_obbinlog [2025-05-15 16:39:24.434] [DEBUG] - exclusive lock `/root/.obd/lock/deploy_obbinlog`, count 1 [2025-05-15 16:39:24.439] [DEBUG] - Deploy status judge [2025-05-15 16:39:24.439] [INFO] Get local repositories [2025-05-15 16:39:24.440] [DEBUG] - mkdir /root/.obd/repository [2025-05-15 16:39:24.440] [DEBUG] - Get local repository obbinlog-ce-4.2.4-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:24.440] [DEBUG] - Search repository obbinlog-ce version: 4.2.4, tag: e9e55042fa2c72707653a31d354f64a3161e8cd6, release: None, package_hash: None [2025-05-15 16:39:24.440] [DEBUG] - try to get share lock /root/.obd/lock/mirror_and_repo [2025-05-15 16:39:24.440] [DEBUG] - share lock `/root/.obd/lock/mirror_and_repo`, count 1 [2025-05-15 16:39:24.441] [DEBUG] - mkdir /root/.obd/repository/obbinlog-ce [2025-05-15 16:39:24.443] [DEBUG] - Found repository obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:24.570] [DEBUG] - Get deploy config [2025-05-15 16:39:24.579] [INFO] Load cluster param plugin [2025-05-15 16:39:24.579] [DEBUG] - Get local repository obbinlog-ce-4.2.4-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:24.579] [DEBUG] - Searching param plugin for components ... [2025-05-15 16:39:24.579] [DEBUG] - Search param plugin for obbinlog-ce [2025-05-15 16:39:24.580] [DEBUG] - mkdir /root/.obd/plugins [2025-05-15 16:39:24.580] [DEBUG] - Found for obbinlog-ce-param-4.0.1 for obbinlog-ce-4.2.4 [2025-05-15 16:39:24.580] [DEBUG] - Applying obbinlog-ce-param-4.0.1 for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:24.711] [INFO] Open ssh connection [2025-05-15 16:39:24.716] [DEBUG] - host: 192.168.10.64, port: 22, user: root, password: ****** [2025-05-15 16:39:24.847] [DEBUG] - Searching start_check template for components ... [2025-05-15 16:39:24.847] [DEBUG] - mkdir /root/.obd/workflows [2025-05-15 16:39:24.848] [DEBUG] - Call workflow obbinlog-ce-py_script_workflow_start_check-4.0.1 for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:24.848] [DEBUG] - mkdir /root/.obd/mirror [2025-05-15 16:39:24.848] [DEBUG] - mkdir /root/.obd/mirror/remote [2025-05-15 16:39:24.848] [DEBUG] - mkdir /root/.obd/mirror/local [2025-05-15 16:39:24.849] [DEBUG] - mkdir /root/.obd/optimize/ [2025-05-15 16:39:24.849] [DEBUG] - mkdir /root/.obd/tool/ [2025-05-15 16:39:24.849] [DEBUG] - import start_check [2025-05-15 16:39:24.849] [DEBUG] - add start_check ref count to 1 [2025-05-15 16:39:24.850] [DEBUG] - sub start_check ref count to 0 [2025-05-15 16:39:24.850] [DEBUG] - export start_check [2025-05-15 16:39:24.850] [DEBUG] - plugin obbinlog-ce-py_script_workflow_start_check-4.0.1 result: True [2025-05-15 16:39:24.850] [DEBUG] - Found for obbinlog-ce-py_script_workflow_start_check-4.0.1 for obbinlog-ce-4.0.1 [2025-05-15 16:39:24.850] [DEBUG] - share lock `/root/.obd/lock/mirror_and_repo`, count 2 [2025-05-15 16:39:24.852] [DEBUG] - Searching start_check plugin for components ... [2025-05-15 16:39:24.852] [DEBUG] - Searching start_check plugin for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:24.853] [DEBUG] - Found for obbinlog-ce-py_script_start_check-4.0.1 for obbinlog-ce-4.2.4 [2025-05-15 16:39:24.853] [DEBUG] - Call plugin obbinlog-ce-py_script_start_check-4.0.1 for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:24.853] [DEBUG] - import start_check [2025-05-15 16:39:24.855] [DEBUG] - add start_check ref count to 1 [2025-05-15 16:39:24.855] [DEBUG] -- oceanbase version check [2025-05-15 16:39:24.856] [DEBUG] -- root@192.168.10.64 execute: cat /data/obbinlog/run/obbinlog-ce-192.168.10.64-2983.pid [2025-05-15 16:39:24.872] [DEBUG] -- exited code 1, error output: [2025-05-15 16:39:24.872] [DEBUG] cat: /data/obbinlog/run/obbinlog-ce-192.168.10.64-2983.pid: No such file or directory [2025-05-15 16:39:24.872] [DEBUG] [2025-05-15 16:39:24.872] [DEBUG] -- server1(192.168.10.64) port check [2025-05-15 16:39:24.872] [DEBUG] -- root@192.168.10.64 execute: bash -c 'cat /proc/net/{tcp*,udp*}' | awk -F' ' '{if($4=="0A") print $2,$4,$10}' | grep ':0BA7' | awk -F' ' '{print $3}' | uniq [2025-05-15 16:39:24.934] [DEBUG] -- exited code 0 [2025-05-15 16:39:24.934] [DEBUG] -- root@192.168.10.64 execute: bash -c 'cat /proc/net/{tcp*,udp*}' | awk -F' ' '{if($4=="0A") print $2,$4,$10}' | grep ':0BA8' | awk -F' ' '{print $3}' | uniq [2025-05-15 16:39:24.956] [DEBUG] -- exited code 0 [2025-05-15 16:39:24.956] [DEBUG] - sub start_check ref count to 0 [2025-05-15 16:39:24.956] [DEBUG] - export start_check [2025-05-15 16:39:24.956] [DEBUG] - plugin obbinlog-ce-py_script_start_check-4.0.1 result: True [2025-05-15 16:39:24.956] [DEBUG] - Searching start template for components ... [2025-05-15 16:39:24.957] [DEBUG] - Call workflow obbinlog-ce-py_script_workflow_start-4.0.1 for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:24.957] [DEBUG] - import start [2025-05-15 16:39:24.958] [DEBUG] - add start ref count to 1 [2025-05-15 16:39:24.958] [DEBUG] - sub start ref count to 0 [2025-05-15 16:39:24.958] [DEBUG] - export start [2025-05-15 16:39:24.958] [DEBUG] - plugin obbinlog-ce-py_script_workflow_start-4.0.1 result: True [2025-05-15 16:39:24.958] [DEBUG] - Found for obbinlog-ce-py_script_workflow_start-4.0.1 for obbinlog-ce-4.0.1 [2025-05-15 16:39:24.958] [DEBUG] - Searching parameter_pre plugin for components ... [2025-05-15 16:39:24.958] [DEBUG] - Searching parameter_pre plugin for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:24.959] [DEBUG] - Found for obbinlog-ce-py_script_parameter_pre-4.0.1 for obbinlog-ce-4.2.4 [2025-05-15 16:39:24.959] [DEBUG] - Call plugin obbinlog-ce-py_script_parameter_pre-4.0.1 for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:24.959] [DEBUG] - import parameter_pre [2025-05-15 16:39:24.960] [DEBUG] - add parameter_pre ref count to 1 [2025-05-15 16:39:24.961] [DEBUG] -- root@192.168.10.64 export LD_LIBRARY_PATH='/data/obbinlog/lib' [2025-05-15 16:39:24.961] [DEBUG] -- root@192.168.10.64 execute: /data/obbinlog/bin/logproxy -x root [2025-05-15 16:39:24.976] [DEBUG] -- exited code 127, error output: [2025-05-15 16:39:24.976] [DEBUG] /data/obbinlog/bin/logproxy: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory [2025-05-15 16:39:24.976] [DEBUG] [2025-05-15 16:39:24.976] [DEBUG] -- root@192.168.10.64 delete env LD_LIBRARY_PATH [2025-05-15 16:39:24.977] [DEBUG] -- write { [2025-05-15 16:39:24.977] [DEBUG] "service_port": 2983, [2025-05-15 16:39:24.978] [DEBUG] "encode_threadpool_size": 8, [2025-05-15 16:39:24.978] [DEBUG] "encode_queue_size": 20000, [2025-05-15 16:39:24.978] [DEBUG] "max_packet_bytes": 67108864, [2025-05-15 16:39:24.978] [DEBUG] "record_queue_size": 20000, [2025-05-15 16:39:24.978] [DEBUG] "read_timeout_us": 2000000, [2025-05-15 16:39:24.978] [DEBUG] "read_fail_interval_us": 1000000, [2025-05-15 16:39:24.978] [DEBUG] "read_wait_num": 20000, [2025-05-15 16:39:24.978] [DEBUG] "send_timeout_us": 2000000, [2025-05-15 16:39:24.978] [DEBUG] "send_fail_interval_us": 1000000, [2025-05-15 16:39:24.978] [DEBUG] "check_quota_enable": false, [2025-05-15 16:39:24.978] [DEBUG] "check_clog_enable": true, [2025-05-15 16:39:24.978] [DEBUG] "command_timeout_s": 10, [2025-05-15 16:39:24.978] [DEBUG] "log_quota_size_mb": 5120, [2025-05-15 16:39:24.978] [DEBUG] "log_quota_day": 7, [2025-05-15 16:39:24.978] [DEBUG] "log_gc_interval_s": 43200, [2025-05-15 16:39:24.978] [DEBUG] "log_level": 2, [2025-05-15 16:39:24.978] [DEBUG] "loh_flush_strategy": 1, [2025-05-15 16:39:24.978] [DEBUG] "log_flush_level": 2, [2025-05-15 16:39:24.978] [DEBUG] "log_flush_period_s": 1, [2025-05-15 16:39:24.978] [DEBUG] "log_max_file_size_mb": 1024, [2025-05-15 16:39:24.978] [DEBUG] "log_retention_h": 360, [2025-05-15 16:39:24.978] [DEBUG] "oblogreader_path_retain_hour": 168, [2025-05-15 16:39:24.978] [DEBUG] "oblogreader_lease_s": 300, [2025-05-15 16:39:24.978] [DEBUG] "oblogreader_path": "/data/obbinlog/run", [2025-05-15 16:39:24.978] [DEBUG] "bin_path": "/data/obbinlog/bin", [2025-05-15 16:39:24.978] [DEBUG] "oblogreader_timezone_conf": "../../conf/timezone_info.conf", [2025-05-15 16:39:24.978] [DEBUG] "oblogreader_obcdc_path_template": "../../obcdc/obcdc-%s.x-access/libobcdcaccess.so", [2025-05-15 16:39:24.978] [DEBUG] "oblogreader_obcdc_ce_path_template": "/data/obbinlog/obcdc/obcdc-ce-%s.x-access/libobcdcaccess.so", [2025-05-15 16:39:24.978] [DEBUG] "allow_all_tenant": true, [2025-05-15 16:39:24.978] [DEBUG] "auth_user": true, [2025-05-15 16:39:24.978] [DEBUG] "auth_use_rs": false, [2025-05-15 16:39:24.978] [DEBUG] "auth_allow_sys_user": true, [2025-05-15 16:39:24.978] [DEBUG] "ob_sys_username": "", [2025-05-15 16:39:24.979] [DEBUG] "ob_sys_password": "******", [2025-05-15 16:39:24.979] [DEBUG] "counter_interval_s": 2, [2025-05-15 16:39:24.979] [DEBUG] "metric_enable": true, [2025-05-15 16:39:24.979] [DEBUG] "metric_interval_s": 10, [2025-05-15 16:39:24.979] [DEBUG] "prometheus_port": 2984, [2025-05-15 16:39:24.979] [DEBUG] "debug": false, [2025-05-15 16:39:24.979] [DEBUG] "verbose": false, [2025-05-15 16:39:24.979] [DEBUG] "verbose_packet": false, [2025-05-15 16:39:24.979] [DEBUG] "verbose_record_read": false, [2025-05-15 16:39:24.979] [DEBUG] "readonly": false, [2025-05-15 16:39:24.979] [DEBUG] "count_record": false, [2025-05-15 16:39:24.979] [DEBUG] "channel_type": "plain", [2025-05-15 16:39:24.979] [DEBUG] "tls_ca_cert_file": "", [2025-05-15 16:39:24.979] [DEBUG] "tls_cert_file": "", [2025-05-15 16:39:24.979] [DEBUG] "tls_key_file": "", [2025-05-15 16:39:24.979] [DEBUG] "tls_verify_peer": true, [2025-05-15 16:39:24.979] [DEBUG] "liboblog_tls": false, [2025-05-15 16:39:24.979] [DEBUG] "liboblog_tls_cert_path": "", [2025-05-15 16:39:24.979] [DEBUG] "binlog_log_bin_basename": "/data/obbinlog/run", [2025-05-15 16:39:24.979] [DEBUG] "binlog_timezone_conf": "../../conf/timezone_info.conf", [2025-05-15 16:39:24.979] [DEBUG] "binlog_obcdc_path_template": "../../obcdc/obcdc-%s.x-access/libobcdcaccess.so", [2025-05-15 16:39:24.979] [DEBUG] "binlog_obcdc_ce_path_template": "/data/obbinlog/obcdc/obcdc-ce-%s.x-access/libobcdcaccess.so", [2025-05-15 16:39:24.979] [DEBUG] "binlog_ignore_unsupported_event": true, [2025-05-15 16:39:24.979] [DEBUG] "binlog_max_event_buffer_bytes": 67108864, [2025-05-15 16:39:24.979] [DEBUG] "binlog_mode": true, [2025-05-15 16:39:24.979] [DEBUG] "table_whitelist": "", [2025-05-15 16:39:24.979] [DEBUG] "binlog_nof_work_threads": 16, [2025-05-15 16:39:24.979] [DEBUG] "binlog_bc_work_threads": 2, [2025-05-15 16:39:24.979] [DEBUG] "binlog_sql_work_threads": 4, [2025-05-15 16:39:24.979] [DEBUG] "binlog_max_file_size_bytes": 536870912, [2025-05-15 16:39:24.979] [DEBUG] "binlog_convert_timeout_us": 10000, [2025-05-15 16:39:24.979] [DEBUG] "binlog_checksum": true, [2025-05-15 16:39:24.979] [DEBUG] "binlog_heartbeat_interval_us": 100000, [2025-05-15 16:39:24.980] [DEBUG] "binlog_log_heartbeat_interval_times": 10, [2025-05-15 16:39:24.980] [DEBUG] "binlog_ddl_convert_jvm_options": "-Djava.class.path=../../deps/lib/etransfer.jar|-Xmx256M|-Xtrace|-XX:+CreateMinidumpOnCrash", [2025-05-15 16:39:24.980] [DEBUG] "binlog_ddl_convert_class": "com/alipay/oms/etransfer/util/OB2MySQLConvertTool", [2025-05-15 16:39:24.980] [DEBUG] "binlog_ddl_convert_func": "parser", [2025-05-15 16:39:24.980] [DEBUG] "binlog_ddl_convert_func_param": "(Ljava/lang/String;Ljava/lang/String;Z)Ljava/lang/String;", [2025-05-15 16:39:24.980] [DEBUG] "binlog_gtid_display": true, [2025-05-15 16:39:24.980] [DEBUG] "binlog_ddl_convert": true, [2025-05-15 16:39:24.980] [DEBUG] "binlog_ddl_convert_ignore_unsupported_ddl": true, [2025-05-15 16:39:24.980] [DEBUG] "binlog_memory_limit": "3G", [2025-05-15 16:39:24.980] [DEBUG] "binlog_working_mode": "storage", [2025-05-15 16:39:24.980] [DEBUG] "binlog_recover_backup": true, [2025-05-15 16:39:24.980] [DEBUG] "start_tcp_port": 8100, [2025-05-15 16:39:24.980] [DEBUG] "reserved_ports_num": 256, [2025-05-15 16:39:24.980] [DEBUG] "cluster_mode": true, [2025-05-15 16:39:24.980] [DEBUG] "gtid_seq_compressed_interval_s": 10, [2025-05-15 16:39:24.980] [DEBUG] "gtid_seq_compressed_trx_size": 100000, [2025-05-15 16:39:24.980] [DEBUG] "gtid_marking_step_size": 100000, [2025-05-15 16:39:24.980] [DEBUG] "gtid_inspector_s": 900, [2025-05-15 16:39:24.980] [DEBUG] "gtid_memory_cache_seconds": 7200, [2025-05-15 16:39:24.980] [DEBUG] "gtid_heartbeat_duration_s": 3600, [2025-05-15 16:39:24.980] [DEBUG] "enable_gtid_inspector": true, [2025-05-15 16:39:24.980] [DEBUG] "database_ip": "192.168.10.64", [2025-05-15 16:39:24.980] [DEBUG] "database_port": 2883, [2025-05-15 16:39:24.980] [DEBUG] "database_name": "binlog_database", [2025-05-15 16:39:24.980] [DEBUG] "database_properties": "", [2025-05-15 16:39:24.980] [DEBUG] "user": "root@binglog", [2025-05-15 16:39:24.980] [DEBUG] "password": "******", [2025-05-15 16:39:24.980] [DEBUG] "node_ip": "192.168.10.64", [2025-05-15 16:39:24.980] [DEBUG] "enable_resource_check": false, [2025-05-15 16:39:24.980] [DEBUG] "cpu_mem_disk_net_weighted": "1:1:1:1", [2025-05-15 16:39:24.980] [DEBUG] "node_cpu_limit_threshold_percent": 80, [2025-05-15 16:39:24.980] [DEBUG] "node_mem_limit_threshold_percent": 85, [2025-05-15 16:39:24.980] [DEBUG] "node_disk_limit_threshold_percent": 70, [2025-05-15 16:39:24.980] [DEBUG] "recovery_point_strategy": "fast", [2025-05-15 16:39:24.981] [DEBUG] "enable_dumper_cpu_precheck": false, [2025-05-15 16:39:24.981] [DEBUG] "max_dumper_num": 128, [2025-05-15 16:39:24.981] [DEBUG] "max_task_execution_time_s": 600, [2025-05-15 16:39:24.981] [DEBUG] "default_defer_drop_sec": 7200, [2025-05-15 16:39:24.981] [DEBUG] "default_instance_replicate_num": 1, [2025-05-15 16:39:24.981] [DEBUG] "enable_auth": false, [2025-05-15 16:39:24.981] [DEBUG] "prometheus_unused_metric_clear_interval_s": 900, [2025-05-15 16:39:24.981] [DEBUG] "max_delete_rows": 10000, [2025-05-15 16:39:24.981] [DEBUG] "max_instance_startup_wait_sec": 60, [2025-05-15 16:39:24.981] [DEBUG] "min_pool_size": 30, [2025-05-15 16:39:24.981] [DEBUG] "max_pool_size": 1000, [2025-05-15 16:39:24.981] [DEBUG] "binlog_convert_ring_buffer_size": 1024, [2025-05-15 16:39:24.981] [DEBUG] "binlog_convert_number_of_concurrences": 12, [2025-05-15 16:39:24.981] [DEBUG] "binlog_convert_thread_size": 16, [2025-05-15 16:39:24.981] [DEBUG] "binlog_serialize_ring_buffer_size": 1024, [2025-05-15 16:39:24.981] [DEBUG] "binlog_serialize_thread_size": 10, [2025-05-15 16:39:24.981] [DEBUG] "binlog_serialize_parallel_size": 8, [2025-05-15 16:39:24.981] [DEBUG] "binlog_release_ring_buffer_size": 1024, [2025-05-15 16:39:24.981] [DEBUG] "binlog_release_thread_size": 4, [2025-05-15 16:39:24.981] [DEBUG] "binlog_release_parallel_size": 2, [2025-05-15 16:39:24.981] [DEBUG] "preallocated_memory_bytes": 2097152, [2025-05-15 16:39:24.981] [DEBUG] "preallocated_expansion_memory_bytes": 8192, [2025-05-15 16:39:24.981] [DEBUG] "binlog_purge_binlog_threads": 2, [2025-05-15 16:39:24.981] [DEBUG] "binlog_obi_column_work_threads": 10 [2025-05-15 16:39:24.981] [DEBUG] } to root@192.168.10.64:22: /data/obbinlog/conf/conf.json [2025-05-15 16:39:25.048] [DEBUG] - current remote_transporter RemoteTransporter.CLIENT [2025-05-15 16:39:25.048] [DEBUG] -- root@192.168.10.64 execute: mkdir -p /data/obbinlog/conf && rm -fr /data/obbinlog/conf/conf.json [2025-05-15 16:39:25.064] [DEBUG] -- exited code 0 [2025-05-15 16:39:25.064] [DEBUG] -- send /tmp/tmpfs8fbgmm to /data/obbinlog/conf/conf.json [2025-05-15 16:39:25.065] [DEBUG] - root@192.168.10.64 execute: chmod 600 /data/obbinlog/conf/conf.json [2025-05-15 16:39:25.080] [DEBUG] - exited code 0 [2025-05-15 16:39:25.080] [DEBUG] - sub parameter_pre ref count to 0 [2025-05-15 16:39:25.080] [DEBUG] - export parameter_pre [2025-05-15 16:39:25.081] [DEBUG] - plugin obbinlog-ce-py_script_parameter_pre-4.0.1 result: True [2025-05-15 16:39:25.081] [DEBUG] - Searching cursor_check plugin for components ... [2025-05-15 16:39:25.081] [DEBUG] - Searching cursor_check plugin for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:25.081] [DEBUG] - Found for obbinlog-ce-py_script_cursor_check-4.0.1 for obbinlog-ce-4.2.4 [2025-05-15 16:39:25.081] [DEBUG] - Call plugin obbinlog-ce-py_script_cursor_check-4.0.1 for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:25.082] [DEBUG] - import cursor_check [2025-05-15 16:39:25.082] [DEBUG] - add cursor_check ref count to 1 [2025-05-15 16:39:25.083] [DEBUG] -- connect 192.168.10.64 -P2883 -uroot@binglog -p****** [2025-05-15 16:39:25.086] [DEBUG] - sub cursor_check ref count to 0 [2025-05-15 16:39:25.086] [DEBUG] - export cursor_check [2025-05-15 16:39:25.086] [DEBUG] - plugin obbinlog-ce-py_script_cursor_check-4.0.1 result: True [2025-05-15 16:39:25.086] [DEBUG] - Searching init_schema plugin for components ... [2025-05-15 16:39:25.086] [DEBUG] - Searching init_schema plugin for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:25.087] [DEBUG] - Found for obbinlog-ce-py_script_init_schema-4.0.1 for obbinlog-ce-4.2.4 [2025-05-15 16:39:25.087] [DEBUG] - Call plugin obbinlog-ce-py_script_init_schema-4.0.1 for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:25.087] [DEBUG] - import init_schema [2025-05-15 16:39:25.088] [DEBUG] - add init_schema ref count to 1 [2025-05-15 16:39:25.088] [DEBUG] -- connect 192.168.10.64 -P2883 -uroot@binglog -p****** [2025-05-15 16:39:25.092] [DEBUG] -- execute sql: CREATE TABLE IF NOT EXISTS nodes [2025-05-15 16:39:25.092] [DEBUG] ( [2025-05-15 16:39:25.092] [DEBUG] id [2025-05-15 16:39:25.092] [DEBUG] varchar(100) NOT NULL COMMENT 'uuid,节点唯一标识', [2025-05-15 16:39:25.092] [DEBUG] ip varchar(100) NOT NULL COMMENT 'IP地址', [2025-05-15 16:39:25.092] [DEBUG] port INT NOT NULL COMMENT '服务端口', [2025-05-15 16:39:25.092] [DEBUG] state INT(11) NULL COMMENT '节点状态', [2025-05-15 16:39:25.092] [DEBUG] metric TEXT NULL COMMENT '节点指标信息', [2025-05-15 16:39:25.092] [DEBUG] node_config TEXT NULL COMMENT '节点配置', [2025-05-15 16:39:25.092] [DEBUG] region varchar(100) NULL COMMENT '地域信息', [2025-05-15 16:39:25.092] [DEBUG] zone varchar(100) NULL COMMENT '可用区信息', [2025-05-15 16:39:25.092] [DEBUG] `group` TEXT NULL COMMENT '组', [2025-05-15 16:39:25.092] [DEBUG] gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', [2025-05-15 16:39:25.093] [DEBUG] gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', [2025-05-15 16:39:25.093] [DEBUG] incarnation BIGINT COMMENT '元信息版本', [2025-05-15 16:39:25.093] [DEBUG] last_modify BIGINT COMMENT '最新修改时间,心跳时间', [2025-05-15 16:39:25.093] [DEBUG] PRIMARY KEY [2025-05-15 16:39:25.093] [DEBUG] ( [2025-05-15 16:39:25.093] [DEBUG] `id` [2025-05-15 16:39:25.093] [DEBUG] ) [2025-05-15 16:39:25.093] [DEBUG] ). args: None [2025-05-15 16:39:25.119] [DEBUG] -- execute sql: [2025-05-15 16:39:25.119] [DEBUG] CREATE TABLE IF NOT EXISTS binlog_instances [2025-05-15 16:39:25.119] [DEBUG] ( [2025-05-15 16:39:25.119] [DEBUG] node_id [2025-05-15 16:39:25.119] [DEBUG] varchar(100) NOT NULL COMMENT 'OBM的节点ID', [2025-05-15 16:39:25.119] [DEBUG] ip VARCHAR(255) NOT NULL COMMENT 'OBI的服务IP', [2025-05-15 16:39:25.119] [DEBUG] instance_name VARCHAR(64) NOT NULL COMMENT 'OBI 名称', [2025-05-15 16:39:25.120] [DEBUG] port INT(11) NOT NULL DEFAULT 0 COMMENT 'OBI的服务port', [2025-05-15 16:39:25.120] [DEBUG] cluster VARCHAR(200) NOT NULL COMMENT 'OBI服务的集群ID', [2025-05-15 16:39:25.120] [DEBUG] tenant VARCHAR(200) NOT NULL COMMENT 'OBI服务的租户ID', [2025-05-15 16:39:25.120] [DEBUG] pid INT(11) COMMENT 'OBI 进程ID', [2025-05-15 16:39:25.120] [DEBUG] work_path VARCHAR(200) NOT NULL DEFAULT '' COMMENT 'OBI的工作目录', [2025-05-15 16:39:25.120] [DEBUG] state INT(11) NOT NULL COMMENT 'OBI状态,INIT、RUNNING、STOP、OFFLINE', [2025-05-15 16:39:25.120] [DEBUG] config TEXT COMMENT 'OBI的配置', [2025-05-15 16:39:25.120] [DEBUG] gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', [2025-05-15 16:39:25.120] [DEBUG] gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', [2025-05-15 16:39:25.120] [DEBUG] heartbeat bigint(20) DEFAULT '0' COMMENT '心跳时间', [2025-05-15 16:39:25.120] [DEBUG] delay bigint(20) NOT NULL DEFAULT -1 COMMENT '延迟时间', [2025-05-15 16:39:25.120] [DEBUG] min_dump_checkpoint bigint(20) DEFAULT '0' COMMENT '最早订阅位点', [2025-05-15 16:39:25.120] [DEBUG] PRIMARY KEY [2025-05-15 16:39:25.120] [DEBUG] ( [2025-05-15 16:39:25.120] [DEBUG] instance_name [2025-05-15 16:39:25.120] [DEBUG] ), [2025-05-15 16:39:25.120] [DEBUG] INDEX obi_list [2025-05-15 16:39:25.120] [DEBUG] ( [2025-05-15 16:39:25.120] [DEBUG] cluster, [2025-05-15 16:39:25.120] [DEBUG] tenant [2025-05-15 16:39:25.120] [DEBUG] ) [2025-05-15 16:39:25.120] [DEBUG] ). args: None [2025-05-15 16:39:25.147] [DEBUG] -- execute sql: [2025-05-15 16:39:25.147] [DEBUG] CREATE TABLE IF NOT EXISTS `config_template` [2025-05-15 16:39:25.147] [DEBUG] ( [2025-05-15 16:39:25.147] [DEBUG] `id` [2025-05-15 16:39:25.147] [DEBUG] bigint [2025-05-15 16:39:25.147] [DEBUG] UNSIGNED [2025-05-15 16:39:25.147] [DEBUG] NOT [2025-05-15 16:39:25.147] [DEBUG] NULL [2025-05-15 16:39:25.147] [DEBUG] AUTO_INCREMENT [2025-05-15 16:39:25.147] [DEBUG] COMMENT [2025-05-15 16:39:25.147] [DEBUG] 'PK', [2025-05-15 16:39:25.147] [DEBUG] `version` [2025-05-15 16:39:25.147] [DEBUG] varchar(32) DEFAULT '1' COMMENT '@desc 配置的版本', [2025-05-15 16:39:25.147] [DEBUG] `key_name` varchar(50) NOT NULL COMMENT '@desc key', [2025-05-15 16:39:25.147] [DEBUG] `value` text NOT NULL COMMENT '@desc 值', [2025-05-15 16:39:25.147] [DEBUG] `granularity` int UNSIGNED NOT NULL DEFAULT '0', [2025-05-15 16:39:25.147] [DEBUG] `scope` varchar(128) DEFAULT '' COMMENT '@desc 作用范围', [2025-05-15 16:39:25.147] [DEBUG] gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', [2025-05-15 16:39:25.147] [DEBUG] gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', [2025-05-15 16:39:25.147] [DEBUG] PRIMARY KEY [2025-05-15 16:39:25.147] [DEBUG] ( [2025-05-15 16:39:25.148] [DEBUG] `id` [2025-05-15 16:39:25.148] [DEBUG] ), [2025-05-15 16:39:25.148] [DEBUG] CONSTRAINT `unique_config` UNIQUE [2025-05-15 16:39:25.148] [DEBUG] ( [2025-05-15 16:39:25.148] [DEBUG] `key_name`, [2025-05-15 16:39:25.148] [DEBUG] `granularity`, [2025-05-15 16:39:25.148] [DEBUG] `scope` [2025-05-15 16:39:25.148] [DEBUG] ) [2025-05-15 16:39:25.148] [DEBUG] ) DEFAULT CHARSET = utf8 COMMENT ='config表'. args: None [2025-05-15 16:39:25.175] [DEBUG] -- execute sql: [2025-05-15 16:39:25.175] [DEBUG] CREATE TABLE IF NOT EXISTS `tasks` [2025-05-15 16:39:25.175] [DEBUG] ( [2025-05-15 16:39:25.175] [DEBUG] `id` [2025-05-15 16:39:25.175] [DEBUG] int(11) NOT NULL AUTO_INCREMENT COMMENT 'PK', [2025-05-15 16:39:25.175] [DEBUG] `task_id` text NOT NULL COMMENT 'task id', [2025-05-15 16:39:25.175] [DEBUG] `type` int(11) DEFAULT NULL COMMENT 'task 类型', [2025-05-15 16:39:25.175] [DEBUG] `instance_name` text DEFAULT NULL COMMENT 'instance 名称', [2025-05-15 16:39:25.175] [DEBUG] `status` int(11) NOT NULL COMMENT 'task 状态', [2025-05-15 16:39:25.176] [DEBUG] `execution_node` text NOT NULL COMMENT '执行 task 的节点', [2025-05-15 16:39:25.176] [DEBUG] `retry_count` int(11) DEFAULT '0' COMMENT 'task 执行最大重试次数', [2025-05-15 16:39:25.176] [DEBUG] `last_modify` bigint NOT NULL DEFAULT 0 COMMENT 'task 最后更新时间', [2025-05-15 16:39:25.176] [DEBUG] `task_param` text DEFAULT NULL COMMENT 'task 参数', [2025-05-15 16:39:25.176] [DEBUG] gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', [2025-05-15 16:39:25.176] [DEBUG] gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', [2025-05-15 16:39:25.176] [DEBUG] PRIMARY KEY [2025-05-15 16:39:25.176] [DEBUG] ( [2025-05-15 16:39:25.176] [DEBUG] `id` [2025-05-15 16:39:25.176] [DEBUG] ) [2025-05-15 16:39:25.176] [DEBUG] ) DEFAULT CHARSET = utf8 COMMENT ='异步任务表'. args: None [2025-05-15 16:39:25.200] [DEBUG] -- execute sql: [2025-05-15 16:39:25.200] [DEBUG] CREATE TABLE IF NOT EXISTS `primary_instance` [2025-05-15 16:39:25.200] [DEBUG] ( [2025-05-15 16:39:25.200] [DEBUG] cluster [2025-05-15 16:39:25.200] [DEBUG] VARCHAR(200) NOT NULL COMMENT 'OBI服务的集群ID', [2025-05-15 16:39:25.200] [DEBUG] tenant VARCHAR(200) NOT NULL COMMENT 'OBI服务的租户ID', [2025-05-15 16:39:25.200] [DEBUG] master_instance VARCHAR(255) NOT NULL COMMENT '当前租户的主 instance', [2025-05-15 16:39:25.200] [DEBUG] gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', [2025-05-15 16:39:25.200] [DEBUG] gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', [2025-05-15 16:39:25.200] [DEBUG] PRIMARY KEY [2025-05-15 16:39:25.200] [DEBUG] ( [2025-05-15 16:39:25.200] [DEBUG] `cluster`, [2025-05-15 16:39:25.200] [DEBUG] `tenant` [2025-05-15 16:39:25.200] [DEBUG] ) [2025-05-15 16:39:25.201] [DEBUG] ). args: None [2025-05-15 16:39:25.224] [DEBUG] -- execute sql: [2025-05-15 16:39:25.224] [DEBUG] CREATE TABLE IF NOT EXISTS `instances_gtid_seq` [2025-05-15 16:39:25.224] [DEBUG] ( [2025-05-15 16:39:25.224] [DEBUG] `id` [2025-05-15 16:39:25.224] [DEBUG] BIGINT [2025-05-15 16:39:25.224] [DEBUG] UNSIGNED [2025-05-15 16:39:25.224] [DEBUG] NOT [2025-05-15 16:39:25.224] [DEBUG] NULL [2025-05-15 16:39:25.224] [DEBUG] AUTO_INCREMENT [2025-05-15 16:39:25.224] [DEBUG] COMMENT [2025-05-15 16:39:25.224] [DEBUG] 'PK', [2025-05-15 16:39:25.224] [DEBUG] `cluster` [2025-05-15 16:39:25.224] [DEBUG] VARCHAR(200) NOT NULL COMMENT 'OBI服务的集群ID', [2025-05-15 16:39:25.224] [DEBUG] `tenant` VARCHAR(200) NOT NULL COMMENT 'OBI服务的租户ID', [2025-05-15 16:39:25.224] [DEBUG] `instance` VARCHAR(64) NOT NULL COMMENT 'OBI 名称', [2025-05-15 16:39:25.224] [DEBUG] `commit_version_start` BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '事务提交时间', [2025-05-15 16:39:25.224] [DEBUG] `xid_start` VARCHAR(255) NOT NULL COMMENT '事务 ID', [2025-05-15 16:39:25.224] [DEBUG] `gtid_start` BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '事务对应的 gtid', [2025-05-15 16:39:25.224] [DEBUG] `trxs_num` INT(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '压缩事务的数量', [2025-05-15 16:39:25.225] [DEBUG] gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', [2025-05-15 16:39:25.225] [DEBUG] gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', [2025-05-15 16:39:25.225] [DEBUG] INDEX [2025-05-15 16:39:25.225] [DEBUG] ( [2025-05-15 16:39:25.225] [DEBUG] `instance`, [2025-05-15 16:39:25.225] [DEBUG] `commit_version_start` [2025-05-15 16:39:25.225] [DEBUG] ), [2025-05-15 16:39:25.225] [DEBUG] PRIMARY KEY [2025-05-15 16:39:25.225] [DEBUG] ( [2025-05-15 16:39:25.225] [DEBUG] `id` [2025-05-15 16:39:25.225] [DEBUG] ) [2025-05-15 16:39:25.225] [DEBUG] ). args: None [2025-05-15 16:39:25.251] [DEBUG] -- execute sql: [2025-05-15 16:39:25.251] [DEBUG] CREATE TABLE IF NOT EXISTS `user` [2025-05-15 16:39:25.251] [DEBUG] ( [2025-05-15 16:39:25.251] [DEBUG] `id` [2025-05-15 16:39:25.251] [DEBUG] int(11) NOT NULL AUTO_INCREMENT COMMENT 'PK', [2025-05-15 16:39:25.251] [DEBUG] `username` varchar(128) NOT NULL COMMENT '用户名', [2025-05-15 16:39:25.251] [DEBUG] `password_sha1` varchar(128) NOT NULL DEFAULT '' COMMENT 'SHA1(用户密码)', [2025-05-15 16:39:25.251] [DEBUG] `password` varchar(128) NOT NULL DEFAULT '' COMMENT 'SHA1(SHA1(用户密码))', [2025-05-15 16:39:25.251] [DEBUG] `tag` int(4) NOT NULL COMMENT '标签,0: 固定账密, 1: 用户可修改', [2025-05-15 16:39:25.251] [DEBUG] `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', [2025-05-15 16:39:25.251] [DEBUG] `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', [2025-05-15 16:39:25.251] [DEBUG] PRIMARY KEY [2025-05-15 16:39:25.251] [DEBUG] ( [2025-05-15 16:39:25.251] [DEBUG] `id` [2025-05-15 16:39:25.251] [DEBUG] ) [2025-05-15 16:39:25.251] [DEBUG] ) DEFAULT CHARSET = utf8 COMMENT ='用户表'. args: None [2025-05-15 16:39:25.274] [DEBUG] -- execute sql: [2025-05-15 16:39:25.274] [DEBUG] REPLACE INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.274] [DEBUG] VALUES ('1', 'binlog_expire_logs_seconds', '259200', 0, ''). args: None [2025-05-15 16:39:25.279] [DEBUG] -- execute sql: [2025-05-15 16:39:25.279] [DEBUG] REPLACE [2025-05-15 16:39:25.279] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.279] [DEBUG] VALUES ('1', 'binlog_expire_logs_size', '53687091200', 0, ''). args: None [2025-05-15 16:39:25.281] [DEBUG] -- execute sql: [2025-05-15 16:39:25.281] [DEBUG] REPLACE [2025-05-15 16:39:25.281] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.281] [DEBUG] VALUES ('1', 'auto_start_obcdc', '1', 0, ''). args: None [2025-05-15 16:39:25.282] [DEBUG] -- execute sql: [2025-05-15 16:39:25.282] [DEBUG] REPLACE [2025-05-15 16:39:25.282] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.282] [DEBUG] VALUES ('1', 'active_state_after_boot', '0', 0, ''). args: None [2025-05-15 16:39:25.284] [DEBUG] -- execute sql: [2025-05-15 16:39:25.284] [DEBUG] REPLACE [2025-05-15 16:39:25.284] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.284] [DEBUG] VALUES ('1', 'failover', '1', 0, ''). args: None [2025-05-15 16:39:25.286] [DEBUG] -- execute sql: [2025-05-15 16:39:25.286] [DEBUG] REPLACE [2025-05-15 16:39:25.286] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.286] [DEBUG] VALUES ('1', 'binlog_gtid_display', 'true', 0, ''). args: None [2025-05-15 16:39:25.287] [DEBUG] -- execute sql: [2025-05-15 16:39:25.287] [DEBUG] REPLACE [2025-05-15 16:39:25.288] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.288] [DEBUG] VALUES ('1', 'binlog_ddl_convert', 'true', 0, ''). args: None [2025-05-15 16:39:25.289] [DEBUG] -- execute sql: [2025-05-15 16:39:25.289] [DEBUG] REPLACE [2025-05-15 16:39:25.289] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.289] [DEBUG] VALUES ('1', 'binlog_memory_limit', '4G', 0, ''). args: None [2025-05-15 16:39:25.291] [DEBUG] -- execute sql: [2025-05-15 16:39:25.291] [DEBUG] REPLACE [2025-05-15 16:39:25.291] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.291] [DEBUG] VALUES ('1', 'binlog_working_mode', 'storage', 0, ''). args: None [2025-05-15 16:39:25.292] [DEBUG] -- execute sql: [2025-05-15 16:39:25.292] [DEBUG] REPLACE [2025-05-15 16:39:25.292] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.292] [DEBUG] VALUES ('1', 'binlog_recover_backup', 'true', 0, ''). args: None [2025-05-15 16:39:25.294] [DEBUG] -- execute sql: [2025-05-15 16:39:25.294] [DEBUG] REPLACE [2025-05-15 16:39:25.294] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.294] [DEBUG] VALUES ('1', 'gtid_seq_compressed_interval_s', '10', 0, ''). args: None [2025-05-15 16:39:25.295] [DEBUG] -- execute sql: [2025-05-15 16:39:25.295] [DEBUG] REPLACE [2025-05-15 16:39:25.295] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.295] [DEBUG] VALUES ('1', 'gtid_seq_compressed_trx_size', '100000', 0, ''). args: None [2025-05-15 16:39:25.297] [DEBUG] -- execute sql: [2025-05-15 16:39:25.297] [DEBUG] REPLACE [2025-05-15 16:39:25.297] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.297] [DEBUG] VALUES ('1', 'gtid_marking_step_size', '100000', 0, ''). args: None [2025-05-15 16:39:25.299] [DEBUG] -- execute sql: [2025-05-15 16:39:25.299] [DEBUG] REPLACE [2025-05-15 16:39:25.299] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.299] [DEBUG] VALUES ('1', 'gtid_inspector_s', '900', 0, ''). args: None [2025-05-15 16:39:25.300] [DEBUG] -- execute sql: [2025-05-15 16:39:25.300] [DEBUG] REPLACE [2025-05-15 16:39:25.300] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.300] [DEBUG] VALUES ('1', 'gtid_memory_cache_seconds', '7200', 0, ''). args: None [2025-05-15 16:39:25.302] [DEBUG] -- execute sql: [2025-05-15 16:39:25.302] [DEBUG] REPLACE [2025-05-15 16:39:25.302] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.302] [DEBUG] VALUES ('1', 'gtid_heartbeat_duration_s', '3600', 0, ''). args: None [2025-05-15 16:39:25.303] [DEBUG] -- execute sql: [2025-05-15 16:39:25.303] [DEBUG] REPLACE [2025-05-15 16:39:25.303] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.303] [DEBUG] VALUES ('1', 'recovery_point_strategy', 'fast', 0, ''). args: None [2025-05-15 16:39:25.305] [DEBUG] -- execute sql: [2025-05-15 16:39:25.305] [DEBUG] REPLACE [2025-05-15 16:39:25.305] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.305] [DEBUG] VALUES ('1', 'max_binlog_size', '536870912', 0, ''). args: None [2025-05-15 16:39:25.306] [DEBUG] -- execute sql: [2025-05-15 16:39:25.306] [DEBUG] REPLACE [2025-05-15 16:39:25.306] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.307] [DEBUG] VALUES ('1', 'binlog_log_heartbeat_interval_times', '10', 0, ''). args: None [2025-05-15 16:39:25.308] [DEBUG] -- execute sql: [2025-05-15 16:39:25.308] [DEBUG] REPLACE [2025-05-15 16:39:25.308] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.308] [DEBUG] VALUES ('1', 'verbose_record_read', 'false', 0, ''). args: None [2025-05-15 16:39:25.310] [DEBUG] -- execute sql: [2025-05-15 16:39:25.310] [DEBUG] REPLACE [2025-05-15 16:39:25.310] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.310] [DEBUG] VALUES ('1', 'binlog_timezone_conf', '../../conf/timezone_info.conf', 0, ''). args: None [2025-05-15 16:39:25.311] [DEBUG] -- execute sql: [2025-05-15 16:39:25.311] [DEBUG] REPLACE [2025-05-15 16:39:25.311] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.311] [DEBUG] VALUES ('1', 'binlog_obcdc_path_template', '../../obcdc/obcdc-%s.x-access/libobcdcaccess.so', 0, ''). args: None [2025-05-15 16:39:25.313] [DEBUG] -- execute sql: [2025-05-15 16:39:25.313] [DEBUG] REPLACE [2025-05-15 16:39:25.313] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.313] [DEBUG] VALUES ('1', 'binlog_obcdc_ce_path_template', '../../obcdc/obcdc-ce-%s.x-access/libobcdcaccess.so', 0, ''). args: None [2025-05-15 16:39:25.314] [DEBUG] -- execute sql: [2025-05-15 16:39:25.314] [DEBUG] REPLACE [2025-05-15 16:39:25.314] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.315] [DEBUG] VALUES ('1', 'binlog_ignore_unsupported_event', 'true', 0, ''). args: None [2025-05-15 16:39:25.316] [DEBUG] -- execute sql: [2025-05-15 16:39:25.316] [DEBUG] REPLACE [2025-05-15 16:39:25.316] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.316] [DEBUG] VALUES ('1', 'binlog_max_event_buffer_bytes', '67108864', 0, ''). args: None [2025-05-15 16:39:25.318] [DEBUG] -- execute sql: [2025-05-15 16:39:25.318] [DEBUG] REPLACE [2025-05-15 16:39:25.318] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.318] [DEBUG] VALUES ('1', 'binlog_convert_timeout_us', '10000', 0, ''). args: None [2025-05-15 16:39:25.319] [DEBUG] -- execute sql: [2025-05-15 16:39:25.319] [DEBUG] REPLACE [2025-05-15 16:39:25.319] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.319] [DEBUG] VALUES ('1', 'binlog_ddl_convert_jvm_options', [2025-05-15 16:39:25.319] [DEBUG] '-Djava.class.path=../../deps/lib/etransfer.jar|-Xmx256M|-Xtrace|-XX:+CreateMinidumpOnCrash', 0, ''). args: None [2025-05-15 16:39:25.321] [DEBUG] -- execute sql: [2025-05-15 16:39:25.321] [DEBUG] REPLACE [2025-05-15 16:39:25.321] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.321] [DEBUG] VALUES ('1', 'binlog_ddl_convert_class', 'com/alipay/oms/etransfer/util/OB2MySQLConvertTool', 0, ''). args: None [2025-05-15 16:39:25.322] [DEBUG] -- execute sql: [2025-05-15 16:39:25.322] [DEBUG] REPLACE [2025-05-15 16:39:25.322] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.322] [DEBUG] VALUES ('1', 'binlog_ddl_convert_func', 'parser', 0, ''). args: None [2025-05-15 16:39:25.324] [DEBUG] -- execute sql: [2025-05-15 16:39:25.324] [DEBUG] REPLACE [2025-05-15 16:39:25.324] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.324] [DEBUG] VALUES ('1', 'binlog_ddl_convert_func_param', '(Ljava/lang/String;Ljava/lang/String;Z)Ljava/lang/String;', 0, ''). args: None [2025-05-15 16:39:25.325] [DEBUG] -- execute sql: [2025-05-15 16:39:25.325] [DEBUG] REPLACE [2025-05-15 16:39:25.326] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.326] [DEBUG] VALUES ('1', 'enable_resource_check', 'true', 0, ''). args: None [2025-05-15 16:39:25.327] [DEBUG] -- execute sql: [2025-05-15 16:39:25.327] [DEBUG] REPLACE [2025-05-15 16:39:25.327] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.327] [DEBUG] VALUES ('1', 'node_cpu_limit_threshold_percent', '80', 0, ''). args: None [2025-05-15 16:39:25.329] [DEBUG] -- execute sql: [2025-05-15 16:39:25.329] [DEBUG] REPLACE [2025-05-15 16:39:25.329] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.329] [DEBUG] VALUES ('1', 'node_mem_limit_threshold_percent', '85', 0, ''). args: None [2025-05-15 16:39:25.330] [DEBUG] -- execute sql: [2025-05-15 16:39:25.330] [DEBUG] REPLACE [2025-05-15 16:39:25.330] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.330] [DEBUG] VALUES ('1', 'node_disk_limit_threshold_percent', '70', 0, ''). args: None [2025-05-15 16:39:25.332] [DEBUG] -- execute sql: [2025-05-15 16:39:25.332] [DEBUG] REPLACE [2025-05-15 16:39:25.332] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.332] [DEBUG] VALUES ('1', 'enable_dumper_interception', 'false', 0, ''). args: None [2025-05-15 16:39:25.333] [DEBUG] -- execute sql: [2025-05-15 16:39:25.333] [DEBUG] REPLACE [2025-05-15 16:39:25.333] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.333] [DEBUG] VALUES ('1', 'max_dumper_num', '128', 0, ''). args: None [2025-05-15 16:39:25.334] [DEBUG] -- execute sql: [2025-05-15 16:39:25.334] [DEBUG] REPLACE [2025-05-15 16:39:25.335] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.335] [DEBUG] VALUES ('1', 'default_instance_replicate_num', '1', 0, ''). args: None [2025-05-15 16:39:25.336] [DEBUG] -- execute sql: [2025-05-15 16:39:25.336] [DEBUG] REPLACE [2025-05-15 16:39:25.336] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.336] [DEBUG] VALUES ('1', 'max_instance_replicate_num', '5', 0, ''). args: None [2025-05-15 16:39:25.337] [DEBUG] -- execute sql: [2025-05-15 16:39:25.337] [DEBUG] [2025-05-15 16:39:25.337] [DEBUG] REPLACE [2025-05-15 16:39:25.337] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.337] [DEBUG] VALUES ('1', 'max_task_execution_time_s', '600', 0, ''). args: None [2025-05-15 16:39:25.339] [DEBUG] -- execute sql: [2025-05-15 16:39:25.339] [DEBUG] REPLACE [2025-05-15 16:39:25.339] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.339] [DEBUG] VALUES ('1', 'default_defer_drop_sec', '0', 0, ''). args: None [2025-05-15 16:39:25.340] [DEBUG] -- execute sql: [2025-05-15 16:39:25.340] [DEBUG] REPLACE [2025-05-15 16:39:25.340] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.340] [DEBUG] VALUES ('1', 'binlog_ddl_convert_ignore_unsupported_ddl', 'true', 0, ''). args: None [2025-05-15 16:39:25.342] [DEBUG] -- execute sql: [2025-05-15 16:39:25.342] [DEBUG] REPLACE [2025-05-15 16:39:25.342] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.342] [DEBUG] VALUES ('1', 'prometheus_unused_metric_clear_interval_s', '900', 0, ''). args: None [2025-05-15 16:39:25.343] [DEBUG] -- execute sql: [2025-05-15 16:39:25.343] [DEBUG] REPLACE [2025-05-15 16:39:25.343] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.343] [DEBUG] VALUES ('1', 'enable_auth', 'false', 0, ''). args: None [2025-05-15 16:39:25.344] [DEBUG] -- execute sql: [2025-05-15 16:39:25.345] [DEBUG] REPLACE [2025-05-15 16:39:25.345] [DEBUG] INTO `user` (`username`, `tag`) [2025-05-15 16:39:25.345] [DEBUG] VALUES ('sys', '0'). args: None [2025-05-15 16:39:25.349] [DEBUG] -- execute sql: REPLACE [2025-05-15 16:39:25.349] [DEBUG] INTO `user` (`username`, `tag`) [2025-05-15 16:39:25.349] [DEBUG] VALUES ('admin', '1'). args: None [2025-05-15 16:39:25.350] [DEBUG] -- execute sql: [2025-05-15 16:39:25.350] [DEBUG] REPLACE [2025-05-15 16:39:25.350] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.350] [DEBUG] VALUES ('1', 'record_queue_size', '20000', 0, ''). args: None [2025-05-15 16:39:25.351] [DEBUG] -- execute sql: [2025-05-15 16:39:25.351] [DEBUG] REPLACE [2025-05-15 16:39:25.351] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.351] [DEBUG] VALUES ('1', 'read_wait_num', '2000', 0, ''). args: None [2025-05-15 16:39:25.352] [DEBUG] -- execute sql: [2025-05-15 16:39:25.352] [DEBUG] REPLACE [2025-05-15 16:39:25.352] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.353] [DEBUG] VALUES ('1', 'storage_wait_num', '2000', 0, ''). args: None [2025-05-15 16:39:25.354] [DEBUG] -- execute sql: [2025-05-15 16:39:25.354] [DEBUG] REPLACE [2025-05-15 16:39:25.354] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.354] [DEBUG] VALUES ('1', 'read_timeout_us', '10000', 0, ''). args: None [2025-05-15 16:39:25.355] [DEBUG] -- execute sql: [2025-05-15 16:39:25.355] [DEBUG] REPLACE [2025-05-15 16:39:25.355] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.355] [DEBUG] VALUES ('1', 'storage_timeout_us', '10000', 0, ''). args: None [2025-05-15 16:39:25.357] [DEBUG] -- execute sql: [2025-05-15 16:39:25.357] [DEBUG] REPLACE [2025-05-15 16:39:25.357] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.357] [DEBUG] VALUES ('1', 'binlog_convert_ring_buffer_size', '1024', 0, ''). args: None [2025-05-15 16:39:25.358] [DEBUG] -- execute sql: [2025-05-15 16:39:25.358] [DEBUG] REPLACE [2025-05-15 16:39:25.358] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.358] [DEBUG] VALUES ('1', 'binlog_convert_number_of_concurrences', '12', 0, ''). args: None [2025-05-15 16:39:25.359] [DEBUG] -- execute sql: [2025-05-15 16:39:25.359] [DEBUG] REPLACE [2025-05-15 16:39:25.359] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.359] [DEBUG] VALUES ('1', 'binlog_convert_thread_size', '16', 0, ''). args: None [2025-05-15 16:39:25.361] [DEBUG] -- execute sql: [2025-05-15 16:39:25.361] [DEBUG] REPLACE [2025-05-15 16:39:25.361] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.361] [DEBUG] VALUES ('1', 'binlog_serialize_ring_buffer_size', '8', 0, ''). args: None [2025-05-15 16:39:25.362] [DEBUG] -- execute sql: [2025-05-15 16:39:25.362] [DEBUG] REPLACE [2025-05-15 16:39:25.362] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.362] [DEBUG] VALUES ('1', 'binlog_serialize_thread_size', '10', 0, ''). args: None [2025-05-15 16:39:25.363] [DEBUG] -- execute sql: [2025-05-15 16:39:25.363] [DEBUG] REPLACE [2025-05-15 16:39:25.363] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.364] [DEBUG] VALUES ('1', 'binlog_serialize_parallel_size', '8', 0, ''). args: None [2025-05-15 16:39:25.365] [DEBUG] -- execute sql: [2025-05-15 16:39:25.365] [DEBUG] REPLACE [2025-05-15 16:39:25.365] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.365] [DEBUG] VALUES ('1', 'binlog_release_ring_buffer_size', '1024', 0, ''). args: None [2025-05-15 16:39:25.366] [DEBUG] -- execute sql: [2025-05-15 16:39:25.366] [DEBUG] REPLACE [2025-05-15 16:39:25.366] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.366] [DEBUG] VALUES ('1', 'binlog_release_thread_size', '4', 0, ''). args: None [2025-05-15 16:39:25.368] [DEBUG] -- execute sql: [2025-05-15 16:39:25.368] [DEBUG] REPLACE [2025-05-15 16:39:25.368] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.368] [DEBUG] VALUES ('1', 'binlog_release_parallel_size', '2', 0, ''). args: None [2025-05-15 16:39:25.369] [DEBUG] -- execute sql: [2025-05-15 16:39:25.369] [DEBUG] REPLACE [2025-05-15 16:39:25.369] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.369] [DEBUG] VALUES ('1', 'preallocated_memory_bytes', '2097152', 0, ''). args: None [2025-05-15 16:39:25.370] [DEBUG] -- execute sql: [2025-05-15 16:39:25.370] [DEBUG] REPLACE [2025-05-15 16:39:25.370] [DEBUG] INTO `config_template` (`version`, `key_name`, `value`, `granularity`, `scope`) [2025-05-15 16:39:25.370] [DEBUG] VALUES ('1', 'preallocated_expansion_memory_bytes', '8192', 0, ''). args: None [2025-05-15 16:39:25.372] [INFO] wait observer usable [2025-05-15 16:39:25.372] [DEBUG] -- execute sql: show databases. args: None [2025-05-15 16:39:25.503] [DEBUG] -- execute sql: UPDATE binlog_database.config_template SET value='false' WHERE key_name='enable_resource_check';. args: None [2025-05-15 16:39:25.504] [DEBUG] - sub init_schema ref count to 0 [2025-05-15 16:39:25.504] [DEBUG] - export init_schema [2025-05-15 16:39:25.504] [DEBUG] - plugin obbinlog-ce-py_script_init_schema-4.0.1 result: True [2025-05-15 16:39:25.504] [DEBUG] - Searching start plugin for components ... [2025-05-15 16:39:25.504] [DEBUG] - Searching start plugin for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:25.505] [DEBUG] - Found for obbinlog-ce-py_script_start-4.0.1 for obbinlog-ce-4.2.4 [2025-05-15 16:39:25.505] [DEBUG] - Call plugin obbinlog-ce-py_script_start-4.0.1 for obbinlog-ce-4.2.4-100000012025050614.el7-e9e55042fa2c72707653a31d354f64a3161e8cd6 [2025-05-15 16:39:25.505] [DEBUG] - import start [2025-05-15 16:39:25.506] [DEBUG] - add start ref count to 1 [2025-05-15 16:39:25.506] [INFO] start obbinlog-ce [2025-05-15 16:39:25.507] [DEBUG] -- root@192.168.10.64 execute: cat /data/obbinlog/run/obbinlog-ce-192.168.10.64-2983.pid [2025-05-15 16:39:25.522] [DEBUG] -- exited code 1, error output: [2025-05-15 16:39:25.522] [DEBUG] cat: /data/obbinlog/run/obbinlog-ce-192.168.10.64-2983.pid: No such file or directory [2025-05-15 16:39:25.522] [DEBUG] [2025-05-15 16:39:25.522] [DEBUG] -- root@192.168.10.64 execute: cd /data/obbinlog/lib/ && ln -sf libstdc++.so.6.0.28 libstdc++.so.6 [2025-05-15 16:39:25.537] [DEBUG] -- exited code 0 [2025-05-15 16:39:25.538] [DEBUG] -- root@192.168.10.64 export LD_LIBRARY_PATH='/data/obbinlog/lib' [2025-05-15 16:39:25.538] [DEBUG] -- root@192.168.10.64 execute: cd /data/obbinlog;nohup /data/obbinlog/bin/logproxy -f /data/obbinlog/conf/conf.json > /data/obbinlog/log/out.log & [2025-05-15 16:39:25.593] [DEBUG] -- exited code 0 [2025-05-15 16:39:25.594] [DEBUG] -- root@192.168.10.64 execute: ps -aux | grep '/data/obbinlog/bin/logproxy -f /data/obbinlog/conf/conf.json' | grep -v grep | awk '{print $2}' [2025-05-15 16:39:25.632] [DEBUG] -- exited code 0 [2025-05-15 16:39:25.632] [DEBUG] -- root@192.168.10.64 delete env LD_LIBRARY_PATH [2025-05-15 16:39:25.633] [ERROR] failed to start obbinlog-ce(server1(192.168.10.64)) [2025-05-15 16:39:25.637] [INFO] [ERROR] failed to start obbinlog-ce(server1(192.168.10.64)) [2025-05-15 16:39:25.637] [INFO] [2025-05-15 16:39:25.637] [DEBUG] - sub start ref count to 0 [2025-05-15 16:39:25.637] [DEBUG] - export start [2025-05-15 16:39:25.637] [DEBUG] - plugin obbinlog-ce-py_script_start-4.0.1 result: False [2025-05-15 16:39:25.640] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 1 [2025-05-15 16:39:25.640] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 0 [2025-05-15 16:39:25.640] [DEBUG] - unlock /root/.obd/lock/mirror_and_repo [2025-05-15 16:39:25.640] [DEBUG] - exclusive lock /root/.obd/lock/deploy_obbinlog release, count 0 [2025-05-15 16:39:25.640] [DEBUG] - unlock /root/.obd/lock/deploy_obbinlog [2025-05-15 16:39:25.641] [DEBUG] - share lock /root/.obd/lock/global release, count 0 [2025-05-15 16:39:25.641] [DEBUG] - unlock /root/.obd/lock/global [2025-05-15 16:39:25.641] [INFO] See https://www.oceanbase.com/product/ob-deployer/error-codes . [2025-05-15 16:39:25.641] [INFO] Trace ID: 1aca76fa-3168-11f0-88bd-3473792adf9e [2025-05-15 16:39:25.641] [INFO] If you want to view detailed obd logs, please run: obd display-trace 1aca76fa-3168-11f0-88bd-3473792adf9e