【详述】执行特定sql导致BE进程挂掉
【背景】执行SQL语句
【业务影响】BE进程挂掉，无法使用SR数据库
【是否存算分离】否
【StarRocks版本】3.3.1
【集群规模】1fe 1be 同一个机器混部
【机器信息】8C32G
【联系方式】yukai@kiscloud.net
【附件】
- fe.audit.log
- be.out
be.out (13.8 KB) - sql error msg
- SQL
SELECT COUNT(*) FROM log WHERE service_name = 'ty-app-groupbuying' AND msg LIKE CONCAT('%', 'https://v.douyin.com/iSNfJWWQ/', '%') AND timestamp >= '2024-10-19 16:00:00' AND timestamp <= '2024-10-19 16:00:00'
- TABLE STRUCT
CREATE TABLE `log` (
`timestamp` datetime NOT NULL COMMENT "时间",
`service_name` varchar(200) NULL DEFAULT "" COMMENT "服务名",
`log_level` varchar(200) NULL DEFAULT "" COMMENT "日志级别 INFO WARN ERROR",
`trace_id` varchar(200) NULL DEFAULT "" COMMENT "trace_id",
`span_id` varchar(500) NULL DEFAULT "" COMMENT "span_id",
`host_name` varchar(500) NULL DEFAULT "" COMMENT "服务地址 如：saas-cloud-docker-1287",
`thread` varchar(500) NULL DEFAULT "" COMMENT "线程",
`class_name` varchar(500) NULL DEFAULT "" COMMENT "打印类路径",
`class_line` int(11) NULL COMMENT "打印类行号",
`msg` varchar(65533) NULL DEFAULT "" COMMENT "日志内容",
`tag` varchar(200) NULL DEFAULT "" COMMENT "标签 SR SS EX SC",
`request_method` varchar(200) NULL DEFAULT "" COMMENT "请求方式 GET,POST等",
`remote_host` varchar(200) NULL DEFAULT "" COMMENT "远程调用ip",
`url` varchar(500) NULL DEFAULT "" COMMENT "接口url",
`invoke_service_name` varchar(500) NULL DEFAULT "" COMMENT "调用服务名",
`exception_name` varchar(500) NULL DEFAULT "" COMMENT "异常名",
`response_status` smallint(6) NULL COMMENT "http响应状态码",
`response_size` int(11) NULL COMMENT "响应大小 单位byte",
`duration` int(11) NULL COMMENT "响应耗时 单位ms",
`extra_map` map<varchar(65533),varchar(65533)> NULL COMMENT "预留map",
INDEX log_level_index (`log_level`) USING BITMAP COMMENT '',
INDEX index_msg (`msg`) USING NGRAMBF("bloom_filter_fpp" = "0.05", "case_sensitive" = "true", "gram_num" = "4") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`timestamp`, `service_name`, `log_level`)
PARTITION BY date_trunc('day', timestamp)
DISTRIBUTED BY HASH(`trace_id`) BUCKETS 100
ORDER BY(`timestamp`)
PROPERTIES (
"compression" = "ZSTD",
"fast_schema_evolution" = "true",
"partition_live_number" = "90",
"replicated_storage" = "false",
"replication_num" = "1"
);