【详述】数据查询报这个错,这是什么原因呢要怎么解决
mysql> select count(1) from ilad_sig.sig_detail where dt='2022-12-27';
ERROR 1064 (HY000): version already been compacted. tablet_id: 588270, version: 26882
【背景】做过哪些操作？
【业务影响】
【StarRocks版本】2.4.0
【集群规模】例如：3fe（1 follower+2observer）+3be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【附件】
tablet 信息
mysql> show tablet 588270;
+----------+------------+---------------+------------+-------+---------+-------------+---------+--------+----------------------------------------------------------------+
| DbName | TableName | PartitionName | IndexName | DbId | TableId | PartitionId | IndexId | IsSync | DetailCmd |
+----------+------------+---------------+------------+-------+---------+-------------+---------+--------+----------------------------------------------------------------+
| ilad_sig | sig_detail | v20221227 | sig_detail | 11048 | 139690 | 587807 | 587939 | true | SHOW PROC '/dbs/11048/139690/partitions/587807/587939/588270'; |
+----------+------------+---------------+------------+-------+---------+-------------+---------+--------+----------------------------------------------------------------+
1 row in set (0.02 sec)
mysql> SHOW PROC '/dbs/11048/139690/partitions/587807/587939/588270';
+-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+------------+-----------+--------+-------+---------------+--------------+----------+----------------------------------------------------+------------------------------------------------------------------------------+
| ReplicaId | BackendId | Version | VersionHash | LstSuccessVersion | LstSuccessVersionHash | LstFailedVersion | LstFailedVersionHash | LstFailedTime | SchemaHash | DataSize | RowCount | State | IsBad | IsSetBadForce | VersionCount | PathHash | MetaUrl | CompactionStatus |
+-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+------------+-----------+--------+-------+---------------+--------------+----------+----------------------------------------------------+------------------------------------------------------------------------------+
| 588271 | 11003 | 26882 | 0 | 26882 | 0 | -1 | 0 | NULL | -1 | 2871088655 | 346527253 | NORMAL | false | false | 2 | -1 | http://172.21.33.53:8040/api/meta/header/588270/-1 | http://172.21.33.53:8040/api/compaction/show?tablet_id=588270&schema_hash=-1 |
| 588272 | 11002 | 26882 | 0 | 26882 | 0 | -1 | 0 | NULL | -1 | 2872415800 | 346527253 | NORMAL | false | false | 2 | -1 | http://172.21.33.45:8040/api/meta/header/588270/-1 | http://172.21.33.45:8040/api/compaction/show?tablet_id=588270&schema_hash=-1 |
+-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+------------+-----------+--------+-------+---------------+--------------+----------+----------------------------------------------------+------------------------------------------------------------------------------+
2 rows in set (0.01 sec)
-bash-4.2$ curl http://172.21.33.53:8040/api/compaction/show?tablet_id=588270&schema_hash=-1
[1] 54942
-bash-4.2$ {
"cumulative point": 26899,
"last cumulative failure time": "1970-01-01 08:00:00.000",
"last base failure time": "1970-01-01 08:00:00.000",
"last cumulative success time": "2022-12-27 14:48:01.598",
"last base success time": "2022-12-27 14:45:23.880",
"rowsets": [
"[0-26893] 3 DATA NONOVERLAPPING",
"[26894-26898] 1 DATA NONOVERLAPPING"
],
"stale version path": []
}
[1]+ Done curl http://172.21.33.53:8040/api/compaction/show?tablet_id=588270
-bash-4.2$ curl http://172.21.33.45:8040/api/compaction/show?tablet_id=588270&schema_hash=-1;
[1] 54973
-bash-4.2$ {
"cumulative point": 26899,
"last cumulative failure time": "1970-01-01 08:00:00.000",
"last base failure time": "2022-12-27 15:16:48.771",
"last cumulative success time": "2022-12-27 14:42:30.002",
"last base success time": "2022-12-27 14:03:46.949",
"rowsets": [
"[0-26881] 3 DATA NONOVERLAPPING",
"[26882-26898] 1 DATA NONOVERLAPPING"
],
"stale version path": []
}
[1]+ Done curl http://172.21.33.45:8040/api/compaction/show?tablet_id=588270
-bash-4.2$