Re: Infinite loop in GetMultiXactIdMembers() on 9.3.5 (involves pg_upgrade)

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject: Re: Infinite loop in GetMultiXactIdMembers() on 9.3.5 (involves pg_upgrade)
Date: 2015-01-28 03:56:43
Message-ID: CAM3SWZToXjqCJ6bVdfV1zdyZfw+QPf2tmC-v-judLCVqwE76Hg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Jan 27, 2015 at 7:16 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
> customerdb=# select age(relfrozenxid), age(relminmxid), * from
> pg_class where relname = 'anonymized';

Whoops. Should have used mxid_age() here, but of course it isn't
available in this release.

I've since found BUG #11264, which seems to be the same issue...don't
know how I missed that one before. I see that Alvaro committed
something that at least addresses the non-interruptibility issue
directly, with a call to CHECK_FOR_INTERRUPTS() (commit d45e8dc52).
But I don't see any follow up addressing the bug itself, which I'd
hoped for. Did the discussion of BUG #11264 simply trail off without
an adequate resolution, as it appeared to?

Thanks
--
Peter Geoghegan

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2015-01-28 07:16:23 Re: BUG #12670: Can't create postgis extension in single-user mode
Previous Message Peter Geoghegan 2015-01-28 03:16:47 Infinite loop in GetMultiXactIdMembers() on 9.3.5 (involves pg_upgrade)