迁移/复制/Rebuild - OceanBase 数据库 V4.2.1

迁移/复制/Rebuild

更新时间：2026-04-16 00:11:35

相关视图

视图 oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY 可以查看 Root Service 调度过的迁移/复制/Rebuild 任务。

obclient> 
select TIMESTAMP,MODULE,EVENT,VALUE1 tenant_id,VALUE2 ls_id,NAME3,VALUE3,NAME4,VALUE4,NAME5,VALUE5,NAME6,VALUE6 from DBA_OB_ROOTSERVICE_EVENT_HISTORY where module like '%disaster%';
+----------------------------+-------------------+-----------------------+-----------+-------+---------+-----------------------------------+-------------+------------------+-------------+-------------------+----------------+-----------------------------------------+
| TIMESTAMP                  | MODULE            | EVENT                 | tenant_id | ls_id | NAME3   | VALUE3                            | NAME4       | VALUE4           | NAME5       | VALUE5            | NAME6          | VALUE6                                  |
+----------------------------+-------------------+-----------------------+-----------+-------+---------+-----------------------------------+-------------+------------------+-------------+-------------------+----------------+-----------------------------------------+
| 2023-06-07 16:12:58.254734 | disaster_recovery | start_add_ls_replica  | 1         | 1     | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | destination | "x.x.xx.43:2882" | data_source | "x.x.xx.106:2882" | comment        | add paxos replica according to locality |
| 2023-06-07 16:14:04.202678 | disaster_recovery | finish_add_ls_replica | 1         | 1     | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | destination | "x.x.xx.43:2882" | data_source | "x.x.xx.106:2882" | execute_result | ret:0; elapsed:65947960;                |
+----------------------------+-------------------+-----------------------+-----------+-------+---------+-----------------------------------+-------------+------------------+-------------+-------------------+----------------+-----------------------------------------+
2 rows in set (0.04 sec)

表中的数据表示 Root Service 已经调度的任务，需要关注其中的 event、source 和 destination 等关键字段。

其中 value6 可以看到任务的执行结果，ret 表示该次任务成功与否，elapsed 表示该次任务的执行时间，如果失败，可能会有 ret_comment 字段直接反应失败在哪一步。

视图 oceanbase.DBA_OB_SERVER_EVENT_HISTORY 可以查看 Root Service 已经调度的任务在对应节点上是否被调度及执行情况。例如对上述 task_id 为 YB4206013B6A-0005FC571364EFE0-0-0 的任务进行查询。

obclient> 
select * from DBA_OB_SERVER_EVENT_HISTORY where VALUE5='YB4206013B6A-0005FC571364EFE0-0-0';
+----------------------------+-----------+----------+------------+---------------------------------+-----------+--------+-------+--------+-------+-------------------+-------+------------------+---------+-----------------------------------+-------------------+--------+------------+
| TIMESTAMP                  | SVR_IP    | SVR_PORT | MODULE     | EVENT                           | NAME1     | VALUE1 | NAME2 | VALUE2 | NAME3 | VALUE3            | NAME4 | VALUE4           | NAME5   | VALUE5                            | NAME6             | VALUE6 | EXTRA_INFO |
+----------------------------+-----------+----------+------------+---------------------------------+-----------+--------+-------+--------+-------+-------------------+-------+------------------+---------+-----------------------------------+-------------------+--------+------------+
| 2023-06-07 16:12:58.324433 | x.x.xx.43 |     2882 | storage_ha | ls_ha_start                     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | is_failed         | 0      | ADD_LS_OP  |
| 2023-06-07 16:12:58.325473 | x.x.xx.43 |     2882 | storage_ha | initial_migration_task          | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | is_failed         | 0      | ADD_LS_OP  |
| 2023-06-07 16:12:58.616840 | x.x.xx.43 |     2882 | storage_ha | start_migration_task            | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | data_tablet_count | 830    | ADD_LS_OP  |
| 2023-06-07 16:12:58.642320 | x.x.xx.43 |     2882 | storage_ha | sys_tablets_migration_task      | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | is_failed         | 0      | ADD_LS_OP  |
| 2023-06-07 16:13:03.754195 | x.x.xx.43 |     2882 | storage_ha | data_tablets_migration_task     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | is_failed         | 0      | ADD_LS_OP  |
| 2023-06-07 16:13:04.348244 | x.x.xx.43 |     2882 | storage_ha | tablet_group_migration_task     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | tablet_count      | 101    | ADD_LS_OP  |
| 2023-06-07 16:13:04.360507 | x.x.xx.43 |     2882 | storage_ha | tablet_group_migration_task     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | tablet_count      | 101    | ADD_LS_OP  |
| 2023-06-07 16:13:04.382052 | x.x.xx.43 |     2882 | storage_ha | tablet_group_migration_task     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | tablet_count      | 101    | ADD_LS_OP  |
| 2023-06-07 16:13:04.422866 | x.x.xx.43 |     2882 | storage_ha | tablet_group_migration_task     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | tablet_count      | 101    | ADD_LS_OP  |
| 2023-06-07 16:13:04.425482 | x.x.xx.43 |     2882 | storage_ha | tablet_group_migration_task     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | tablet_count      | 101    | ADD_LS_OP  |
| 2023-06-07 16:13:04.426223 | x.x.xx.43 |     2882 | storage_ha | tablet_group_migration_task     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | tablet_count      | 101    | ADD_LS_OP  |
| 2023-06-07 16:13:04.432973 | x.x.xx.43 |     2882 | storage_ha | tablet_group_migration_task     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | tablet_count      | 101    | ADD_LS_OP  |
| 2023-06-07 16:13:04.433154 | x.x.xx.43 |     2882 | storage_ha | tablet_group_migration_task     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | tablet_count      | 101    | ADD_LS_OP  |
| 2023-06-07 16:13:04.519100 | x.x.xx.43 |     2882 | storage_ha | tablet_group_migration_task     | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | tablet_count      | 22     | ADD_LS_OP  |
| 2023-06-07 16:13:20.152015 | x.x.xx.43 |     2882 | storage_ha | migration_finish_task           | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | is_failed         | 0      | ADD_LS_OP  |
| 2023-06-07 16:13:20.152624 | x.x.xx.43 |     2882 | storage_ha | initial_complete_migration_task | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | is_failed         | 0      | ADD_LS_OP  |
| 2023-06-07 16:14:04.198183 | x.x.xx.43 |     2882 | storage_ha | start_complete_migration_task   | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | is_failed         | 0      | ADD_LS_OP  |
| 2023-06-07 16:14:04.198518 | x.x.xx.43 |     2882 | storage_ha | finish_complete_migration_task  | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | is_failed         | 0      | ADD_LS_OP  |
| 2023-06-07 16:14:04.203593 | x.x.xx.43 |     2882 | storage_ha | ls_ha_finish                    | tenant_id | 1      | ls_id | 1      | src   | "x.x.xx.106:2882" | dst   | "x.x.xx.43:2882" | task_id | YB4206013B6A-0005FC571364EFE0-0-0 | is_failed         | 0      | ADD_LS_OP  |
+----------------------------+-----------+----------+------------+---------------------------------+-----------+--------+-------+--------+-------+-------------------+-------+------------------+---------+-----------------------------------+-------------------+--------+------------+
19 rows in set (0.40 sec)

例如，通过视图 oceanbase.DBA_OB_SERVER_EVENT_HISTORY 查看任务是否被卡住。

获取已经被 Root Service 调度但还没有完成的任务列表（tenant_id、ls_id）。

(select value1, value2 from DBA_OB_ROOTSERVICE_EVENT_HISTORY where event like '%add_ls%') except (select value1, value2 from DBA_OB_SERVER_EVENT_HISTORY where module like 'storage_ha' and event like '%finish_complete%');

获取报错的迁移/复制任务，并进行分析。

select * from DBA_OB_SERVER_EVENT_HISTORY where event like '%migrat%' and name6 like '%fail%' and value6=1;

视图 DBA_OB_LS_REPLICA_TASKS 记录了所有正在运行的迁移/复制/rebuild 任务，如果怀疑某任务有问题，可用 task_id 搜索对应时间段的日志。

排查历史任务报错原因

可以通过以下 SQL 查看某个日志流的迁移/复制/Rebuild 任务执行历史。

select * from DBA_OB_ROOTSERVICE_EVENT_HISTORY 
where module like "%disaster%" and value1 = $TENANT_ID and value2 = $LS_ID;

其中 finish 事件中的 name6 和 value6 记录了任务的执行结果：ret 字段为 0 说明该次任务执行成功，非 0 说明该次任务执行的报错结果；elapsed 字段记录该次任务的执行时长；ret_comment 描述了失败的原因，如果没有失败的报错信息，可以拿对应 task_id 去当时的 Root Service 上搜索相关的日志。

grep "$TASK_ID" rootservice.log*