From: BJ Taylor <btaylor@propertysolutions.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: missing chunk number 0 for toast value
Date: Wed, 24 Sep 2008 15:46:49 -0600
Message-ID: <3d78fcfd0809241446j326110c4p9907e04dbd10106b@mail.gmail.com> (raw)
In-Reply-To: <10862.1222287999@sss.pgh.pa.us>
References: <3d78fcfd0809241132y14a832cai8b32bc32e936699e@mail.gmail.com>
<10862.1222287999@sss.pgh.pa.us>
We are using version 8.3.1. And to be precise, when I started the vacuum
(analyze), I started it as a cron job to run daily around midnight. The
next day I came in and checked on it and it was still running. Not thinking
that it would take more than a full 24 hours to run, I let it be, and the
next day I came in and the server started acting weird. I believe the
vacuum process continued to run, and a second vacuum process was started.
The server became unstable, and refused incoming connections. At which
point, I killed all vacuum processes, and restarted postgresql. I believe
it was somewhere during this process that the database became corrupted. I
am not certain what happens when two vacuum processes run at the same time.
That may have been the problem, or it may not have. Or it may have been
that I killed the vacuum process in the middle of what it was doing. One
way or another, the problem that we have now, is that we are unable to get a
dump of the database for backups, and the database seems less stable than it
was previously (dropping connections, and refusing connections seemingly at
random).
BJ
On Wed, Sep 24, 2008 at 2:26 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "BJ Taylor" <btaylor@propertysolutions.com> writes:
> > Our database seems to have been corrupted. It is a heavily used
> database,
> > and went several months without any type of vacuuming. When we finally
> > realized that it wasn't being vacuumed, we started the process, but the
> > process never successfully completed, and our database has never been the
> > same since.
>
> What PG version is this? Exactly what do you mean by "never
> successfully completed"?
>
> regards, tom lane
>
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: btaylor@propertysolutions.com, tgl@sss.pgh.pa.us
Subject: Re: missing chunk number 0 for toast value
In-Reply-To: <3d78fcfd0809241446j326110c4p9907e04dbd10106b@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