2.5.22莫名空指针问题

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】执行 insert into select 会空指针
【背景】无
【业务影响】数据未正常运行
【是否存算分离】否
【StarRocks版本 2.5.22
【集群规模】4fe(1 follower+2observer)+4be(fe与be混部)
【联系方式】社区群10-A或者1959533192@qq.com
【附件】报错信息
A problem occurred while executing the [ insert into data_zucc_personal.zidingyisql_jieguoji1_1_0548A9(id_0_0,DMJLBID_1_1,XH_2_2,SFYSC_3_3,TBCJSJ_4_4,DMJG_8_5)(select id_0,DMJLBID_1,XH_2,SFYSC_3,TBCJSJ_4,DMJG_8 from chaxun_jieguoji1_1_1A4D8A as a inner join (select max(id_0) id from chaxun_jieguoji1_1_1A4D8A group by XH_2 ,TBCJSJ_4)b on a.id_0 = b.id )] statement with label:insert_60251f64-ba45-11ef-a5b3-726d282ba827

2024-12-15 02:01:00,047 INFO (thrift-server-pool-15047087|15144611) [DatabaseTransactionMgr.beginTransaction():313] begin transaction: txn_id: 28024118 with label insert_60251f64-ba45-11ef-a5b3-726d282ba827 from coordinator FE: 10.61.186.229, listner id: -1
2024-12-15 02:01:00,047 INFO (thrift-server-pool-15047058|15144582) [LeaderImpl.finishCreateReplica():358] finish create replica. tablet id: 17412994, be: 11005, report version: 17200178249743, tablet type: TABLET_TYPE_DISK
2024-12-15 02:01:00,047 INFO (thrift-server-pool-15047051|15144575) [SystemInfoService.updateBackendReportVersion():780] update backend 11001 report version: 17200176289745, db: 11152
2024-12-15 02:01:00,047 INFO (thrift-server-pool-15047051|15144575) [LeaderImpl.finishCreateReplica():358] finish create replica. tablet id: 17412996, be: 11001, report version: 17200176289745, tablet type: TABLET_TYPE_DISK
2024-12-15 02:01:00,047 INFO (thrift-server-pool-15047086|15144610) [LocalMetastore.buildPartitionsSequentially():1695] build partitions sequentially, all tasks finished, took 3ms
2024-12-15 02:01:00,052 INFO (thrift-server-pool-15047082|15144606) [LocalMetastore.truncateTable():4772] finished to truncate table data_zucc_personal.chaxun_jieguoji1_1_1A4D8A, partitions: null
2024-12-15 02:01:00,052 INFO (thrift-server-pool-15047082|15144606) [MetadataMgr.removeQueryMetadata():113] Succeed to deregister query level connector metadata on query id: 60248320-ba45-11ef-a5b3-726d282ba827
2024-12-15 02:01:00,054 INFO (thrift-server-pool-15047088|15144612) [MetadataMgr.removeQueryMetadata():113] Succeed to deregister query level connector metadata on query id: 6024f852-ba45-11ef-a5b3-726d282ba827
2024-12-15 02:01:00,054 INFO (thrift-server-pool-15047088|15144612) [DatabaseTransactionMgr.beginTransaction():313] begin transaction: txn_id: 28024119 with label insert_6024f852-ba45-11ef-a5b3-726d282ba827 from coordinator FE: 10.61.186.229, listner id: -1
2024-12-15 02:01:00,054 INFO (thrift-server-pool-15047087|15144611) [QeProcessorImpl.registerQuery():83] register query id = 60251f64-ba45-11ef-a5b3-726d282ba827, job: 17413002
2024-12-15 02:01:00,054 WARN (thrift-server-pool-15047087|15144611) [StmtExecutor.handleDMLStmtImpl():1648] failed to handle stmt [insert into data_zucc_personal.zidingyisql_jieguoji1_1_0548A9(id_0_0,DMJLBID_1_1,XH_2_2,SFYSC_3_3,TBCJSJ_4_4,DMJG_8_5)(select id_0,DMJLBID_1,XH_2,SFYSC_3,TBCJSJ_4,DMJG_8 from chaxun_jieguoji1_1_1A4D8A as a inner join (select max(id_0) id from chaxun_jieguoji1_1_1A4D8A group by XH_2 ,TBCJSJ_4)b on a.id_0 = b.id )] label: insert_60251f64-ba45-11ef-a5b3-726d282ba827
java.lang.NullPointerException: null
2024-12-15 02:01:00,055 INFO (thrift-server-pool-15047082|15144606) [FrontendServiceImpl.forward():878] receive forwarded stmt 23916423 from FE: 10.61.186.227
2024-12-15 02:01:00,055 INFO (thrift-server-pool-15047082|15144606) [ConnectProcessor.proxyExecute():655] Set session variables first: SET autocommit = 1,sql_mode = ‘ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES’,character_set_results = NULL
2024-12-15 02:01:00,055 INFO (thrift-server-pool-15047082|15144606) [MetadataMgr.removeQueryMetadata():113] Succeed to deregister query level connector metadata on query id: 60287ac6-ba45-11ef-a5b3-726d282ba827
2024-12-15 02:01:00,055 INFO (thrift-server-pool-15047082|15144606) [MetadataMgr.removeQueryMetadata():113] Succeed to deregister query level connector metadata on query id: 60287ac6-ba45-11ef-a5b3-726d282ba827
2024-12-15 02:01:00,057 INFO (thrift-server-pool-15047083|15144607) [LocalMetastore.truncateTable():4772] finished to truncate table data_zucc_personal.chaxun_jieguoji1_1_2FB50D, partitions: null
2024-12-15 02:01:00,057 INFO (thrift-server-pool-15047083|15144607) [MetadataMgr.removeQueryMetadata():113] Succeed to deregister query level connector metadata on query id: 60251f63-ba45-11ef-a5b3-726d282ba827
2024-12-15 02:01:00,057 INFO (thrift-server-pool-15047084|15144608) [FrontendServiceImpl.forward():878] receive forwarded stmt 23916424 from FE: 10.61.186.227
2024-12-15 02:01:00,057 INFO (thrift-server-pool-15047084|15144608) [ConnectProcessor.proxyExecute():655] Set session variables first: SET autocommit = 1,sql_mode = ‘ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES’,character_set_results = NULL
2024-12-15 02:01:00,057 INFO (thrift-server-pool-15047084|15144608) [MetadataMgr.removeQueryMetadata():113] Succeed to deregister query level connector metadata on query id: 6028a1d7-ba45-11ef-a5b3-726d282ba827
2024-12-15 02:01:00,057 INFO (thrift-server-pool-15047084|15144608) [MetadataMgr.removeQueryMetadata():113] Succeed to deregister query level connector metadata on query id: 6028a1d7-ba45-11ef-a5b3-726d282ba827
2024-12-15 02:01:00,060 INFO (thrift-server-pool-15047088|15144612) [QeProcessorImpl.registerQuery():83] register query id = 6024f852-ba45-11ef-a5b3-726d282ba827, job: 17413003
2024-12-15 02:01:00,060 INFO (thrift-server-pool-15047087|15144611) [DatabaseTransactionMgr.abortTransaction():1289] transaction:[TransactionState. txn_id: 28024118, label: insert_60251f64-ba45-11ef-a5b3-726d282ba827, db id: 11152, table id list: 7481986, callback id: -1, coordinator: FE: 10.61.186.229, transaction status: ABORTED, error replicas num: 0, replica ids: , prepare time: 1734199260047, commit time: -1, finish time: 1734199260055, total cost: 8ms, reason: A problem occurred while executing the [ insert into data_zucc_personal.zidingyisql_jieguoji1_1_0548A9(id_0_0,DMJLBID_1_1,XH_2_2,SFYSC_3_3,TBCJSJ_4_4,DMJG_8_5)(select id_0,DMJLBID_1,XH_2,SFYSC_3,TBCJSJ_4,DMJG_8 from chaxun_jieguoji1_1_1A4D8A as a inner join (select max(id_0) id from chaxun_jieguoji1_1_1A4D8A group by XH_2 ,TBCJSJ_4)b on a.id_0 = b.id )] statement with label:insert_60251f64-ba45-11ef-a5b3-726d282ba827] successfully rollback
2024-12-15 02:01:00,061 INFO (thrift-server-pool-15047088|15144612) [Coordinator.prepareResultSink():778] dispatch load job: 6024f852-ba45-11ef-a5b3-726d282ba827 to [TNetworkAddress(hostname:10.61.186.228, port:9060), TNetworkAddress(hostname:10.61.186.229, port:9060)]
2024-12-15 02:01:00,063 INFO (thrift-server-pool-15047085|15144609) [LocalMetastore.truncateTable():4772] finished to truncate table data_zucc_personal.chaxun_jieguoji1_1_02E19E, partitions: null
2024-12-15 02:01:00,063 INFO (thrift-server-pool-15047085|15144609) [MetadataMgr.removeQueryMetadata():113] Succeed to deregister query level connector metadata on query id: 6024d141-ba45-11ef-a5b3-726d282ba827
2024-12-15 02:01:00,065 INFO (thrift-server-pool-15047083|15144607) [FrontendServiceImpl.forward():878] receive forwarded stmt 23916425 from FE: 10.61.186.227

2.5当前已经不发新版了,问题修复都会合并到高版本中,建议升级到高版本,如果还有该问题,重新发帖