BUG #16523: The wal logs fill the disk and are not cleaned up
От | PG Bug reporting form |
---|---|
Тема | BUG #16523: The wal logs fill the disk and are not cleaned up |
Дата | |
Msg-id | 16523-54d643065961bc4d@postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16523 Logged by: yi Ding Email address: abcxiaod@126.com PostgreSQL version: 10.13 Operating system: linux Description: Assuming that the current wal log's logseq is 00000008 and wal_keep_segments is 2, then wal logs before [all timelines + logid + 00000006] will be recycled In some cases:,The database restarts repeatedly, resulting in many wal logs with different timelines which their segment numbers are all 00000007. In this case, even if the size of the wal logs are very large and exceed the max_wal_size, they will not be cleaned up. -rw------- 1 postgres postgres 1.9K Jun 29 10:31 0000002D.history -rw------- 1 postgres postgres 64M Jun 29 10:31 0000002D0000000000000007 -rw------- 1 postgres postgres 2.0K Jun 29 10:31 0000002E.history -rw------- 1 postgres postgres 64M Jun 29 10:31 0000002E0000000000000007 -rw------- 1 postgres postgres 2.0K Jun 29 10:31 0000002F.history -rw------- 1 postgres postgres 64M Jun 29 10:31 0000002F0000000000000007 -rw------- 1 postgres postgres 2.1K Jun 29 10:31 00000030.history -rw------- 1 postgres postgres 64M Jun 29 10:31 000000300000000000000007 -rw------- 1 postgres postgres 2.1K Jun 29 10:31 00000031.history -rw------- 1 postgres postgres 64M Jun 29 10:31 000000310000000000000007 -rw------- 1 postgres postgres 2.1K Jun 29 10:31 00000032.history -rw------- 1 postgres postgres 64M Jun 29 10:31 000000320000000000000007 -rw------- 1 postgres postgres 2.2K Jun 29 10:31 00000033.history Actual environment: [postgres@3cf842e4-4f8b-4d26-a123-4cb94dd2369f-pgsrv-1 ~]$ du -sh /pg_xlog/ 9.8G /pg_xlog/ -rw------- 1 postgres postgres 1.9K Jun 29 10:31 0000002D.history -rw------- 1 postgres postgres 64M Jun 29 10:31 0000002D000000000000001A -rw------- 1 postgres postgres 2.0K Jun 29 10:31 0000002E.history -rw------- 1 postgres postgres 64M Jun 29 10:31 0000002E000000000000001A -rw------- 1 postgres postgres 2.0K Jun 29 10:31 0000002F.history -rw------- 1 postgres postgres 64M Jun 29 10:31 0000002F000000000000001A -rw------- 1 postgres postgres 2.1K Jun 29 10:31 00000030.history -rw------- 1 postgres postgres 64M Jun 29 10:31 00000030000000000000001A -rw------- 1 postgres postgres 2.1K Jun 29 10:31 00000031.history -rw------- 1 postgres postgres 64M Jun 29 10:31 00000031000000000000001A -rw------- 1 postgres postgres 2.1K Jun 29 10:31 00000032.history -rw------- 1 postgres postgres 64M Jun 29 10:31 00000032000000000000001A -rw------- 1 postgres postgres 2.2K Jun 29 10:31 00000033.history postgres=# show max_wal_size; max_wal_size -------------- 2GB (1 row) postgres=# show wal_keep_segments ; wal_keep_segments ------------------- 40 (1 row)
В списке pgsql-bugs по дате отправления: