http://starrocks.io logo
Join Slack
Powered by
hey, getting tablet doesnot exists while querying:...
# questions-and-troubleshooting
k
hey, getting tablet doesnot exists while querying:
Copy code
StarRocks > select * from facts limit 10;
ERROR 1064 (HY000): failed to get tablet. tablet_id=41230, with schema_hash=1491520976, reason=tablet does not exist backend [id=11001] [
tried out https://github.com/StarRocks/starrocks/blob/main/tools/restore_tablet_tool.sh as well, but tablet is not found in trash
Copy code
root@starrocks-shared-nothing-be-2:/opt/starrocks# curl -X POST "<http://127.0.0.1:8040/api/restore_tablet?tablet_id=41230&schema_hash=147408576>"
{
    "status": "Fail",
    "msg": "can not find tablet path in trash"
}
r
Try to look for the partition id the tablet is in using 
show tablet 41230
and try running 
admin repair facts partition (<partition>)
. Also make sure your 11001 backend is healthy 
show backends;
k
@Robert Raharjo any way to check if the specific tablet exist in backend?
Copy code
StarRocks > show tablet 41230;
+------------+-----------------+-----------------+-----------------+-------+---------+-------------+---------+--------+------------------------------------------------------------+
| DbName     | TableName       | PartitionName   | IndexName       | DbId  | TableId | PartitionId | IndexId | IsSync | DetailCmd                                                  |
+------------+-----------------+-----------------+-----------------+-------+---------+-------------+---------+--------+------------------------------------------------------------+
| paymentops | settlement_fact | settlement_fact | settlement_fact | 28064 | 41227   | 41229       | 41228   | true   | SHOW PROC '/dbs/28064/41227/partitions/41229/41228/41230'; |
+------------+-----------------+-----------------+-----------------+-------+---------+-------------+---------+--------+------------------------------------------------------------+
1 row in set (0.04 sec)

StarRocks > admin repair table settlement_fact partition (settlement_fact);
Query OK, 0 rows affected (0.03 sec)

StarRocks > select * from settlement_fact limit 1;
ERROR 1064 (HY000): failed to get tablet. tablet_id=41230, with schema_hash=1491520976, reason=tablet does not exist backend [id=11001] [
StarRocks > ADMIN SHOW REPLICA STATUS from paymentops.settlement_fact partition (settlement_fact);
ERROR 2027 (HY000): Malformed packet
StarRocks >
also this is happening frequently. tried creating another table and inserted data. no other changes were made but still getting the error:
Copy code
StarRocks > select @@version_comment;
+--------------------+
| @@version_comment  |
+--------------------+
| 4.0.0-rc01-6c87b5f |
+--------------------+
1 row in set (0.11 sec)

StarRocks > select * from kailas_test_2;
ERROR 1064 (HY000): failed to get tablet. tablet_id=54025, with schema_hash=1082520807, reason=tablet does not exist backend [id=11065] [
StarRocks >
are we missing on any common mistake?
Open in Slack
PreviousNext
Powered by