Vacuum/visibility is busted

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:

http://www.postgresql.org/message-id/CAMkU=1xoA6Fdyoj_4fMLqpicZR1V9GP7cLnXJdHU+iGgqb6WUw@mail.gmail.com

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

Responses

Browse pgsql-hackers by date

  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