ERROR: invalid page header in block 13760 of relation base/16995/67484
来源:互联网 发布:买家怎么进淘宝试衣间 编辑:程序博客网 时间:2024/06/06 03:26
ERROR: invalid page header in block 13760 of relation base/16995/67484
or that, when doing your database dump:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid page header in block 11947 of relation base/16995/17062
pg_dump: The command was: COPY public.samaged_table (column1, column2, column3, ...) TO stdout;
it is likely your PostgreSQL server has hardware issues or has crashed (or, the VM host, as in my case). If it’s the case, pg_dump / pg_dumpall will error and exit when seeing a corrupted block.
Unfortunately, it mean’s you’ll loose some data, so depending on what you have in your database, you may resort to some other methods.
Here is a quick way to fix it:
database=# SET zero_damaged_pages = on;
SET
database=# VACUUM FULL damaged_table;
WARNING: invalid page header in block 13748 of relation base/16995/67484; zeroing out page
WARNING: invalid page header in block 13749 of relation base/16995/67484; zeroing out page
WARNING: invalid page header in block 13757 of relation base/16995/67484; zeroing out page
WARNING: invalid page header in block 13758 of relation base/16995/67484; zeroing out page
WARNING: invalid page header in block 13759 of relation base/16995/67484; zeroing out page
WARNING: invalid page header in block 13760 of relation base/16995/67484; zeroing out page
WARNING: invalid page header in block 13762 of relation base/16995/67484; zeroing out page
WARNING: invalid page header in block 13782 of relation base/16995/67484; zeroing out page
(...)
WARNING: index "damaged_table_site_id" contains 14697831 row versions, but table contains 14709258 row versions
HINT: Rebuild the index with REINDEX.
WARNING: invalid page header in block 13762 of relation base/16995/67484; zeroing out page
WARNING: invalid page header in block 13816 of relation base/16995/67484; zeroing out page
WARNING: invalid page header in block 13817 of relation base/16995/67484; zeroing out page
WARNING: invalid page header in block 13818 of relation base/16995/67484; zeroing out page
(...)
WARNING: index "damaged_table_site_id" contains 14697498 row versions, but table contains 14709258 row versions
HINT: Rebuild the index with REINDEX.
VACUUM
database=# REINDEX TABLE damaged_table;
Do a database dump after that to make sure it’s no longer corrupted (pg_dump / pg_dumpall should no longer complain).
Referenced from: http://blog.wpkg.org/2012/04/30/error-invalid-page-header-in-block-13760-of-relation-base1699567484/
- ERROR: invalid page header in block 13760 of relation base/16995/67484
- 严重: Error in dependencyCheck java.io.IOException: invalid header field
- Invalid number of data directories in NT header
- Oracle Invalid character ' ' in value part of property error
- Oracle Invalid character ' ' in value part of property error
- error : implicit declaration of function CC_MD5 is invalid in C99
- Repeating Table Header on Each Page of the Report in the SSRS 2008
- InnoDB: space header page consists of zero bytes in tablespace ./mysql/iyikcr32.ibd (table mysql/iyi
- Bug 6270137 Unnecessary acquisition of the list header block in ASM
- EXCEL caused an invalid page fault in
- Global Error Page in JSF
- essbase数据库某个plan type出现invalid block header问题
- 严重: Error in dependencyCheck java.io.IOException: invalid header field(tomcat启动成功但是访问web项目404错误)
- Xcode出现error: Implicit declaration of function sysctl is invalid in C99
- ORA-12528: TNS:listener: 和error in reading(block 3,# blocks 8) of control file
- Error:Cause: invalid LOC header (bad signature)怎么解决
- invalid header field value "oci runtime error: container_linux.go:247
- Emacs Error: Invalid function: org-babel-header-args-safe-fn
- 读大数据白皮书,大数据与产业发展白皮书感悟
- 平时学习积累
- Unable to locate Spring NamespaceHandler for XML schema namespace [http://www.springframework.org/sc
- bind双网卡
- Linux进程间通信-基于内存(共享队列)
- ERROR: invalid page header in block 13760 of relation base/16995/67484
- No.06 Xcode(5.1.x) UINavigationController
- Android初级教程_保留listview item的选中样式
- Android下获取各种存储目录
- UUID/UDID/
- grep in Windows
- C++大学基础教程_11_10_实例研究:String类
- UVA 10561 - Treblecross(博弈SG函数)
- 启动tomcat报错 java.lang.Exception: Socket bind failed