By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,882 Members | 2,460 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,882 IT Pros & Developers. It's quick & easy.

again, invalid page header in block ...

P: n/a
Hi list,

I am working with 7.4.1 under Linux (SuSE 8.1) The server is a HP
ProLiant DL 380-G3, 2x Intel Pentium4-Xeon, 2.8 GHz, 4 GB memory and a
RAID 5 system with ca. 500 GB diskspace (xfs file system)
When doing big transactions or changes (UPDATE several million rows in
one step) on a database with ca. 50 GB diskspace and ca 15 million
entries, PostGIS and lots of indexes, I get errors like

ERROR: invalid page header in block 582024 of relation ...

The error does not occur regularly. It seems to me that the error is
related with heavy load and heavy I/O . CPU and memory does not seem the
problem, according to my hotsanic tools.

I have worked through

http://archives.postgresql.org/pgsql...1/msg01288.php
http://archives.postgresql.org/pgsql...9/msg00423.php
http://groups.google.com/groups?hl=e....uk%26rnum%3D8
which suggest to me that I have run into hardware trouble (disk?
memory?!) But I supposed that my server was not SO bad for this database
application...

How to fix that? (I mean - not to repair the tables or pages but to get
a stable one? ) Trying another sotrage hardware?!
--
-------------------------------------------------------------------------------
Dr.-Ing. Hubert Fröhlich
Bezirksfinanzdirektion München
Alexandrastr. 3, D-80538 München, GERMANY
Tel. :+49 (0)89 / 2190 - 2980
Fax :+49 (0)89 / 2190 - 2997
hubert dot froehlich at bvv dot bayern dot de
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.