Re: ERROR: found multixact from before relminmxid

Hi,

On 2018-06-08 13:30:33 -0500, Jeremy Finzel wrote:
> Avoid spuriously marking pages as all-visible (Dan Wood, Pavan Deolasee,
> Álvaro Herrera)
>
> This could happen if some tuples were locked (but not deleted). While
> queries would still function correctly, vacuum would normally ignore such
> pages, with the long-term effect that the tuples were never frozen. In
> recent releases this would eventually result in errors such as "found
> multixact nnnnn from before relminmxid nnnnn".

Oh, I already had forgotten about that one... It does sound like a
likely explanation of your issue. Hard to tell without investigating a
*lot* more closely than I realistically can do remotely. It seems quite
possible to be the cause - I'd strongly suggest to upgrade to prevent
further occurances, or at least exclude it as a cause.

Greetings,

Andres Freund