1、表结构sql
create table tseal (
seal_id number(10) default 0 not null,
add_date number(10) default 0 not null,
update_date number(10) default 0 not null,
update_time number(18,0) default 0 not null,
remark varchar2(256) default ’ ’ not null,
seal blob default empty_blob() not null,
constraint ptseal primary key (seal_id)
) ;
2、ob-loader-dumper版本
4.2.1-RELEASE
3、插入的sql
insert into tseal(seal_id) values(1)
4、备份恢复报错信息
备份结果是正常的,备份出来的sql是INSERT INTO “FM5”.“TSEAL” (“SEAL_ID”,“ADD_DATE”,“UPDATE_DATE”,“UPDATE_TIME”,“REMARK”,“SEAL”) VALUES (1,0,0,0,’ ‘,HEXTORAW(’’));
执行恢复命令时,报错如下
2024-08-13 17:21:40 [WARN] Calculate leader of table “TSEAL” failed, treat it as non-partition table. Remain: 0
2024-08-13 17:21:40 [INFO] Waiting to refresh observer load status …
2024-08-13 17:21:40 [INFO] Refresh observer load status success. Table: “TSEAL”. Remain: 0
2024-08-13 17:21:40 [INFO] Refresh observer load status finished. Elapsed: 22.66 ms
2024-08-13 17:21:40 [INFO] Use c.l.d.LiteBlockingWaitStrategy as available cpu(s) is 8
2024-08-13 17:21:40 [INFO] Create 16 slots for ring buffer finished. [0.0.0.0]
2024-08-13 17:21:40 [INFO] Start 16 database writer threads finished. [0.0.0.0]
2024-08-13 17:21:40 [INFO] Start 16 record file reader threads success
2024-08-13 17:21:40 [WARN] Failed to serialize list to “/home/fm/server/ob_oracle_backup/FM_20240808203802_TOOL/data/data/load.ckpt”. Error: Unable to make field private volatile long java.util.concurrent.atomic.AtomicLong.value accessible: module java.base does not “opens java.util.concurrent.atomic” to unnamed module @17a714ea
2024-08-13 17:21:40 [WARN] Retry Table: “TSEAL”, Partition: 0. Records: 1. Error: ORA-01400: cannot insert NULL into ‘(SEAL)’. Retry Mode: SERIAL.
2024-08-13 17:21:40 [ERROR] Other Error: “ORA-01400: cannot insert NULL into ‘(SEAL)’”. SQL: INSERT INTO “FM9”.“TSEAL” (“SEAL_ID”,“ADD_DATE”,“UPDATE_DATE”,“UPDATE_TIME”,“REMARK”,“SEAL”) VALUES (‘1’,‘0’,‘0’,‘0’,’ ‘,’’);
2024-08-13 17:21:40 [WARN] Failed to serialize list to “/home/fm/server/ob_oracle_backup/FM_20240808203802_TOOL/data/data/load.ckpt”. Error: Unable to make field private volatile long java.util.concurrent.atomic.AtomicLong.value accessible: module java.base does not “opens java.util.concurrent.atomic” to unnamed module @17a714ea
2024-08-13 17:21:40 [INFO] File: “/home/fm/server/ob_oracle_backup/FM_20240808203802_TOOL/data/data/FM5/TABLE/TSEAL.1.0.sql” has been parsed finished
2024-08-13 17:21:41 [INFO] Wait for the all the workers to drain of published events then halt the workers
2024-08-13 17:21:41 [INFO] Close connection count: 2041 of the DataSource. Key: BIZ
2024-08-13 17:21:41 [INFO] Shutdown task context finished
2024-08-13 17:21:41 [ERROR] Error: ORA-01400: cannot insert NULL into ‘(SEAL)’
2024-08-13 17:21:41 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ----------