From: Tom Lane <tgl@sss.pgh.pa.us>
To: BJ Taylor <btaylor@propertysolutions.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: missing chunk number 0 for toast value
Date: Thu, 25 Sep 2008 09:24:08 -0400
Message-ID: <5723.1222349048@sss.pgh.pa.us> (raw)
In-Reply-To: <3d78fcfd0809241446j326110c4p9907e04dbd10106b@mail.gmail.com>
References: <3d78fcfd0809241132y14a832cai8b32bc32e936699e@mail.gmail.com>
<10862.1222287999@sss.pgh.pa.us>
<3d78fcfd0809241446j326110c4p9907e04dbd10106b@mail.gmail.com>
"BJ Taylor" <btaylor@propertysolutions.com> writes:
> 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.
Unstable how? What error did you get on the refused connections? What
was showing up in the postmaster log?
> At which
> point, I killed all vacuum processes, and restarted postgresql.
How did you do that killing exactly?
> 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.
Nothing of interest, it's done all the 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).
Again, what errors are you getting exactly, and what shows up in the
postmaster log?
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: tgl@sss.pgh.pa.us, btaylor@propertysolutions.com
Subject: Re: missing chunk number 0 for toast value
In-Reply-To: <5723.1222349048@sss.pgh.pa.us>
* 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