be.out对应的日志如下
start BE in local mode
thrift error, reason=No more data to read.Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
*** Query id: 92b23ee3ebb64371-ba7c75aba87f06b4 ***
*** is nereids: 1 ***
*** tablet id: 0 ***
*** Aborted at 1790503220 (unix time) try "date -d @1790503220" if you are using GNU date ***
*** Current BE git commitID: aec169d2025 ***
*** SIGSEGV address not mapped to object (@0x7f3a6c7ff000) received by PID 58237 (TID 59087 OR 0x7f499e9bb700) from PID 1820323840; stack trace: ***
0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at /home/zcp/repo_center/doris_release/doris/be/src/common/signal_handler.h:420
1# PosixSignals::chained_handler(int, siginfo*, void*) [clone .part.0] in /data/server/jdk-17.0.12/lib/server/libjvm.so
2# JVM_handle_linux_signal in /data/server/jdk-17.0.12/lib/server/libjvm.so
3# 0x00007F4DC8AE8630 in /lib64/libpthread.so.0
4# doris::InListPredicateBase<(doris::PrimitiveType)6, (doris::PredicateType)7, 9>::InListPredicateBase(unsigned int, std::__cxx11::basic_string<char, std::char_traits, std::allocator >, std::shared_ptr const&, bool, unsigned long) at /home/zcp/repo_center/doris_release/doris/be/src/storage/predicate/in_list_predicate.h:122
5# std::_Sp_counted_ptr_inplace<doris::InListPredicateBase<(doris::PrimitiveType)6, (doris::PredicateType)7, 9>, std::allocator, (__gnu_cxx::_Lock_policy)2>::_Sp_counted_ptr_inplace<unsigned int const&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, std::shared_ptr const&, bool&, unsigned long&>(std::allocator, unsigned int const&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, std::shared_ptr const&, bool&, unsigned long&) at /usr/local/ldb-toolchain-v0.26/bin/../lib/gcc/x86_64-pc-linux-gnu/15/include/g++-v15/bits/shared_ptr_base.h:606
6# std::shared_ptr doris::create_in_list_predicate<(doris::PredicateType)7>(unsigned int, std::__cxx11::basic_string<char, std::char_traits, std::allocator >, std::shared_ptr<doris::IDataType const> const&, std::shared_ptr, bool) at /home/zcp/repo_center/doris_release/doris/be/src/storage/predicate/predicate_creator_in_list_in.cpp:87
7# doris::Status doris::ScanLocalStateBase::_normalize_in_predicate<(doris::PrimitiveType)6>(doris::VExprContext*, std::shared_ptr const&, doris::SlotDescriptor*, std::vector<std::shared_ptr, std::allocator<std::shared_ptr > >&, doris::ColumnValueRange<(doris::PrimitiveType)6>&, doris::PushDownType*) in /data/server/apache-doris-4.1.2-bin-x64/be/lib/doris_be
8# auto doris::ScanLocalState::_normalize_predicate(doris::VExprContext*, std::shared_ptr const&, std::shared_ptr&)::{lambda(auto:1&)#1}::operator()<doris::ColumnValueRange<(doris::PrimitiveType)6> >(doris::ColumnValueRange<(doris::PrimitiveType)6>&) const at /home/zcp/repo_center/doris_release/doris/be/src/exec/operator/scan_operator.cpp:411
9# doris::ScanLocalState::_normalize_predicate(doris::VExprContext*, std::shared_ptr const&, std::shared_ptr&) at /home/zcp/repo_center/doris_release/doris/be/src/exec/operator/scan_operator.cpp:462
10# doris::ScanLocalState::_normalize_conjuncts(doris::RuntimeState*) at /home/zcp/repo_center/doris_release/doris/be/src/exec/operator/scan_operator.cpp:320
11# doris::OlapScanLocalState::_process_conjuncts(doris::RuntimeState*) at /home/zcp/repo_center/doris_release/doris/be/src/exec/operator/olap_scan_operator.cpp:407
12# doris::ScanLocalState::open(doris::RuntimeState*) at /home/zcp/repo_center/doris_release/doris/be/src/exec/operator/scan_operator.cpp:209
13# doris::OlapScanLocalState::open(doris::RuntimeState*) at /home/zcp/repo_center/doris_release/doris/be/src/exec/operator/olap_scan_operator.cpp:851
14# doris::PipelineTask::_open() at /home/zcp/repo_center/doris_release/doris/be/src/exec/pipeline/pipeline_task.cpp:272
15# doris::PipelineTask::execute(bool*) at /home/zcp/repo_center/doris_release/doris/be/src/exec/pipeline/pipeline_task.cpp:553
16# doris::TaskScheduler::_do_work(int) at /home/zcp/repo_center/doris_release/doris/be/src/exec/pipeline/task_scheduler.cpp:153
17# doris::ThreadPool::dispatch_thread() at /home/zcp/repo_center/doris_release/doris/be/src/util/threadpool.cpp:623
18# doris::Thread::supervise_thread(void*) at /home/zcp/repo_center/doris_release/doris/be/src/util/thread.cpp:461
19# start_thread in /lib64/libpthread.so.0
20# clone in /lib64/libc.so.6
INFO: java_cmd /data/server/jdk-17.0.12/bin/java
INFO: jdk_version 17
StdoutLogger 2026-09-27 18:04:59,500 Start time: Sun Sep 27 18:04:59 CST 2026
INFO: java_cmd /data/server/jdk-17.0.12/bin/java
INFO: jdk_version 17
StdoutLogger 2026-09-27 18:04:59,539 Added missing Java option: -Dhadoop.shell.setsid.enabled=false
StdoutLogger 2026-09-27 18:04:59,571 Added missing Java option: --add-opens=java.base/jdk.internal.ref=ALL-UNNAMED
StdoutLogger 2026-09-27 18:04:59,574 Added missing Java option: --add-opens=java.xml/com.sun.org.apache.xerces.internal.jaxp=ALL-UNNAMED
Java HotSpot(TM) 64-Bit Server VM warning: Option CriticalJNINatives was deprecated in version 16.0 and will likely be removed in a future release.
SLF4J(W): Class path contains multiple SLF4J providers.
SLF4J(W): Found provider [org.apache.logging.slf4j.SLF4JServiceProvider@d70c109]
SLF4J(W): Found provider [org.slf4j.reload4j.Reload4jServiceProvider@17ed40e0]
SLF4J(W): See https://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J(I): Actual provider is of type [org.apache.logging.slf4j.SLF4JServiceProvider@d70c109]
start BE in local mode
Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
对应的query:
insert into user_tag_bitmap (tag_code, tag_name, uids, create_time)
select
'30.2.4.19',
'忠实未付费',
bitmap_union(to_bitmap(uid)),
'2026-03-26T10:39:05'
from (
select distinct uid
from (
select distinct t3.uid
from (
select distinct t1.uid
from (
select distinct uid from mv_user_account
) t1
left join (
select uid from (
select uid, sum(real_pay_price) as amount
from mv_user_order
where pay_date >= DATE_ADD(STR_TO_DATE(CONCAT(CURDATE(), ' 00:00:00'), '%Y-%m-%d %H:%i:%s'), INTERVAL -3000 DAY)
and pay_date <= DATE_ADD(STR_TO_DATE(CONCAT(CURDATE(), ' 23:59:59'), '%Y-%m-%d %H:%i:%s'), INTERVAL 0 DAY)
group by uid
) a
where amount > 0.0
) t2 on t2.uid = t1.uid
where t2.uid is null
) t3
inner join (
select uid from (
select uid, count(distinct date(log_server_time)) as amount
from user_event
where dt >= DATE_ADD(STR_TO_DATE(CONCAT(CURDATE(), ' 00:00:00'), '%Y-%m-%d %H:%i:%s'), INTERVAL -90 DAY)
and dt <= DATE_ADD(STR_TO_DATE(CONCAT(CURDATE(), ' 23:59:59'), '%Y-%m-%d %H:%i:%s'), INTERVAL -1 DAY)
group by uid
) a
where amount >= 20.0
) t4 on t4.uid = t3.uid
inner join (
select uid from (
select uid, sum(pt)/1000 as amount
from user_play
where dt >= DATE_ADD(STR_TO_DATE(CONCAT(CURDATE(), ' 00:00:00'), '%Y-%m-%d %H:%i:%s'), INTERVAL -30 DAY)
and dt <= DATE_ADD(STR_TO_DATE(CONCAT(CURDATE(), ' 23:59:59'), '%Y-%m-%d %H:%i:%s'), INTERVAL -1 DAY)
group by uid
) a
where amount > 27000.0
) t5 on t5.uid = t4.uid
inner join (
select distinct t6.uid
from (
select distinct uid from mv_user_account
) t6
left join (
select distinct uid
from user_play
where dt >= DATE_ADD(STR_TO_DATE(CONCAT(CURDATE(), ' 00:00:00'), '%Y-%m-%d %H:%i:%s'), INTERVAL -30 DAY)
and dt <= DATE_ADD(STR_TO_DATE(CONCAT(CURDATE(), ' 23:59:59'), '%Y-%m-%d %H:%i:%s'), INTERVAL -1 DAY)
and (play_type in ('live', 'replay'))
) t8 on t8.uid = t6.uid
where t8.uid is null
) t9 on t9.uid = t5.uid
) t10
) tmp;
