Skip to content

docs: add checkpoint restore warning#23201

Open
qiancai wants to merge 3 commits into
pingcap:masterfrom
qiancai:add-warning-about-deletion-21711
Open

docs: add checkpoint restore warning#23201
qiancai wants to merge 3 commits into
pingcap:masterfrom
qiancai:add-warning-about-deletion-21711

Conversation

@qiancai

@qiancai qiancai commented Jul 4, 2026

Copy link
Copy Markdown
Collaborator

First-time contributors' checklist

What is changed, added or deleted? (Required)

Add a warning for checkpoint restore after DROP TABLE, covering checksum failure or possible later data loss, and link to the related issue.

Which TiDB version(s) do your changes apply to? (Required)

  • master (the latest development version)
  • v9.0 (TiDB 9.0 versions)
  • v8.5 (TiDB 8.5 versions)
  • v8.1 (TiDB 8.1 versions)
  • v7.5 (TiDB 7.5 versions)
  • v7.1 (TiDB 7.1 versions)
  • v6.5 (TiDB 6.5 versions)
  • v6.1 (TiDB 6.1 versions)

What is the related PR or file link(s)?

Do your changes match any of the following descriptions?

  • Delete files
  • Change aliases
  • Need modification after applied to another branch
  • Might cause conflicts after applied to another branch

@qiancai qiancai added needs-cherry-pick-release-8.5 Should cherry pick this PR to release-8.5 branch. translation/from-docs-cn This PR is translated from a PR in pingcap/docs-cn. labels Jul 4, 2026
@gemini-code-assist

Copy link
Copy Markdown
Contributor

Note

Gemini is unable to generate a review for this pull request due to the file types involved not being currently supported.

@ti-chi-bot ti-chi-bot Bot added the size/XS Denotes a PR that changes 0-9 lines, ignoring generated files. label Jul 4, 2026
Synced from: pingcap/docs-cn#21711
Target PR: pingcap#23201
AI Provider: azure

Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
@github-actions

github-actions Bot commented Jul 4, 2026

Copy link
Copy Markdown
Contributor

Auto-sync completed successfully

Source PR: pingcap/docs-cn#21711
Target PR: #23201

English documentation has been updated based on Chinese documentation changes.

@ti-chi-bot

ti-chi-bot Bot commented Jul 4, 2026

Copy link
Copy Markdown

[APPROVALNOTIFIER] This PR is NOT APPROVED

This pull-request has been approved by:
Once this PR has been reviewed and has the lgtm label, please assign qiancai for approval. For more information see the Code Review Process.
Please ensure that each of them provides their approval before proceeding.

The full list of commands accepted by this bot can be found here.

Details Needs approval from an approver in each of these files:

Approvers can indicate their approval by writing /approve in a comment
Approvers can cancel approval by writing /approve cancel in a comment

@ti-chi-bot ti-chi-bot Bot added size/S Denotes a PR that changes 10-29 lines, ignoring generated files. and removed size/XS Denotes a PR that changes 0-9 lines, ignoring generated files. labels Jul 4, 2026
Comment thread br/br-checkpoint-restore.md Outdated
@qiancai

qiancai commented Jul 4, 2026

Copy link
Copy Markdown
Collaborator Author

/gemini review

@gemini-code-assist gemini-code-assist Bot left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Code Review

This pull request adds a warning section to the br-checkpoint-restore.md documentation, detailing the risks of deleting a table during an active restore and retrying from a checkpoint starting from v8.5.5. It outlines potential issues, such as checksum failures and data loss, and provides instructions on how to properly abandon the restore. The reviewer suggested refining the warning block to improve clarity, eliminate repetitive phrasing, and adhere to the style guide by using active voice and the second person.

Important

The consumer version of Gemini Code Assist on GitHub is being sunset. Starting June 18, 2026, new organization installations will be blocked, and all code review activity will officially cease on July 17, 2026.
For more details on the timeline and next steps, please review the Help Documentation.

Comment on lines +64 to +74
> **Warning:**
>
> Starting from v8.5.5, if you delete a table being restored during the restore and then retry the restore from the checkpoint, you might encounter the following issues (see [#68709](https://github.com/pingcap/tidb/issues/68709) for details):
>
> - The restore is terminated due to a checksum verification failure.
> - The restored data is lost some time after the restore is completed.
>
> If you are sure that you want to abandon the current restore result, first perform one of the following operations based on the restore type, and then `DROP` the restored table:
>
> - For `restore point`, execute [`br abort`](/br/br-pitr-manual.md#abort-restore-operations).
> - For `restore full`, manually delete the checkpoint database in the downstream cluster. The name format of the checkpoint database is `__TiDB_BR_Temporary_Snapshot_Restore_Checkpoint_<restoreID>`, where `<restoreID>` can be found in `mysql.tidb_restore_registry`.

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

low

To improve clarity, reduce repetition, and adhere to the active voice and second-person guidelines in the style guide, we can refine this warning block:

  • Avoid repeating "restored" and "restore" in "delete a table being restored during the restore".
  • Change passive voice ("is terminated", "is completed", "can be found") to active voice ("terminates", "completes", "you can find").
  • Use second person ("you") to address the user directly.
Suggested change
> **Warning:**
>
> Starting from v8.5.5, if you delete a table being restored during the restore and then retry the restore from the checkpoint, you might encounter the following issues (see [#68709](https://github.com/pingcap/tidb/issues/68709) for details):
>
> - The restore is terminated due to a checksum verification failure.
> - The restored data is lost some time after the restore is completed.
>
> If you are sure that you want to abandon the current restore result, first perform one of the following operations based on the restore type, and then `DROP` the restored table:
>
> - For `restore point`, execute [`br abort`](/br/br-pitr-manual.md#abort-restore-operations).
> - For `restore full`, manually delete the checkpoint database in the downstream cluster. The name format of the checkpoint database is `__TiDB_BR_Temporary_Snapshot_Restore_Checkpoint_<restoreID>`, where `<restoreID>` can be found in `mysql.tidb_restore_registry`.
> **Warning:**
>
> Starting from v8.5.5, if you delete a table during the restore process and then retry the restore from the checkpoint, you might encounter the following issues (see [#68709](https://github.com/pingcap/tidb/issues/68709) for details):
>
> - The restore terminates due to a checksum verification failure.
> - You might lose the restored data some time after the restore completes.
>
> If you are sure that you want to abandon the current restore result, first perform one of the following operations based on the restore type, and then `DROP` the restored table:
>
> - For `restore point`, execute [`br abort`](/br/br-pitr-manual.md#abort-restore-operations).
> - For `restore full`, manually delete the checkpoint database in the downstream cluster. The name format of the checkpoint database is `__TiDB_BR_Temporary_Snapshot_Restore_Checkpoint_<restoreID>`, where you can find `<restoreID>` in the `mysql.tidb_restore_registry` table.
References
  1. Write in second person ('you') when addressing users. (link)
  2. Prefer present tense unless describing historical behavior. (link)
  3. Avoid unnecessary words and repetition. (link)
  4. Avoid passive voice overuse. (link)

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

Labels

needs-cherry-pick-release-8.5 Should cherry pick this PR to release-8.5 branch. size/S Denotes a PR that changes 10-29 lines, ignoring generated files. translation/from-docs-cn This PR is translated from a PR in pingcap/docs-cn.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant