starrocks
starrocks copied to clipboard
StarRocks
[inverted index]downgrade from 3.3 to 3.2, show create table, info is error
Steps to reproduce the behavior (Required)
- deploy main
- run sql
CREATE TABLE duplicate_table_demo_datatype_not_replicated_all_varchar ( AAA DATETIME not NULL COMMENT "", BBB VARCHAR(200) not NULL COMMENT "", CCC VARCHAR(200) not NULL COMMENT "", DDD VARCHAR(20000) COMMENT "", EEE LARGEINT NULL COMMENT "", FFF DECIMAL(20,10) NULL COMMENT "", GGG VARCHAR(200) NULL COMMENT "", HHH FLOAT NULL COMMENT "", III BOOLEAN NULL COMMENT "", KKK CHAR(20) NULL COMMENT "", LLL STRING NULL COMMENT "", MMM VARCHAR(20) NULL COMMENT "", NNN BINARY NULL COMMENT "", OOO TINYINT NULL COMMENT "", PPP DATETIME NULL COMMENT "", QQQ ARRAY<INT> NULL COMMENT "", RRR JSON NULL COMMENT "", SSS MAP<INT,INT> NULL COMMENT "", TTT STRUCT<a INT, b INT> NULL COMMENT "", INDEX init_bitmap_index (KKK) USING BITMAP ) duplicate KEY(AAA, BBB, CCC) PARTITION BY RANGE (`AAA`) ( START ("1970-01-01") END ("2030-01-01") EVERY (INTERVAL 30 YEAR) ) DISTRIBUTED BY HASH(`AAA`, `BBB`) BUCKETS 3 ORDER BY(`AAA`,`BBB`,`CCC`,`DDD`) PROPERTIES ( "replicated_storage"="false", "replication_num" = "3", "storage_format" = "v2", "enable_persistent_index" = "true", "bloom_filter_columns" = "MMM", "unique_constraints" = "GGG" );
CREATE INDEX idx ON duplicate_table_demo_datatype_not_replicated_all_varchar(DDD) USING GIN('parser' = 'english');
- downgrade to 3.2, show create table
Real behavior (Required)
+----------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| duplicate_table_demo_datatype_not_replicated_all_varchar | CREATE TABLE `duplicate_table_demo_datatype_not_replicated_all_varchar` (
`AAA` datetime NOT NULL COMMENT "",
`BBB` varchar(200) NOT NULL COMMENT "",
`CCC` varchar(200) NOT NULL COMMENT "",
`DDD` varchar(20000) NULL COMMENT "",
`EEE` largeint(40) NULL COMMENT "",
`FFF` decimal(20, 10) NULL COMMENT "",
`GGG` varchar(200) NULL COMMENT "",
`HHH` float NULL COMMENT "",
`III` boolean NULL COMMENT "",
`KKK` char(20) NULL COMMENT "",
`LLL` varchar(65533) NULL COMMENT "",
`MMM` varchar(20) NULL COMMENT "",
`NNN` varbinary NULL COMMENT "",
`OOO` tinyint(4) NULL COMMENT "",
`PPP` datetime NULL COMMENT "",
`QQQ` array<int(11)> NULL COMMENT "",
`RRR` json NULL COMMENT "",
`SSS` map<int(11),int(11)> NULL COMMENT "",
`TTT` struct<a int(11), b int(11)> NULL COMMENT "",
INDEX init_bitmap_index (`KKK`) USING BITMAP COMMENT '',
INDEX idx (`DDD`) COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`AAA`, `BBB`, `CCC`)
PARTITION BY RANGE(`AAA`)
(PARTITION p1970 VALUES [("1970-01-01 00:00:00"), ("2000-01-01 00:00:00")),
PARTITION p2000 VALUES [("2000-01-01 00:00:00"), ("2030-01-01 00:00:00")))
DISTRIBUTED BY HASH(`AAA`, `BBB`) BUCKETS 3
ORDER BY(`AAA`, `BBB`, `CCC`, `DDD`)
PROPERTIES (
"replication_num" = "3",
"bloom_filter_columns" = "MMM",
"in_memory" = "false",
"enable_persistent_index" = "true",
"replicated_storage" = "false",
"fast_schema_evolution" = "true",
"unique_constraints" = "default_catalog.testinvertedindex_db776144cc_fca1_11ee_aec9_00163e21975a.duplicate_table_demo_datatype_not_replicated_all_varchar.GGG",
"compression" = "LZ4"
); |
and drop index failed add index failed
2024-05-10 17:36:56.131+08:00 WARN (thrift-server-pool-24|237) [StmtExecutor.handleDdlStmt():1607] DDL statement (CREATE INDEX idx2 ON duplicate_table_demo_datatype_not_replicated_all_varchar(LLL) USING GIN('parser
' = 'english')) process failed.
java.lang.NullPointerException: null
at com.starrocks.catalog.Index.hashCode(Index.java:174) ~[starrocks-fe.jar:?]
at java.util.HashMap.hash(HashMap.java:340) ~[?:?]
at java.util.HashMap.put(HashMap.java:608) ~[?:?]
at java.util.HashSet.add(HashSet.java:220) ~[?:?]
at java.util.AbstractCollection.addAll(AbstractCollection.java:352) ~[?:?]
at java.util.HashSet.<init>(HashSet.java:120) ~[?:?]
at com.starrocks.alter.SchemaChangeHandler.finalAnalyze(SchemaChangeHandler.java:1121) ~[starrocks-fe.jar:?]
at com.starrocks.alter.SchemaChangeHandler.analyzeAndCreateJob(SchemaChangeHandler.java:1682) ~[starrocks-fe.jar:?]
at com.starrocks.alter.SchemaChangeHandler.process(SchemaChangeHandler.java:1764) ~[starrocks-fe.jar:?]
at com.starrocks.alter.AlterJobMgr.processAlterTable(AlterJobMgr.java:565) ~[starrocks-fe.jar:?]
at com.starrocks.server.LocalMetastore.alterTable(LocalMetastore.java:3062) ~[starrocks-fe.jar:?]
at com.starrocks.server.MetadataMgr.alterTable(MetadataMgr.java:313) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitAlterTableStatement$13(DDLStmtExecutor.java:355) ~[starrocks-fe.jar:?]
at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:108) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitAlterTableStatement(DDLStmtExecutor.java:354) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitAlterTableStatement(DDLStmtExecutor.java:180) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.AlterTableStmt.accept(AlterTableStmt.java:64) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:70) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:166) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDdlStmt(StmtExecutor.java:1577) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:642) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.proxyExecute(ConnectProcessor.java:850) ~[starrocks-fe.jar:?]
at com.starrocks.service.FrontendServiceImpl.forward(FrontendServiceImpl.java:1154) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:4276) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:4256) ~[starrocks-fe.jar:?]
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38) ~[libthrift-0.13.0.jar:0.13.0]
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38) ~[libthrift-0.13.0.jar:0.13.0]
at com.starrocks.common.SRTThreadPoolServer$WorkerProcess.run(SRTThreadPoolServer.java:311) ~[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) ~[?:?]
StarRocks version (Required)
- You can get the StarRocks version by executing SQL
select current_version()
