From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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:06:09 |
Message-ID: | 45A7B1F1.1000003@hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Tom Lane wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
>> On Fri, Jan 12, 2007 at 09:47:55AM -0500, Tom Lane wrote:
>>> No, I didn't claim that Windows AV software is bug-free ;-). What I
>>> said was that I'm not certain it's related to the "permission denied"
>>> reports, as opposed to other problems. Or are your stack traces
>>> specifically for "permission denied" failures?
>
>> I have at least two cases specifically for the permission denied
>> failures in postgres.
>
> 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.
> That could result in the AV code holding a table file open for a little
> bit (or not such a little bit, if it's a big table) after it's nominally
> been deleted, and that's exactly the situation we see checkpoints
> failing in.
Partially the same, but I've seen AV software keeping it open for
hours... Basically until reboot.
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Al Balmer | 2007-01-12 16:20:21 | Version 8.2 for HP-UX |
Previous Message | Alvaro Herrera | 2007-01-12 15:53:53 | Re: WAL question |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-01-12 16:22:59 | Re: [GENERAL] Corrupt database? 8.1/FreeBSD6.0 |
Previous Message | Bruce Momjian | 2007-01-12 15:44:27 | Re: copy table from file: with row replacement? |