Re: ERROR: found multixact from before relminmxid

From: Alexandre Arruda <adaldeia(at)gmail(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: ERROR: found multixact from before relminmxid
Date: 2018-04-10 01:56:48
Message-ID: CAGewt-usb3YJkf0N1H2D9Yq+fiPEawfw3e_6mQ21VLVi2S6R_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2018-04-09 22:16 GMT-03:00 Peter Geoghegan <pg(at)bowt(dot)ie>:
> On Mon, Apr 9, 2018 at 5:55 PM, Alexandre Arruda <adaldeia(at)gmail(dot)com> wrote:
>> I ran amcheck in all index of a table and I only get empty returns.
>
> Did you try doing so with the "heapallindexed" option? That's what's
> really interesting here.
>
> --
> Peter Geoghegan

production=# select bt_index_parent_check('fn06t_pkey',true);

bt_index_parent_check

-----------------------

(1 row)

production=# select bt_index_parent_check('ifn06t1',true);

bt_index_parent_check

-----------------------

(1 row)

production=# select bt_index_parent_check('ifn06t4',true);

bt_index_parent_check

-----------------------

(1 row)

(... and all other indexes returns null too)

I tried with bt_index_check too. Same results.

regards,

Alexandre

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2018-04-10 02:51:19 Re: ERROR: found multixact from before relminmxid
Previous Message Peter Geoghegan 2018-04-10 01:16:26 Re: ERROR: found multixact from before relminmxid