Br log truncate did not completely clean up the log backup data

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

Original topic: br log truncate没有完全清理日志备份数据

| username: yeminhua

When cleaning up log backup data, if you choose to clean up data before the 27th, why is only part of the backup from the 26th cleaned up, while data from earlier dates is completely cleaned up?

| username: 大飞哥online | Original post link

What data is retained inside?

| username: zhanggame1 | Original post link

The log time and TSO are not exactly the same, right?

| username: Fly-bird | Original post link

You can manually clear it.

| username: Soysauce520 | Original post link

You can use lsof to check if a file is being used by a process.

| username: 像风一样的男子 | Original post link

Why not just directly remove the unwanted backups that are archived by date?

| username: yeminhua | Original post link

It’s just log backup.

| username: yeminhua | Original post link

Finally, it was discovered that the time on the NFS server host was incorrect, lagging by several hours. As a result, when mounted, the backup time appeared to be 16:00 on the 27th, while the TiDB host was actually at midnight on the 28th. Therefore, when deleting, it deleted everything before midnight on the 28th, while the NFS side showed deletions before 16:00. The log backup itself was not an issue.

| username: 大飞哥online | Original post link

The time is not synchronized.

| username: ajin0514 | Original post link

The time is different.

| username: Kongdom | Original post link

:joy: This problem was solved three days ago~

| username: system | Original post link

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