It seems not available to access table __all_virtual_server_stat to look up status of my oceanbase cluster, when I connect to DB as the sys tenant. My oceanbase version should be community edition 4.0.
Is there not __all_virtual_server_stat table exist any more, Does anyone have the same issue?
>Solution :
It is possible that the __all_virtual_server_stat table is not available in your OceanBase database, or that you do not have sufficient permissions to access it.
In OceanBase 4.0, the __all_virtual_server_stat table is used to store information about the status of virtual servers in the cluster. This table is only available to the sys tenant, and it is not accessible to other tenants.
If you are unable to access the __all_virtual_server_stat table, it could be due to one of the following reasons:
The table does not exist in your database. This could be due to an issue with your database installation, or it could be that the table has been removed or disabled.
You do not have the necessary permissions to access the table. The sys tenant has full access to all tables in the database, but other tenants may have more limited permissions.
To troubleshoot this issue, you may want to try the following:
Verify that you are connecting to the database as the sys tenant. You can check your current tenant by using the SHOW CURRENT TENANT; command.
Check the database logs for any errors or messages that may be related to the __all_virtual_server_stat table.
Consult the OceanBase documentation or contact OceanBase support for more information about the __all_virtual_server_stat table and how to access it.