回复： 通过streamload导入数据报异常abort reason: coordinate BE is down

[james <23...@qq.com.INVALID>]

下面的部分就是BE的日志。晚上定时load的数据，第二天发现问题时候查看几个BE节点显示状态是正常的。




------------------ 原始邮件 ------------------
发件人:                                                                                                                        "dev"                                                                                    <zhangjf1@gmail.com&gt;;
发送时间:&nbsp;2022年6月29日(星期三) 晚上6:11
收件人:&nbsp;"23461664"<23461664@qq.com.invalid&gt;;
抄送:&nbsp;"dev"<dev@doris.apache.org&gt;;
主题:&nbsp;Re: 通过streamload导入数据报异常abort reason: coordinate BE is down



应该是你的be挂了
show backends&nbsp; 看看


james <23461664@qq.com.invalid&gt;于2022年6月29日 周三15:44写道：

&gt; 您好！
&gt;
&gt;
&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;系统的部署情况说明：一台FE，3台BE 部署在一个局域网内。
&gt;
&gt;
&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;在通过streamload导入大量数据时候，报上面的错误！
&gt; 请问一般在什么情况下可能出现这样的问题，有什么解决方案没。
&gt; BE 的 日志内容如下：
&gt;
&gt;
&gt; W0625 21:11:04.788328 19871 stream_load_executor.cpp:281] commit
&gt; transaction failed, errmsg=errCode = 2, detailMessage = transaction [1638]
&gt; is already aborted. abort reason: coordinate BE is down,
&gt; id=d14f60f37fe29182-e2452ee346c991b8, job_id=-1, txn_id=1638,
&gt; label=xxx_t_3e9877180e1f415686443124a9fb72b0, elapse(s)=34
&gt; W0625 21:11:04.788368 19871 stream_load.cpp:144] handle streaming load
&gt; failed, id=d14f60f37fe29182-e2452ee346c991b8, errmsg=errCode = 2,
&gt; detailMessage = transaction [1638] is already aborted. abort reason:
&gt; coordinate BE is down
&gt; W0625 21:11:04.796619 19890 stream_load_executor.cpp:281] commit
&gt; transaction failed, errmsg=errCode = 2, detailMessage = transaction [1640]
&gt; is already aborted. abort reason: coordinate BE is down,
&gt; id=bb4ac386050f365f-5697ff9a7614929d, job_id=-1, txn_id=1640,
&gt; label=xxx_t_30bde0223a4c49bfae8855ea510e5157, elapse(s)=34
&gt; W0625 21:11:04.796648 19890 stream_load.cpp:144] handle streaming load
&gt; failed, id=bb4ac386050f365f-5697ff9a7614929d, errmsg=errCode = 2,
&gt; detailMessage = transaction [1640] is already aborted. abort reason:
&gt; coordinate BE is down
&gt; W0625 21:11:04.796726 19872 stream_load_executor.cpp:281] commit
&gt; transaction failed, errmsg=errCode = 2, detailMessage = transaction [1632]
&gt; is already aborted. abort reason: coordinate BE is down,
&gt; id=3e4bc3cd3e3e853f-cf8604ac349eb1b5, job_id=-1, txn_id=1632,
&gt; label=xxx_t_a20283afde854b54b362b91141571445, elapse(s)=34
&gt; W0625 21:11:04.796748 19894 stream_load_executor.cpp:281] commit
&gt; transaction failed, errmsg=errCode = 2, detailMessage = transaction [1635]
&gt; is already aborted. abort reason: coordinate BE is down,
&gt; id=0c4a7e043b34eb88-9d27887e66e1e392, job_id=-1, txn_id=1635,
&gt; label=xxx_t_638ea9d5da994462b56674f4218aa95d, elapse(s)=34
&gt; W0625 21:11:04.796767 19872 stream_load.cpp:144] handle streaming load
&gt; failed, id=3e4bc3cd3e3e853f-cf8604ac349eb1b5, errmsg=errCode = 2,
&gt; detailMessage = transaction [1632] is already aborted. abort reason:
&gt; coordinate BE is down
&gt; W0625 21:11:04.796799 19894 stream_load.cpp:144] handle streaming load
&gt; failed, id=0c4a7e043b34eb88-9d27887e66e1e392, errmsg=errCode = 2,
&gt; detailMessage = transaction [1635] is already aborted. abort reason:
&gt; coordinate BE is down
&gt; W0626 21:07:20.208528 19894 stream_load_executor.cpp:281] commit
&gt; transaction failed, errmsg=errCode = 2, detailMessage = transaction [1834]
&gt; is already aborted. abort reason: coordinate BE is down,
&gt; id=6c4fc4d91eead9d1-c7bd542607b427a5, job_id=-1, txn_id=1834,
&gt; label=xxx_t_a9c563f5eb2f45ee8a299889704ee42e, elapse(s)=33
&gt; W0626 21:07:20.208611 19894 stream_load.cpp:144] handle streaming load
&gt; failed, id=6c4fc4d91eead9d1-c7bd542607b427a5, errmsg=errCode = 2,
&gt; detailMessage = transaction [1834] is already aborted. abort reason:
&gt; coordinate BE is down

-- 
张家峰