Re: Checkpoint request failed on version 8.2.1.

From: "Patrick Earl" <patearl(at)patearl(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Checkpoint request failed on version 8.2.1.
Date: 2007-01-11 19:37:26
Message-ID: e0762e610701111137m365b9e0elec49c86ea8ac03b6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Patrick Earl" <patearl(at)patearl(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2007-01-11 20:04:25 Re: ORDER BY col is NULL in UNION causes error?
Previous Message Tom Lane 2007-01-11 19:35:59 Re: generate_series with month intervals

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-01-11 19:45:10 Re: unusual performance for vac following 8.2 upgrade
Previous Message Neil Conway 2007-01-11 19:36:42 Re: -f <output file> option for pg_dumpall