469,916 Members | 1,861 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,916 developers. It's quick & easy.

Invalid page header in block

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
2 3524
"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
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.

Similar topics

reply views Thread by CSN | last post: by
1 post views Thread by Carmen Wai | last post: by
5 posts views Thread by Nick Flandry | last post: by
reply views Thread by Konstantinos Agouros | last post: by
reply views Thread by Hubert Fröhlich | last post: by
5 posts views Thread by Ed L. | last post: by
16 posts views Thread by matt | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.