[BUGS] Possibly corrupted shared memory, PostgreSQL 8.1 beta2,
Windows 2000
""Jean-Pierre Pelletier"" <[EMAIL PROTECTED]> wrote
Turning off the antivirus fixed the problem.
We haven't have any read/write/open error in more
than two days.
Thank you very much
""Jean-Pierre Pelletier"" <[EMAIL PROTECTED]> wrote
> Turning off the antivirus fixed the problem.
> We haven't have any read/write/open error in more
> than two days.
>
> Thank you very much for your help and keep up the good work.
>
You are welcome :-) But I still suspect if this really solves
riginal Message -
From: "Qingqing Zhou" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, October 05, 2005 5:16 PM
Subject: Re: [BUGS] Possibly corrupted shared memory, PostgreSQL 8.1
beta2,
Windows 2000
""Jean-Pierre Pelletier"" <[EMAIL PROTECTED]> w
On Fri, Oct 07, 2005 at 11:19:25AM -0400, Jean-Pierre Pelletier wrote:
> Our only remaining PostgreSQL problem is with pg_stat_actitivity
> being unreliable and the statistics collector being restarted many times
> every day.
The stats collector (which mantains pg_stat_activity among other things
:
Sent: Wednesday, October 05, 2005 5:16 PM
Subject: Re: [BUGS] Possibly corrupted shared memory, PostgreSQL 8.1 beta2,
Windows 2000
""Jean-Pierre Pelletier"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Yes, there is an antivirus software on the m
""Jean-Pierre Pelletier"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> Yes, there is an antivirus software on the machine, a reboot is needed
> when it's turned off,
> I'll be allowed to reboot it tonight or I'll do it sooner if it crashes
> before that.
>
> There are around
inserts but no bulk inserts, the biggest load would come
from
select statements.
Jean-Pierre Pelletier
- Original Message -
From: "Qingqing Zhou" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, October 05, 2005 3:03 AM
Subject: Re: [BUGS] Possibly corrupted shared memory,
""Jean-Pierre Pelletier"" <[EMAIL PROTECTED]> wrote
>
> I've installed PostgreSQL 8.1 beta2 five days ago and it crashed 3 times
> since then.
> Here is what's been logged for the last crash
>
> 2005-10-04 11:00:19 FATAL: could not read block 121 of relation
> 1663/16384/2608: Invalid argument
Hi,
I've installed PostgreSQL 8.1 beta2 five days ago and it crashed 3 times
since then.
Here is what's been logged for the last crash
2005-10-04 11:00:19 FATAL: could not read block 121 of relation
1663/16384/2608: Invalid argument
2005-10-04 11:00:20 LOG: server process (PID 2592) was ter
