pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: daveg <daveg@sonic.net>
To: bricklen <bricklen@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum
Date: Wed, 2 Mar 2011 16:29:52 -0800
Message-ID: <20110303002952.GQ26397@sonic.net> (raw)
In-Reply-To: <AANLkTikNL3wqx5t_-TCmWOKhd+PZUakB=FmNUCqH0ZNn@mail.gmail.com>
References: <AANLkTino+Gc2vvOVdzCPRRXW-N7R5=ikYMnNKT5W=mk1@mail.gmail.com>
	<AANLkTikw==USr3+4Mt+w97P3ymux-Bhn0G7Ad0ZJHbqG@mail.gmail.com>
	<4D2D6A56.9060808@enterprisedb.com>
	<20110228212832.GH26397@sonic.net>
	<4D6C1B16.6030708@enterprisedb.com>
	<20110301212043.GN26397@sonic.net>
	<20110302213034.GO26397@sonic.net>
	<1299101996-sup-4206@alvh.no-ip.org>
	<20110302235354.GP26397@sonic.net>
	<AANLkTikNL3wqx5t_-TCmWOKhd+PZUakB=FmNUCqH0ZNn@mail.gmail.com>

On Wed, Mar 02, 2011 at 04:20:24PM -0800, bricklen wrote:
> On Wed, Mar 2, 2011 at 3:53 PM, daveg <daveg@sonic.net> wrote:
> >> > Postgresql version is 8.4.4.
> >>
> >> I don't see how this could be related, but since you're running on NFS,
> >> maybe it is, somehow:
> >> http://archives.postgresql.org/message-id/4D40DDB7.1010000@credativ.com
> >> (for example what if the visibility map fork's last page is overwritten?)
> >
> > Running on ISCSI, not nfs. But it is still a Netapp, so who knows. I'll look.
> > Also, we are not seeing any of the "unexpected data beyond EOF" errors,
> > just thousands per day of the PD_ALL_VISIBLE error.
> >
> > -dg
> 
> FWIW, we had a couple occurrences of that message about a month ago on 9.0.2
> 
> http://archives.postgresql.org/pgsql-general/2011-01/msg00887.php
> 
> Haven't seen it since we ran a cluster-wide vacuum.

We did a shutdown and restart to clear the buffer cache (but did not reboot
the host) and a vacuum on all dbs in the cluster last night. That cleared it
up for a couple hours, but we are still getting lots of these messages.

Most of them are pg_statistic and we create and drop hundreds of thousands of
temp tables daily, so there is a good chance there is a concurrancy issue.

-dg
 

-- 
David Gould       daveg@sonic.net      510 536 1443    510 282 0869
If simplicity worked, the world would be overrun with insects.



view thread (32+ messages)  latest in thread

Message-ID: <20110303002952.GQ26397@sonic.net>
Permalink:  ../20110303002952.GQ26397@sonic.net/
Also on:    postgresql.org/message-id/20110303002952.GQ26397@sonic.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: daveg@sonic.net, bricklen@gmail.com, pgsql-hackers@postgresql.org
  Subject: Re: [HACKERS] Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum
  In-Reply-To: <20110303002952.GQ26397@sonic.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox