Skip to content

br: pitr doesn't support system restore yet #60201

Closed
#60202
Closed
br: pitr doesn't support system restore yet#60201
#60202
Labels
affects-9.0This bug affects the 9.0.x versions.component/brThis issue is related to BR of TiDB.severity/majortype/bugThe issue is confirmed as a bug.

Description

@Tristan1900
Tristan1900
opened on Mar 21, 2025

Bug Report

The latest change enables pitr to restore system tables where previously it was not, but later we found it's not possible to do pitr restore system table since during snapshot restore it's using REPLACE INTO to inject the data into system table. This operation will change the row id of the system table and messed up with log backup row id unless we have a way to override the log backup. It can potentially cause system table consistency issue.

Impact master branch and 9.0.0 pitr with system tables.

Activity

  1. Tristan1900
    added
    type/bugThe issue is confirmed as a bug.
    on Mar 21, 2025
  2. BornChanger
    added
    component/brThis issue is related to BR of TiDB.
    affects-9.0This bug affects the 9.0.x versions.
    severity/major
    on Mar 21, 2025
  3. ti-chi-bot
    added
    may-affects-6.1
    may-affects-6.5
    may-affects-7.1
    may-affects-7.5
    may-affects-8.1
    may-affects-8.5
    on Mar 21, 2025
  4. Leavrth
    removed
    may-affects-6.1
    may-affects-6.5
    may-affects-7.1
    may-affects-7.5
    may-affects-8.1
    may-affects-8.5
    on Mar 21, 2025
  5. ti-chi-bot
    closed this as completedin #60202on Mar 21, 2025
  6. ti-chi-bot
    closed this as completedin 0d74a99on Mar 21, 2025
  7. ti-chi-bot
    added a commit that references this issue on Mar 21, 2025

    br: fix pitr system table inconsistency issue (#60202) (#60210)

    fc0ed72
  8. CbcWestwolf
    added a commit that references this issue on Mar 21, 2025

    br: fix pitr system table inconsistency issue (pingcap#60202)

    0d74a99
  9. disksing
    added a commit that references this issue on Mar 27, 2025

    br: fix pitr system table inconsistency issue (pingcap#60202)

    1822234
  10. zeminzhou
    added a commit that references this issue on May 6, 2025

    br: fix pitr system table inconsistency issue (pingcap#60202)

    cb22f8a
  11. Tristan1900
    added 2 commits that reference this issue on Jun 4, 2025

    br: fix pitr system table inconsistency issue (pingcap#60202)

    c6ec7da

    br: fix pitr system table inconsistency issue (pingcap#60202)

    1348c36
  12. YuJuncen
    added a commit that references this issue on Dec 1, 2025

    br: fix pitr system table inconsistency issue (pingcap#60202)

    99c0427
  13. Leavrth
    added a commit that references this issue on Dec 9, 2025

    br: fix pitr system table inconsistency issue (pingcap#60202)

    d8d8aa2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    affects-9.0This bug affects the 9.0.x versions.component/brThis issue is related to BR of TiDB.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