Purpose
gv$unit_load_balance_event_history displays the results of replica migrations in the cluster.
Related tables/views
oceanbase.__all_rootservice_event_history
Fields
| Field | 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 replica type. Valid values: |
| src_ip | varchar(256) | NO | The IP address of the OBServer node where the replica was stored before the migration. |
| src_port | varchar(256) | NO | The port number of the OBServer node 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 node. |
| dest_port | varchar(256) | NO | The port number of the destination OBServer node. |
| 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 | Remarks |
| rs_svr_ip | varchar(32) | YES | The IP address of the OBServer node that provides the RootService. |
| rs_svr_port | bigint(20) | YES | The port number of the OBServer node that provides RootService. |