Content-Type: multipart/alternative;
 boundary="------------yuiM1g0MIdWPRlyxiI2G7gLI"
Message-ID: <938c7425-076f-f752-de61-c5f8f183d24b@quadratum-braccas.com>
Date: Fri, 22 Apr 2022 14:23:00 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.8.0
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Language: en-US
From: Sbob <sbob@quadratum-braccas.com>
Subject: could not read block 0 in file Error
Archived-At: 
 <https://www.postgresql.org/message-id/938c7425-076f-f752-de61-c5f8f183d24b%40quadratum-braccas.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------yuiM1g0MIdWPRlyxiI2G7gLI
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi all;


We had an issue with a PostgreSQL v12 cluster. Not sure all of the 
history as I was pulled in late, however we were seeing that the db 
would not start due to WAL inconsistencies, was throwing an error about 
could not find wal records.

So we ran a pg_resetwal -f -D [data dir]


we are dumping (via pg_dump) all the databases in the broken cluster and 
I will restore them to a new cluster,

however in one of the databases, for one of the tables we are getting this:


pg_dump: error: Dumping the contents of table "bigtable" failed: 
PQgetResult() fai
led.
pg_dump: error: Error message from server: ERROR:  could not read block 
0 in file "base/6328739/6340053": read only 0 of 8192 bytes
pg_dump: error: The command was: COPY public.bigtable (recordid, 
containerid, record_type, description, overlaygroup) TO stdout;


Is there any way to recover?


Thanks in advance


--------------yuiM1g0MIdWPRlyxiI2G7gLI
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Hi all;</p>
    <p><br>
    </p>
    <p>We had an issue with a PostgreSQL v12 cluster. Not sure all of
      the history as I was pulled in late, however we were seeing that
      the db would not start due to WAL inconsistencies, was throwing an
      error about could not find wal records.</p>
    <p>So we ran a pg_resetwal -f -D [data dir]</p>
    <p><br>
    </p>
    <p>we are dumping (via pg_dump) all the databases in the broken
      cluster and I will restore them to a new cluster,</p>
    <p>however in one of the databases, for one of the tables we are
      getting this:</p>
    <p><br>
    </p>
    <p><span style="font-family:monospace"><span
          style="color:#000000;background-color:#ffffff;">pg_dump:
          error: Dumping the contents of table "bigtable" failed:
          PQgetResult() fai
        </span><br>
        led.
        <br>
        pg_dump: error: Error message from server: ERROR:  could not
        read block 0 in file "base/6328739/6340053": read only 0 of 8192
        bytes
        <br>
        pg_dump: error: The command was: COPY public.bigtable (recordid,
        containerid, record_type, description, overlaygroup) TO stdout;<br>
        <br>
        <br>
      </span></p>
    <p><br>
    </p>
    <p>Is there any way to recover?</p>
    <p><br>
    </p>
    <p>Thanks in advance</p>
    <p><br>
    </p>
  </body>
</html>

--------------yuiM1g0MIdWPRlyxiI2G7gLI--