Re: [HACKERS] Checkpoint request failed on version 8.2.1.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, Patrick Earl <patearl(at)patearl(dot)net>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Checkpoint request failed on version 8.2.1.
Date: 2007-01-12 16:35:25
Message-ID: 7654.1168619725@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Magnus Hagander <magnus(at)hagander(dot)net> writes:
> Tom Lane wrote:
>> Actually, it could still be the same problem, with the AV software only
>> involved to the extent that it's trying to scan files for viruses.

> Partially the same, but I've seen AV software keeping it open for
> hours... Basically until reboot.

Well, the bug report that just went by proves there's another problem:

: select version();
:
: "PostgreSQL 8.2.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
: 3.4.2 (mingw-special)"
:
: pg_log:
:
: 2007-01-12 17:23:16 PANIC: could not open control file
: "global/pg_control": Permission denied

pg_control is certainly not ever deleted or renamed, and in fact I
believe there's an LWLock enforcing that only one PG process at a time
is even touching it. So we need another theory to explain this one :-(
... anyone have a better one than "Windows is a piece of junk"?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stéphane Schildknecht 2007-01-12 16:50:51 FK Constraint on index not PK
Previous Message Alvaro Herrera 2007-01-12 16:22:59 Re: [GENERAL] Corrupt database? 8.1/FreeBSD6.0

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Enke 2007-01-12 16:38:28 Re: copy table from file: with row replacement?
Previous Message Alvaro Herrera 2007-01-12 16:22:59 Re: [GENERAL] Corrupt database? 8.1/FreeBSD6.0