问题:
StarRocks1.19.0 MySQL外部表导入SR内部表成功,但导致无法查询内部表
1、MySQL外部表建表语句
CREATE EXTERNAL TABLE demo
(
pk
bigint (255) NOT NULL,
name
varchar(1275),
age
int (11) DEFAULT NULL
)
ENGINE=mysql
PROPERTIES(
“host” = “”,
“port” = “”,
“user” = “”,
“password” = “”,
“database” = “test”,
“table” = “demo”
);
2、内部表建表语句
CREATE TABLE demo1
(
pk
largeint(40) NOT NULL COMMENT “”,
name
varchar(65533) REPLACE NULL COMMENT “”,
age
int(11) REPLACE NULL COMMENT “”
) ENGINE=OLAP
PRIMARY KEY(pk
)
COMMENT “OLAP”
DISTRIBUTED BY HASH(pk
) BUCKETS 1
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”
);
3.数据同步
INSERT INTO demo1(pk, name, age ) SELECT * FROM demo;
4.同步成功
5.查询demo1
SELECT * FROM demo1;
报错:
1064 - [172.17.22.28] fail to prepare tablet reader 679637.1517087579.2b4f1982a69fc0c6-e571e29e56c0ce87: Internal error: fail to find rowset of version 0-2
时间: 60.133s
fe.warn.log日志:
2021-11-16 13:33:30,881 WARN (thrift-server-pool-20|151) [Coordinator.updateFragmentExecStatus():1386] one instance report fail errorCode INTERNAL_ERROR [172.17.22.28] fail to prepare tablet reader 679637.1517087579.2b4f1982a69fc0c6-e571e29e56c0ce87: Internal error: fail to find rowset of version 0-2, query_id=97d309b7-469e-11ec-aa97-00163e3057de instance_id=97d309b7-469e-11ec-aa97-00163e3057df
2021-11-16 13:33:30,882 WARN (thrift-server-pool-20|151) [Coordinator.updateStatus():730] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: 97d309b7-469e-11ec-aa97-00163e3057de, instance id: 97d309b7-469e-11ec-aa97-00163e3057df
2021-11-16 13:33:30,883 WARN (starrocks-mysql-nio-pool-633|22958) [Coordinator.getNext():749] get next fail, need cancel. status errorCode INTERNAL_ERROR [172.17.22.28] fail to prepare tablet reader 679637.1517087579.2b4f1982a69fc0c6-e571e29e56c0ce87: Internal error: fail to find rowset of version 0-2, query id: 97d309b7-469e-11ec-aa97-00163e3057de
2021-11-16 13:33:30,883 WARN (starrocks-mysql-nio-pool-633|22958) [Coordinator.getNext():770] query failed: [172.17.22.28] fail to prepare tablet reader 679637.1517087579.2b4f1982a69fc0c6-e571e29e56c0ce87: Internal error: fail to find rowset of version 0-2