Re: BUG #11264: Auto vacuum wraparound job blocking everything - Mailing list pgsql-bugs

From Dinesh Bhandary
Subject Re: BUG #11264: Auto vacuum wraparound job blocking everything
Date
Msg-id 9ac49eee319c43f6a344a2d5d2c38093@CO2PR05MB569.namprd05.prod.outlook.com
Whole thread Raw
In response to Re: BUG #11264: Auto vacuum wraparound job blocking everything  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
and that should fix it.  The oldestMulti value in pg_control would get upda=
ted 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 2=
0783.

Are you referreing to NextMultiXactId of current pg_controldata ( from post=
gres 9.3.5) for x?
There is also NextMultiOffset, not sure If you meant to reset this. Please =
confirm.

Thanks,
Dinesh

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #11264: Auto vacuum wraparound job blocking everything
Next
From: Dinesh Bhandary
Date:
Subject: Re: BUG #11264: Auto vacuum wraparound job blocking everything