大表加字段导致 be 崩溃

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】大表加字段,导致be崩溃
【背景】大概23亿数据表加字段
【业务影响】30秒左右不可用
【是否存算分离】
【StarRocks版本】2.2.13
【集群规模】例如:3fe(1 follower+2observer)+3be(fe与be分开部署)
【机器信息】16C/32G/万兆
【联系方式】627736354@qq.com
【附件】

  • be crash
    query_id:00000000-0000-0000-0000-000000000000
    *** Aborted at 1700041741 (unix time) try “date -d @1700041741” if you are using GNU date ***
    PC: @ 0x19a0a53 starrocks::vectorized::FixedLengthColumnBase<>::append_selective()
    *** SIGSEGV (@0x0) received by PID 20033 (TID 0x7fd1371d9700) from PID 0; stack trace: ***
    @ 0x3db8592 google::(anonymous namespace)::FailureSignalHandler()
    @ 0x7fd22ef6c5d0 (unknown)
    @ 0x19a0a53 starrocks::vectorized::FixedLengthColumnBase<>::append_selective()
    @ 0x237efcd starrocks::vectorized::NullableColumn::append_selective()
    @ 0x236e0a7 starrocks::vectorized::Chunk::rolling_append_selective()
    @ 0x1b6b253 starrocks::vectorized::MemTable::_sort()
    @ 0x1b6bbed starrocks::vectorized::MemTable::finalize()
    @ 0x3284a2c starrocks::vectorized::DeltaWriter::_flush_memtable_async()
    @ 0x328522c starrocks::vectorized::DeltaWriter::close()
    @ 0x327678c starrocks::vectorized::AsyncDeltaWriter::_execute()
    @ 0x3e88dac bthread::ExecutionQueueBase::_execute()
    @ 0x3e89b78 bthread::ExecutionQueueBase::_execute_tasks()
    @ 0x2001889 starrocks::ThreadPool::dispatch_thread()
    @ 0x1ffd43a starrocks::thread::supervise_thread()
    @ 0x7fd22ef64dd5 start_thread
    @ 0x7fd22e57fead __clone
    @ 0x0 (unknown)
    start time: Wed Nov 15 17:52:13 CST 2023

参考 https://docs.starrocks.io/zh/docs/deployment/environment_configurations/ 排查下参数都配置正确没,尤其是swap是否关闭,overcommit是否配置为1 ,另外咱们版本太老了,升级到最新的版本吧,2.5当前是lts

没有使用swap,但是确实overcommit是0 这个参数很有影响吗。

应该不是Overcommit导致,具体我们还要看下。

应该是导入导致的Crash