Re: ERROR: found multixact from before relminmxid

From: Adrien NAYRAT <adrien(dot)nayrat(at)anayrat(dot)info>
To: Alexandre Arruda <adaldeia(at)gmail(dot)com>
Cc: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: ERROR: found multixact from before relminmxid
Date: 2018-11-09 10:33:12
Message-ID: 1c63782e-ca6e-8456-d946-238a71045275@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/7/18 1:21 PM, Alexandre Arruda wrote:
> The best solution that I have found is kick all connections and execute
> a select for update to /dev/null in the affected tables, i.e.:
>
> psql -o /dev/null -c "select * from table for update" database
>
> After this, the vacuum is executed w/o problems again.
>
> Best regards,
>
> Alexandre

Thanks Alexandre, I will try.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2018-11-09 10:39:28 Re: Full list of operations that constitute a "maintenance" operation?
Previous Message Lance Luvaul 2018-11-09 09:57:28 Full list of operations that constitute a "maintenance" operation?