Re: BUG #15528: on v11.0 version still get error "ERROR: catalog is missing 1 attribute(s) for relid 6855092"

Поиск
Список
Период
Сортировка
От 小威
Тема Re: BUG #15528: on v11.0 version still get error "ERROR: catalog is missing 1 attribute(s) for relid 6855092"
Дата
Msg-id tencent_7309AE0C13B7BEE3830140CE2F39D0F9D607@qq.com
обсуждение исходный текст
Ответ на BUG #15528: on v11.0 version still get error "ERROR: catalog ismissing 1 attribute(s) for relid 6855092"  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
when set max_parallel_maintenance_workers = 0,no issue(vacuum full ok)now.before it my 2 times test were all failed.now I set it to 2 again and set log_min_message = debug5,log_min_error_statement=debug5,try to get more details.

---Original---
From: "Peter Geoghegan"<pg@bowt.ie>
Date: Sat, Dec 1, 2018 14:14 PM
To: "zxw110876189"<zxw110876189@qq.com>;
Cc: "PostgreSQL mailing lists"<pgsql-bugs@lists.postgresql.org>;
Subject: Re: BUG #15528: on v11.0 version still get error "ERROR: catalog is missing 1 attribute(s) for relid 6855092"

On Fri, Nov 30, 2018 at 9:52 PM Peter Geoghegan <pg@bowt.ie> wrote:
> Using amcheck would let us know if the index is completely corrupt
> (e.g. tuples are in the wrong order), or if the duplicate is garbage
> that has somehow become visible again, a symptom of bugs which is also
> possible. It's easy to use amcheck. Maybe there is another bug that is
> similar to #15309, but we need to establish if the index is truly
> corrupt, and what it looks like. It would also be good to use
> contrib/pageinspect to look at any blocks that amcheck shows in an
> error message.

Also, can you confirm that the problem goes away when
max_parallel_maintenance_workers is set to 0? That's what we saw with
bug #15309.

--
Peter Geoghegan

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15530: unable restore index on function from earthdistance contrib
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #15528: on v11.0 version still get error "ERROR: catalog ismissing 1 attribute(s) for relid 6855092"