obloader导入失败

OceanBase 技术问题
#1

obloader -h 192.168.48.107 -P2881 --direct --parallel 4 --rpc-port 2882 -uroot@ERP -p -D simba_tw_hans --sql --allf /root/dbbackup/hans/tw/data/simba_tw_hans/TABLE/handle
进度条卡住
目录中每次放不同的表一张表一张表重试，有的表成功了，有的表失败，如果是目录中放多张表运行到某张有问题的表就会卡住，现在只能筛选找到不成功的表，error日志看到，麻烦帮忙看下

2025-11-05 15:04:46 [ERROR] Fatal error occurred while loading data from “/root/dbbackup/hans/tw/data/simba_tw_hans/TABLE/handle/trade.0.sql” into table simba_tw_hans.trade. Reason: Write into table “trade” failed. com.alipay.oceanbase.rpc.direct_load.exception.ObDirectLoadIllegalStateException: statement cannot write because is fail, state:7, expect:[2, 3]

2025-11-05 15:04:48 [ERROR] Error: Write into table “trade” failed. com.alipay.oceanbase.rpc.direct_load.exception.ObDirectLoadIllegalStateException: statement cannot write because is fail, state:7, expect:[2, 3]

1 个赞
#3

麻烦提供一份完整的日志看下。

#4

日志只有这个消息

#5

logs.zip (27.6 KB)

#6

看着像是.sql文件存在异常

#7

image
image1885×386 25.3 KB

比如随便找一条sql：INSERT INTO trade (tr_id,eid,meid,buyer_id,sid,tid,created,addtime,leftime,paytime,final_payment_time,updtime,modify,signtime,endtime,hash_item,wh_id,buyer,type,lock,ctype,status,third_warehouse_status,sh_id,priority,ship_type,ship_name,ship_when,ship_code,ship_date,package_no,fee_pay,fee_post,fee_discount,fee_point,fee_adjust,fee_original,fee_total,fee_balance,inv_name,inv_text,weight,gp_id,promo,level,task_id,single_brush,reason,abroad,currency,xpromo_id,source_order_code,sku_weight,op_id,has_out_of_stock,new_sign_time) VALUES (1459345,‘14471704855603916370’,‘24471704858130918456’,‘51471704855603937807’,‘6917560171212373799’,‘6917560171212373799’,1704855301,1704855603,0,1704855324,0,1704858109,1704858130,0,0,‘77369c70f8136c36f40eddb2d1b38528’,4,‘詹*’,‘FIX’,‘C’,‘PAY’,‘FAIL’,null,6601,0,‘246’,‘YUNDA’,‘ALL’,‘318818588094162’,0,null,3990.0000000000000000,0.0000000000000000,1000.0000000000000000,0.0000000000000000,0.0000000000000000,3990.0000000000000000,4990.0000000000000000,0.0000000000000000,’’,’’,230,5,‘JU’,1,0,null,27,0,‘CNY’,8292,null,null,null,0,null); 直接insert是没错的

#8

会不会是磁盘性能问题？

#9

不是，之前别的机器安装oceanbase，也执行过obloader也遇到这个问题，当时也提了工单没有下文，这次因为非常需要导入数据，再发帖求答疑下， Write into table “trade” failed. com.alipay.oceanbase.rpc.direct_load.exception.ObDirectLoadIllegalStateException: statement cannot write because is fail, state:7, expect:[2, 3] 这个问题官网都搜不到