MySQL [oceanbase]> select * from __all_tablet_meta_table where tenant_id = 1001 and report_scn < 1716466470749632455; Empty set (0.25 sec) MySQL [oceanbase]> MySQL [oceanbase]> select * from __all_tenant; select * from cdb_ob_ls_locations; +----------------------------+----------------------------+-----------+-------------+-------------------+-------------------+--------+----------------+---------------+---------------------------------------------+-------------------+-----------------------+--------------------+------------------+--------+---------------+----------------------------+ | gmt_create | gmt_modified | tenant_id | tenant_name | zone_list | primary_zone | locked | collation_type | info | locality | previous_locality | default_tablegroup_id | compatibility_mode | drop_tenant_time | status | in_recyclebin | arbitration_service_status | +----------------------------+----------------------------+-----------+-------------+-------------------+-------------------+--------+----------------+---------------+---------------------------------------------+-------------------+-----------------------+--------------------+------------------+--------+---------------+----------------------------+ | 2024-04-25 16:25:27.840469 | 2024-05-22 11:11:39.767627 | 1 | sys | zone1;zone2;zone3 | zone1;zone2;zone3 | 0 | 0 | system tenant | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | -1 | 0 | -1 | NORMAL | 0 | DISABLED | | 2024-04-29 14:21:10.399081 | 2024-05-22 14:34:11.862293 | 1001 | META$1002 | zone1;zone2;zone3 | zone1;zone2;zone3 | 0 | 0 | | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | -1 | 0 | -1 | NORMAL | 0 | DISABLED | | 2024-04-29 14:21:10.411576 | 2024-05-22 14:34:11.858166 | 1002 | mysql_ob | zone1;zone2;zone3 | zone1;zone2;zone3 | 0 | 0 | | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | -1 | 0 | -1 | NORMAL | 0 | DISABLED | | 2024-05-08 14:37:59.438291 | 2024-05-22 14:34:12.041335 | 1003 | META$1004 | zone1;zone2;zone3 | zone1;zone2;zone3 | 0 | 0 | | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | -1 | 0 | -1 | NORMAL | 0 | DISABLED | | 2024-05-08 14:37:59.467191 | 2024-05-22 14:34:12.039774 | 1004 | oratnt | zone1;zone2;zone3 | zone1;zone2;zone3 | 0 | 0 | | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | -1 | 1 | -1 | NORMAL | 0 | DISABLED | +----------------------------+----------------------------+-----------+-------------+-------------------+-------------------+--------+----------------+---------------+---------------------------------------------+-------------------+-----------------------+--------------------+------------------+--------+---------------+----------------------------+ 5 rows in set (0.01 sec) +----------------------------+----------------------------+-----------+-------+---------------+----------+----------+-------+----------+-------------------------------------------------------------------------------------------------------------+----------------------+--------------+--------------+---------+ | CREATE_TIME | MODIFY_TIME | TENANT_ID | LS_ID | SVR_IP | SVR_PORT | SQL_PORT | ZONE | ROLE | MEMBER_LIST | PAXOS_REPLICA_NUMBER | REPLICA_TYPE | LEARNER_LIST | REBUILD | +----------------------------+----------------------------+-----------+-------+---------------+----------+----------+-------+----------+-------------------------------------------------------------------------------------------------------------+----------------------+--------------+--------------+---------+ | 2024-05-24 10:23:38.692910 | 2024-05-24 10:23:38.692910 | 1 | 1 | 10.186.64.161 | 2882 | 2881 | zone1 | LEADER | 10.186.64.161:2882:1716179579188143,10.186.64.162:2882:1716259557207207,10.186.64.163:2882:1716261281557584 | 3 | FULL | | FALSE | | 2024-05-24 10:23:38.692910 | 2024-05-24 10:23:38.692910 | 1 | 1 | 10.186.64.162 | 2882 | 2881 | zone2 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-24 10:23:38.692910 | 2024-05-24 10:23:38.692910 | 1 | 1 | 10.186.64.163 | 2882 | 2881 | zone3 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-06 16:37:17.773440 | 2024-05-23 16:20:00.878678 | 1001 | 1 | 10.186.64.161 | 2882 | 2881 | zone1 | LEADER | 10.186.64.161:2882:1714984637659732,10.186.64.162:2882:1716259322114879,10.186.64.163:2882:1716261046287386 | 3 | FULL | | FALSE | | 2024-05-21 10:42:02.285130 | 2024-05-22 14:34:16.583798 | 1001 | 1 | 10.186.64.162 | 2882 | 2881 | zone2 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-21 11:10:46.467507 | 2024-05-22 10:54:15.313564 | 1001 | 1 | 10.186.64.163 | 2882 | 2881 | zone3 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-06 16:37:17.883860 | 2024-05-23 16:20:01.218937 | 1002 | 1 | 10.186.64.161 | 2882 | 2881 | zone1 | LEADER | 10.186.64.161:2882:1714984637681594,10.186.64.162:2882:1716259322130972,10.186.64.163:2882:1716261046301096 | 3 | FULL | | FALSE | | 2024-05-21 10:42:02.487400 | 2024-05-22 14:34:18.298999 | 1002 | 1 | 10.186.64.162 | 2882 | 2881 | zone2 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-21 11:10:46.595446 | 2024-05-22 10:54:15.356988 | 1002 | 1 | 10.186.64.163 | 2882 | 2881 | zone3 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-06 16:37:18.002381 | 2024-05-23 16:20:09.743513 | 1002 | 1001 | 10.186.64.161 | 2882 | 2881 | zone1 | LEADER | 10.186.64.161:2882:1714984637703245,10.186.64.162:2882:1716259322147957,10.186.64.163:2882:1716261046317235 | 3 | FULL | | FALSE | | 2024-05-21 10:42:02.675232 | 2024-05-23 16:20:00.919074 | 1002 | 1001 | 10.186.64.162 | 2882 | 2881 | zone2 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-21 11:10:46.890435 | 2024-05-22 10:54:15.999065 | 1002 | 1001 | 10.186.64.163 | 2882 | 2881 | zone3 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-08 14:38:04.744436 | 2024-05-23 16:20:00.899373 | 1003 | 1 | 10.186.64.161 | 2882 | 2881 | zone1 | LEADER | 10.186.64.161:2882:1,10.186.64.162:2882:1716259557264493,10.186.64.163:2882:1716261281614869 | 3 | FULL | | FALSE | | 2024-05-21 10:45:57.523360 | 2024-05-23 16:19:56.548488 | 1003 | 1 | 10.186.64.162 | 2882 | 2881 | zone2 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-21 11:14:41.818090 | 2024-05-22 14:34:17.329571 | 1003 | 1 | 10.186.64.163 | 2882 | 2881 | zone3 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-08 14:39:00.861628 | 2024-05-23 16:20:01.502584 | 1004 | 1 | 10.186.64.161 | 2882 | 2881 | zone1 | LEADER | 10.186.64.161:2882:1,10.186.64.162:2882:1716259557277270,10.186.64.163:2882:1716261281631464 | 3 | FULL | | FALSE | | 2024-05-21 10:45:57.676808 | 2024-05-23 16:20:00.919074 | 1004 | 1 | 10.186.64.162 | 2882 | 2881 | zone2 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-21 11:14:41.980907 | 2024-05-22 14:34:16.477728 | 1004 | 1 | 10.186.64.163 | 2882 | 2881 | zone3 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-08 14:40:16.522976 | 2024-05-23 16:20:00.819826 | 1004 | 1001 | 10.186.64.161 | 2882 | 2881 | zone1 | LEADER | 10.186.64.161:2882:1,10.186.64.162:2882:1716259557290637,10.186.64.163:2882:1716261281646419 | 3 | FULL | | FALSE | | 2024-05-21 10:45:57.819954 | 2024-05-22 14:34:17.828133 | 1004 | 1001 | 10.186.64.162 | 2882 | 2881 | zone2 | FOLLOWER | NULL | NULL | FULL | | FALSE | | 2024-05-21 11:14:42.207189 | 2024-05-22 14:34:16.695234 | 1004 | 1001 | 10.186.64.163 | 2882 | 2881 | zone3 | FOLLOWER | NULL | NULL | FULL | | FALSE | +----------------------------+----------------------------+-----------+-------+---------------+----------+----------+-------+----------+-------------------------------------------------------------------------------------------------------------+----------------------+--------------+--------------+---------+ 21 rows in set (0.17 sec) MySQL [oceanbase]>