Re: ERROR: found multixact from before relminmxid

Поиск
Список
Период
Сортировка
От Sean McIntyre
Тема Re: ERROR: found multixact from before relminmxid
Дата
Msg-id CAAWwSTru281qbWbuVijr9CGU5asuC08HhvKiyqZ-dXGDSV4xrQ@mail.gmail.com
обсуждение исходный текст
Ответ на ERROR: found multixact from before relminmxid  (Sean McIntyre <sean.mcintyre@warbyparker.com>)
Ответы Re: ERROR: found multixact from before relminmxid
Список pgsql-general
Quick correction :)

I am running PostgreSQL *9.6.8* on AWS RDS. I'm going to try to pg-repack the table and will look to upgrade to *9.6.9* (though it's not presently available on RDS).

Sean

On Fri, Jul 13, 2018 at 11:14 AM Sean McIntyre <sean.mcintyre@warbyparker.com> wrote:
Dear all,

I just wanted to report that I found similar error "found multixact from before relminmxid" that Alexandre Arruda and Jeremy Finzel recently reported and discussed with Andres Freund. (Thanks all for good notes.)

I get this error when vacuuming a specific table in my high-transaction OLTP workload database. I am running PostgreSQL 9.5.8 on AWS RDS. I'm going to try to pg-repack the table and will look to upgrade to 9.5.9 (though it's not presently available).

Best,

Sean

--

Sean McIntyre
Summer reading calls for summery frames
We made an app! Download it here
Follow us:  FacebookTwitterInstagramSnapchat


--

Sean McIntyre
Summer reading calls for summery frames
We made an app! Download it here
Follow us:  FacebookTwitterInstagramSnapchat

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

Предыдущее
От: Edgard Battisti Guimarães
Дата:
Сообщение: Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small forthe InfoValue'
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: ERROR: found multixact from before relminmxid