The exception handling feature displays the abnormal events that have occurred or are occurring in the database cluster in the last 3 days. You can use this feature to quickly obtain the health status of the cluster and, when abnormal events occur, perform root cause analysis to pinpoint the cause of the problem.
View the list of abnormal events for all instances
Log on to the ApsaraDB for OceanBase console.
In the left-side navigation pane, choose Autonomy Service > Exception Handling.
In the Abnormal Events section, view the list of abnormal events for all instances.
By default, the system displays all abnormal events in the last 3 days, including those that are still ongoing and those that have been restored. Currently, the following types of abnormal events are supported: Node CPU Exception, Tenant CPU Exception, Tenant SQL Queue Wait Time Exception, Data Disk I/O Usage Exception, Tenant Active Session Count Exception, and Tenant Disk I/O Time Exception.
View abnormal events for a single instance
In the Abnormal Events section, view the Root Cause Analysis in the Operation column of the target instance.
The system automatically redirects to the Exception Handling page of the diagnostics center.
In the Abnormal Events section, view abnormal events of the target instance, including Object, Exception Type, Abnormal Performance, Current Status, Occurrence Time, Recovery Time, Duration, and Operation.
Click the Root Cause Analysis in the Operation column of a single abnormal event to view the root cause analysis and optimization suggestions for the abnormal event.
If the cause of the abnormal event is in the analysis graph, the system will highlight the cause in red and provide optimization suggestions.
NoteIn the analysis graph, each node represents an analysis rule. When performing root cause analysis, the system traverses the graph to find the root cause node. The root cause node is highlighted in red, while the green node indicates that the rule does not hit the root cause.
If the cause of the abnormal event is not in the analysis graph, the system will provide optimization suggestions in the Solution section.
The following is an example:
Upon detecting Tenant CPU Exception, the system will still display the analysis graph and provide optimization suggestions in the Solution section.
