V2.5.20，SQL偶发执行失败，报java.lang.NullPointerException

💬 StarRocks 用户问答 日常运维
#1

【详述】SQL偶发执行失败，报java.lang.NullPointerException，手动拿SQL通过dbeaver去跑，可以正常获取数据。
【背景】无
【业务影响】影响用户查询数据
【是否存算分离】否
【StarRocks版本】V2.5.20
【集群规模】5fe（3 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，104C/512G/万兆
【联系方式】StarRocks社区群9-微笑人生
【附件】

  • fe.warn.log.20240521-1日志
    2024-05-21 18:20:19,378 WARN (starrocks-mysql-nio-pool-3063|318062) [Coordinator.cancel():1645] cancel execution of query, this is outside invoke
    2024-05-21 18:20:19,379 WARN (starrocks-mysql-nio-pool-3063|318062) [ConnectProcessor.handleQuery():360] Process one query failed. SQL: --IHD账号_HC列表
    with in_pow_emp as (
    …
    LIMIT 0, 50, because unknown reason:
    java.lang.NullPointerException: null
    at com.starrocks.qe.Coordinator.cancelInternal(Coordinator.java:1666) ~[starrocks-fe.jar:?]
    at com.starrocks.qe.Coordinator.cancel(Coordinator.java:1646) ~[starrocks-fe.jar:?]
    at com.starrocks.qe.Coordinator.cancel(Coordinator.java:1662) ~[starrocks-fe.jar:?]
    at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:618) ~[starrocks-fe.jar:?]
    at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:337) ~[starrocks-fe.jar:?]
    at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:446) ~[starrocks-fe.jar:?]
    at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:723) ~[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_151]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_151]
    at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_151]
    2024-05-21 18:21:14,335 WARN (replayer|91) [OlapTableTxnLogApplier.applyVisibleLog():107] skip update replica[2064924900.11002] to visible version

run_sql.txt
run_sql.txt (10.2 KB)

explain.txt
explain.txt (105.7 KB)

dump_query.txt
dump_query.txt (88.8 KB)

#2

3.1.5-bfcef6e 版本在并发的情况下，也偶然有出现这种报错，不能稳定重现。大家有遇到和解决方法吗，感谢。
2024-10-30 02:42:40,740 INFO (starrocks-mysql-nio-pool-1423512|143332807) [QeProcessorImpl.unregisterQuery():139] deregister query id = 99d3bb88-9668-11ef-9629-52540088c0cf
2024-10-30 02:42:40,740 WARN (starrocks-mysql-nio-pool-1423512|143332807) [StmtExecutor.execute():665] execute Exception, sql select * from ton_address_total_latest_balance where wallet_address in (‘EQAZ-xaJFvhFoF5ghtM-0-p8pC9NT1jdljzO7gk6owlGRpda’,‘eqaz-xajfvhfof5ghtm-0-p8pc9nt1jdljzo7gk6owlgrpda’) order by value desc limit 100
java.lang.NullPointerException: null
2024-10-30 02:42:40,740 WARN (starrocks-mysql-nio-pool-1423512|143332807) [Coordinator.cancel():1560] cancel execution of query, this is outside invoke
2024-10-30 02:42:40,740 INFO (starrocks-mysql-nio-pool-1423493|143330340) [QeProcessorImpl.unregisterQuery():139] deregister query id = 9ab39445-9668-11ef-9629-52540088c0cf
2024-10-30 02:42:40,741 WARN (starrocks-mysql-nio-pool-1423493|143330340) [StmtExecutor.execute():665] execute Exception, sql select * from ton_address_total_latest_balance where wallet_address in (‘EQCGGdVpSlTJE0auxyCbK2O3_3E7skfBLxiAo2zmHjm3qhWt’,‘eqcggdvpsltje0auxycbk2o3_3e7skfblxiao2zmhjm3qhwt’) order by value desc limit 100
java.lang.NullPointerException: null
2024-10-30 02:42:40,741 WARN (starrocks-mysql-nio-pool-1423493|143330340) [Coordinator.cancel():1560] cancel execution of query, this is outside invoke

京ICP备2022026421号-1