Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae
| От | Bowen Shi |
|---|---|
| Тема | Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae |
| Дата | |
| Msg-id | CAM_vCueZFuCOF8Q=6Z5TGiyvLJRDr6Eb+aQfHiswMPMawu_79Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae (Andres Freund <andres@anarazel.de>) |
| Список | pgsql-bugs |
Hi
On Fri, May 17, 2024 at 12:38 AM Andres Freund <andres@anarazel.de> wrote:
Hi,
On 2024-05-16 15:31:20 +0800, Bowen Shi wrote:
> Yes, I have preserved the coredump file of vacuum and several other related
> processes. It has been at least 10 minutes stuck in the retry loop since I
> dumped this core file.
Could you print out *vacrel?
I'm wondering if there was index processing, due to the number of tuples. And
if so, what type of indexes. There'd need to be something that could lead to
new snapshots being acquired...
(gdb) p * vacrel
$2 = {rel = 0x2403028, indrels = 0x234e550, nindexes = 12, bstrategy = 0x2368e28, pvs = 0x0,
aggressive = false, skipwithvm = true, consider_bypass_optimization = false,
do_index_vacuuming = true, do_index_cleanup = true, do_rel_truncate = true, cutoffs = {
relfrozenxid = 927, relminmxid = 1, OldestXmin = 1106, OldestMxact = 1,
FreezeLimit = 4244968402, MultiXactCutoff = 4289967297},
vistest = 0xe693f0 <GlobalVisDataRels>, NewRelfrozenXid = 1106, NewRelminMxid = 1,
skippedallvis = false, dbname = 0x234e7f0 "db1", relnamespace = 0x234eb38 "public",
relname = 0x234eb48 "t1", indname = 0x0, blkno = 349565,
offnum = 10, phase = VACUUM_ERRCB_PHASE_SCAN_HEAP, verbose = false,
dead_items = 0x7fa22f48d040, rel_pages = 1302478, scanned_pages = 349566, removed_pages = 0,
frozen_pages = 592, lpdead_item_pages = 349565, missed_dead_pages = 0,
nonempty_pages = 349495, new_rel_tuples = 0, new_live_tuples = 0, indstats = 0x234e6e0,
num_index_scans = 1, tuples_deleted = 11184540, tuples_frozen = 1540, lpdead_items = 11184540,
live_tuples = 1540, recently_dead_tuples = 0, missed_dead_tuples = 0}
$2 = {rel = 0x2403028, indrels = 0x234e550, nindexes = 12, bstrategy = 0x2368e28, pvs = 0x0,
aggressive = false, skipwithvm = true, consider_bypass_optimization = false,
do_index_vacuuming = true, do_index_cleanup = true, do_rel_truncate = true, cutoffs = {
relfrozenxid = 927, relminmxid = 1, OldestXmin = 1106, OldestMxact = 1,
FreezeLimit = 4244968402, MultiXactCutoff = 4289967297},
vistest = 0xe693f0 <GlobalVisDataRels>, NewRelfrozenXid = 1106, NewRelminMxid = 1,
skippedallvis = false, dbname = 0x234e7f0 "db1", relnamespace = 0x234eb38 "public",
relname = 0x234eb48 "t1", indname = 0x0, blkno = 349565,
offnum = 10, phase = VACUUM_ERRCB_PHASE_SCAN_HEAP, verbose = false,
dead_items = 0x7fa22f48d040, rel_pages = 1302478, scanned_pages = 349566, removed_pages = 0,
frozen_pages = 592, lpdead_item_pages = 349565, missed_dead_pages = 0,
nonempty_pages = 349495, new_rel_tuples = 0, new_live_tuples = 0, indstats = 0x234e6e0,
num_index_scans = 1, tuples_deleted = 11184540, tuples_frozen = 1540, lpdead_items = 11184540,
live_tuples = 1540, recently_dead_tuples = 0, missed_dead_tuples = 0}
(gdb) p * vacrel->bstrategy
$3 = {btype = BAS_VACUUM, nbuffers = 32, current = 30, buffers = 0x2368e34}
$3 = {btype = BAS_VACUUM, nbuffers = 32, current = 30, buffers = 0x2368e34}
Regards
Bowen Shi
В списке pgsql-bugs по дате отправления: