Error When Importing Database from 5.4.1 to 6.5.0 Using BR

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 从5.4.1 使用br导入数据库6.5.0 报错如下

| username: ffeenn

[TiDB Usage Environment] Test/PoC
[TiDB Version] 6.5.0
Encountered an error related to new features when using BR to export data from 5.4.1 to 6.5.0. Are there any solutions for this?
[Attachment: Screenshot/Log/Monitoring]
New_collation information from the upstream database 5.4.1

image
image746×519 11.2 KB

Error screenshot from the downstream database 6.5.0
image
image1380×146 52.2 KB

2
| username: WalterWj | Original post link

Backup and restore seem to have version requirements, right?

3
| username: Billmay表妹 | Original post link

Do not operate across versions.

4
| username: 裤衩儿飞上天 | Original post link

Personal suggestions:

  1. If using br to restore, keep the new_collations_enabled_on_first_bootstrap parameter consistent with 5.X when creating the new 6.5 cluster.
  2. If they are inconsistent, recreate the cluster or consider using dumpling lightning for backup and restore.
5
| username: Billmay表妹 | Original post link

Option 1:
Upgrade the existing cluster to version 6.0 or above, then import it into the new 6.5.0 cluster.

Option 2:
Create a new 5.x version cluster, import using BR, and then upgrade the cluster to 6.5.0.

6
| username: ffeenn | Original post link

We can only use Solution 2. The new_collations_enabled_on_first_bootstrap parameter in the lower version is consistent with the new version, but it doesn’t work after trying.

7
| username: 裤衩儿飞上天 | Original post link

The default value of tidb_gc_life_time is 10m, which means that the data deleted within 10 minutes can be restored. If you want to restore the data deleted within 10 minutes, you can set tidb_gc_life_time to a larger value, such as 24h.

8
| username: ffeenn | Original post link

Both clusters have enabled collation support.

9
| username: ffeenn | Original post link

If the collations feature was not enabled in version 5.4.1 of the database, will it be automatically enabled after upgrading to 6.5.0? One of my clusters on site did not have it enabled. :joy:

10
| username: ffeenn | Original post link

Upgrading from 5.4.1 to 6.5.0, exporting data with BR, and restoring to 6.5.0. The new_collations_enabled_on_first_bootstrap warning is gone, but a new issue has appeared.

11
| username: Billmay表妹 | Original post link

Post this question in a new thread for consultation, and also paste the error message into the new topic.

12
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.