tablet version not found 2023-11-17问题反馈
输入“/”快速插入
tablet version not found 2023-11-17问题反馈
飞书用户61082023年11月7日创建
基本信息：
5个物理机fe和be混部（物理机 配置 104C 384GB内存）
SR版本：2.3.16
报错信息 业务反馈时间：2023-11-17 16:51
1、show tablet xx;
mysql> show tablet 992358406;
+------------------------+---------------------------------------+---------------------------------------+---------------------------------------+-------+-----------+-------------+-----------+--------+----------------------------------------------------------------------------+
| DbName | TableName | PartitionName | IndexName | DbId | TableId | PartitionId | IndexId | IsSync | DetailCmd |
+------------------------+---------------------------------------+---------------------------------------+---------------------------------------+-------+-----------+-------------+-----------+--------+----------------------------------------------------------------------------+
| default_cluster:ads_ec | s_ec_sa_dy_qc_account_promotion_d_sum | s_ec_sa_dy_qc_account_promotion_d_sum | s_ec_sa_dy_qc_account_promotion_d_sum | 14915 | 992358349 | 992358348 | 992358351 | true | SHOW PROC '/dbs/14915/992358349/partitions/992358348/992358351/992358406'; |
+------------------------+---------------------------------------+---------------------------------------+---------------------------------------+-------+-----------+-------------+-----------+--------+----------------------------------------------------------------------------+
1 row in set (0.00 sec)
2、show frontends;
+-----------------------------------+----------------+-------------+----------+-----------+---------+----------+----------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+----------------+
| Name | IP | EditLogPort | HttpPort | QueryPort | RpcPort | Role | IsMaster | ClusterId | Join | Alive | ReplayedJournalId | LastHeartbeat | IsHelper | ErrMsg | StartTime | Version |
+-----------------------------------+----------------+-------------+----------+-----------+---------+----------+----------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+----------------+
| 192.168.39.107_9010_1665993377832 | 192.168.39.107 | 9010 | 8030 | 9030 | 9020 | OBSERVER | false | 1077617265 | true | true | 601627019 | 2023-11-17 16:56:17 | false | | 2023-08-26 22:25:35 | 2.3.16-a5ba4dd |
| 192.168.39.105_9010_1654657548466 | 192.168.39.105 | 9010 | 8030 | 9030 | 9020 | FOLLOWER | false | 1077617265 | true | true | 601627019 | 2023-11-17 16:56:17 | true | | 2023-11-11 02:14:14 | 2.3.16-a5ba4dd |
| 192.168.39.106_9010_1654657549520 | 192.168.39.106 | 9010 | 8030 | 9030 | 9020 | FOLLOWER | true | 1077617265 | true | true | 601627048 | 2023-11-17 16:56:17 | true | | 2023-11-10 08:05:16 | 2.3.16-a5ba4dd |
| 192.168.39.104_9010_1654657424666 | 192.168.39.104 | 9010 | 8030 | 9030 | 9020 | FOLLOWER | false | 1077617265 | true | true | 601627019 | 2023-11-17 16:56:17 | true | | 2023-08-26 22:23:56 | 2.3.16-a5ba4dd |
| 192.168.39.108_9010_1688094709050 | 192.168.39.108 | 9010 | 8030 | 9030 | 9020 | OBSERVER | false | 1077617265 | true | true | 601627019 | 2023-11-17 16:56:17 | false | | 2023-08-26 22:26:22 | 2.3.16-a5ba4dd |
+-----------------------------------+----------------+-------------+----------+-----------+---------+----------+----------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+----------------+
5 rows in set (0.04 sec)
3、show backends;
+-----------+-----------------+----------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+----------------+--------------------------------------------------------+-------------------+-------------+----------+
| BackendId | Cluster | IP | HeartbeatPort | BePort | HttpPort | BrpcPort | LastStartTime | LastHeartbeat | Alive | SystemDecommissioned | ClusterDecommissioned | TabletNum | DataUsedCapacity | AvailCapacity | TotalCapacity | UsedPct | MaxDiskUsedPct | ErrMsg | Version | Status | DataTotalCapacity | DataUsedPct | CpuCores |
+-----------+-----------------+----------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+----------------+--------------------------------------------------------+-------------------+-------------+----------+
| 11032 | default_cluster | 192.168.39.105 | 9050 | 9060 | 8040 | 8060 | 2023-11-11 02:13:33 | 2023-11-17 16:56:27 | true | false | false | 345709 | 838.226 GB | 12.538 TB | 15.471 TB | 18.96 % | 20.27 % | | 2.3.16-a5ba4dd | {"lastSuccessReportTabletsTime":"2023-11-17 16:55:34"} | 13.356 TB | 6.13 % | 104 |
| 11033 | default_cluster | 192.168.39.106 | 9050 | 9060 | 8040 | 8060 | 2023-11-11 02:13:33 | 2023-11-17 16:56:27 | true | false | false | 341419 | 829.301 GB | 12.223 TB | 15.471 TB | 21.00 % | 21.77 % | | 2.3.16-a5ba4dd | {"lastSuccessReportTabletsTime":"2023-11-17 16:55:41"} | 13.033 TB | 6.21 % | 104 |
| 6743399 | default_cluster | 192.168.39.107 | 9050 | 9060 | 8040 | 8060 | 2023-11-11 02:13:33 | 2023-11-17 16:56:27 | true | false | false | 345173 | 839.551 GB | 12.506 TB | 15.471 TB | 19.17 % | 19.97 % | | 2.3.16-a5ba4dd | {"lastSuccessReportTabletsTime":"2023-11-17 16:55:36"} | 13.326 TB | 6.15 % | 104 |
| 511597239 | default_cluster | 192.168.39.108 | 9050 | 9060 | 8040 | 8060 | 2023-08-26 22:48:46 | 2023-11-17 16:56:27 | true | false | false | 317009 | 713.790 GB | 11.001 TB | 15.471 TB | 28.90 % | 30.64 % | | 2.3.16-a5ba4dd | {"lastSuccessReportTabletsTime":"2023-11-17 16:56:02"} | 11.698 TB | 5.96 % | 128 |
| 11002 | default_cluster | 192.168.39.104 | 9050 | 9060 | 8040 | 8060 | 2023-11-11 02:13:33 | 2023-11-17 16:56:27 | true | false | false | 346091 | 828.171 GB | 12.367 TB | 15.471 TB | 20.06 % | 21.14 % | | 2.3.16-a5ba4dd | {"lastSuccessReportTabletsTime":"2023-11-17 16:56:03"} | 13.176 TB | 6.14 % | 104 |
+-----------+-----------------+----------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+----------------+--------------------------------------------------------+-------------------+-------------+----------+
5 rows in set (0.03 sec)
4、记录 DetailCmd信息 SHOW PROC （在leader节点执行）
+-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+----------------------------------------------------------------+------------------------------------------------------------------------------------------+
| ReplicaId | BackendId | Version | VersionHash | LstSuccessVersion | LstSuccessVersionHash | LstFailedVersion | LstFailedVersionHash | LstFailedTime | SchemaHash | DataSize | RowCount | State | IsBad | IsSetBadForce | VersionCount | PathHash | MetaUrl | CompactionStatus |
+-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+----------------------------------------------------------------+------------------------------------------------------------------------------------------+
| 992358408 | 11032 | 2 | 0 | 2 | 0 | -1 | 0 | NULL | 634759493 | 1243990 | 18855 | NORMAL | false | false | 2 | 847337717580051071 | http://192.168.39.105:8040/api/meta/header/992358406/634759493 | http://192.168.39.105:8040/api/compaction/show?tablet_id=992358406&schema_hash=634759493 |
| 992358409 | 11002 | 2 | 0 | 2 | 0 | -1 | 0 | NULL | 634759493 | 1243990 | 18855 | NORMAL | false | false | 2 | 4237236482707069341 | http://192.168.39.104:8040/api/meta/header/992358406/634759493 | http://192.168.39.104:8040/api/compaction/show?tablet_id=992358406&schema_hash=634759493 |
| 992358870 | 6743399 | 2 | 0 | 2 | 0 | -1 | 0 | NULL | 634759493 | 0 | 0 | NORMAL | false | false | 1 | -5000329112734460547 | http://192.168.39.107:8040/api/meta/header/992358406/634759493 | http://192.168.39.107:8040/api/compaction/show?tablet_id=992358406&schema_hash=634759493 |
+-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+----------------------------------------------------------------+------------------------------------------------------------------------------------------+
3 rows in set (0.02 sec)