【已解决】LOAD DATA LOCAL报错

Viewed 40

语句:
LOAD DATA LOCAL
INFILE '/data1/data/xxx.csv'
INTO TABLE xxx
PROPERTIES ('exec_mem_limit'='3221225472', 'timeout'='3600');
csv条数:25499152
版本:selectdb-2.0.8
报错内容:
execute sql error: errCode = 2, detailMessage = [INTERNAL_ERROR]cancelled: PlanFragmentExecutor open failed, reason: [INTERNAL_ERROR]VNodeChannel[17336-10008], load_id=cc421971f8f499de-70369de720f8bea0, txn_id=107206, node=10.8.40.83:8060, open failed, err: [INTERNAL_ERROR]failed to open tablet writer, error=RPC call is timed out, error_text=[E1008]Reached timeout=60000ms @10.8.40.83:8060, info=VNodeChannel[17336-10008], load_id=cc421971f8f499de-70369de720f8bea0, txn_id=107206, node=10.8.40.83:8060, host: 10.8.40.83

0#  doris::io::StreamLoadPipe::_append(std::shared_ptr<doris::ByteBuffer> const&, unsigned long) at /home/zcp/repo_center/doris_enterprise/doris/be/src/common/status.h:0
1#  doris::io::StreamLoadPipe::append(std::shared_ptr<doris::ByteBuffer> const&) at /home/zcp/repo_center/doris_enterprise/doris/be/src/io/fs/stream_load_pipe.cpp:162
2#  doris::StreamLoadAction::on_chunk_data(doris::HttpRequest*) at /home/zcp/repo_center/doris_enterprise/doris/be/src/common/status.h:446
3#  ?
4#  bufferevent_run_readcb_
5#  ?
6#  ?
7#  ?
8#  ?
9#  std::_Function_handler<void (), doris::EvHttpServer::start()::$_0>::_M_invoke(std::_Any_data const&) at /var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/ext/atomicity.h:98
10# doris::ThreadPool::dispatch_thread() at /home/zcp/repo_center/doris_enterprise/doris/be/src/util/threadpool.cpp:0
11# doris::Thread::supervise_thread(void*) at /var/local/ldb_toolchain/bin/../usr/include/pthread.h:562
12# start_thread
13# clone

with load id c97ee770-2064-4c17-bec0-5e2eb76573dc

1 Answers

检查一下fe和be之间的网络通信是否顺畅,试一下用stream load是否能够导入成功