Re: [HACKERS] Could not finish anti-wraparound VACUUM when stop limit is reached

2014-06-05 Thread Heikki Linnakangas
On 06/04/2014 12:45 AM, Jeff Janes wrote: On Sun, May 25, 2014 at 8:40 AM, Heikki Linnakangas hlinnakan...@vmware.com wrote: While debugging the B-tree bug that Jeff Janes reported ( http://www.postgresql.org/message-id/CAMkU=1y=VwF07Ay+Cpqk_ 7fpihrctmssv9y99sbghitkxpb...@mail.gmail.com), a

Re: [HACKERS] Could not finish anti-wraparound VACUUM when stop limit is reached

2014-06-03 Thread Jeff Janes
On Sun, May 25, 2014 at 8:40 AM, Heikki Linnakangas hlinnakan...@vmware.com wrote: While debugging the B-tree bug that Jeff Janes reported ( http://www.postgresql.org/message-id/CAMkU=1y=VwF07Ay+Cpqk_ 7fpihrctmssv9y99sbghitkxpb...@mail.gmail.com), a new issue came up: If you reach the

Re: [HACKERS] Could not finish anti-wraparound VACUUM when stop limit is reached

2014-06-03 Thread Jeff Janes
On Sun, May 25, 2014 at 8:53 AM, Andres Freund and...@2ndquadrant.com wrote: On 2014-05-25 11:40:09 -0400, Heikki Linnakangas wrote: So, vac_truncate_clog() tries to get a new transaction ID, which fails because we've already reached the stop-limit. vac_truncate_clog() doesn't really need

[HACKERS] Could not finish anti-wraparound VACUUM when stop limit is reached

2014-05-25 Thread Heikki Linnakangas
While debugging the B-tree bug that Jeff Janes reported (http://www.postgresql.org/message-id/CAMkU=1y=vwf07ay+cpqk_7fpihrctmssv9y99sbghitkxpb...@mail.gmail.com), a new issue came up: If you reach the xidStopLimit, and try to run VACUUM, it fails with error: jjanes=# vacuum; ERROR: database

Re: [HACKERS] Could not finish anti-wraparound VACUUM when stop limit is reached

2014-05-25 Thread Andres Freund
On 2014-05-25 11:40:09 -0400, Heikki Linnakangas wrote: So, vac_truncate_clog() tries to get a new transaction ID, which fails because we've already reached the stop-limit. vac_truncate_clog() doesn't really need a new XID to be assigned, though, it only uses it to compare against datfrozenxid

[HACKERS] Could not finish anti-wraparound VACUUM when stop limit is reached

2014-05-25 Thread Jeff Janes
On Sunday, May 25, 2014, Heikki Linnakangas hlinnakan...@vmware.comjavascript:_e(%7B%7D,'cvml','hlinnakan...@vmware.com'); wrote: While debugging the B-tree bug that Jeff Janes reported ( http://www.postgresql.org/message-id/CAMkU=1y=VwF07Ay+Cpqk_ 7fpihrctmssv9y99sbghitkxpb...@mail.gmail.com),