corruption since 7.4.13 update ?
От | Franz.Rasper@izb.de |
---|---|
Тема | corruption since 7.4.13 update ? |
Дата | |
Msg-id | 11EC9A592C31034C88965C87AF18C2A7581C5D@m0000s61 обсуждение исходный текст |
Список | 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 по дате отправления: