From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Vacuum/visibility is busted |
Date: | 2013-02-07 05:39:18 |
Message-ID: | CAMkU=1ztsEd1XYgVYQoXz4dSzeh7_nVBOWjfb3nECEHSiOa9xA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
While stress testing Pavan's 2nd pass vacuum visibility patch, I realized
that vacuum/visibility was busted. But it wasn't his patch that busted it.
As far as I can tell, the bad commit was in the
range 692079e5dcb331..168d3157032879
Since a run takes 12 to 24 hours, it will take a while to refine that
interval.
I was testing using the framework explained here:
Except that I increased JJ_torn_page to 8000, so that autovacuum has a
chance to run to completion before each crash; and I turned off
archive_mode as it was not relevant and caused annoying noise. As far as I
know, crashing is entirely irrelevant to the current problem, but I just
used and adapted the framework I had at hand.
A tarball of the data directory is available below, for those who would
like to do a forensic inspection. The table jjanes.public.foo is clearly
in violation of its unique index.
https://docs.google.com/file/d/0Bzqrh1SO9FcEbk1lUWgwSk9Od28/edit?usp=sharing
Thanks for any help,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-02-07 06:41:35 | Re: Vacuum/visibility is busted |
Previous Message | Alexander Korotkov | 2013-02-07 05:14:40 | Re: Alias hstore's ? to ~ so that it works with JDBC |