AItale-4 commented on issue #56154: URL: https://github.com/apache/doris/issues/56154#issuecomment-3316462777
> you can check your fe.audit.log file whether there is more than once `insert overwrite` This error occurs rarely, but it happened again recently. I checked the fe.audit.log on all FE nodes by filtering with the table name, and only one FE node contained related logs. I think it is not related to multi-threaded execution. The log is as follows: ``` 2025-09-22 08:03:54,594 [query] |QueryId=xxxxxx|Timestamp=2025-09-22 08:03:44.049|Client=***.***.***.***:41052|User=***|FeIp=***.***.***.***| Ctl=internal|Db=|State=ERR|ErrorCode=1105| ErrorMessage=errCode = 2, detailMessage = internal error, commitTxn failed, transactionId:3945676102130688, code:KV_TXN_COMMIT_ERR, msg:failed to commit kv txn, txn_id=3945676102130688 err=MaybeCommitted| Time(ms)=3875|CpuTimeMS=690|PeakMemoryBytes=185772937|ScanBytes=174661632|ScanRows=592900|ReturnRows=0| ShuffleSendRows=0|ShuffleSendBytes=0|ScanBytesFromLocalStorage=0|ScanBytesFromRemoteStorage=0| FuzzyVariables=|CommandType=Query|StmtType=INSERT|StmtId=23586| SqlHash=89990e0acd1da6e9aac2e6e92f305136|SqlDigest=|IsQuery=false|IsNereids=true| WorkloadGroup=normal|ComputeGroupName=defaultComputeGroup| Stmt=INSERT OVERWRITE TABLE <target_table>(...) SELECT ... FROM <source_table> WHERE dt = '20250921' ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
