【show test】Modify replication_num. The result is inconsistent

[lvchenyang-maker]

Steps to reproduce the behavior (Required)

1. CREATE TABLE '...'

   CREATE TABLE `aggregate_table_with_null` ( `k1` date, `k2` datetime, `k3` char(20), `k4` varchar(20), `k5` boolean, `v1` tinyint sum, `v2` smallint sum, `v3` int sum, `v4` bigint max, `v5` largeint max, `v6` float min, `v7` double min, `v8` decimal(27,9) sum ) ENGINE=OLAP AGGREGATE KEY(`k1`, `k2`, `k3`, `k4`, `k5`) COMMENT "OLAP" DISTRIBUTED BY HASH(`k1`, `k2`, `k3`, `k4`, `k5`) BUCKETS 3 PROPERTIES ( "replication_num" = "3", "storage_format" = "v2" );

2. ALTER TABLE '....'

   ALTER TABLE aggregate_table_with_null SET ("replication_num" = "2")

3. SHOW '....'

   ADMIN SHOW REPLICA STATUS FROM aggregate_table_with_null;

Expected behavior (Required)

The result is consistent

Real behavior (Required)

The result is inconsistent

mysql> ADMIN SHOW REPLICA STATUS FROM aggregate_table_with_null;
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
| TabletId | ReplicaId | BackendId | Version | LastFailedVersion | LastSuccessVersion | CommittedVersion | SchemaHash | VersionNum | IsBad | IsSetBadForce | State  | Status |
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
| 2307128  | 2307130   | 321442    | 1       | -1                | 1                  | 1                | 1323381050 | -1         | false | false         | NORMAL | OK     |
| 2307128  | 2307131   | 10007     | 1       | -1                | 1                  | 1                | 1323381050 | 1          | false | false         | NORMAL | OK     |
| 2307132  | 2307134   | 321442    | 1       | -1                | 1                  | 1                | 1323381050 | -1         | false | false         | NORMAL | OK     |
| 2307132  | 2307135   | 10007     | 1       | -1                | 1                  | 1                | 1323381050 | 1          | false | false         | NORMAL | OK     |
| 2307136  | 2307138   | 321442    | 1       | -1                | 1                  | 1                | 1323381050 | -1         | false | false         | NORMAL | OK     |
| 2307136  | 2307139   | 10007     | 1       | -1                | 1                  | 1                | 1323381050 | 1          | false | false         | NORMAL | OK     |
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
6 rows in set (0.00 sec)

mysql> ADMIN SHOW REPLICA STATUS FROM aggregate_table_with_null;
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
| TabletId | ReplicaId | BackendId | Version | LastFailedVersion | LastSuccessVersion | CommittedVersion | SchemaHash | VersionNum | IsBad | IsSetBadForce | State  | Status |
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
| 2307128  | 2307130   | 321442    | 1       | -1                | 1                  | 1                | 1323381050 | -1         | false | false         | NORMAL | OK     |
| 2307132  | 2307134   | 321442    | 1       | -1                | 1                  | 1                | 1323381050 | -1         | false | false         | NORMAL | OK     |
| 2307136  | 2307138   | 321442    | 1       | -1                | 1                  | 1                | 1323381050 | -1         | false | false         | NORMAL | OK     |
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
3 rows in set (0.00 sec)

mysql> ADMIN SHOW REPLICA STATUS FROM aggregate_table_with_null;
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
| TabletId | ReplicaId | BackendId | Version | LastFailedVersion | LastSuccessVersion | CommittedVersion | SchemaHash | VersionNum | IsBad | IsSetBadForce | State  | Status |
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
| 2307128  | 2307141   | 10006     | 1       | -1                | 1                  | 1                | 1323381050 | -1         | false | false         | NORMAL | OK     |
| 2307132  | 2307134   | 321442    | 1       | -1                | 1                  | 1                | 1323381050 | 1          | false | false         | NORMAL | OK     |
| 2307136  | 2307140   | 10007     | 1       | -1                | 1                  | 1                | 1323381050 | 1          | false | false         | NORMAL | OK     |
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
3 rows in set (0.00 sec)

mysql> ADMIN SHOW REPLICA STATUS FROM aggregate_table_with_null;
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
| TabletId | ReplicaId | BackendId | Version | LastFailedVersion | LastSuccessVersion | CommittedVersion | SchemaHash | VersionNum | IsBad | IsSetBadForce | State  | Status |
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
| 2307128  | 2307141   | 10006     | 1       | -1                | 1                  | 1                | 1323381050 | 1          | false | false         | NORMAL | OK     |
| 2307132  | 2307134   | 321442    | 1       | -1                | 1                  | 1                | 1323381050 | 1          | false | false         | NORMAL | OK     |
| 2307136  | 2307140   | 10007     | 1       | -1                | 1                  | 1                | 1323381050 | 1          | false | false         | NORMAL | OK     |
+----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+---------------+--------+--------+
3 rows in set (0.00 sec)

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version()

  +----------------------+
  | current_version()    |
  +----------------------+
  | MAIN-RELEASE d12a28a |
  +----------------------+

[lvchenyang-maker]

meet expectation