Re: [HACKERS] 10RC1 crash testing MultiXact oddity

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [HACKERS] 10RC1 crash testing MultiXact oddity
Дата
Msg-id CAMkU=1wRYs8oecg+Fz0LD0TH_vWBehP6dmDWxUGpwDVdjiKXvQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] 10RC1 crash testing MultiXact oddity  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [HACKERS] 10RC1 crash testing MultiXact oddity  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
Дерево обсуждения
On Fri, Sep 22, 2017 at 1:19 PM, Robert Haas <robertmhaas@gmail.com> wrote:
On Fri, Sep 22, 2017 at 3:39 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
> It turns out it is not new in pg10.  I spotted in the log file only by
> accident while looking for something else.  Now that I am looking for it, I
> do see it in 9.6 as well.

So I guess the next question is whether it also shows up if you initdb
with 9.4.latest and then run the same test.

git bisect shows that it shows up in 9.5, at this commit:

commit bd7c348d83a4576163b635010e49dbcac7126f01
Author: Andres Freund <andres@anarazel.de>
Date:   Sat Sep 26 19:04:25 2015 +0200

    Rework the way multixact truncations work.

The patches which enable the crashes and the rapid consumption of xid and multixact both need a little adjustment from the 10rc1 versions, so I'm attaching a combined patch that applies to bd7c348d83.

Not really sure what the next step is here.  I could promote the ereport(LOG...) to a PANIC to get a core dump, but I don't think that would help because presumably the problem occurred early, when the truncation was done, not when it was detected.

Cheers,

Jeff


Вложения

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

Предыдущее
От: chenhj
Дата:
Сообщение: Re: [HACKERS] [PATCH]make pg_rewind to not copy useless WALfiles
Следующее
От: Noah Misch
Дата:
Сообщение: Re: [HACKERS] Re: CREATE COLLATION does not sanitize ICU's BCP 47language tags. Should it?