Postgresql Error Could Not Read Block In File
Contents |
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces could not read block in file postgresql pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer
Invalid Page In Block Of Relation Base
lists Regional lists Associations User groups Project lists Inactive lists IRC postgres zero_damaged_pages Local User Groups Featured Users International Sites Propaganda Resources Weekly News Unfamous 'could not read block ...
Postgresql Invalid Page In Block
in file "...": read only 0 of 8192 bytes' again From: Maxim Boguk
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
Postgresql Repair
lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites Propaganda Resources Weekly News "could not read block" error message From: peter(at)vfemail(dot)net To: pgsql-novice(at)postgresql(dot)org Subject: "could not read block" error message Date: 2010-01-08 14:14:38 Message-ID: 20100108142337.E05FC632211@mail.postgresql.org (view raw or https://www.postgresql.org/message-id/CAK-MWwT_5N1jwSH8F84ZD2iPrPCuuBoA0Tu-Ujw8+SXMg1OELQ@mail.gmail.com whole thread) Thread: 2010-01-08 14:14:38 from peter(at)vfemail(dot)net 2010-01-08 14:33:06 from Tom Lane
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and http://stackoverflow.com/questions/6895736/error-could-not-read-block-4707-of-relation-1663-16384-16564-success policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a could not minute: Sign up ERROR: could not read block 4707 of relation 1663/16384/16564: Success up vote 6 down vote favorite 1 I am using psql 8.1.18 on Glassfishserver. I have a query like this: select ip,round((select sum(t1.size) from table t1)) from table where date > '2011.07.29' and date < '2011.07.30' and ip = '255.255.255.255' group by ip; When I run this query could not read I got this error: ERROR: could not read block 4707 of relation 1663/16384/16564: Success However this query works fine: select ip,round(sum(size)/175) from table where date > '2011.07.29' and l_date < '2011.07.30' and ip = '255.255.255.255' group by ip; I think it might be a database error and I need to restore the table from the backup, maybe. But first I need to learn where this corrupted data exist. Does anyone know how to find 1663/16384/16564 relation? Or 4707 block? EDIT: I tried this code: select relname , relfilenode from pg_class where relname in ('1663','16384','16564'); but it returns: relname | relfilenode ---------+------------- (0 rows) postgresql share|improve this question edited Aug 1 '11 at 8:55 asked Aug 1 '11 at 8:13 lamostreta 85122046 it must be something like: select relname , relfilenode from pg_class where relname in ('1663','16384','16564'); but still couldn't find the exact code –lamostreta Aug 1 '11 at 8:48 add a comment| 1 Answer 1 active oldest votes up vote 8 down vote accepted It looks like there are bad blocks in a talbe or a index . To find the