Questions About GC Delay

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

Original topic: 关于gc推迟疑惑

| username: kuuhaku

[TiDB Version] 7.1.3
[Reproduction Path] No operations performed
[Encountered Problem: Phenomenon and Impact]
Found that the database GC has not progressed normally for a period of time, and the logs indicate:


Quite puzzled, theoretically, I haven’t touched any GC configurations, so this situation shouldn’t occur.

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

There are long-running transactions that are blocking the advancement of the safe point.

| username: zhanggame1 | Original post link

Let’s see if there are any SQL queries that have been running for several hours.

SELECT * FROM INFORMATION_SCHEMA.CLUSTER_PROCESSLIST t
WHERE t.command <> 'Sleep'
ORDER BY t.TIME DESC;
| username: 双开门变频冰箱 | Original post link

Check if there are any long active sessions.

| username: dba远航 | Original post link

There are large transactions running or transactions that have not been committed for a long time.

| username: zhanggame1 | Original post link

Was it resolved in the end?

| username: system | Original post link

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