【2.5.13】select/insert select某个表报错Expr evaluate meet error

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】查询或者insert select某个表,返回报错:
ERROR 1064 (HY000): Expr evaluate meet error: assert_true failed due to false value
【背景】
【业务影响】
【是否存算分离】
【StarRocks版本】2.5.13
【集群规模】例如:3fe(1 follower+2observer)+3be
【机器信息】CPU虚拟核/内存/网卡,例如:48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息,请补充下您的联系方式,例如:社区群4-小李或者邮箱,谢谢
【附件】
fe.warn.log错误:
2024-02-19 15:16:06,141 WARN (thrift-server-pool-2101036|2147640) [Coordinator.updateFragmentExecStatus():2501] one instance report fail errorCode RUNTIME_ERROR Expr evaluate meet error: as
sert_true failed due to false value, params=TReportExecStatusParams(protocol_version:V1, query_id:TUniqueId(hi:-4675621606793014802, lo:-6825484225782984462), backend_num:14, fragment_insta
nce_id:TUniqueId(hi:-4675621606793014802, lo:-6825484225782984367), status:TStatus(status_code:RUNTIME_ERROR, error_msgs:[Expr evaluate meet error: assert_true failed due to false value]),
done:true, error_log:[, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
, , , , , , , , , , , ], backend_id:263701635) query_id=bf1cdaeb-cef6-11ee-a147-0242762c50f2 instance_id=bf1cdaeb-cef6-11ee-a147-0242762c5151
2024-02-19 15:16:06,141 WARN (thrift-server-pool-2101042|2147646) [Coordinator.updateFragmentExecStatus():2501] one instance report fail errorCode RUNTIME_ERROR Expr evaluate meet error: as
sert_true failed due to false value, params=TReportExecStatusParams(protocol_version:V1, query_id:TUniqueId(hi:-4675621606793014802, lo:-6825484225782984462), backend_num:22, fragment_insta
nce_id:TUniqueId(hi:-4675621606793014802, lo:-6825484225782984281), status:TStatus(status_code:RUNTIME_ERROR, error_msgs:[Expr evaluate meet error: assert_true failed due to false value]),
done:true, error_log:[, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
, , , , , , , , , , , ], backend_id:263701635) query_id=bf1cdaeb-cef6-11ee-a147-0242762c50f2 instance_id=bf1cdaeb-cef6-11ee-a147-0242762c51a7
2024-02-19 15:16:06,141 WARN (starrocks-mysql-nio-pool-38264|2146649) [Coordinator.getNext():1556] get next fail, need cancel. status errorCode RUNTIME_ERROR Expr evaluate meet error: asser
t_true failed due to false value, query id: bf1cdaeb-cef6-11ee-a147-0242762c50f2
2024-02-19 15:16:06,141 WARN (thrift-server-pool-2101036|2147640) [Coordinator.updateStatus():1536] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: bf1cdae
b-cef6-11ee-a147-0242762c50f2, instance id: bf1cdaeb-cef6-11ee-a147-0242762c5151
2024-02-19 15:16:06,142 WARN (starrocks-mysql-nio-pool-38264|2146649) [Coordinator.getNext():1577] query failed: Expr evaluate meet error: assert_true failed due to false value

be的错误日志:
Feb 19, 2024 @ 16:42:10.090 - pipeline_driver_executor.cpp:137] [Driver] Process error, query_id=c0603a5b-cf02-11ee-a147-0242762c50f2, instance_id=c0603a5b-cf02-11ee-a147-0242762c514b, status=Runtime error: Expr evaluate meet error: assert_true failed due to false value /build/starrocks/be/src/exec/pipeline/project_operator.cpp:44 value_or_err_L44
Feb 19, 2024 @ 16:42:08.988 - pipeline_driver_executor.cpp:137] [Driver] Process error, query_id=c0603a5b-cf02-11ee-a147-0242762c50f2, instance_id=c0603a5b-cf02-11ee-a147-0242762c514a, status=Runtime error: Expr evaluate meet error: assert_true failed due to false value /build/starrocks/be/src/exec/pipeline/project_operator.cpp:44 value_or_err_L44
Feb 19, 2024 @ 16:42:08.988 - stack_util.cpp:350] 2024-02-19 16:42:02.284597, query_id=c0603a5b-cf02-11ee-a147-0242762c50f2, fragment_instance_id=c0603a5b-cf02-11ee-a147-0242762c514a throws exception: std::runtime_error, trace: @ 0x2a445e8 _ZN9starrocks10vectorized16UtilityFunctions11assert_trueEPN13starrocks_udf15FunctionContextERKSt6vectorISt10shared_ptrINS0_6ColumnEESaIS8_EE.cold @ 0x41f6db0 starrocks::vectorized::VectorizedFunctionCallExpr::evaluate_checked() @ 0x3a0ae73 starrocks::ExprContext::evaluate() @ 0x3a0b252 starrocks::ExprContext::evaluate() @ 0x30a8a63 starrocks::pipeline::ProjectOperator::push_chunk() @ 0x2e05d6b starrocks::pipeline::PipelineDriver::process() @ 0x541c717 starrocks::pipeline::GlobalDriverExecutor::_worker_thread() @ 0x4d9759b starrocks::ThreadPool::dispatch_thread() @ 0x4d924ea starrocks::thread::supervise_thread() @ 0x7f729d10cb43 (unknown) @ 0x7f729d19dbb4 clone @ (nil) (unknown)

麻烦发下对应的查询语句和建表

解决了,是源数据存在脏数据导致,清理了这个脏数据就可以了。

1赞