Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
irisrain opened this issue Nov 8, 2024 · 0 comments
Open

Comments

@irisrain
Copy link

irisrain commented Nov 8, 2024

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) [?:?]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant