The gc_safe_point drifted on its own

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

Original topic: gc_safe_point 自己漂移了

| username: TiDBer_yangxi

【TiDB Usage Environment】Production Environment / Testing / Poc
【TiDB Version】
【Reproduction Path】What operations were performed when the issue occurred
【Encountered Issue: Issue Phenomenon and Impact】
【Resource Configuration】Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots / Logs / Monitoring】


mysql> select TIDB_PARSE_TSO(445860230465060864);
±-----------------------------------+
| TIDB_PARSE_TSO(445860230465060864) |
±-----------------------------------+
| 2023-11-24 18:30:02.006000 |
±-----------------------------------+
1 row in set (0.00 sec)

mysql> select TIDB_PARSE_TSO(445859217727815680);
±-----------------------------------+
| TIDB_PARSE_TSO(445859217727815680) |
±-----------------------------------+
| 2023-11-24 17:25:38.720000 |
±-----------------------------------+
1 row in set (0.00 sec)

mysql> select TIDB_PARSE_TSO(445859437050855424);
±-----------------------------------+
| TIDB_PARSE_TSO(445859437050855424) |
±-----------------------------------+
| 2023-11-24 17:39:35.371000 |
±-----------------------------------+
1 row in set (0.00 sec)

mysql> select TIDB_PARSE_TSO(445860106422190104);
±-----------------------------------+
| TIDB_PARSE_TSO(445860106422190104) |
±-----------------------------------+
| 2023-11-24 18:22:08.820000 |
±-----------------------------------+
Two br tasks Full Backup <------------> 100.00%
Checksum <-------…> 37.50%panic: cannot pass gc safe point check, aborting

| username: h5n1 | Original post link

Apart from the second backup task failure, is there any other issue?
Service GC Safepoint, it is normal for some tasks to cause changes in the safe point, such as cdc, br, dumpling, analyze, etc.

| username: 芮芮是产品 | Original post link

No problem.

| username: 芮芮是产品 | Original post link

It feels quite normal.

| username: zhanggame1 | Original post link

This time is fine.

| username: Kongdom | Original post link

Normally, the BR tool no longer requires manual GC settings.

Note

The BR tool now supports adaptive GC. It will automatically register the backupTS (default is the latest PD timestamp) to PD’s safePoint, ensuring that TiDB’s GC Safe Point does not move forward during the backup period, thus avoiding the need for manual GC settings.

| username: dba远航 | Original post link

No issues found.

| username: TiDBer_小阿飞 | Original post link

Is this because the safe point automatically advances, causing the backup task to fail? Or is it due to some other reason?

| username: Kongdom | Original post link

I looked at the related posts, and it should be this situation.

| username: TiDBer_小阿飞 | Original post link

Learned :+1: :+1: :+1:

| username: TiDBer_gxUpi9Ct | Original post link

There is no problem with this.