Scenarios
You can use the obdiag rca run command to analyze the major_hold scenario based on internal logs and table data of OceanBase Database.
OceanBase Database V4.0.0.0 and later are supported for this feature. When you use obdiag commands, you must configure cluster information in the config.yml file stored in the ~/.obdiag directory or by specifying --config options in the commands.
Notice
Internal table data is updated in real time. Therefore, obdiag only supports the analysis of current data.
Examples
Specify the scenario in the command. obdiag analyzes the root cause of the stuck major compaction based on current data.
obdiag rca run --scene=major_hold
The command only analyzes the root cause and collects effective information. You can post the information in the Q&A module of the OceanBase community forum or send it to OceanBase Technical Support for further diagnostics.
References
For more information, see OceanBase Database Community Edition V4.2.1 takes about 20 hours in a major compaction with 1-TB data and a 10-GB data increase. What do I do to solve this problem?.