[Question]: What's the difference between root service and server of freeze information

[hnwyllmm]

Describe your question

https://open.oceanbase.com/docs/observer-cn/V3.1.3/0000000000162757
这篇文档中描述的，有两张表可以查看转储信息。我在本地做测试发现两张表查出来的数据是不完全相同的，想问下两边的数据区别是什么？

obclient> SELECT * FROM oceanbase. __all_server_event_history WHERE  module IN ('freeze', 'minor_merge') ORDER BY gmt_create  DESC LIMIT 10;
+----------------------------+----------------+----------+--------+-------------------------+-----------+--------+-------+--------+-------+--------+-------+--------+-------+--------+-------+--------+------------+
| gmt_create                 | svr_ip         | svr_port | module | event                   | name1     | value1 | name2 | value2 | name3 | value3 | name4 | value4 | name5 | value5 | name6 | value6 | extra_info |
+----------------------------+----------------+----------+--------+-------------------------+-----------+--------+-------+--------+-------+--------+-------+--------+-------+--------+-------+--------+------------+
| 2022-05-19 17:42:08.445355 | 100.81.215.217 |     2882 | freeze | do minor freeze fail    | tenant_id | 1      | ret   | -4263  |       |        |       |        |       |        |       |        |            |
| 2022-05-19 17:42:08.398877 | 100.81.215.217 |     2882 | freeze | do minor freeze         | tenant_id | 1      |       | NULL   |       |        |       |        |       |        |       |        |            |
| 2022-05-19 17:42:06.448156 | 100.81.215.217 |     2882 | freeze | do minor freeze fail    | tenant_id | 1      | ret   | -4263  |       |        |       |        |       |        |       |        |            |
| 2022-05-19 17:42:06.398550 | 100.81.215.217 |     2882 | freeze | do minor freeze         | tenant_id | 1      |       | NULL   |       |        |       |        |       |        |       |        |            |
| 2022-05-19 17:42:04.447574 | 100.81.215.217 |     2882 | freeze | do minor freeze success | tenant_id | 1      |       | NULL   |       |        |       |        |       |        |       |        |            |
| 2022-05-19 17:42:04.397013 | 100.81.215.217 |     2882 | freeze | do minor freeze         | tenant_id | 1      |       | NULL   |       |        |       |        |       |        |       |        |            |
| 2022-05-19 17:42:02.310378 | 100.81.215.217 |     2882 | freeze | do minor freeze success | tenant_id | 1      |       | NULL   |       |        |       |        |       |        |       |        |            |
| 2022-05-19 17:42:02.260467 | 100.81.215.217 |     2882 | freeze | do minor freeze         | tenant_id | 1      |       | NULL   |       |        |       |        |       |        |       |        |            |
| 2022-05-19 17:42:00.303691 | 100.81.215.217 |     2882 | freeze | do minor freeze success | tenant_id | 1      |       | NULL   |       |        |       |        |       |        |       |        |            |
| 2022-05-19 17:42:00.259343 | 100.81.215.217 |     2882 | freeze | do minor freeze         | tenant_id | 1      |       | NULL   |       |        |       |        |       |        |       |        |            |
+----------------------------+----------------+----------+--------+-------------------------+-----------+--------+-------+--------+-------+--------+-------+--------+-------+--------+-------+--------+------------+
10 rows in set (0.05 sec)


obclient> SELECT * FROM oceanbase.__all_rootservice_event_history WHERE event LIKE '%minor%' ORDER BY gmt_create DESC LIMIT 10;
+----------------------------+--------------+-------------------+-------+--------+-------+------------------------------------------------------------------------------------------------------------------------------------------------+-------+--------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+
| gmt_create                 | module       | event             | name1 | value1 | name2 | value2                                                                                                                                         | name3 | value3 | name4 | value4 | name5 | value5 | name6 | value6 | extra_info | rs_svr_ip      | rs_svr_port |
+----------------------------+--------------+-------------------+-------+--------+-------+------------------------------------------------------------------------------------------------------------------------------------------------+-------+--------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+
| 2022-05-19 17:43:07.819951 | root_service | root_minor_freeze | ret   | -4263  | arg   | {tenant_ids:[], partition_key:{tid:18446744073709551615, partition_id:-1, part_idx:268435455, subpart_idx:268435455}, server_list:[], zone:""} |       |        |       |        |       |        |       |        |            | 100.81.215.217 |        2882 |
| 2022-05-19 17:41:38.044752 | root_service | root_minor_freeze | ret   | -4263  | arg   | {tenant_ids:[], partition_key:{tid:18446744073709551615, partition_id:-1, part_idx:268435455, subpart_idx:268435455}, server_list:[], zone:""} |       |        |       |        |       |        |       |        |            | 100.81.215.217 |        2882 |
| 2022-05-19 17:40:28.728694 | root_service | root_minor_freeze | ret   | -4263  | arg   | {tenant_ids:[], partition_key:{tid:18446744073709551615, partition_id:-1, part_idx:268435455, subpart_idx:268435455}, server_list:[], zone:""} |       |        |       |        |       |        |       |        |            | 100.81.215.217 |        2882 |
+----------------------------+--------------+-------------------+-------+--------+-------+------------------------------------------------------------------------------------------------------------------------------------------------+-------+--------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+

[a1iive]

__all_server_event_history记录 OBServer 级的历史事件，如转储完成、合并完成、切主、执行用户命令等；
__all_rootservice_event_history展示了RS的事件历史。
4.0查询转储信息可以参考https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000886125