ob-loader-dumper-4.3.3版本oceanbase4.3.5_bp1 导出数据报错

OceanBase 技术问题
#1

【 使用环境 】生产环境
【 ob-loader-dumper 】
【 使用版本 】ob-loader-dumper-4.3.3-RELEASE 数据库版本oceanbase-all-in-one-4.3.5_bp1_20250320.el
【问题描述】导出数据报错
【复现路径】执行命令
./obdumper -h ‘10.110.8.22’ -P’2883’ -u’root’ -t’parking’ -c’myoceanbase’ -p’DRAzl1bnR9WS./cyfHr58)Z’ -D’stric-cloud-db’ --ddl --sql --table ‘t_car_in’ -f ‘/data/bak’ --preserve-zero-datetime --skip-check-dir

【附件及日志】
ob-loader-dumper.error.txt (6.0 KB)
ob-loader-dumper.info.txt (7.7 KB)

#3

已知问题，后面会修复，现在暂时没有绕过办法，用4.3.2.1版本可以绕过

1 个赞
#4

麻烦在发一下 ddl语句

#5

导出ddl 正常

#6

麻烦发一下 谢谢

#7

./obdumper -h ‘10.110.8.22’ -P’2883’ -u’root’ -t’parking’ -c’myoceanbase’ -p’DRAzl1bnR9WS./cyfHr58)Z’ -D’stric-cloud-db’ --ddl --table ‘*’ -f ‘/data/bak’ --preserve-zero-datetime --skip-check-dir

#8

导出的ddl sql语句 不是命令语句

#9

发现导出数据时会超时
2025-03-25 16:10:32 [ERROR] Dump failed. Reason: Timeout, query has reached the maximum query timeout: 300000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again… SQL: SELECT id,serial_no,park_id,park_name,park_type,in_entrance,zone,space_no,device_no,plate_color,plate_no,in_time,in_pic,car_pic,car_type,car_class,credible_rate,open_id,is_out,toller_id,toller_name,bind_time,partner_code,tenant_id,create_time,creator,update_time,updater,deleted FROM t_car_in WHERE (id)>(?) AND (id)<=(?). Range: 4111019,5111019.
2025-03-25 16:10:32 [ERROR] Dump stric-cloud-db.t_car_in failed. java.lang.IllegalStateException: java.sql.SQLTransientConnectionException: Timeout, query has reached the maximum query timeout: 300000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.

#10

超时可以改大 ob_query_timeout, 路径：conf/session.config.json

image
image1948×884 98.6 KB

#11

麻烦提供下 t_car_in 这张表的 create 语句

#12

CREATE TABLE t_car_in (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
serial_no varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ‘停车序号’,
park_id bigint(20) NOT NULL COMMENT ‘停车场ID’,
park_name varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ‘停车场名称’,
park_type tinyint(4) NOT NULL COMMENT ‘停车场类型’,
in_entrance varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ‘入场口’,
zone varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ‘分区’,
space_no varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ‘车位编码’,
device_no varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ‘设备编号’,
plate_color tinyint(1) NULL DEFAULT NULL COMMENT ‘车牌颜色：0-未知，1-蓝色，2-绿色，3-黄色，4-黑色，5-白色，6-黄绿双色，7-渐变绿色’,
plate_no varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ‘车牌号码’,
in_time datetime NOT NULL COMMENT ‘入场时间’,
in_pic varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ‘入场照片’,
car_pic varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ‘车辆照片’,
car_type tinyint(4) NULL DEFAULT NULL COMMENT ‘车辆类型’,
car_class tinyint(4) NOT NULL COMMENT ‘车辆分类’,
credible_rate tinyint(4) NULL DEFAULT NULL COMMENT ‘车牌可信度’,
open_id varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ‘微信openId’,
is_out tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否离场’,
toller_id bigint(20) NULL DEFAULT NULL COMMENT ‘收费员ID’,
toller_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ‘收费员名称’,
bind_time datetime NULL DEFAULT NULL COMMENT ‘绑定时间’,
partner_code varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT ‘合作商编码’,
tenant_id bigint(20) NOT NULL COMMENT ‘租户号’,
create_time datetime NOT NULL COMMENT ‘创建时间’,
creator bigint(20) NULL DEFAULT NULL COMMENT ‘创建人’,
update_time datetime NOT NULL COMMENT ‘更新时间’,
updater bigint(20) NULL DEFAULT NULL COMMENT ‘更新人’,
deleted tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否删除’,
PRIMARY KEY (id) USING BTREE,
INDEX idx_serial_no(serial_no) USING BTREE,
INDEX idx_park_id(park_id) USING BTREE,
INDEX idx_plate_no(plate_no) USING BTREE,
INDEX idx_in_time(in_time) USING BTREE,
INDEX idx_tenant_id(tenant_id) USING BTREE,
INDEX idx_create_time(create_time) USING BTREE,
INDEX idx_deleted(deleted) USING BTREE,
INDEX idx_id(id) USING BTREE
) ENGINE = oceanbase CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = ‘车辆记录表’ ROW_FORMAT = DYNAMIC;