查询超时问题

💬 StarRocks 用户问答 常见 FAQ
#1

image
image1814×158 84.7 KB

W0207 21:33:24.304175 69495 fragment_mgr.cpp:194] Fail to open fragment 6264e80b-881a-11ec-8a27-1267ed271837: Internal error: [172.29.160.196] fail to prepare tablet reader 10443.1820923224.904104f3e17f4004-dd138841317d8d93: Timeout: wait_for_version timeout(60002ms) version:57 tablet:10443 #version:1 [51.1 51.1@0 51.1] pending:53,54,55,56,57, rowsets:1[id/seg/row/del/byte/compaction]: [50/1/3137/0/312.74 KB/31.69 MB]

#2

请问下使用的是哪个版本？

#3

目前使用的是最新版

#4

2.0.1版本吗？是只有一个表有这个问题？是一直有问题还是偶尔？
连接master fe执行show tablet 10443看下

image
image2524×672 63 KB

执行下上图的命令，结果如下图
image
image2528×1116 291 KB

再curl 下上面的MetaUrl，发下结果

#5

image
image1816×548 174 KB

#6

{
“table_id”: 10431,
“partition_id”: 10430,
“tablet_id”: 10443,
“schema_hash”: 1820923224,
“shard_id”: 170,
“creation_time”: 1644238746,
“cumulative_layer_point”: -1,
“tablet_state”: “PB_RUNNING”,
“schema”: {
“keys_type”: “PRIMARY_KEYS”,
“column”: [
{
“unique_id”: 0,
“name”: “id”,
“type”: “VARCHAR”,
“is_key”: true,
“aggregation”: “NONE”,
“is_nullable”: false,
“precision”: 0,
“frac”: 0,
“length”: 34,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 1,
“name”: “channel”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 2,
“name”: “business_type”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 3,
“name”: “source”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 4,
“name”: “user_id”,
“type”: “VARCHAR”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 34,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 5,
“name”: “real_name”,
“type”: “VARCHAR”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 34,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 6,
“name”: “phone”,
“type”: “VARCHAR”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 34,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 7,
“name”: “card_id”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 8,
“name”: “card_no”,
“type”: “VARCHAR”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 34,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 9,
“name”: “card_name”,
“type”: “VARCHAR”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 34,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 10,
“name”: “card_icon”,
“type”: “VARCHAR”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 66,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 11,
“name”: “card_type”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 12,
“name”: “card_level”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 13,
“name”: “card_price”,
“type”: “DECIMAL64”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 8,
“frac”: 2,
“length”: 8,
“index_length”: 8,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 14,
“name”: “valid_date”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 15,
“name”: “card_desc”,
“type”: “VARCHAR”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 257,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 16,
“name”: “pay_price”,
“type”: “DECIMAL64”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 8,
“frac”: 2,
“length”: 8,
“index_length”: 8,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 17,
“name”: “pay_way”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 18,
“name”: “trade_no”,
“type”: “VARCHAR”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 34,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 19,
“name”: “pay_state”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 20,
“name”: “reason”,
“type”: “VARCHAR”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 257,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 21,
“name”: “refund_price”,
“type”: “DECIMAL64”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 8,
“frac”: 2,
“length”: 8,
“index_length”: 8,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 22,
“name”: “store_user_id”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 23,
“name”: “tenant_id”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 24,
“name”: “del_flag”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 25,
“name”: “create_time”,
“type”: “TIMESTAMP”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 8,
“index_length”: 8,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 26,
“name”: “update_time”,
“type”: “TIMESTAMP”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 8,
“index_length”: 8,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 27,
“name”: “card_activity_type”,
“type”: “INT”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 4,
“index_length”: 4,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 28,
“name”: “card_secret”,
“type”: “VARCHAR”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 257,
“index_length”: 20,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 29,
“name”: “pay_time”,
“type”: “TIMESTAMP”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 8,
“index_length”: 8,
“is_bf_column”: false,
“has_bitmap_index”: false
},
{
“unique_id”: 30,
“name”: “__op”,
“type”: “BOOLEAN”,
“is_key”: false,
“aggregation”: “REPLACE”,
“is_nullable”: true,
“precision”: 0,
“frac”: 0,
“length”: 1,
“index_length”: 1,
“is_bf_column”: false,
“has_bitmap_index”: false
}
],
“num_short_key_columns”: 1,
“num_rows_per_row_block”: 1024,
“compress_kind”: “COMPRESS_LZ4”,
“next_column_unique_id”: 31,
“id”: 10442
},
“in_restore_mode”: false,
“tablet_uid”: {
“hi”: -8052149213254959100,
“lo”: -2516517953185411693
},
“preferred_rowset_type”: “BETA_ROWSET”,
“tablet_type”: “TABLET_TYPE_DISK”,
“updates”: {
“versions”: [
{
“version”: {
“major”: 51,
“minor”: 1
},
“creation_time”: 1644240006,
“rowsets”: [
50
],
“compaction”: {
“start_version”: {
“major”: 0
},
“inputs”: [
0,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15,
16,
17,
18,
19,
20,
21,
22,
23,
24,
25,
26,
27,
28,
29,
30,
31,
32,
33,
34,
35,
36,
37,
38,
39,
40,
41,
42,
43,
44,
45,
46,
47,
48,
49
],
“outputs”: [
50
]
}
}
],
“apply_version”: {
“major”: 51,
“minor”: 1
},
“next_rowset_id”: 51,
“next_log_id”: 3
}
}

#7

不知道什么原因 我重新安装就好了

#8

重新安装是指重新部署了？

#9

是的 不知道后面有没有问题

#10

能提供一下建表语句和be、fe的日志不，我们追踪一下问题。如果日志比较大，可以发给这个邮箱lichaoyong121@qq.com

京ICP备2022026421号-1