Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B4B4C632B88 for ; Thu, 8 Apr 2010 02:00:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 07843-04 for ; Thu, 8 Apr 2010 04:59:48 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pz0-f171.google.com (mail-pz0-f171.google.com [209.85.222.171]) by mail.postgresql.org (Postfix) with ESMTP id 9B586632A45 for ; Thu, 8 Apr 2010 01:59:34 -0300 (ADT) Received: by pzk1 with SMTP id 1so213714pzk.15 for ; Wed, 07 Apr 2010 21:59:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:in-reply-to :references:from:date:x-google-sender-auth:received:message-id :subject:to:cc:content-type:content-transfer-encoding; bh=BBo8XJMtpa5WPIhJYHjdchMVLwwd2omnlCgb8+6OsY4=; b=uXj/DFW1VK5QH2ZKD/PWczpdOKTmspYPZHc6/bvuIQKxETpCqcTTY79nKWT1z4GKr5 h+X3HnCFjv+BMNpoTJmVzF7Vb02C1Yfuq/b1DCg0YzciwEU/HU2rutSMiXlYGtUJqIbE Q3393HRW7cCXbfbyRYQgF5/LAi6TBolEbX2/o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:cc:content-type :content-transfer-encoding; b=hlvi0M1j0MqlzXw8HfbHBNcSCXIQkITYUXzyYuBCMa2DGMnQamnNZ14kYLm4iTw4pL oXFB+dzcfPfeDJZhcZ/CKfALNRW/Q0jYuYL0F1uYU3OJvKv9CWAo7eh0NuA2dOlB4XON hYH6U/bJVAQaNxe4KzszV94drd8PTJTFJFyHU= MIME-Version: 1.0 Received: by 10.140.128.3 with HTTP; Wed, 7 Apr 2010 21:59:12 -0700 (PDT) In-Reply-To: References: From: Greg Stark Date: Thu, 8 Apr 2010 05:59:12 +0100 X-Google-Sender-Auth: afd1a1eacacd17b2 Received: by 10.141.125.19 with SMTP id c19mr7782992rvn.55.1270702773326; Wed, 07 Apr 2010 21:59:33 -0700 (PDT) Message-ID: Subject: Re: PD_ALL_VISIBLE flag warning To: Jonathan Foy Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.48 tagged_above=-10 required=5 tests=AWL=0.119, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201004/77 X-Sequence-Number: 34171 On Thu, Apr 1, 2010 at 2:10 PM, Jonathan Foy wrote: > Hello > > I came in this morning and noticed this warning sitting in my inbox quite= a > few times... > > WARNING:=A0 PD_ALL_VISIBLE flag was incorrectly set in relation "table_20= 10q1" > page 471118 > WARNING:=A0 PD_ALL_VISIBLE flag was incorrectly set in relation "table_20= 10q1" > page 471119 > WARNING:=A0 PD_ALL_VISIBLE flag was incorrectly set in relation "table_20= 10q1" > page 471120 > .... > > and I'm wondering how worked up I should be getting. This is a warning about a fairly serious data corruption problem. In the worst case prior queries returned incorrect results -- which if those results were used to calculate subsequent updates could have caused your data to be inconsistent. Specifically, having that flag set would cause rows to be returned which should not have been returned, either because they had been deleted, the transaction inserting them aborted, or they had been updated (causing duplicate copies of the same row to be returned). There was a bug which could cause this in 8.4.0 but it was fixed in 8.4.1. You say you're running 8.4.1 (you should be running 8.4.3 though none of the subsequent bug-fixes are as serious if the SSL security vulnerability isn't relevant) so this is quite worrisome. Nobody else has reported anything similar though. Is it possible these pages have never been vacuumed since you updated from 8.4.0 to 8.4.1? I'm not sure how likely that is. In 8.4 Postgres tries to avoid vacuuming pages that don't need it so it's possible this situation could live on for longer than in the past. I think a regular "VACUUM" of every table should guarantee that any remnants of this bug from 8.4.0 are cleaned up. If you do this and possibly get some more warnings from it but never see it again afterwards then I would assume they're leftovers from that old bug. --=20 greg