【详述】通过proxySql代理端口执行某个insert语句，偶然发生返回报错Unknown error，查询ProxySQL日志为FE节点返回的error, 该insertFE error日志信息：
[StmtExecutor.execute():521] execute Exception, sql insert into t_arc_event(event_id, game_id, type, sdate, edate, targets, comments, is_delete) values (3888,200013, 3, ‘2023-01-24’, ‘2023-01-31’, null, ‘对战平台’, 1)
java.lang.NullPointerException: null
at com.starrocks.sql.analyzer.AST2SQL$SQLBuilder.visitSetStatement(AST2SQL.java:85) ~[starrocks-fe.jar:?]
at com.starrocks.sql.analyzer.AST2SQL$SQLBuilder.visitSetStatement(AST2SQL.java:71) ~[starrocks-fe.jar:?]
at com.starrocks.analysis.SetStmt.accept(SetStmt.java:87) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:129) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:125) ~[starrocks-fe.jar:?]
at com.starrocks.sql.analyzer.AST2SQL.toString(AST2SQL.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.qe.LeaderOpExecutor.forward(LeaderOpExecutor.java:143) ~[starrocks-fe.jar:?]
at com.starrocks.qe.LeaderOpExecutor.execute(LeaderOpExecutor.java:80) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.forwardToLeader(StmtExecutor.java:621) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:398) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:322) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:437) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:683) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_211]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_211]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_211]
【背景】建表语句:
CREATE TABLE t_arc_event (
event_id int(11) NULL COMMENT “”,
game_id int(11) NULL COMMENT “”,
type int(11) NULL COMMENT “”,
sdate varchar(20) NULL COMMENT “”,
edate varchar(20) NULL COMMENT “”,
targets varchar(200) NULL COMMENT “”,
comments varchar(200) NULL COMMENT “”,
is_delete tinyint(4) NOT NULL DEFAULT “0” COMMENT “软删除标识”
) ENGINE=OLAP
UNIQUE KEY(event_id)
COMMENT “t_arc_event”
DISTRIBUTED BY HASH(event_id) BUCKETS 1
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”
);
SQL 执行语句: insert into t_arc_event(event_id, game_id, type, sdate, edate, targets, comments, is_delete) values (3888,200013, 3, ‘2023-01-24’, ‘2023-01-31’, null, ‘对战平台’, 1)
【业务影响】
【StarRocks版本】 2.4.2 3994421
【集群规模】5fe（2 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
- fe.log/beINFO/相应截图
- 慢查询：
- Profile信息
- 并行度：show variables like ‘%parallel_fragment_exec_instance_num%’;
- pipeline是否开启：show variables like ‘%pipeline%’;
- be节点cpu和内存使用率截图
- 查询报错：
- query_dump，怎么获取query_dump文件
- be crash
- be.out
