From: Jonathan Foy <thefoy@gmail.com>
To: Greg Stark <gsstark@mit.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: PD_ALL_VISIBLE flag warning
Date: Thu, 8 Apr 2010 11:03:14 -0400
Message-ID: <j2y4b46b5f01004080803yc018a6cbqf38ceedd6933817d@mail.gmail.com> (raw)
In-Reply-To: <t2j407d949e1004080716iff21f326p4cd52c79ed204359@mail.gmail.com>
References: <g2o4b46b5f01004010610ib8625426uae6ee90ac1435ba1@mail.gmail.com>
<t2u407d949e1004072159yaf03feffu1c18e03d75859bba@mail.gmail.com>
<g2v4b46b5f01004080557j25cb26f1ic054f92b4f543baa@mail.gmail.com>
<t2j407d949e1004080716iff21f326p4cd52c79ed204359@mail.gmail.com>
On Thu, Apr 8, 2010 at 10:16 AM, Greg Stark <gsstark@mit.edu> wrote:
>
> If you're on 8.1 it's important to be on the latest 8.1 -- there are
> at least 17 significant bugs that warranted bug-fix releases between
> 8.1.3 and 8.1.20 including security bugs and data corruption bugs.
>
Understood. It's my current top priority.
>
> > We never actually ran 8.4.0. We went straight from 8.3.3 to 8.4.1. I
> did a
> > full dump/restore from the 8.3.3 database into the 8.4.1 database (using
> the
> > 8.4 pg_dump), partitioning as I went.
>
> Ugh, then it sounds like there's a real as-yet unidentified problem.
>
> The other thing to check before panicking is, has this server ever run
> with fsync off and crashed (either kernel panic or power failure)?
>
I have never turned off fsync. Also, the server is showing an uptime of 281
days, and the postgres instance has been up since 2/21.
>
> What does the storage system on this server look like? Are they IDE or
> SCSI drives? Is there an LVM layer involved? etc.
>
> --
> greg
>
Storage is on an NFS mounted Fiber Netapp volume.
Let me know if you need more...
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: thefoy@gmail.com, gsstark@mit.edu
Subject: Re: PD_ALL_VISIBLE flag warning
In-Reply-To: <j2y4b46b5f01004080803yc018a6cbqf38ceedd6933817d@mail.gmail.com>
* 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