corruption since 7.4.13 update ?

From: Franz(dot)Rasper(at)izb(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: corruption since 7.4.13 update ?
Date: 2006-08-09 08:10:07
Message-ID: 11EC9A592C31034C88965C87AF18C2A7581C5D@m0000s61
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Victor Snezhko 2006-08-09 09:16:39 Re: BUG #2555: runtime error 80040e21
Previous Message James 2006-08-09 06:08:34 BUG #2569: statement_timeout bug on Windows