【 使用环境 】linux
【 OB or 其他组件 】
【 使用版本 】 ob4.2
【问题描述】清晰明确描述问题
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：
2024-01-02 12:21:38 [ERROR] Load sql file: “/cka/dump/dump1228/data/CLIC_MRYS/TABLE/FIP_FETCHERRORMESSAGE.0.0.sql” failed. Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Load sql file: “/cka/dump/dump1228/data/CLIC_MRYS/TABLE/SCCT_SEQUENCE.0.0.sql” failed. Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Load sql file: “/cka/dump/dump1228/data/CLIC_MRYS/TABLE/IUFO_TASKCOMMIT_LOCK.0.0.sql” failed. Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Error: The buffer: [0.0.0.0] is unregistered
2024-01-02 12:21:38 [ERROR] Error: The buffer: [0.0.0.0] is unregistered
王利博
#5
ob-loader-dumper4.0.1 升级到最新版本试试看
[INFO] 2024-06-04 15:52:38.719 +0800 [taskAppId=TASK-20240604-13820267662016_1-12356556-148485967] TaskLogLogger-class org.apache.dolphinscheduler.plugin.task.integration.IntegrationTask:[122] - {“code”:500,“message”:"[oceanbaseIn导入失败，失败信息如下： ERROR： fgs_210000_admin.linshi 传输失败 模式： 全量 错误原因： 导入文件 错误明细： java.lang.Exception: error： admin.linshi 传输失败 失败信息：2024-06-04 15:52:34 [INFO] Parsed args:[–cut] true[–ctl-path] /nas/di_data/20240604155229_6103/linshi/linshi.crtl[–file-path] /nas/di_data/20240604155229_6103/linshi/f_linshi_20240604155229_6103.dat.0[–file-suffix] .dat.0[–no-sys] true[–column-splitter] @!#[–line-separator] %$^[–host] ...[–port] 3306[–user] root[–tenant] lmysqlhbbase_ob[–cluster] [–password] [–database] [–sys-user] [–table] [linshi][–external-data] true2024-06-04 15:52:34 [INFO] Try to decrypt the sys password from the secure.crt2024-06-04 15:52:34 [INFO] The security certificate file: “/home/gdsuser/oceanbase/ob-loader-dumper-4.0.1-SNAPSHOT/ob-loader-dumper-4.0.1-SNAPSHOT/conf/secure.crt” is not exists2024-06-04 15:52:34 [INFO] Parse ctrl definition: “/nas/di_data/20240604155229_6103/linshi/linshi.crtl” successed2024-06-04 15:52:34 [INFO] Load jdbc driver class: “com.oceanbase.jdbc.Driver” finished2024-06-04 15:52:35 [INFO] The manifest file: “/nas/di_data/20240604155229_6103/linshi/MANIFEST.bin” has been saved2024-06-04 15:52:35 [INFO] Query column metadata for the table: “linshi” finished2024-06-04 15:52:35 [INFO] Binding table: “linshi” to the file: “/nas/di_data/20240604155229_6103/linshi/f_linshi_20240604155229_6103.dat.0” finished2024-06-04 15:52:35 [INFO] Splitted 1 cut subfiles by 64.0 MB. Elapsed: 15.13 ms2024-06-04 15:52:35 [INFO] Generate 1 subfiles finished2024-06-04 15:52:35 [INFO] Ignore to clean any tables as --truncate-table or --delete-from-table is not specified2024-06-04 15:52:35 [INFO] Query table entry and primary key for table: “linshi” finished. Remain: 02024-06-04 15:52:36 [INFO] Query the leader location of “linshi” finished. Remain: 02024-06-04 15:52:36 [INFO] Calculate leader: ...： of table: “linshi”, part: 0. Remain: 02024-06-04 15:52:36 [INFO] Waiting to refresh observer load status …2024-06-04 15:52:36 [INFO] Refresh observer load status success. Table: “linshi”. Remain: 02024-06-04 15:52:36 [INFO] Refresh observer load status finished. Elapsed: 9.817 ms2024-06-04 15:52:36 [INFO] Use c.l.d.PhasedBackoffWaitStrategy as available cpu(s) is 1282024-06-04 15:52:36 [INFO] Create 4096 slots for ring buffer finished. [...：]2024-06-04 15:52:36 [INFO] Start 256 database writer threads finished. [...：**]2024-06-04 15:52:36 [INFO] Start 256 cut file reader threads successed2024-06-04 15:52:36 [ERROR] Load cut file: “/nas/di_data/20240604155229_6103/linshi/f_linshi_20240604155229_6103.dat.0” failed. Error: The buffer: [0.0.0.0] is unregistered2024-06-04 15:52:36 [INFO] File: “/nas/di_data/20240604155229_6103/linshi/f_linshi_20240604155229_6103.dat.0” has been parsed finished2024-06-04 15:52:38 [INFO] Wait for the all the workers to drain of published events then halt the workers2024-06-04 15:52:38 [INFO] Close connection count: 36 of the DataSource. Key: 10_17_174_30_13224_1060056289_ln_ods2024-06-04 15:52:38 [INFO] Shutdown task context finished2024-06-04 15:52:38 [ERROR] Error: The buffer: [0.0.0.0] is unregistered2024-06-04 15:52:38 [INFO] ----------\tFinished Tasks: 1\tRunning Tasks: 0\tProgress: 100.00%\t----------2024-06-04 15:52:38 [INFO] All Load Tasks Finished: ---------------------------------------------------------------------------------------------------------------------------- No.# | Type | Name | Count | Status ---------------------------------------------------------------------------------------------------------------------------- 1 | TABLE | linshi | 0 | FAILURE ----------------------------------------------------------------------------------------------------------------------------Total Count: 0\t\tEnd Time: 2024-06-04 15:52:382024-06-04 15:52:38 [INFO] Load record finished. Total Elapsed: 3.303 s2024-06-04 15:52:38 [ERROR] System exit 1执行命令：/home/gdsuser/oceanbase/ob-loader-dumper-4.0.1-SNAPSHOT/ob-loader-dumper-4.0.1-SNAPSHOT/bin/obloader -h ... -P 3306 -u root -c dkobc08fgs --no-sys -p ********** -t ln_ods_mysqlhbbase_ob -D ln_ods --file-suffix .dat.0 --external-data --cut --column-splitter @!# --line-separator %$^ --table linshi -f /nas/di_data/clicmpp8_fgsa/fgs_210000_admin/20240604155229_6103/linshi/f_linshi_20240604155229_6103.dat.0 --ctl-path /nas/di_data/clicmpp8_fgsa/fgs_210000_admin/20240604155229_6103/linshi/linshi.crtl ]"}
王利博
#11
建议还是升级下ob-loader-dumper4.0.1 为最新 或者直接按照最新的
