升级3.2.6之后无法创建临时分区

💬 StarRocks 用户问答 功能使用相关
#1

【详述】升级3.2.6版本之后创建临时分区报错：[42000][1064] Unexpected exception: null
【StarRocks版本】3.2.6-2585333
【附件】
建表语句：

CREATE TABLE `stream_load_table` (
          `commodity_id` int(11) NOT NULL COMMENT "商品id",
          `date` date NOT NULL COMMENT "发文日期",
          `text` varchar(65533) NULL COMMENT "text",
          `update_time` datetime NOT NULL COMMENT "写入日期"
        ) ENGINE=OLAP
        UNIQUE KEY(`commodity_id`, `date`)
        COMMENT "OLAP"
        PARTITION BY RANGE(`date`)
        (PARTITION p2019 VALUES [("2019-01-01"), ("2020-01-01")),
        PARTITION p202001 VALUES [("2020-01-01"), ("2020-02-01")),
        PARTITION p202002 VALUES [("2020-02-01"), ("2020-03-01")),
        PARTITION p202003 VALUES [("2020-03-01"), ("2020-04-01")),
        PARTITION p202004 VALUES [("2020-04-01"), ("2020-05-01")),
        PARTITION p202005 VALUES [("2020-05-01"), ("2020-06-01")),
        PARTITION p202006 VALUES [("2020-06-01"), ("2020-07-01")),
        PARTITION p202007 VALUES [("2020-07-01"), ("2020-08-01")),
        PARTITION p202008 VALUES [("2020-08-01"), ("2020-09-01")),
        PARTITION p202009 VALUES [("2020-09-01"), ("2020-10-01")),
        PARTITION p202010 VALUES [("2020-10-01"), ("2020-11-01")),
        PARTITION p202011 VALUES [("2020-11-01"), ("2020-12-01")),
        PARTITION p202012 VALUES [("2020-12-01"), ("2021-01-01")),
        PARTITION p202101 VALUES [("2021-01-01"), ("2021-02-01")),
        PARTITION p202102 VALUES [("2021-02-01"), ("2021-03-01")),
        PARTITION p202103 VALUES [("2021-03-01"), ("2021-04-01")),
        PARTITION p202104 VALUES [("2021-04-01"), ("2021-05-01")),
        PARTITION p202105 VALUES [("2021-05-01"), ("2021-06-01")),
        PARTITION p202106 VALUES [("2021-06-01"), ("2021-07-01")),
        PARTITION p202107 VALUES [("2021-07-01"), ("2021-08-01")),
        PARTITION p202108 VALUES [("2021-08-01"), ("2021-09-01")),
        PARTITION p202109 VALUES [("2021-09-01"), ("2021-10-01")),
        PARTITION p202110 VALUES [("2021-10-01"), ("2021-11-01")),
        PARTITION p202111 VALUES [("2021-11-01"), ("2021-12-01")),
        PARTITION p202112 VALUES [("2021-12-01"), ("2022-01-01")),
        PARTITION p202201 VALUES [("2022-01-01"), ("2022-02-01")),
        PARTITION p202202 VALUES [("2022-02-01"), ("2022-03-01")),
        PARTITION p202203 VALUES [("2022-03-01"), ("2022-04-01")),
        PARTITION p202204 VALUES [("2022-04-01"), ("2022-05-01")),
        PARTITION p202205 VALUES [("2022-05-01"), ("2022-06-01")),
        PARTITION p202206 VALUES [("2022-06-01"), ("2022-07-01")),
        PARTITION p202207 VALUES [("2022-07-01"), ("2022-08-01")),
        PARTITION p202208 VALUES [("2022-08-01"), ("2022-09-01")),
        PARTITION p202209 VALUES [("2022-09-01"), ("2022-10-01")),
        PARTITION p202210 VALUES [("2022-10-01"), ("2022-11-01")),
        PARTITION p202211 VALUES [("2022-11-01"), ("2022-12-01")),
        PARTITION p202212 VALUES [("2022-12-01"), ("2023-01-01")),
        PARTITION p202301 VALUES [("2023-01-01"), ("2023-02-01")),
        PARTITION p202302 VALUES [("2023-02-01"), ("2023-03-01")),
        PARTITION p202303 VALUES [("2023-03-01"), ("2023-04-01")),
        PARTITION p202304 VALUES [("2023-04-01"), ("2023-05-01")),
        PARTITION p202305 VALUES [("2023-05-01"), ("2023-06-01")),
        PARTITION p202306 VALUES [("2023-06-01"), ("2023-07-01")),
        PARTITION p202307 VALUES [("2023-07-01"), ("2023-08-01")),
        PARTITION p202308 VALUES [("2023-08-01"), ("2023-09-01")),
        PARTITION p202309 VALUES [("2023-09-01"), ("2023-10-01")),
        PARTITION p202310 VALUES [("2023-10-01"), ("2023-11-01")),
        PARTITION p202311 VALUES [("2023-11-01"), ("2023-12-01")),
        PARTITION p202312 VALUES [("2023-12-01"), ("2024-01-01")),
        PARTITION p202401 VALUES [("2024-01-01"), ("2024-02-01")),
        PARTITION p202402 VALUES [("2024-02-01"), ("2024-03-01")),
        PARTITION p202403 VALUES [("2024-03-01"), ("2024-04-01")),
        PARTITION p202404 VALUES [("2024-04-01"), ("2024-05-01")),
        PARTITION p202405 VALUES [("2024-05-01"), ("2024-06-01")),
        PARTITION p202406 VALUES [("2024-06-01"), ("2024-07-01")),
        PARTITION p202407 VALUES [("2024-07-01"), ("2024-08-01")),
        PARTITION p202408 VALUES [("2024-08-01"), ("2024-09-01")),
        PARTITION p202409 VALUES [("2024-09-01"), ("2024-10-01")),
        PARTITION p202410 VALUES [("2024-10-01"), ("2024-11-01")),
        PARTITION p202411 VALUES [("2024-11-01"), ("2024-12-01")),
        PARTITION p202412 VALUES [("2024-12-01"), ("2025-01-01")),
        PARTITION p202501 VALUES [("2025-01-01"), ("2025-02-01")),
        PARTITION p202502 VALUES [("2025-02-01"), ("2025-03-01")),
        PARTITION p202503 VALUES [("2025-03-01"), ("2025-04-01")),
        PARTITION p202504 VALUES [("2025-04-01"), ("2025-05-01")),
        PARTITION p202505 VALUES [("2025-05-01"), ("2025-06-01")),
        PARTITION p202506 VALUES [("2025-06-01"), ("2025-07-01")),
        PARTITION p202507 VALUES [("2025-07-01"), ("2025-08-01")),
        PARTITION p202508 VALUES [("2025-08-01"), ("2025-09-01")),
        PARTITION p202509 VALUES [("2025-09-01"), ("2025-10-01")),
        PARTITION p202510 VALUES [("2025-10-01"), ("2025-11-01")),
        PARTITION p202511 VALUES [("2025-11-01"), ("2025-12-01")),
        PARTITION p202512 VALUES [("2025-12-01"), ("2026-01-01")),
        PARTITION p202601 VALUES [("2026-01-01"), ("2026-02-01")),
        PARTITION p202602 VALUES [("2026-02-01"), ("2026-03-01")),
        PARTITION p202603 VALUES [("2026-03-01"), ("2026-04-01")),
        PARTITION p202604 VALUES [("2026-04-01"), ("2026-05-01")),
        PARTITION p202605 VALUES [("2026-05-01"), ("2026-06-01")),
        PARTITION p202606 VALUES [("2026-06-01"), ("2026-07-01")),
        PARTITION p202607 VALUES [("2026-07-01"), ("2026-08-01")),
        PARTITION p202608 VALUES [("2026-08-01"), ("2026-09-01")),
        PARTITION p202609 VALUES [("2026-09-01"), ("2026-10-01")),
        PARTITION p202610 VALUES [("2026-10-01"), ("2026-11-01")),
        PARTITION p202611 VALUES [("2026-11-01"), ("2026-12-01")),
        PARTITION p202612 VALUES [("2026-12-01"), ("2027-01-01")),
        PARTITION p202701 VALUES [("2027-01-01"), ("2027-02-01")),
        PARTITION p202702 VALUES [("2027-02-01"), ("2027-03-01")),
        PARTITION p202703 VALUES [("2027-03-01"), ("2027-04-01")),
        PARTITION p202704 VALUES [("2027-04-01"), ("2027-05-01")),
        PARTITION p202705 VALUES [("2027-05-01"), ("2027-06-01")),
        PARTITION p202706 VALUES [("2027-06-01"), ("2027-07-01")),
        PARTITION p202707 VALUES [("2027-07-01"), ("2027-08-01")),
        PARTITION p202708 VALUES [("2027-08-01"), ("2027-09-01")),
        PARTITION p202709 VALUES [("2027-09-01"), ("2027-10-01")),
        PARTITION p202710 VALUES [("2027-10-01"), ("2027-11-01")),
        PARTITION p202711 VALUES [("2027-11-01"), ("2027-12-01")),
        PARTITION p202712 VALUES [("2027-12-01"), ("2028-01-01")),
        PARTITION p202801 VALUES [("2028-01-01"), ("2028-02-01")),
        PARTITION p202802 VALUES [("2028-02-01"), ("2028-03-01")),
        PARTITION p202803 VALUES [("2028-03-01"), ("2028-04-01")),
        PARTITION p202804 VALUES [("2028-04-01"), ("2028-05-01")),
        PARTITION p202805 VALUES [("2028-05-01"), ("2028-06-01")),
        PARTITION p202806 VALUES [("2028-06-01"), ("2028-07-01")),
        PARTITION p202807 VALUES [("2028-07-01"), ("2028-08-01")),
        PARTITION p202808 VALUES [("2028-08-01"), ("2028-09-01")),
        PARTITION p202809 VALUES [("2028-09-01"), ("2028-10-01")),
        PARTITION p202810 VALUES [("2028-10-01"), ("2028-11-01")),
        PARTITION p202811 VALUES [("2028-11-01"), ("2028-12-01")),
        PARTITION p202812 VALUES [("2028-12-01"), ("2029-01-01")),
        PARTITION p202901 VALUES [("2029-01-01"), ("2029-02-01")),
        PARTITION p202902 VALUES [("2029-02-01"), ("2029-03-01")),
        PARTITION p202903 VALUES [("2029-03-01"), ("2029-04-01")),
        PARTITION p202904 VALUES [("2029-04-01"), ("2029-05-01")),
        PARTITION p202905 VALUES [("2029-05-01"), ("2029-06-01")),
        PARTITION p202906 VALUES [("2029-06-01"), ("2029-07-01")),
        PARTITION p202907 VALUES [("2029-07-01"), ("2029-08-01")),
        PARTITION p202908 VALUES [("2029-08-01"), ("2029-09-01")),
        PARTITION p202909 VALUES [("2029-09-01"), ("2029-10-01")),
        PARTITION p202910 VALUES [("2029-10-01"), ("2029-11-01")),
        PARTITION p202911 VALUES [("2029-11-01"), ("2029-12-01")),
        PARTITION p202912 VALUES [("2029-12-01"), ("2030-01-01")))
        DISTRIBUTED BY HASH(`commodity_id`) BUCKETS 2
        PROPERTIES (
        "replication_num" = "3",
        "in_memory" = "false",
        "enable_persistent_index" = "false",
        "replicated_storage" = "false",
        "compression" = "LZ4"
        );

添加临时分区：
ALTER TABLE stream_load_table ADD TEMPORARY PARTITION IF NOT EXISTS tp202101 VALUES [('2021-01-01'),('2021-02-01')) ;

报错：
[42000][1064] Unexpected exception: null

#2

麻烦在FE LEADER提供一下fe.log的日志。

#3 
2024-04-24 16:25:47.825+08:00 INFO (starrocks-mysql-nio-pool-482|70343) [QeProcessorImpl.registerQuery():108] register query id = 409a24ea-0214-11ef-8eaf-1866dae960a9
2024-04-24 16:25:47.828+08:00 INFO (starrocks-mysql-nio-pool-482|70343) [QeProcessorImpl.unregisterQuery():150] deregister query id = 409a24ea-0214-11ef-8eaf-1866dae960a9
2024-04-24 16:25:48.009+08:00 INFO (starrocks-mysql-nio-pool-482|70343) [Database.checkDataSizeQuota():444] database[m_dev] data quota: left bytes: 8388607.822 TB / total: 8388608.000 TB
2024-04-24 16:25:48.050+08:00 INFO (starrocks-mysql-nio-pool-482|70343) [Database.checkReplicaQuota():455] database[m_dev] replica quota: left number: 9223372036853754631 / total: 9223372036854775807
2024-04-24 16:25:48.081+08:00 INFO (starrocks-mysql-nio-pool-482|70343) [LocalMetastore.buildPartitions():1903] start to build 1 partitions sequentially for table m_dev.stream_load_table with 6 replicas
2024-04-24 16:25:48.082+08:00 INFO (starrocks-mysql-nio-pool-482|70343) [LocalMetastore.buildCreateReplicaTasks():2034] build create replica tasks for index index id: 558210; index state: NORMAL; row count: 0; tablets size: 2; visibleTxnId: 0; tablets: [tablet: id=12850149, tablet: id=12850153, ];  db 10112 table 558209 partition partition_id: 12850148; name: tp202101; partition_state.name: NORMAL; base_index: index id: 558210; index state: NORMAL; row count: 0; tablets size: 2; visibleTxnId: 0; tablets: [tablet: id=12850149, tablet: id=12850153, ]; ; rollup count: 0; committedVersion: 1; committedVersionHash: 0; distribution_info.type: HASH; distribution_info: type: HASH; distribution columns: [commodity_id,]; bucket num: 2; 
2024-04-24 16:25:48.082+08:00 WARN (starrocks-mysql-nio-pool-482|70343) [StmtExecutor.handleDdlStmt():1599] DDL statement (/* ApplicationName=DataGrip 2024.1.1 */ ALTER TABLE stream_load_table ADD TEMPORARY PARTITION IF NOT EXISTS tp202101 VALUES [('2021-01-01'),('2021-02-01'))) process failed.
java.lang.IllegalStateException: null
        at com.google.common.base.Preconditions.checkState(Preconditions.java:496) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.catalog.SchemaInfo$Builder.build(SchemaInfo.java:262) ~[starrocks-fe.jar:?]
        at com.starrocks.server.LocalMetastore.buildCreateReplicaTasks(LocalMetastore.java:2057) ~[starrocks-fe.jar:?]
        at com.starrocks.server.LocalMetastore.buildCreateReplicaTasks(LocalMetastore.java:2027) ~[starrocks-fe.jar:?]
        at com.starrocks.server.LocalMetastore.buildCreateReplicaTasks(LocalMetastore.java:2018) ~[starrocks-fe.jar:?]
        at com.starrocks.server.LocalMetastore.buildPartitionsSequentially(LocalMetastore.java:1927) ~[starrocks-fe.jar:?]
        at com.starrocks.server.LocalMetastore.buildPartitions(LocalMetastore.java:1905) ~[starrocks-fe.jar:?]
        at com.starrocks.server.LocalMetastore.addPartitions(LocalMetastore.java:1420) ~[starrocks-fe.jar:?]
        at com.starrocks.server.LocalMetastore.addPartitions(LocalMetastore.java:890) ~[starrocks-fe.jar:?]
        at com.starrocks.server.GlobalStateMgr.addPartitions(GlobalStateMgr.java:2554) ~[starrocks-fe.jar:?]
        at com.starrocks.alter.AlterJobMgr.processAlterTable(AlterJobMgr.java:631) ~[starrocks-fe.jar:?]
        at com.starrocks.server.LocalMetastore.alterTable(LocalMetastore.java:2995) ~[starrocks-fe.jar:?]
        at com.starrocks.server.GlobalStateMgr.alterTable(GlobalStateMgr.java:3505) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitAlterTableStatement$13(DDLStmtExecutor.java:333) ~[starrocks-fe.jar:?]
        at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:108) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitAlterTableStatement(DDLStmtExecutor.java:332) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitAlterTableStatement(DDLStmtExecutor.java:159) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.ast.AlterTableStmt.accept(AlterTableStmt.java:52) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:145) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.handleDdlStmt(StmtExecutor.java:1573) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:650) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:413) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:607) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:901) ~[starrocks-fe.jar:?]
        at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
        at java.lang.Thread.run(Thread.java:829) ~[?:?]
2024-04-24 16:25:48.129+08:00 INFO (starrocks-mysql-nio-pool-482|70343) [QeProcessorImpl.registerQuery():108] register query id = 40c8d610-0214-11ef-8eaf-1866dae960a9
2024-04-24 16:25:48.131+08:00 INFO (starrocks-mysql-nio-pool-482|70343) [QeProcessorImpl.unregisterQuery():150] deregister query id = 40c8d610-0214-11ef-8eaf-1866dae960a9
2024-04-24 16:25:48.131+08:00 INFO (thrift-server-pool-67852|70516) [QeProcessorImpl.reportExecStatus():191] ReportExecStatus() failed, query does not exist, fragment_instance_id=40c8d610-0214-11ef-8eaf-1866dae960aa, query_id=40c8d610-0214-11ef-8eaf-1866dae960a9,
2024-04-24 16:25:48.164+08:00 INFO (starrocks-mysql-nio-pool-482|70343) [QeProcessorImpl.registerQuery():108] register query id = 40ce5452-0214-11ef-8eaf-1866dae960a9
#4

已知问题, 要么退出到原来的版本, 要么有条件可以把原先的表Drop重新创建.

#5

什么时候修复？

#6

https://github.com/StarRocks/starrocks/pull/44397 可以关注这个PR的发版

京ICP备2022026421号-1