Re: Checkpoint request failed on version 8.2.1. - Mailing list pgsql-general

From Patrick Earl
Subject Re: Checkpoint request failed on version 8.2.1.
Date
Msg-id e0762e610701111137m365b9e0elec49c86ea8ac03b6@mail.gmail.com
Whole thread Raw
In response to Re: Checkpoint request failed on version 8.2.1.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Checkpoint request failed on version 8.2.1.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
There is no antivirus software running on the machine.

I'm not entirely sure how to determine which relation it is
complaining about.  I see a folder that corresponds to the middle
number in the log, and I see numbers in the same range as the right
number from the log.

In any case, the unit tests remove all contents and schema within the
database before starting, and they remove the tables they create as
they proceed.  Certainly there are many things have been recently
deleted.

        Patrick

On 1/11/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Patrick Earl" <patearl@patearl.net> writes:
> > We're getting the error as part of an automated test suite and it is
> > seems to occur every time the suite is run.  The platform is Win XP 64
> > bit.
>
> Hm.  We've seen problems of this ilk caused by bogus antivirus software,
> but if that were the explanation it's not clear why running the test
> locally vs remotely would change anything.
>
> Another theory is that it's got something to do with Windows' problems
> with unlinking open files --- we've found that "permission denied" can
> be the error code when attempting to open a file that's been unlinked
> but isn't yet gone because someone is holding it open.  Can you
> determine whether the complained-of relation is one that's recently been
> deleted?
>
>                         regards, tom lane
>

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: generate_series with month intervals
Next
From: Bruce Momjian
Date:
Subject: Re: ORDER BY col is NULL in UNION causes error?