Re: [GENERAL] ERROR: XX001: could not read block 2354 of relation…

I am on Windows Server 2003 and humm I will have to check tommorow morning
but I do not think any Anti-Virus is scanning.

On Tue, Mar 31, 2009 at 6:53 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> On Tue, Mar 31, 2009 at 2:10 PM, Patrick Desjardins
> <mrdesjardins(at)gmail(dot)com> wrote:
> > Hi,
> >
> > I have the error ERROR: XX001: could not read block 2354 of relation
> > 1663/17633/17925: read only 0 of 8192 bytes, but only sometime, when
> trying
> > to Insert data into a table. I would say that 99% of Insert works and
> 100%
> > of read works. This is only happenning since few weeks. I have done
> Vaccum
> > Analyze without any success (the vaccum take 65 minutes but nothing is
> > fixed, still have the ERROR XXX001). I have this error in the backend
> > application and when I do some Insert Query in the PgAdmin tool.
>
> What OS, pg version etc are you running?
>
> If windows, are you running any anti-virus software? A lot of
> anti-virus packages are dumb as a brick and lock files when checking
> them and cause these problems. If so, either exclude the pg
> directories from virus checking or turn it off altogether.
>
> Just a guess. Not enough info to really know.
>