Re: ERROR: found multixact XX from before relminmxid YY

Поиск
Список
Период
Сортировка
От Mark Fletcher
Тема Re: ERROR: found multixact XX from before relminmxid YY
Дата
Msg-id CAEO096pO6or8NPXv4T1qWJADeWMreSYUTggewduED57p8K-Jfg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: found multixact XX from before relminmxid YY  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Fri, Dec 28, 2018 at 4:49 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

Yeah, SELECT FOR UPDATE should overwrite the broken xmax value and thereby
fix it, I expect.  However, I don't see anything in the release notes
suggesting that we've fixed any related bugs since 9.6.10, so if this
just appeared then we've still got a problem :-(.  Did anything
interesting happen since your last successful autovacuum on that table?
Database crashes, WAL-related parameter changes, that sort of thing?

The last autovacuum of that table was on Dec 8th, the last auto analyze was Dec 26. There have been no schema changes on that particular table, database crashes or WAL-related parameter changes since then. We've done other schema changes during that time, but otherwise the database has been stable.

Thanks,
Mark

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: found multixact XX from before relminmxid YY
Следующее
От: Mitar
Дата:
Сообщение: Re: In which session context is a trigger run?