Internal error: fail to find rowset of version 0-2

问题:
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

帮忙上传下172.17.22.28这个be的be.info和be.warn日志

be.info日志:
W1116 14:40:22.901371 26336 olap_scanner.cpp:48] [172.17.22.28] fail to prepare tablet reader 679637.1517087579.2b4f1982a69fc0c6-e571e29e56c0ce87: Internal error: fail to find rowset of version 0-2
E1116 14:40:22.901386 26336 olap_scan_node.cpp:103] Failed to start scan node: 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
W1116 14:40:22.901398 26336 plan_fragment_executor.cpp:228] fail to open fragment, instance_id=ef3e1a5f-46a7-11ec-aa97-00163e3057df, status=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
W1116 14:40:22.905989 26336 fragment_mgr.cpp:184] Fail to open fragment ef3e1a5f-46a7-11ec-aa97-00163e3057df: 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
I1116 14:40:22.906205 26336 plan_fragment_executor.cpp:487] Fragment ef3e1a5f-46a7-11ec-aa97-00163e3057df:(Active: 1m, non-child: 0.00%)

  • AverageThreadTokens: 1.00
  • MemoryLimit: 2.00 GB
  • PeakMemoryUsage: 0
  • PeakReservation: 0
  • PeakUsedReservation: 0
  • RowsProduced: 0
    BlockMgr:
    • BlockWritesOutstanding: 0
    • BlocksCreated: 0
    • BlocksRecycled: 0
    • BufferedPins: 0
    • BytesWritten: 0
    • MaxBlockSize: 8.00 MB
    • TotalBufferWaitTime: 0.000ns
    • TotalReadBlockTime: 0.000ns
      DataBufferSender (dst_fragment_instance_id=ef3e1a5f-46a7-11ec-aa97-00163e3057df):
    • AppendBatchTime: 0.000ns
      • ResultRendTime: 0.000ns
      • TupleConvertTime: 0.000ns
    • NumSentRows: 0
      OLAP_SCAN_NODE (id=0):(Active: 1m, non-child: 100.00%)
    • Table: demo1
    • Rollup: demo1
    • BytesRead: 0
    • NumDiskAccess: 0
    • PeakMemoryUsage: 0
    • PerReadThreadRawHdfsThroughput: 0.00 /sec
    • RowsRead: 0
    • RowsReturned: 0
    • RowsReturnedRate: 0
    • ScanTime: 0.000ns
    • ScannerThreadsInvoluntaryContextSwitches: 0
    • ScannerThreadsTotalWallClockTime: 0.000ns
      • MaterializeTupleTime(*): 0.000ns
      • ScannerThreadsSysTime: 0.000ns
      • ScannerThreadsUserTime: 0.000ns
    • ScannerThreadsVoluntaryContextSwitches: 0
    • TabletCount : 1
    • TotalRawReadTime(*): 0.000ns
    • TotalReadThroughput: 0.00 /sec
      SCAN:
      • CachedPagesNum: 0
      • CompressedBytesRead: 0
      • CreateSegmentIter: 0.000ns
      • IOTime: 0.000ns
      • PushdownPredicates: 0
      • RawRowsRead: 0
      • SegmentInit: 0.000ns
        • BitmapIndexFilter: 0.000ns
        • BitmapIndexFilterRows: 0
        • BloomFilterFilterRows: 0
        • ShortKeyFilterRows: 0
        • ZoneMapIndexFilterRows: 0
      • SegmentRead: 0.000ns
        • BlockFetch: 0.000ns
        • BlockFetchCount: 0
        • BlockSeek: 0.000ns
        • BlockSeekCount: 0
        • ChunkCopy: 0.000ns
        • DecompressT: 0.000ns
        • DelVecFilterRows: 0
        • IndexLoad: 0.000ns
        • PredFilter: 0.000ns
        • PredFilterRows: 0
      • TotalPagesNum: 0
      • UncompressedBytesRead: 0

be.warn日志:
W1116 14:40:22.899973 26336 tablet_updates.cpp:906] wait_for_version timeout(60002ms) version:2 tablet:679637 #version:1 [0 0@0 0] pending:2, rowsets:0[id/seg/row/del/byte/compaction]:
W1116 14:40:22.901371 26336 olap_scanner.cpp:48] [172.17.22.28] fail to prepare tablet reader 679637.1517087579.2b4f1982a69fc0c6-e571e29e56c0ce87: Internal error: fail to find rowset of version 0-2
E1116 14:40:22.901386 26336 olap_scan_node.cpp:103] Failed to start scan node: 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
W1116 14:40:22.901398 26336 plan_fragment_executor.cpp:228] fail to open fragment, instance_id=ef3e1a5f-46a7-11ec-aa97-00163e3057df, status=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
W1116 14:40:22.905989 26336 fragment_mgr.cpp:184] Fail to open fragment ef3e1a5f-46a7-11ec-aa97-00163e3057df: 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

碰到了同样的问题,有解决吗

正在努力复现中~

之前是过段时间没有导入,会自动好。这边还在复现这个逻辑。您那边能稳定复现不?

您好,这个问题现在有解决方案了吗?