Postgresql Error Could Not Read Block 0 In File
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta
Could Not Read Block In File Postgresql
Discuss the workings and policies of this site About Us Learn more postgresql error could not read block in file about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators postgres could not read block Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and
Invalid Page In Block Of Relation Base
learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Error: Could not read Block X of relation base/Y/Z up vote 1 down vote favorite We have some serious issues
Postgresql Invalid Page In Block
with our PostgreSQL-Server (Version 8.4). Our webapplication uses jdbc to connect to the PostgreSQL Server. Suddenly our webapplication cant connect to the PostgreSQL Server. We get the PSQLException: Broken Pipe. Cause of this, i tried to connect via pg_admin. This works, but i'm getting errors like this: ERROR: could not read block 32570 of relation base/16390/2663: read only 0 of 8192 bytes I tried to make a dump to backup the data and this doesnt work too: (Look on the edit at the bottom of the side) pg_dump: SQL command failed pg_dump: Error message from server: ERROR: could not read block 32570 of relation base/16390/2663: read only 0 of 8192 bytes pg_dump: The command was: LOCK TABLE public.results_233_top100_disease_state_karyotype IN ACCESS SHARE MODE I tried to get some information with SELECT oid, relname FROM pg_class WHERE oid=2663 The result was this: 2663 ; "pg_class_relname_nsp_index" During my effort of collecting some information, i read, that recreating that specific index could help. So reindexed it with the following command: REINDEX INDEX pg_class_relname_nsp_index This didnt helped at all
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs postgres zero_damaged_pages pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists
Postgresql Reindex Table
Regional lists Associations User groups Project lists Inactive lists IRC Local postgresql repair User Groups Featured Users International Sites Propaganda Resources Weekly News Re: BUG #10329: Could not read block 0 http://dba.stackexchange.com/questions/44508/error-could-not-read-block-x-of-relation-base-y-z in file "base/56100265/57047884": read only 0 of 8192 bytes From: David G Johnston
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists Inactive lists IRC Local User https://www.postgresql.org/message-id/1208551308255001@web137.yandex.ru Groups Featured Users International Sites Propaganda Resources Weekly News could not read block XXXXX in file "base/YYYYY/ZZZZZZ": read only 160 of 8192 bytes From: Антон Степаненко
List Threaded ♦ ♦ Locked 30 messages 12 Olivier Macchioni Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes The following bug has been logged on the website: Bug reference: 10329 Logged by: Olivier Macchioni Email address: [hidden email] PostgreSQL version: 9.1.13 Operating system: Debian 7.4 and 6.0.9 Description: Hello all, - Streaming Replication setup, 2 DB servers - 9.1.13 on both sides (from apt.postgresql.org) - Debian 6.0.9 on master server, 7.4 on standby server When doing the following query on the standby server: select * from ir_translation where src = 'a'; We have the following error in the logfiles: ERROR: could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes When checking the file usage, the following is reported: postgres@db-stdby:~/9.1/main/base/56100265$ /usr/lib/postgresql/9.1/bin/oid2name -d xx -f 57047884 >From database "xx": Filenode Table Name --------------------------------------- 57047884 ir_translation_src_hash_idx ls -la shows that the file has a size of 0. What's interesting as well is that this file has a last modification date of April, 29th - when the DB has been created on the Master server much more recently, by doing a "drop xx; rename xx_new xx;" root@db-stdby:/var/lib/postgresql/9.1/main/base/56100265# stat 57047884 File: `57047884' Size: 0 Blocks: 0 IO Block: 4096 regular empty file Device: 801h/2049d Inode: 1051439 Links: 1 Access: (0600/-rw-------) Uid: ( 106/postgres) Gid: ( 111/postgres) Access: 2014-05-15 11:15:50.218038536 +0200 Modify: 2014-04-29 16:20:36.645605377 +0200 Change: 2014-04-29 16:20:36.645605377 +0200 Birth: - root@db:/var/lib