The following bug has been logged online:
Bug reference: 5278
Logged by: Murali
Email address: nmmreddy11(at)hotmail(dot)com
PostgreSQL version: 8.0.6
Operating system: Windows Server 2003 Standard 32 Bit
Description: Postgres hangs / crashes every day
Postgres hangs / crashes every day (gets corrupted?). It neither serves any
requests from connected applications nor accepts new connections. I can’t
connect to the data base through PG Admin also. Below given is the log
snippet at the time of failure.
2009-12-16 10:59:11 FATAL: could not open relation 17253/33902/16729: No
such file or directory
2009-12-16 09:44:50 ERROR: could not open relation 17253/33902/16691:
2009-12-16 09:44:50 CONTEXT: writing block 100 of relation
2009-12-16 09:44:50 WARNING: could not write block 100 of
2009-12-16 09:44:50 DETAIL: Multiple failures --- write error may be
What does Application do?
Multiple applications communicate with Postgres.
One application inserts the data into Postgres and all other applications
get the data from Postgres
Data will not be deleted from Postgres as soon as other applications get
data. It will be deleted at a alter point of time.
RAID configuration for the hard disk that Postgres is using:
RAID 1 + 0
Is anti-virus software monitoring the Postgres drives?
Anti-virus is running on the system but Postgres folder is excluded
Is any other application using the same hard disk?
All our applications log traces into this drive so heavy logging is
Is the hard disk health ok?
No event log found indicating hard drive errors. There were some power
module issues over a year back.
What is the database size?
Around 200k rows.
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2010-01-14 23:11:24|
|Subject: Re: BUG #5278: Postgres hangs / crashes every day |
|Previous:||From: Tim Bunce||Date: 2010-01-14 20:45:06|
|Subject: Re: Termination When Switching between PL/Perl and PL/PerlU|