From: | Dinesh Bhandary <dbhandary(at)switchfly(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #11264: Auto vacuum wraparound job blocking everything |
Date: | 2014-08-27 19:39:35 |
Message-ID: | f4659c77a92540d2ba8e67042fa9971f@CO2PR05MB569.namprd05.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi Alvaro,
Thank you so much for jumping onto this issue. I greatly appreciate it.
We will be testing the fix that you have mentioned in test env first. I
will let you know when we are done with testing. Then we can update
production db.
Dinesh
-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)2ndquadrant(dot)com]
Sent: Wednesday, August 27, 2014 10:51 AM
To: Dinesh Bhandary
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #11264: Auto vacuum wraparound job blocking
everything
Dinesh Bhandary wrote:
> Yes, it was upgraded a month ago using postgresql 9.3.4 binaries. It
> was just patched up last week with 9.3.5.
Ok, that makes a lot more sense.
> I checked all the other servers which we upgraded using postgres
> 9.3.5 binaries, oldestMultiXid is other than 1 and it seems to be have
> picked the right number. But the server in question was upgraded using
> postgres
> 9.3.4 binaries. This sounds suspicious. Could it be pg_upgrade in
> 9.3.4 is buggy.
Well, yes, 9.3.4 had a bug fixed by this commit:
Author: Bruce Momjian <bruce(at)momjian(dot)us>
Branch: master [a61daa14d] 2014-07-02 15:29:38 -0400
Branch: REL9_4_STABLE [b446a384b] 2014-07-02 15:29:38 -0400
Branch: REL9_3_STABLE Release: REL9_3_5 [3d2e18510] 2014-07-02 15:29:38
-0400
pg_upgrade: preserve database and relation minmxid values
Also set these values for pre-9.3 old clusters that don't have values
to
preserve.
Analysis by Alvaro
Backpatch through 9.3
> How do we fix the current issue with this one server? Is there an easy
>fix?
> Thanks.
As far as I am aware, you should
UPDATE pg_database SET datminmxid=20783
and that should fix it. The oldestMulti value in pg_control would get
updated by itself some time later. If you experience stalls before
oldestMulti fixes itself, you could stop the server (cleanly!) and then
pg_resetxlog -m x,y where x is the correct nextMulti value from
pg_controldata and y is 20783.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-08-27 23:28:45 | Re: Error with citext extension when upgrading from 9.0.3 to 9.3.5: 'cannot cast type oid[] to oidvector' |
Previous Message | Alvaro Herrera | 2014-08-27 17:51:05 | Re: BUG #11264: Auto vacuum wraparound job blocking everything |