BE.alive is false when i begain sql

zkyuser commented 2 years ago

Search before asking

[X] I had searched in the issues and found no similar issues.

Version

1.1.0

What's Wrong?

nvaicat 链接doris数据库，执行sql之后3个be节点中的一个会掉

What You Expected?

查看这个是bug还是我的配置或sql或者其他问题

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

[X] Yes I am willing to submit a PR!

Code of Conduct

[X] I agree to follow this project's Code of Conduct

zkyuser commented 2 years ago

W0727 14:40:58.582839 8567 internal_service.cpp:446] apply filter meet error: Invalid argument: fragment-id: 10c8dc9bf6d94460-a3fb832330c749a9 W0727 14:40:58.592717 8557 internal_service.cpp:446] apply filter meet error: Invalid argument: fragment-id: 10c8dc9bf6d94460-a3fb832330c74db4 F0727 14:57:59.556994 9758 vslot_ref.cpp:63] Check failed: _column_id >= 0 (-1 vs. 0) , SlotRef(slot_id=419 type=VARCHAR codegen=false) column id: -1, name: pname, is nulable: 1, @ 0x55aa0d75bbf9 doris::vectorized::VSlotRef::execute() @ 0x55aa0d755a24 doris::vectorized::VInPredicate::execute() @ 0x55aa0d761719 doris::vectorized::VCaseExpr::execute() @ 0x55aa0d17b01b doris::vectorized::VExprContext::get_output_block_after_execute_exprs() @ 0x55aa0e2e16a9 doris::vectorized::VMysqlResultWriter::append_block() @ 0x55aa0e2a1cbc doris::vectorized::VResultSink::send() @ 0x55aa0cb89115 doris::PlanFragmentExecutor::open_vectorized_internal() @ 0x55aa0cb8a82f doris::PlanFragmentExecutor::open() @ 0x55aa0cb041c5 doris::FragmentExecState::execute() @ 0x55aa0cb08e7a doris::FragmentMgr::_exec_actual() @ 0x55aa0cb1241c std::_Function_handler<>::_M_invoke() @ 0x55aa0ccb5ca9 doris::ThreadPool::dispatch_thread() @ 0x55aa0ccaf29f doris::Thread::supervise_thread() @ 0x7f4a69fb7609 start_thread @ 0x7f4a6a0f1133 clone @ (nil) (unknown)

kpfly commented 2 years ago

W0727 14:40:58.582839 8567 internal_service.cpp:446] apply filter meet error: Invalid argument: fragment-id: 10c8dc9bf6d94460-a3fb832330c749a9 W0727 14:40:58.592717 8557 internal_service.cpp:446] apply filter meet error: Invalid argument: fragment-id: 10c8dc9bf6d94460-a3fb832330c74db4 F0727 14:57:59.556994 9758 vslot_ref.cpp:63] Check failed: _column_id >= 0 (-1 vs. 0) , SlotRef(slot_id=419 type=VARCHAR codegen=false) column id: -1, name: pname, is nulable: 1, @ 0x55aa0d75bbf9 doris::vectorized::VSlotRef::execute() @ 0x55aa0d755a24 doris::vectorized::VInPredicate::execute() @ 0x55aa0d761719 doris::vectorized::VCaseExpr::execute() @ 0x55aa0d17b01b doris::vectorized::VExprContext::get_output_block_after_execute_exprs() @ 0x55aa0e2e16a9 doris::vectorized::VMysqlResultWriter::append_block() @ 0x55aa0e2a1cbc doris::vectorized::VResultSink::send() @ 0x55aa0cb89115 doris::PlanFragmentExecutor::open_vectorized_internal() @ 0x55aa0cb8a82f doris::PlanFragmentExecutor::open() @ 0x55aa0cb041c5 doris::FragmentExecState::execute() @ 0x55aa0cb08e7a doris::FragmentMgr::_exec_actual() @ 0x55aa0cb1241c std::_Function_handler<>::_M_invoke() @ 0x55aa0ccb5ca9 doris::ThreadPool::dispatch_thread() @ 0x55aa0ccaf29f doris::Thread::supervise_thread() @ 0x7f4a69fb7609 start_thread @ 0x7f4a6a0f1133 clone @ (nil) (unknown)

Could you share the sql?

coderjiang commented 2 years ago

遇到相同的问题了。 I0719 17:49:32.507297 53813 env.cpp:46] Env init successfully. Aborted at 1658224338 (unix time) try "date -d @1658224338" if you are using GNU date SIGSEGV address not mapped to object (@0x5593887ebffe) received by PID 53813 (TID 0x7fe11776e700) from PID 18446744071704592382; stack trace: 0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t, void) at /root/doris-1.1.0-rc05/be/src/common/signal_handler.h:420 1# 0x00007FE16155A040 in /lib/x86_64-linux-gnu/libc.so.6 2# 0x00007FE1616A9C34 in /lib/x86_64-linux-gnu/libc.so.6 3# doris::vectorized::ColumnString::insert_from(doris::vectorized::IColumn const&, unsigned long) at /root/doris-1.1.0-rc05/be/src/vec/columns/column_string.h:146 4# doris::vectorized::ColumnNullable::insert_from(doris::vectorized::IColumn const&, unsigned long) at /root/doris-1.1.0-rc05/be/src/vec/columns/column_nullable.cpp:162 5# doris::vectorized::VCrossJoinNode::process_left_child_block(std::vector<COW::mutable_ptr, std::allocator<COW::mutable_ptr > >&, doris::vectorized::Block const&) at /root/doris-1.1.0-rc05/be/src/vec/exec/vcross_join_node.cpp:175 6# doris::vectorized::VCrossJoinNode::get_next(doris::RuntimeState, doris::vectorized::Block, bool) at /root/doris-1.1.0-rc05/be/src/vec/exec/vcross_join_node.cpp:133 7# doris::vectorized::HashJoinNode::get_next(doris::RuntimeState, doris::vectorized::Block, bool) at /root/doris-1.1.0-rc05/be/src/vec/exec/join/vhash_join_node.cpp:881 8# doris::vectorized::HashJoinNode::get_next(doris::RuntimeState, doris::vectorized::Block, bool*) at /root/doris-1.1.0-rc05/be/src/vec/exec/join/vhash_join_node.cpp:881 9# doris::PlanFragmentExecutor::get_vectorized_internal(doris::vectorized::Block*) at /root/doris-1.1.0-rc05/be/src/runtime/plan_fragment_executor.cpp:346 10# doris::PlanFragmentExecutor::open_vectorized_internal() at /root/doris-1.1.0-rc05/be/src/runtime/plan_fragment_executor.cpp:295 11# doris::PlanFragmentExecutor::open() at /root/doris-1.1.0-rc05/be/src/runtime/plan_fragment_executor.cpp:255 12# doris::FragmentExecState::execute() at /root/doris-1.1.0-rc05/be/src/runtime/fragment_mgr.cpp:241 13# doris::FragmentMgr::_exec_actual(std::shared_ptr, std::function<void (doris::PlanFragmentExecutor)>) at /root/doris-1.1.0-rc05/be/src/runtime/fragment_mgr.cpp:476 14# std::_Function_handler<void (), std::_Bind_result<void, void (doris::FragmentMgr::(doris::FragmentMgr, std::shared_ptr, std::function<void (doris::PlanFragmentExecutor)>))(std::shared_ptr, std::function<void (doris::PlanFragmentExecutor)>)> >::_M_invoke(std::_Any_data const&) at /var/local/ldb-toolchain/include/c++/11/bits/std_function.h:291 15# doris::ThreadPool::dispatch_thread() at /root/doris-1.1.0-rc05/be/src/util/threadpool.cpp:578 16# doris::Thread::supervise_thread(void*) at /root/doris-1.1.0-rc05/be/src/util/thread.cpp:407 17# start_thread in /lib/x86_64-linux-gnu/libpthread.so.0 18# __clone in /lib/x86_64-linux-gnu/libc.so.6

是因为开启了向量化引擎，导致的报错，升级到 1.1.0，并关闭向量化，解决问题

apache / doris