This document provides event statistics based on the DBA_OB_ROOTSERVICE_EVENT_HISTORY view. To avoid data duplication, records that also exist in the DBA_OB_TENANT_EVENT_HISTORY view have been excluded.
Disaster recovery
Module |
Event |
Other Records |
Description |
|---|---|---|---|
| disaster_recovery | start_add_ls_replica | tenant_id,ls_id,task_id,destination,data_source,comment | The replica replenishment task is enabled. |
| disaster_recovery | finish_add_ls_replica | tenant_id,ls_id,task_id,destination,data_source,execute_result,comment | The replica replenishment task has ended. |
| disaster_recovery | start_migrate_ls_replica | tenant_id,ls_id,task_id,source,destination,comment | Replica migration task started |
| disaster_recovery | finish_migrate_ls_replica | tenant_id,ls_id,task_id,source,destination,execute_result,comment | Replica migration task completed |
| disaster_recovery | start_type_transform_ls_replica | tenant_id,ls_id,task_id,destination,leader,comment | Replica type conversion task started |
| disaster_recovery | finish_type_transform_ls_replica | tenant_id,ls_id,task_id,destination,leader,execute_result,comment | Replica type conversion task completed |
| disaster_recovery | start_remove_ls_paxos_replica | tenant_id,ls_id,task_id,leader,remove_server,comment | Remove Paxos member replicas |
| disaster_recovery | finish_remove_ls_paxos_replica | tenant_id,ls_id,task_id,leader,remove_server,execute_result,comment | End of removing Paxos member replicas |
| disaster_recovery | start_remove_ls_non_paxos_replic | tenant_id,ls_id,task_id,remove_server,comment | Move non-Paxos member replicas online |
| disaster_recovery | finish_remove_ls_non_paxos_repl | tenant_id,ls_id,task_id,remove_server,execute_result,comment | Move non-Paxos member replicas out of the end |
| disaster_recovery | start_modify_paxos_replica_numbe | tenant_id,ls_id,task_id,destination,change_of_paxos_replica_number,comment | Modify the Paxos replica count of a log stream |
| disaster_recovery | finish_modify_paxos_replica_num | tenant_id,ls_id,task_id,destination,change_of_paxos_replica_number,execute_result,comment | Modified the Paxos replica number of the log stream. |
| disaster_recovery | start_replace_ls_replica | tenant_id,ls_id,task_id,config_version,destination,comment | Record the start event of a log stream replica replacement task. |
| disaster_recovery | finish_replace_ls_replica | tenant_id,ls_id,task_id,config_version,destination,execute_result,comment | Record log stream replica replacement task completion event |
| disaster_recovery | finish_rebuild_ls_replica | tenant_id,ls_id,task_id,source,destination,comment | Record log stream replica reconstruction task completion event |
| disaster_recovery | finish_rebuild_tablet_replica | tenant_id,ls_id,task_id,source,destination,comment | Record tablet replica rebuilding task completion event |
| disaster_recovery | start_rebuild_ls_replica | tenant_id,ls_id,task_id,source,destination,comment | Record the start event of a log stream replica rebuilding task |
| disaster_recovery | rebuild_disable_vote_failed | tenant_id,ls_id,task_id,source,destination,type,result | Record vote failure events during replica rebuilding |
DDL
Module |
Event |
Other Records |
Description |
|---|---|---|---|
| ddl scheduler | check constraint validation task process finish | tenant_id + ret + trace_id, etc. | Records the completion event of a CHECK CONSTRAINT validation task. |
| ddl scheduler | foreign key constraint validation task process finish | tenant_id + ret + trace_id, etc. | Record the completion event of a FOREIGN KEY CONSTRAINT validation task. |
Note
Due to the large number of DDL event types involved and their descriptions covering various DDL operations, they are not listed individually in this document.
Backup
Module |
Event |
Other Records |
Description |
|---|---|---|---|
| backup_data | cancel_backup_data | tenant_id,backup_tenant_id | Records events where a backup task is canceled. |
| backup_data | start_backup_data | tenant_id,ret | Records the event when a backup task starts. |
| backup_data | deal with failed job | tenant_id,job_id,err,trace_id | Record events for processing failed backup jobs |
| backup_data | persist_set_task | tenant_id,job_id | Events for persisting backup task information |
| backup_data | handle_user_tenant_backup_failed | user_tenant_id,ret,trace_id | Record user tenant backup failure handling event |
| backup_data | advance_status | tenant_id,job_id,backup_set_id,curr_status,next_status,ret | Record backup task status transition events |
| backup_data | persist sys ls task succeed | tenant_id,job_id,task_id | Record the successful persistence of system log stream tasks |
| backup_data | backup sys ls meta succeed | tenant_id,job_id,task_id | Record system log stream metadata backup success event |
| backup_data | before_backup_data | tenant_id,job_id,task_id | Record preprocessing events before backing up data |
| backup_data | backup user ls meta succeed | tenant_id,job_id,task_id | Record user log stream metadata backup successful event |
| backup_data | after_backup_consistent_scn | - | Record events after the backup-consistent SCN is determined. |
| backup_data | backup data succeed | tenant_id,job_id,task_id | Record the overall success event of the backup data task. |
| backup_data | after_change_backup_turn_id | tenant_id,backup_status,new_turn_id | Record events after the backup round ID is changed. |
| backup_data | complement_newly_created_ls_ids | tenant_id,task_id,start_scn,end_scn,ls_array | Record the event of creating a new log stream ID |
| backup_data | prepare backup completing log succeed | tenant_id,job_id,task_id | Record backup preparation completion log success event |
| backup_data | cancel backup succeed | tenant_id,job_id,task_id | Record backup cancellation successful event |
| backup | check_backup_task_alive | is_exist,job_id,tenant_id,ls_id,dst,trace_id | Record the backup task liveness check event. |
| log_archive | open_archive_mode | tenant_id,ret | Record the event of enabling log archiving mode |
| log_archive | close_archive_mode | tenant_id,ret | Record close log archiving mode events |
| log_archive | enable_archive | tenant_id,dest_no,round_id,status,path | Record log archiving events |
| log_archive | disable_archive | tenant_id,dest_no,round_id,status,path | Record log archiving disabled event |
| log_archive | defer_archive | tenant_id,dest_no,round_id,status,path | Record delayed archiving events |
| log_archive | change_status | tenant_id,dest_no,old_staus,new_status | Record archive status change events |
Restore
Module |
Event |
Other Records |
Description |
|---|---|---|---|
| physical_restore | restore_start | ret,tenant_name | User initiates a physical restore command |
| physical_restore | change_restore_status | job_id,tenant_name,status | Physical restore status change |
| physical_restore | restore_finish | restore_stauts,tenant_name | Physical restore task completion event |
| import_table | reconstruct_ref_constraint | tenant_id,job_id | Rebuild referential constraints during table import |
| import_table | import table finish | tenant_id,job_id | Table import task completion event |
| import_table | generate import table task | tenant_id,job_id, task_cnt | Generate import table task event |
| import_table | import table task finish | tenant_id,job_id | Single import table subtask completion event |
| import_table | cancel import table task | tenant_id,job_id | Cancel import table task event |
| recover_table | start_recover_table | tenant_id,job_id,ret,trace_id | Table restore task start event |
| recover_table | cancel_recover_table | result,tenant_id | Cancel table restore task event |
| recover_table | recover_table_failed | tenant_id,job_id,err,trace_id | Table restore task failure event |
| recover_table | advance_status | tenant_id,job_id,cur_status,next_status | Table restore task status progression events |
| recover_table | insert_user_job | tenant_id,job_id | Insert user recovery job event |
| recover_table | sys_wait_user_recover_finish | tenant_id,job_id | System waiting for user to complete recovery event |
| recover_table | sys_recover_finish | tenant_id,job_id | System waiting for user to complete recovery event |
| recover_table | drop_aux_tenant | tenant_id,job_id,aux_tenant_name | Delete secondary tenant event |
| recover_table | cancel recover job finish | tenant_id,job_id | Cancel restore job completion event |
| recover_table | restore_aux_tenant_finish | tenant_id,job_id,aux_tenant_name | Restore secondary tenant completed event |
| recover_table | generate_import_job | tenant_id,job_id,import_job_id | Generate import job events |
| recover_table | import job finish | tenant_id,job_id,import_job_id | Import job completed event |
| recover_table | recover table job finish | tenant_id,job_id | Table restore job completed event |
Clone
Module |
Event |
Other Records |
Description |
|---|---|---|---|
| clone | clone_start | job_id,ret,clone_tenant_name,source_tenant_name | Tenant cloning progress started |
| clone | change_clone_status | job_id,ret,prev_clone_status,cur_clone_status | Tenant cloning progress |
| clone | clone_sys_finish | job_id,ret,cur_clone_status | Successfully cloned the system log stream. |
| clone | clone_ls_replica_failed | job_id,ls_restore_status,ls_id,server | Failed to clone log stream. |
| clone | clone_user_finish | job_id,ret,cur_clone_status | Successfully cloned the user log stream. |
| clone | clone_recycle_failed_job_finish | job_id,ret,cur_clone_status | Recycle jobs that failed to clone |
Upgrade
Module |
Event |
Other Records |
Description |
|---|---|---|---|
| upgrade | begin_upgrade_post | trace_id,action | Post phase of upgrade start |
| upgrade | finish_upgrade_post | trace_id,ret | End of post phase |
| upgrade | begin_upgrade_post_action | tenant_id,version | A tenant has entered the post-upgrade phase. |
| upgrade | begin_upgrade_begin_write_log | tenant_id | Upgrade start log for tenant writing |
| upgrade | finish_upgrade_begin_write_log | tenant_id,ret,tmp_ret,cost | Upgrade start log end |
| upgrade | finish_upgrade_begin_wait_all | ret, cost | Wait for GTS to push upgrade start log |
| upgrade | begin_upgrade_system_variable | tenant_id | Start upgrading tenant system variables |
| upgrade | finish_upgrade_system_variable | tenant_id,ret,tmp_ret,cost | Tenant system variable upgrade completed |
| upgrade | begin_upgrade_system_table | tenant_id | Upgrade tenant system tables |
| upgrade | finish_upgrade_system_table | tenant_id,ret,tmp_ret,cost | Tenant system table upgrade completed |
| upgrade | begin_upgrade_virtual_schema | tenant_id | Upgrade tenant's virtual table |
| upgrade | finish_upgrade_virtual_schema | tenant_id,ret,tmp_ret,cost | Virtual table upgrade completed |
| upgrade | begin_upgrade_system_package | tenant_id | Upgrade tenant system tables |
| upgrade | finish_upgrade_system_package | tenant_id,ret,tmp_ret,cost | System table upgrade completed |
| upgrade | begin_upgrade_all_post_action | tenant_id | Full-phase post-migration started |
| upgrade | finish_upgrade_all_post_action | tenant_id,ret,tmp_ret,cost | The full-phase post-upgrade is complete. |
| upgrade | begin_upgrade_inspection | tenant_id | Tenant election started |
| upgrade | finish_upgrade_inspection | tenant_id,ret,tmp_ret,cost | Tenant inspection completed |
| upgrade | begin_check_sys_table_schemas | tenant_id | Check tenant system tables |
| upgrade | finish_check_sys_table_schemas | tenant_id,ret,tmp_ret,cost | End of checking tenant system tables |
| upgrade | begin_upgrade_end | tenant_id | Write upgrade end log |
| upgrade | finish_upgrade_end | tenant_id,ret,tmp_ret,cost | Upgrade complete |
| upgrade | begin_upgrade_finish | tenant_id | Start pushing the version number, etc. |
| upgrade | finish_upgrade_finish | tenant_id,ret,tmp_ret,cost | Upgrade completed |
Resource management
Module |
Event |
Other Records |
Description |
|---|---|---|---|
| server | last_offline_time set | server | Set server offline time |
| server | last_offline_time reset | server | Time since server went offline |
| server | disk error repaired, start server | server | Because after a server disk failure, the RS backend initiates a stop server command, and the server needs to be started again after the disk failure period expires. |
| server | disk error, stop server | server | After a server disk failure, the RS backend initiates a stop server |
| server | permanent_offline | server | The server has been down for a long enough time and is permanently offline. |
| server | lease_expire | server | No heartbeat received within 10 seconds; the server may be offline. |
| server | online | server | Server re-launch |
| server | rootserver | server | The server is elected as the RS. |
| server | build_version | server | The build_version reported by the server has changed. |
| server | start_service | server | Update of the service availability period |
| unit | alter_resource_unit | name,unit_config_id,old_resource,new_resource | Modify unit specification |
| unit | drop_resource_unit | name | Delete unit specification |
| unit | clone_resource_pool/create_resource_pool | name,unit,zone_list,source_tenant_id | Create resource_pool |
| unit | split_pool | unit_id,server,prev_pool_id,curr_pool_id | Split resource_pool |
| unit | merge_pool | unit_id,server,prev_pool_id,curr_pool_id | Merged resource_pool |
| unit | alter_resource_pool | name | Modify resource_pool |
| unit | drop_resource_pool | name | Delete resource_pool |
| unit | create_unit | unit_id,server | Create a new unit. |
| unit | migrate_unit | unit_id,migrate_from_server,server,tenant_id,manual_migrate | migration unit |
| unit | finish_migrate_unit | unit_id,end_op,migrate_from_server,server,tenant_id,manual_migrate | Unit migration completed |
| unit | drop_unit | unit_id | Delete unit |
| zone | add_zone | zone | New zone |
| zone | delete_zone | zone | Delete zone |
| zone | start_zone | zone | Enable zone services |
| zone | stop_zone | zone | Stop replicas in a zone |
| zone | alter_zone | zone,region,idc,zone_type | Modify zone |
| storage | add_storage | path,use_for,zone,wait_type,max_iops,max_bandwidth | Add shared storage directory for zone |
| storage | drop_storage | path,use_for,zone,wait_type | Delete shared storage directory |
| storage | alter storage authorization | path,wait_type | Modify shared storage directory |
| storage | alter storage attribute | path,wait_type,attribute | Modify shared storage directory properties |
Inspection
Module |
Event |
Other Records |
Description |
|---|---|---|---|
| inspector | tenant_checker | the tenant may be in the process of creating,if the error reports continuously,please check | An inspection found a garbage tenant being created. |
| inspector | check_part_option | tenant_id,part_option | Table partitions within the table group are inconsistent. |
| inspector | tablegroup_checker/system_schema_checker/system_schema_checker | info | Inspection result |
RS related
Module |
Event |
Other Records |
Description |
|---|---|---|---|
| root_service | update_primary_ip_list | tenant_id,info | Update upstream from network standby database |
| root_service | start_rootservice | addr | RS started the term |
| root_service | finish_start_rootservice | result,addr | RS end of term |
| root_service | full_rootservice | result, addr | RS can provide services |
| root_service | stop_rootservice | addr | RS resignation |
| root_service | finish_stop_thread | addr | RS abdication completed |
| root_service | finish_wait_stop | addr | RS waiting for background thread to end |
| root_service | create_resource_unit | ret + arg | Create resource pool specification |
| root_service | alter_resource_unit | ret + arg | Modify resource pool specification |
| root_service | drop_resource_unit | ret + arg | Delete resource pool specification |
| root_service | clone_resource_pool | ret + arg | Resource pool of the cloned tenant |
| root_service | create_resource_pool | ret + arg | Create resource pool |
| root_service | split_resource_pool | ret + arg | Split resource pool |
| root_service | alter_resource_tenant | ret + arg | Modify tenant resource pool |
| root_service | merge_resource_pool | ret + arg | Merge resource pool |
| root_service | alter_resource_pool | ret + arg | Modify resource pool |
| root_service | drop_resource_pool | ret + arg | Delete resource pool |
| root_service | root_minor_freeze | ret + arg | Trigger a minor compaction |
| root_service | admin_load_baseline | ret + arg | Trigger load plan baseline |
| root_service | admin_sync_rewrite_rules | ret + arg | Record events of RootService executing management commands to synchronize SQL rewrite rules |
| root_service | add_server | ret + arg | Add server |
| root_service | delete_server | ret + arg | Delete node |
| root_service | cancel_delete_server | ret + arg | Cancel deletion of node |
| root_service | add_zone | ret + arg | Add zone |
| root_service | delete_zone | ret + arg | Delete zone |
| root_service | start_zone | ret + arg | Start zone service |
| root_service | alter_zone | ret + arg | Modify zone status |
| root_service | admin_switch_replica_role | ret + arg | Modify the role information of a log stream. |
| root_service | admin_flush_cache | ret + arg | User-triggered cleanup of KVCache |
| root_service | admin_refresh_schema | ret + arg | User-triggered schema refresh |
| root_service | admin_refresh_memory_stat | ret + arg | Record events of RootService executing management commands to refresh memory statistics |
| root_service | admin_wash_memory_fragmentation | ret + arg | Record events of RootService executing management commands to clean up memory fragmentation |
| root_service | admin_refresh_io_calibration | ret + arg | Record events of RootService executing management commands to refresh I/O calibration information |
| root_service | admin_set_config | ret + arg | Modify parameter |
| root_service | clear_merge_error | ret + arg | Error occurred during major compaction cleanup |
| root_service | admin_add_arbitration_service | ret + arg | Add an arbitration node |
| root_service | admin_remove_arbitration_service | ret + arg | Delete an arbitration node |
| root_service | admin_replace_arbitration_service | ret + arg | Replace an arbitration node |
| root_service | admin_migrate_unit | ret + arg | User-triggered unit migration |
| root_service | admin_upgrade_virtual_schema | ret + arg | Trigger virtual table upgrade |
| root_service | admin_upgrade_cmd | ret + arg | Execute the upgrade command. |
| root_service | admin_rolling_upgrade_cmd | ret + arg | Rollout upgrade started |
| root_service | admin_run_job | ret + arg | User-triggered O&M commands |
| root_service | admin_run_upgrade_job | ret + arg | User-triggered upgrade |
| root_service | refresh_time_zone_info | ret + arg | Refresh time zone |
Others
Module |
Event |
Other Records |
Description |
|---|---|---|---|
| remove_tenant | remove_tenant | tenant_id + server_addr | Underlying unit GC. Printed when tenant resources are released. |
| remove_tenant | remove_tenant | tenant_id + server_addr | Underlying unit GC. Printed when tenant resources are released. |
| major_merge | root_major_freeze | tenant_id,ret,new_frozen_scn,freeze_reason | Concurrent major compaction for tenants |
| daily_merge | verification | tenant_id,check verification fail,global_broadcast_scn,service_addr | Check whether major compaction of tenants is completed |
| daily_merge | merge_process | tenant_id, check merge progress fail,global_broadcast_scn, service_addr | Failed to update the major compaction status during the major compaction process. |
| daily_merge | merging | tenant_id,global_broadcast_scn,zone | Tenant major compaction progress statistics |
| daily_merge | start_merge | tenant_id,zone, global_broadcast_scn | Major compaction starts in a zone of the tenant |
| daily_merge | global_merged | tenant_id,global_broadcast_scn | Tenant major compaction completed |
| daily_merge | set_zone_merging | tenant_id, zone | Initiate a major compaction for a zone |