| From: | "Wong, Yi Wen" <yiwong(at)amazon(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de>, Paolo Crosato <paolo(dot)crosato(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Error on vacuum: xmin before relfrozenxid |
| Date: | 2018-05-24 20:25:04 |
| Message-ID: | 1527193504642.36340@amazon.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Hello,
We have also seen this issue ourselves and are actively working on it. We do not have a definite proposed solution or full RCA yet, but we have managed to narrow down the cause to stale values of relfrozenxid in the relcache for shared relations.
We are in the process of coming up with a repro as well.
A proposed workaround to this issue is to delete global/pg_internal.init. That will allow a vacuum of the shared relation to proceed.
Thanks,
Yi Wen Wong
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2018-05-24 20:30:56 | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
| Previous Message | Paolo Crosato | 2018-05-24 19:00:55 | Re: Error on vacuum: xmin before relfrozenxid |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2018-05-24 20:30:56 | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
| Previous Message | Robbie Harwood | 2018-05-24 20:10:52 | Re: [PATCH v15] GSSAPI encryption support |