Skip to content

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

@Tristan1900

Description

@Tristan1900

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.

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