stream load导入失败, 提示current running txns on db 5323729 is 1000...

Viewed 63

{
'TxnId': -1,
'Label': 'historical_data_load_20250327_175109',
'Comment': '',
'TwoPhaseCommit': 'false',
'Status': 'Fail',
'Message': '[ANALYSIS_ERROR]TStatus: errCode = 2, detailMessage = current running txns on db 5323729 is 1000, larger than limit 1000',
'NumberTotalRows': 0,
'NumberLoadedRows': 0,
'NumberFilteredRows': 0,
'NumberUnselectedRows': 0,
'LoadBytes': 0,
'LoadTimeMs': 0,
'BeginTxnTimeMs': 0,
'StreamLoadPutTimeMs': 0,
'ReadDataTimeMs': 0,
'WriteDataTimeMs': 0,
'ReceiveDataTimeMs': 0,
'CommitAndPublishTimeMs': 0
}

1 Answers

已经解决,原因是因为停电导致 version 缺失了。

解决方式:
找到卡住的源头事物,将对应的tablet 缺少的version填充后恢复正常。

image.png

image.png

先补一个 183860 version 然后后边等报错再补。

curl -X POST "http://xxxx:8040/api/pad_rowset?tablet_id=xxxx&start_version=183860&end_version=183860"