Issue with GC Not Cleaning in TiDB 7.1.3

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

Original topic: tidb 7.1.3 gc不清理的问题

| username: tug_twf

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version] 7.1.3
[Reproduction Path] No specific operations performed
[Encountered Issue: Problem Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]

Issue: TiDB GC cleanup is stuck around February 20th
image

From the logs, it appears that GC cleanup logs are being printed

Checked and found no TiCDC tasks, and no long transactions

The business has tables set with TTL

| username: porpoiselxj | Original post link

Check what is blocking the GC.

| username: dba远航 | Original post link

Check the relevant parameters of GC to see if there are any anomalies.

| username: 小于同学 | Original post link

Check if there are any issues with the configuration parameters.

| username: IanWong | Original post link

Please provide the following information:

  1. select VARIABLE_NAME, VARIABLE_VALUE from mysql.tidb where VARIABLE_NAME like ‘%gc%’;
  2. tiup ctl:v7.1.3 pd -u http://xxx:2379 service-gc-safepoint
  3. Check the logs and send any errors, grep ‘gc_worker’
| username: tug_twf | Original post link

There is only one gc_worker itself inside, so it’s quite strange.

| username: tug_twf | Original post link

After performing a rolling restart, it returned to normal.

| username: residentevil | Original post link

What is the impact of GC not cleaning up?

| username: zhanggame1 | Original post link

The hard drive is full.

| username: system | Original post link

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