【详述】
集群从2.1.1升级到2.5.3,修改主键模型的表的属性:
ALTER TABLE XXX.XXX
SET (“enable_persistent_index”=“true”);
升级完成后,fe只有LEADER的alive是true,其他都是false,
三个节点的fe的日志中出现大量报错:
2023-04-09 23:47:55,030 ERROR (replayer|82) [BDBJournalCursor.deserializeData():241] fail to read journal entity key=21460997, data=
java.io.IOException: UNKNOWN Operation Type 10005
at com.starrocks.journal.JournalEntity.readFields(JournalEntity.java:766) ~[starrocks-fe.jar:?]
at com.starrocks.journal.bdbje.BDBJournalCursor.deserializeData(BDBJournalCursor.java:236) [starrocks-fe.jar:?]
at com.starrocks.journal.bdbje.BDBJournalCursor.next(BDBJournalCursor.java:280) [starrocks-fe.jar:?]
at com.starrocks.server.GlobalStateMgr.replayJournalInner(GlobalStateMgr.java:1894) [starrocks-fe.jar:?]
at com.starrocks.server.GlobalStateMgr$5.runOneCycle(GlobalStateMgr.java:1759) [starrocks-fe.jar:?]
at com.starrocks.common.util.Daemon.run(Daemon.java:115) [starrocks-fe.jar:?]
at com.starrocks.server.GlobalStateMgr$5.run(GlobalStateMgr.java:1824) [starrocks-fe.jar:?]
设置ignore_unknown_log_id = true参数后,fe节点顺利启动,但是查询:
SELECT * FROM information_schema.tables_config WHERE
– TABLE_SCHEMA = ‘MRTDB’;
TABLE_MODEL = ‘PRIMARY_KEYS’
and PROPERTIES like ‘%“enable_persistent_index”:“false”%’;
LEADER节点和Follow节点enable_persistent_index属性的值不一致。
【背景】ALTER TABLE XXX.XXX
SET (“enable_persistent_index”=“true”);
【业务影响】
【StarRocks版本】例如:2.5.3
【集群规模】例如:3fe(1 follower+2observer)+5be(fe与be混部)
【机器信息】CPU虚拟核/内存/网卡,例如:48C/64G/万兆
【联系方式】社区群1-数据小黑