information_schema.region_peers returns same region_id multiple times

[WenyXu]

What type of bug is this?

Incorrect result

What subsystems are affected?

Table Engine

Minimal reproduce step

CREATE TABLE phy (ts timestamp time index, val double) engine=metric with ("physical_metric_table" = "");
CREATE TABLE t1 (ts timestamp time index, val double, host string primary key) engine = metric with ("on_physical_table" = "phy");
CREATE TABLE t2 (ts timestamp time index, job string primary key, val double) engine = metric with ("on_physical_table" = "phy");
select * from information_schema.region_peers;

What did you expect to see?

+---------------+---------+-----------+-----------+--------+--------------+
| region_id     | peer_id | peer_addr | is_leader | status | down_seconds |
+---------------+---------+-----------+-----------+--------+--------------+
| 4402341478400 |       0 |           | Yes       | ALIVE  |         NULL |
| 4406636445696 |       0 |           | Yes       | ALIVE  |         NULL |
| 4398046511104 |       0 |           | Yes       | ALIVE  |         NULL |
+---------------+---------+-----------+-----------+--------+--------------+

What did you see instead?

+---------------+---------+-----------+-----------+--------+--------------+
| region_id     | peer_id | peer_addr | is_leader | status | down_seconds |
+---------------+---------+-----------+-----------+--------+--------------+
| 4398046511104 |       0 |           | Yes       | ALIVE  |         NULL |
| 4398046511104 |       0 |           | Yes       | ALIVE  |         NULL |
| 4398046511104 |       0 |           | Yes       | ALIVE  |         NULL |
+---------------+---------+-----------+-----------+--------+--------------+

What operating system did you use?

doesn't matter

What version of GreptimeDB did you use?

main

Relevant log output and stack trace

No response

[killme2008]

Looks like it always uses the physical region route info:

greptimedb/src/partition/src/manager.rs

Line 111 in cc2f7ef

.batch_get_physical_table_routes(table_ids)