Overview
gv$unit_load_balance_event_history displays the results of replica migrations in the cluster.
Related tables/views
oceanbase.__all_rootservice_event_history
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| gmt_create | TIMESTAMP(6) | No | The time when the replica migration occurred. |
| zone | varchar(256) | No | The zone in which the migration occurred. |
| table_id | varchar(256) | No | The ID of the table. |
| partition_id | varchar(256) | No | The ID of the partition. |
| data_size | varchar(256) | No | The amount of data. |
| replica_type | varchar(256) | No | The type of the replica. |
| src_ip | varchar(256) | No | The IP address of the OBServer where the replica was stored before the migration. |
| src_port | varchar(256) | No | The port number of the OBServer where the replica was stored before the migration. |
| dest_unit_id | varchar(256) | No | The ID of the destination unit. |
| dest_ip | varchar(256) | No | The IP address of the destination OBServer. |
| dest_port | varchar(256) | No | The port number of the destination OBServer. |
| data_src_ip | varchar(256) | No | The source IP address of static data. |
| data_src_port | varchar(256) | No | The source port of static data. |
| result_code | varchar(256) | Yes | The error code for the migration result. |
| result_str | varchar(27) | Yes | The result of the migration. |
| comment | varchar(256) | Yes | The comment. |
| rs_svr_ip | varchar(32) | Yes | The IP address of the OBServer that provides the RootService. |
| rs_svr_port | BIGINT(20) | Yes | The port number of the OBServer that provides RootService. |