again, invalid page header in block ...

Hubert Fröhlich

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

Subscribe Reply

1399

Similar topics

2967

Count of checkboxes (again)

by: Pete | last post by:

Okay, I'm still stuck with this problem. Here's a quick recap/summary :- 1. Page 1:User checks 3 out of 10 checkboxes and submits form to page 2 2. Page 2:Item count shows 3 items. User checks an additional 2 checkboxes and presses Update button. Item count now shows 5 checkboxes are checked and "New" checkboxes remain checked. 3. Page...

PHP

472

Invalid page header in block

by: CSN | last post by:

There are a bunch of these in PG's log: ERROR: Invalid page header in block 14 of start_items_key What does it mean? PG seems to be working fine - anything I need to fix/adjust/worry about? TIA, CSN

PostgreSQL Database

2008

Invalid page header in block xxxx

by: Carmen Wai | last post by:

Hello: I am a new user of postgresql. I am using postgresql 7.3.4 and I had inserted about 1.7 million records to a table. When I vacuum / select * from table, it gets a error message of : Invalid page header in block xxx of TableA. I check that I still can insert records to the table. But I am not able to get part of the data (as I try to...

PostgreSQL Database

4008

used pages increase after deleting and loading again

by: Olaf Gschweng | last post by:

We're new into DB2 and have some problem with DB2 8.1 (?) on a Linux system. We load some big tables of a DB2 database from files every day. We do a "DELETE FROM table" for each table and then we load the data by something like that: LOAD FROM "/pathto/artikel.data" OF DEL MODIFIED BY DATESISO CHARDEL0xbf SAVECOUNT 50000 MESSAGES...

DB2 Database

1338

Invalid page header in block...

by: Konstantinos Agouros | last post by:

Hi, I have a machine that is currently a bit unstable. No I got a: sysad=# select * from attacks where start < '1.1.2000'; ERROR: Invalid page header in block 3618 of attacks From googeling I saw that this should be solvable if I can delete the bad rows or find the bad datafile. Anybody has a tip on how to do that? Because I could not...

PostgreSQL Database

11558

PostgreSQL Invalid Page Header in Block XXXXX

by: Anthony | last post by:

Our Database is having errors. We are currently using PostgreSQL to store 2.5 Million records per day. The average addition to our primary table is 4.5 Gigs of data. We are doing this on a dual Opteron 244 system with 1 TeraByte of HDD space. The drives are 250 Gig Western Digital. The Raid Controller is LSI Logic MegaRaid 150-6. We are...

PostgreSQL Database

4118

Invalid page header

by: Ed L. | last post by:

I have 5 corrupted page headers as evidenced by these errors: ERROR: Invalid page header in block 13947 of ... The corruption is causing numerous queries to abort. First option is to try to salvage data before attempt restore from backup. I want to try to edit the file to zero out the bogus headers. I realize there may be data lost...

PostgreSQL Database

8230

invalid page header in block 52979 of relation "pg_attribute"

by: Steve Crawford | last post by:

This morning I got bitten by the "SELECT INTO" / "CREATE TABLE AS" from tables without OIDs bug in 7.4.1. Postmaster killed all the backends and restarted - pg was down for 2 seconds. This happened two times within a few minute period. Now I am getting 'invalid page header in block 52979 of relation "pg_attribute"' errors in the...

PostgreSQL Database

8355

<TBODY>, IE, and page-break

by: matt | last post by:

hello, ive been trying to figure something out, largely thru trial & error. thought perhaps someone else may have knowledge. i have an html table that consists of blocks of related data -- each block contains three rows. this table is destined for paper printing. i would like to tell the browser *not* to bust up my blocks. rather, i...

HTML / CSS

7276

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7408

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7581

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7142

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

5714

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

4773

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3259

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1624

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

488

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General