zendesk / maxwell

Maxwell's daemon, a mysql-to-json kafka producer
https://maxwells-daemon.io/
Other
4.05k stars 1.01k forks source link

Error parsing SQL .MaxwellSQLSyntaxError: '0' "default _utf8mb4'0'" #2128

Open irisrain opened 2 weeks ago

irisrain commented 2 weeks ago

Howdy

I discovered an unexpected reboot issue today, and the log is as follows. The analysis indicates that the error occurs in the section "default _utf8mb4'0'". Is there a way to fix this issue, or can we choose to bypass or ignore this content?

2024-11-07 21:20:32 ERROR MysqlParserListener - (create_specifications ( (create_specification (column_definition (name (id id)) (data_type (signed_type bigint (length ( 21 )) (column_options (nullability not null)) (column_options auto_increment) (column_options comment (string_literal '主键id')))))) , (create_specification (column_definition (name (id user_id)) (data_type (signed_type bigint (length ( 21 )) (column_options (nullability not null)) (column_options (default_value default (literal_with_weirdo_multistring (byte_literal _utf8mb4)))))))) '0' <missing ')'>)

2024-11-07 21:20:32 ERROR SchemaChange - Error parsing SQL: 'create table if not exists _jdts_inner.9db09ac3-9d0a-11ef-b55c-6697661a481a (id bigint(21) not null auto_increment comment '主键id',user_id bigint(21) not null default _utf8mb4'0' comment '用户id',send_status tinyint(3) unsigned not null default _utf8mb4'0' comment '发送状态 0 默认 1 发送成功 2 发送失败',mini_status tinyint(3) unsigned not null default _utf8mb4'0' comment '小程序发>送状态 0 默认 1 发送成功 2 发送失败',app_status tinyint(3) unsigned not null default _utf8mb4'0' comment 'APP发送状态 0 默认 1 发送成功 2 发送失败',message_status tinyint(3) unsigned not null default _utf8mb4'0' comment '>短信发送状态 0 默认 1 发送成功 2 发送失败',push_time datetime not null on update current_timestamp() comment '发送时间',create_time datetime not null on update current_timestamp() comment '创建时间',update_time datetime not null on update current_timestamp() comment '更新时间',business_id bigint(21) not null default _utf8mb4'0' comment '业务ID',primary key(id)) engine = InnoDB auto_increment = 124482 default character set = utf8mb4 comment = '场景营销-购物车明细''

2024-11-07 21:20:32 ERROR TaskManager - cause: com.zendesk.maxwell.schema.ddl.MaxwellSQLSyntaxError: '0' at com.zendesk.maxwell.schema.ddl.MysqlParserListener.visitErrorNode(MysqlParserListener.java:93) ~[maxwell-1.39.6.jar:1.39.6] at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:17) ~[antlr4-runtime-4.8-1.jar:4.8-1] at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) ~[antlr4-runtime-4.8-1.jar:4.8-1] at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) ~[antlr4-runtime-4.8-1.jar:4.8-1] at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) ~[antlr4-runtime-4.8-1.jar:4.8-1] at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) ~[antlr4-runtime-4.8-1.jar:4.8-1] at com.zendesk.maxwell.schema.ddl.SchemaChange.parseSQL(SchemaChange.java:101) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.schema.ddl.SchemaChange.parse(SchemaChange.java:115) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.schema.AbstractSchemaStore.resolveSQL(AbstractSchemaStore.java:49) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.schema.MysqlSchemaStore.processSQL(MysqlSchemaStore.java:102) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.replication.BinlogConnectorReplicator.processQueryEvent(BinlogConnectorReplicator.java:385) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.replication.BinlogConnectorReplicator.processQueryEvent(BinlogConnectorReplicator.java:407) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getRow(BinlogConnectorReplicator.java:735) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.replication.BinlogConnectorReplicator.work(BinlogConnectorReplicator.java:235) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.util.RunLoopProcess.runLoop(RunLoopProcess.java:34) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.Maxwell.startInner(Maxwell.java:302) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.Maxwell.start(Maxwell.java:227) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.MaxwellHA.run(MaxwellHA.java:41) ~[maxwell-1.39.6.jar:1.39.6] at com.zendesk.maxwell.MaxwellHA.lambda$startHA$0(MaxwellHA.java:69) ~[maxwell-1.39.6.jar:1.39.6] at org.jgroups.protocols.raft.RAFT.notifyRoleChangeListeners(RAFT.java:960) ~[jgroups-raft-1.0.0.Final.jar:1.0.0.Final] at org.jgroups.protocols.raft.RAFT.changeRole(RAFT.java:872) ~[jgroups-raft-1.0.0.Final.jar:1.0.0.Final] at org.jgroups.protocols.raft.ELECTION.changeRole(ELECTION.java:323) ~[jgroups-raft-1.0.0.Final.jar:1.0.0.Final] at org.jgroups.protocols.raft.ELECTION.handleVoteResponse(ELECTION.java:242) ~[jgroups-raft-1.0.0.Final.jar:1.0.0.Final] at org.jgroups.protocols.raft.ELECTION.handleEvent(ELECTION.java:200) ~[jgroups-raft-1.0.0.Final.jar:1.0.0.Final] at org.jgroups.protocols.raft.ELECTION.up(ELECTION.java:144) ~[jgroups-raft-1.0.0.Final.jar:1.0.0.Final] at org.jgroups.protocols.FRAG2.up(FRAG2.java:141) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.FlowControl.up(FlowControl.java:316) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.FlowControl.up(FlowControl.java:316) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.pbcast.GMS.up(GMS.java:851) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.raft.NO_DUPES.up(NO_DUPES.java:44) ~[jgroups-raft-1.0.0.Final.jar:1.0.0.Final] at org.jgroups.protocols.pbcast.STABLE.up(STABLE.java:234) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.UNICAST3.up(UNICAST3.java:404) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.pbcast.NAKACK2.up(NAKACK2.java:646) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.VERIFY_SUSPECT.up(VERIFY_SUSPECT.java:133) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.FailureDetection.up(FailureDetection.java:188) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.FD_SOCK.up(FD_SOCK.java:295) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.MERGE3.up(MERGE3.java:281) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.Discovery.up(Discovery.java:295) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.protocols.TP.passMessageUp(TP.java:1477) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] at org.jgroups.util.SubmitToThreadPool$SingleMessageHandler.run(SubmitToThreadPool.java:92) ~[jgroups-5.1.2.Final.jar:5.1.2.Final] 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:834) [?:?]