doris 2.0.6中事务卡住,无法终止

Viewed 195

执行命令:

curl -X PUT --location-trusted -u user:passwd  -H "txn_id: 105002619" -H "txn_operation:abort"  http://fe_host:http_port/api/{db}/{table}/_stream_load_2pc

错误如下:

{
    "status": "ANALYSIS_ERROR",
    "msg": "TStatus: errCode = 2, detailMessage = transaction [105002619] is already COMMITTED, could not abort."
}

该事务信息如下:

TransactionId:105002046
Label:insert_10094942d06e472d_b8b678486598dc6a
TransactionStatus:COMMITTED
LoadJobSourceType:INSERT_STREAMING
TimeoutMs:86400000
ErrMsg:wait for publishing partition 19829478 version 33349005. self version: 33343540. table 19829479

2 Answers

这个看这个是publish 卡住了,你在be.INFO 中 grep下:
命令:

grep PUBLISH be.INFO | grep queue

截图发下的