corruption since 7.4.13 update ? - Mailing list pgsql-bugs

From Franz.Rasper@izb.de
Subject corruption since 7.4.13 update ?
Date
Msg-id 11EC9A592C31034C88965C87AF18C2A7581C5D@m0000s61
Whole thread Raw
List pgsql-bugs
Hello,

i have a "new" machine with following problem:
postgres-7.4.13[7874]: [457-1] ERROR:  could not open segment 1 of relation
"data_server_id_idx" (target block 791807): No such file or directory

I my point of view it seems the same error as:
http://archives.postgresql.org/pgsql-admin/2006-07/msg00028.php

http://archives.postgresql.org/pgsql-admin/2006-07/msg00103.php

The server is an HP DL 380 G4 with Battery Backup write cache.

I am doing a lot of inserts. (Linux + Postgresql 7.4.13)
I works correctly on an other server (Linux + Postgresl 7.4.10 , HP DL 380
G3 without Battery Backup Write Cache).

Linux + Postgresql 7.4.10 + HP DL 380 G3 without Battery Backup Write Cache
it takes about 4 hours
Linux + Postgresql 7.4.13 + HP DL 380 G4 with Battery Backup Write Cache it
takes about 15 minutes

Amount of RAM is the same (4 GB ) both have ext3 Filesystems

What could be the reason ?  Postgresql 7.4.13 ? Configuration ? Linux Kernel
(2.4.28 vs. 2.4.32) ? Backup Write Cache ? Hardware ?

The first time it works correctly. Next day ist doesnt work.

Any help is appreciated.

regrads,

-Franz

pgsql-bugs by date:

Previous
From: "James"
Date:
Subject: BUG #2569: statement_timeout bug on Windows
Next
From: Victor Snezhko
Date:
Subject: Re: BUG #2555: runtime error 80040e21