doris2.0.5 Stream Load 导入数据偶发性的很慢,怎么排查

Viewed 74

日志如下,prepare 与 commit 状态之间相隔15分钟,请问如何排查?是doris入库慢还是应用程序写入慢?
08:15:23,194 INFO (thrift-server-pool-526|1281496) [DatabaseTransactionMgr.beginTransaction():361] begin transaction: txn id 4486301 with label 3b8b643e-7bdb-4055-80be-d28ee9abb310 from coordinator BE: xxxxx, listener id: -1
08:30:41,608 INFO (thrift-server-pool-664|1412641) [DatabaseTransactionMgr.commitTransaction():748] transaction:[TransactionState. transaction id: 4486301, label: 3b8b643e-7bdb-4055-80be-d28ee9abb310, db id: xxx, table id list: xxx, callback id: -1, coordinator: BE: xxxxx, transaction status: COMMITTED, error replicas num: 0, replica ids: , prepare time: 1721636123194, commit time: 1721637041607, finish time: -1, reason: ] successfully committed
08:30:41,628 INFO (PUBLISH_VERSION|31) [DatabaseTransactionMgr.finishTransaction():1113] finish transaction TransactionState. transaction id: 4486301, label: 3b8b643e-7bdb-4055-80be-d28ee9abb310, db id: xxx, table id list: xxx, callback id: -1, coordinator: BE: xxxxx, transaction status: VISIBLE, error replicas num: 0, replica ids: , prepare time: 1721637041607, commit time: 1721637041607, finish time: 1721637041626, reason: successfully, publish result: QUORUM_SUCC

2 Answers

这个是应用程序开始到结束streamload慢了。

我们也遇到类似的问题,写入两条数据,特别慢 大概10几秒才写入