Skip to content

DDL ignored by ddl job finishedTs less than puller resolvedTs #11714

@sdojjy

Description

@sdojjy

assume there are two ddl jobs
Job 60 : ALTER TABLE a ADD COLUMN x, y, z, it's commit ts is 400
Job 62: ALTER TABLE b ADD COLUMN y it's commit ts is 300

TiCDC sorts these jobs and run Job 62 first, then Job 60
DDL Puller processed Job 62 and set p.schemaVersion to 62,

p.schemaVersion = job.BinlogInfo.SchemaVersion

Job 60 will be ignored due to b.BinlogInfo.SchemaVersion <= p.schemaVersion

ddl job finishedTs less than puller resolvedTs,discard the ddl job

job.BinlogInfo.SchemaVersion <= p.schemaVersion {

Metadata

Metadata

Assignees

No one assigned

    Labels

    affects-5.4This bug affects the 5.4.x(LTS) versions.affects-6.1This bug affects the 6.1.x(LTS) versions.affects-6.5This bug affects the 6.5.x(LTS) versions.affects-7.1This bug affects the 7.1.x(LTS) versions.affects-7.5This bug affects the 7.5.x(LTS) versions.affects-8.1This bug affects the 8.1.x(LTS) versions.affects-8.5This bug affects the 8.5.x(LTS) versions.area/ticdcIssues or PRs related to TiCDC.found/gsreport/customerCustomers have encountered this bug.severity/majortype/bugThe issue is confirmed as a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions