The following bug has been logged online:
Bug reference: 5278
Logged by: Murali
Email address: nmmreddy11@hotmail.com
PostgreSQL version: 8.0.6
Operating system: Windows Server 2003 Standard 32 Bit
Description: Postgres hangs / crashes every day
Details:
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.
Log Snippet1:
2009-12-16 10:59:11 FATAL: could not open relation 17253/33902/16729: No
such file or directory
Log Snippet2:
2009-12-16 09:44:50 ERROR: could not open relation 17253/33902/16691:
Permission denied
2009-12-16 09:44:50 CONTEXT: writing block 100 of relation
17253/33902/16691
2009-12-16 09:44:50 WARNING: could not write block 100 of
17253/33902/16691
2009-12-16 09:44:50 DETAIL: Multiple failures --- write error may be
permanent.
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
happening.
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.