| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Jeremy Finzel <finzelj(at)gmail(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
| Date: | 2018-03-21 21:29:40 |
| Message-ID: | CAH2-WznSVK-G60FYWf=5shijgqvtw1HVSkv2wzxv8AQ76s1h-g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Wed, Mar 21, 2018 at 1:38 PM, Jeremy Finzel <finzelj(at)gmail(dot)com> wrote:
> A server restart and upgrade to 9.5.12 (at the same time), as expected, made
> the issue go away. Still doesn't give us any answers as to what happened or
> if it would happen again! Thanks for the feeback.
You may still want to use amcheck to look for problems. The version on
Github works with 9.5, and there are Redhat and Debian pgdg packages.
See:
https://github.com/petergeoghegan/amcheck
The "heapallindexed" option will be of particular interest to you -
that option verifies that the table has matching rows for a target
index (in addition to testing the structure of a target B-Tree index
itself). This is probably the best general test for corruption that is
available. There is a fair chance that this will reveal new
information.
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Atkins | 2018-03-21 21:32:46 | Re: Prepared statements |
| Previous Message | Rakesh Kumar | 2018-03-21 21:16:54 | Re: Prepared statements |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-03-21 21:36:19 | Multiple-output-file make rules: We're Doing It Wrong |
| Previous Message | Andres Freund | 2018-03-21 21:21:01 | Re: JIT compiling with LLVM v12.2 |