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

Invalid page header in block

P: n/a
Hello:

I encounter a problem in which I have inserted about 1.6 million record to a
database table (using postgresql 7.3.4), when I vacuum or select * from the
table, it gets error message: Invalid page header in block 314345 of table.
At first, I think it is my hard-disk problem, so I install another new
machine (with the same config) and try again. But my new machine gets the
same error when I insert more than 1.6 million to the database table.

My machine running the postgresql is installed with Red Hat 7.3, it has a
IDE and SCSI hard disk. The data directory (PGDATA) is placed in the SCSI
hard disk. When I installed the OS, it has already checked the bad block, so
I don't think the error is caused by the bad block in my hard disk!

Does any one know to solve this problem?

Thanks a lot!
Carmen

__________________________________________________ _______________
Linguaphone : Learning English? Get Japanese lessons for FREE
http://go.msnserver.com/HK/30476.asp
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Carmen Wai" <wa********@hotmail.com> writes:
I encounter a problem in which I have inserted about 1.6 million record to a
database table (using postgresql 7.3.4), when I vacuum or select * from the
table, it gets error message: Invalid page header in block 314345 of table.
At first, I think it is my hard-disk problem, so I install another new
machine (with the same config) and try again. But my new machine gets the
same error when I insert more than 1.6 million to the database table.


Oh? Could we see the contents of that block as dumped with pg_filedump?
(You can get it from http://sources.redhat.com/rhdb/tools.html)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #2

P: n/a
Hello,

I also ran into this with 7.3.4. We had to reindex the database. It
recovered all but
two blocks. Once we figured out where those blocks were, we were able to
delete the
bad rows, dump the table, drop the table, restore the table.

We only lost those two rows and haven't had the problem since.
Sincerely,

Joshua D. Drake
Tom Lane wrote:
"Carmen Wai" <wa********@hotmail.com> writes:

I encounter a problem in which I have inserted about 1.6 million record to a
database table (using postgresql 7.3.4), when I vacuum or select * from the
table, it gets error message: Invalid page header in block 314345 of table.
At first, I think it is my hard-disk problem, so I install another new
machine (with the same config) and try again. But my new machine gets the
same error when I insert more than 1.6 million to the database table.


Oh? Could we see the contents of that block as dumped with pg_filedump?
(You can get it from http://sources.redhat.com/rhdb/tools.html)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.