Internal error: vector::_M_range_insert

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】查询sql报错
【背景】做过哪些操作?
【业务影响】
【是否存算分离】是
【StarRocks版本】3.1.4
【集群规模】例如:3fe(1 follower+2observer)+5be(fe与be混部)
【机器信息】CPU虚拟核/内存/网卡,例如:48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息,请补充下您的联系方式,例如:社区群4-小李或者邮箱,谢谢
【附件】
返回错误:
java.sql.SQLSyntaxErrorException: Internal error: vector::_M_range_insert
【be.warn】
W0205 03:49:49.914880 17847 socket.cpp:1227] Fail to wait EPOLLOUT of fd=660: Connection timed out [110]

W0205 03:49:50.549226 17640 mem_hook.cpp:266] large memory alloc: 5063903186 bytes, stack:

@          0x4e766b3  malloc

@          0x873feb5  operator new()

@          0x2a8b4ce  std::vector<>::_M_range_insert<>()

@          0x2a8f134  starrocks::BinaryColumnBase<>::append()

@          0x5585dfa  starrocks::NullableColumn::append()

@          0x2b8dec3  starrocks::JoinHashTable::append_chunk()

@          0x2ffcb4c  starrocks::HashJoinBuilder::append_chunk()

@          0x2ff6a5c  starrocks::HashJoiner::append_chunk_to_ht()

@          0x2e45329  starrocks::pipeline::HashJoinBuildOperator::push_chunk()

@          0x2e4c628  starrocks::pipeline::SpillableHashJoinBuildOperator::push_chunk()

@          0x2ac5193  starrocks::pipeline::PipelineDriver::process()

@          0x568b55e  starrocks::pipeline::GlobalDriverExecutor::_worker_thread()

@          0x4f782b2  starrocks::ThreadPool::dispatch_thread()

@          0x4f72d4a  starrocks::Thread::supervise_thread()

@     0x7fe4fb451e65  start_thread

@     0x7fe4fa85388d  __clone

@              (nil)  (unknown)

W0205 03:49:51.293735 17907 socket.cpp:1227] Fail to wait EPOLLOUT of fd=601: Connection timed out [110]

W0205 03:49:51.668005 17906 socket.cpp:1227] Fail to wait EPOLLOUT of fd=660: Connection timed out [110]

W0205 03:49:51.936722 17907 socket.cpp:1227] Fail to wait EPOLLOUT of fd=601: Connection timed out [110]

W0205 03:49:52.930547 17907 socket.cpp:1227] Fail to wait EPOLLOUT of fd=601: Connection timed out [110]

W0205 03:49:53.415207 17850 socket.cpp:1227] Fail to wait EPOLLOUT of fd=660: Connection timed out [110]

W0205 03:49:54.794036 17902 socket.cpp:1227] Fail to wait EPOLLOUT of fd=601: Connection timed out [110]

W0205 03:49:55.168368 17845 socket.cpp:1227] Fail to wait EPOLLOUT of fd=660: Connection timed out [110]

W0205 03:49:55.437172 17902 socket.cpp:1227] Fail to wait EPOLLOUT of fd=601: Connection timed out [110]

W0205 03:49:56.431013 17847 socket.cpp:1227] Fail to wait EPOLLOUT of fd=601: Connection timed out [110]

W0205 03:49:56.915925 17906 socket.cpp:1227] Fail to wait EPOLLOUT of fd=660: Connection timed out [110]

W0205 03:49:57.323752 17641 mem_hook.cpp:266] large memory alloc: 3292993512 bytes, stack:

@          0x4e766b3  malloc

@          0x873feb5  operator new()

@          0x2a7ebab  std::vector<>::_M_default_append()

@          0x2a945c0  starrocks::BinaryColumnBase<>::upgrade_if_overflow()

@          0x2a4b217  starrocks::Column::upgrade_helper_func()

@          0x5583d93  starrocks::NullableColumn::upgrade_if_overflow()

@          0x55685dd  starrocks::Chunk::upgrade_if_overflow()

@          0x2b8e92f  starrocks::JoinHashTable::build()

@          0x2ffccfa  starrocks::HashJoinBuilder::build()

@          0x2ff6b03  starrocks::HashJoiner::build_ht()

@          0x2e46152  starrocks::pipeline::HashJoinBuildOperator::set_finishing()

@          0x2e4d4ce  starrocks::pipeline::SpillableHashJoinBuildOperator::set_finishing()

@          0x2ac2747  starrocks::pipeline::PipelineDriver::_mark_operator_finishing()

@          0x2ac4abe  starrocks::pipeline::PipelineDriver::process()

@          0x568b55e  starrocks::pipeline::GlobalDriverExecutor::_worker_thread()

@          0x4f782b2  starrocks::ThreadPool::dispatch_thread()

@          0x4f72d4a  starrocks::Thread::supervise_thread()

@     0x7fe4fb451e65  start_thread

@     0x7fe4fa85388d  __clone

@              (nil)  (unknown)

W0205 03:49:58.294275 17847 socket.cpp:1227] Fail to wait EPOLLOUT of fd=601: Connection timed out [110]

W0205 03:49:58.668642 17850 socket.cpp:1227] Fail to wait EPOLLOUT of fd=660: Connection timed out [110]

W0205 03:49:58.937438 17909 socket.cpp:1227] Fail to wait EPOLLOUT of fd=601: Connection timed out [110]

W0205 03:49:59.931257 17902 socket.cpp:1227] Fail to wait EPOLLOUT of fd=601: Connection timed out [110]

W0205 03:49:59.968382 17641 mem_hook.cpp:266] large memory alloc: 2147483648 bytes, stack:

同问,一样的报错,版本3.1.11

set enable_spill=true; set spill_mode=“force”; 试一下