Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Thomas Munro <tmunro(at)postgresql(dot)org>
Subject: Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843
Date: 2020-11-04 01:49:24
Message-ID: CA+hUKG+c+Rtz3JuXBK=+tWZa4F=3w5eFA97MTAzZKER2ARF_0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 4, 2020 at 2:32 PM Tomas Vondra
<tomas(dot)vondra(at)2ndquadrant(dot)com> wrote:
> After a while (~1h on my machine) the pg_multixact gets over 10GB, which
> triggers a more aggressive cleanup (per MultiXactMemberFreezeThreshold).
> My guess is that this discards some of the files, but checkpointer is
> not aware of that, or something like that. Not sure.

Urgh. Thanks. Looks like perhaps the problem is that I have
RegisterSyncRequest(&tag, SYNC_FORGET_REQUEST, true) in one codepath
that unlinks files, but not another. Looking.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2020-11-04 01:56:30 Re: Collation versioning
Previous Message Kyotaro Horiguchi 2020-11-04 01:41:07 Re: Explicit NULL dereference (src/backend/utils/adt/ruleutils.c)