| From: | Mark Fletcher <markf(at)corp(dot)groups(dot)io> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | ERROR: found multixact XX from before relminmxid YY |
| Date: | 2018-12-29 00:25:08 |
| Message-ID: | CAEO096rj5B16Ybfeq8M39GmNuGq_gU64T-NkGc0OWCruLWa0yw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
Starting yesterday morning, auto vacuuming of one of our postgresql 9.6.10
(CentOS 7) table's started failing:
ERROR: found multixact 370350365 from before relminmxid 765860874
CONTEXT: automatic vacuum of table "userdb.public.subs"
This is about as plain and simple a table as there is. No triggers or
foreign keys, I'm not using any extensions. It has about 2.8M rows. I have
not done any consistency checks, but nothing strange has manifested in
production.
Reading the various discussions about this error, the only solution I found
was here:
But no other reports of this solving the problem. Can someone verify that
if I do the mentioned fix (and I assume upgrade to 9.6.11) that will fix
the problem? And that it doesn't indicate table corruption?
Thanks,
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-12-29 00:49:36 | Re: ERROR: found multixact XX from before relminmxid YY |
| Previous Message | patrick keshishian | 2018-12-28 23:40:27 | Re: libpq bug? |