Re: Snapshot too old logging

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Snapshot too old logging
Дата
Msg-id CACjxUsNpNWoumWMxR9ppPNkvOHib406TkorkfMerDv2rLm0Mbw@mail.gmail.com
обсуждение исходный текст
Ответ на Snapshot too old logging  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Snapshot too old logging
Список pgsql-hackers
On Tue, Nov 15, 2016 at 3:38 AM, Magnus Hagander <magnus@hagander.net> wrote:
> Is there a reason why we don't log which relation triggered the snapshot too
> old error when it happens?
>
> Since we do have Relation available in TestForOldSnapshot_impl(), shouldn't
> we be able to include it?
>
> Having that in the log message would be very helpful, but is there a reason
> why it wouldn't work?

I would probably not want to mess with the text of the error
itself, in case any client-side software bases recovery on that
rather than the SQLSTATE value; but including relation (and maybe
the timestamp on the snapshot?) in detail or context portions seems
like a great idea.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: jsonb_delete with arrays
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: psql \setfileref