ADD UNIQUE KEY IF NOT EXISTS #2204
Description
ALTER TABLE vnet_vpc.zone_vpc_associationADD UNIQUE KEY IF NOT EXISTSindex_id(id)" 2025-07-03 14:21:18 ERROR MysqlParserListener - (index_type_3 UNIQUE (index_or_key KEY) IF NOT EXISTS index_id(id)) 2025-07-03 14:21:18 ERROR SchemaChange - Error parsing SQL: '-- fix zone_vpc_association deadlock ALTER TABLEvnet_vpc.zone_vpc_associationADD UNIQUE KEY IF NOT EXISTSindex_id(id)' 2025-07-03 14:21:18 ERROR AbstractSchemaStore - Error on bin log position Position[BinlogPosition[mysql-bin.000017:3756495], lastHeartbeat=1751523678484] com.zendesk.maxwell.schema.ddl.MaxwellSQLSyntaxError: IF at com.zendesk.maxwell.schema.ddl.MysqlParserListener.visitErrorNode(MysqlParserListener.java:93) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:17) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at com.zendesk.maxwell.schema.ddl.SchemaChange.parseSQL(SchemaChange.java:101) at com.zendesk.maxwell.schema.ddl.SchemaChange.parse(SchemaChange.java:115) at com.zendesk.maxwell.schema.AbstractSchemaStore.resolveSQL(AbstractSchemaStore.java:49) at com.zendesk.maxwell.schema.MysqlSchemaStore.processSQL(MysqlSchemaStore.java:102) at com.zendesk.maxwell.replication.BinlogConnectorReplicator.processQueryEvent(BinlogConnectorReplicator.java:385) at com.zendesk.maxwell.replication.BinlogConnectorReplicator.processQueryEvent(BinlogConnectorReplicator.java:407) at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getRow(BinlogConnectorReplicator.java:738) at com.zendesk.maxwell.replication.BinlogConnectorReplicator.work(BinlogConnectorReplicator.java:235) at com.zendesk.maxwell.util.RunLoopProcess.runLoop(RunLoopProcess.java:34) at com.zendesk.maxwell.Maxwell.startInner(Maxwell.java:302) at com.zendesk.maxwell.Maxwell.start(Maxwell.java:227) at com.zendesk.maxwell.Maxwell.main(Maxwell.java:337)
I encountered this error while using Maxwell; how do I fix it? thx