Skip to content

[Question] bug-使用的是aws的aurora-mysql数据库,这里账户权限是有binlog权限的,但是回滚语句保存。麻烦排查下呢 #1260

@jeffary-he

Description

@jeffary-he

[2026/03/12 03:10:49] [info] binlogsyncer.go:144 create BinlogSyncer with config {1848509 mysql cluster:3306 yearning-dba false false false UTC true 0 0s 0s 0 false false 0}
[2026/03/12 03:10:49] [info] binlogsyncer.go:359 begin to sync binlog from position (mysql-bin-changelog.000348, 3410060)
time="2026-03-12T03:10:49Z" level=error msg="Start sync error: invalid sequence 8 != 1\ngithub.com/cookieY/go-mysql/packet.(*Conn).ReadPacketTo\n\tgithub.com/cookieY/go-mysql@v0.0.0-20220225021506-4b439e6c0f7f/packet/conn.go:104\ngithub.com/cookieY/go-mysql/packet.(*Conn).ReadPacket\n\tgithub.com/cookieY/go-mysql@v0.0.0-20220225021506-4b439e6c0f7f/packet/conn.go:85\ngithub.com/cookieY/go-mysql/client.(*Conn).readResult\n\tgithub.com/cookieY/go-mysql@v0.0.0-20220225021506-4b439e6c0f7f/client/resp.go:215\ngithub.com/cookieY/go-mysql/client.(*Conn).exec\n\tgithub.com/cookieY/go-mysql@v0.0.0-20220225021506-4b439e6c0f7f/client/conn.go:273\ngithub.com/cookieY/go-mysql/client.(*Conn).Execute\n\tgithub.com/cookieY/go-mysql@v0.0.0-20220225021506-4b439e6c0f7f/client/conn.go:155\ngithub.com/cookieY/go-mysql/replication.(*BinlogSyncer).registerSlave\n\tgithub.com/cookieY/go-mysql@v0.0.0-20220225021506-4b439e6c0f7f/replication/binlogsyncer.go:250\ngithub.com/cookieY/go-mysql/replication.(*BinlogSyncer).prepare\n\tgithub.com/cookieY/go-mysql@v0.0.0-20220225021506-4b439e6c0f7f/replication/binlogsyncer.go:331\ngithub.com/cookieY/go-mysql/replication.(*BinlogSyncer).prepareSyncPos\n\tgithub.com/cookieY/go-mysql@v0.0.0-20220225021506-4b439e6c0f7f/replication/binlogsyncer.go:602\ngithub.com/cookieY/go-mysql/replication.(*BinlogSyncer).StartSync\n\tgithub.com/cookieY/go-mysql@v0.0.0-20220225021506-4b439e6c0f7f/replication/binlogsyncer.go:368\ngitee.com/cookieYe/enginex/parse.(*EngineXStmt).binLogParser\n\tgitee.com/cookieYe/enginex@v0.0.3/parse/roll.go:42\ngitee.com/cookieYe/enginex/parse.(*EngineXStmt).backupDML\n\tgitee.com/cookieYe/enginex@v0.0.3/parse/exec.go:168\ngitee.com/cookieYe/enginex/parse.(*EngineXStmt).execDML\n\tgitee.com/cookieYe/enginex@v0.0.3/parse/exec.go:23\ngitee.com/cookieYe/enginex/parse.(*engineX).Exec\n\tgitee.com/cookieYe/enginex@v0.0.3/parse/parse.go:37\nYearning-go/src/handler/order/audit.(*Review).Exec\n\tYearning-go/src/handler/order/audit/executor.go:180\nYearning-go/src/handler/order/audit.(*Review).Ex
ecutor.func1\n\tYearning-go/src/handler/order/audit/executor.go:161\nruntime.goexit\n\truntime/asm_amd64.s:1700\n" file="gitee.com/cookieYe/enginex@v0.0.3/parse/roll.go:45"
[2026/03/12 03:10:49] [info] binlogsyncer.go:175 syncer is closing...
[2026/03/12 03:10:49] [error] binlogsyncer.go:843 kill connection 1812832 error invalid sequence 8 != 1
[2026/03/12 03:10:49] [error] binlogsyncer.go:846 invalid sequence 8 != 1
[2026/03/12 03:10:49] [info] binlogsyncer.go:849 kill last connection id 1812832
[2026/03/12 03:10:49] [info] binlogsyncer.go:202 syncer is closed

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions