| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Steve Kehlet <steve(dot)kehlet(at)gmail(dot)com>, Forums postgresql <pgsql-general(at)postgresql(dot)org>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1 |
| Date: | 2015-06-08 06:52:57 |
| Message-ID: | 20150608065257.GE24997@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On 2015-06-05 20:47:33 +0200, Andres Freund wrote:
> On 2015-06-05 14:33:12 -0400, Tom Lane wrote:
> > Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> > > 1. The problem that we might truncate an SLRU members page away when
> > > it's in the buffers, but not drop it from the buffers, leading to a
> > > failure when we try to write it later.
>
> I've got a fix for this, and about three other issues I found during
> development of the new truncation codepath.
>
> I'll commit the fix tomorrow.
I've looked through multixact.c/slru.c and afaics there currently is, as
observed by Thomas, no codepath that exercises the broken behaviour. Due
to the way checkpoints and SLRU truncation are linked "problematic"
pages will have been flushed beforehand.
I think we should fix this either way as it seems like a bad trap, but
I'd rather commit it after the the next minor releases are out.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | otheus uibk | 2015-06-08 12:45:05 | pg_start_backup does not actually allow for consistent, file-level backup |
| Previous Message | Craig Ringer | 2015-06-08 02:37:23 | Re: BDR - Failure of Primary Server - How to recover? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2015-06-08 07:22:20 | Re: PATCH: use foreign keys to improve join estimates v1 |
| Previous Message | Michael Paquier | 2015-06-08 06:48:51 | Memory leak fixes for pg_dump, pg_dumpall, initdb and pg_upgrade |