| 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 15:21:09 |
| Message-ID: | 7001.1168615269@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:
> 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.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Evgeny Gridasov | 2007-01-12 15:45:06 | Re: WAL question |
| Previous Message | Jeff Amiel | 2007-01-12 15:16:42 | Re: Corrupt database? 8.1/FreeBSD6.0 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-01-12 15:44:27 | Re: copy table from file: with row replacement? |
| Previous Message | Jeff Amiel | 2007-01-12 15:16:42 | Re: Corrupt database? 8.1/FreeBSD6.0 |