Re: Could not read block 0 in file

From: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: friend(dot)have_00(at)icloud(dot)com, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Could not read block 0 in file
Date: 2022-04-08 10:01:10
Message-ID: CAM+6J94QEseoZzQ8w7uhidZZ3acf4A2MiHBTWgXd_tuq_h4Z4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 8 Apr 2022 at 15:24, Magnus Hagander <magnus(at)hagander(dot)net> wrote:

>
>
> On Fri, Apr 8, 2022 at 11:06 AM <friend(dot)have_00(at)icloud(dot)com> wrote:
>
>> Hi,
>>
>> While we are looking for a suitable backup to recover from, I hope this
>> community may have some other advice on forward steps in case we cannot
>> restore.
>>
>> RCA: Unexpected shutdown due to critical power failure
>>
>> Current Issue: The file base/16509/17869 is zero bytes in size.
>>
>> The error message when running this query is:
ERROR: could not read block 0 in file "base/16509/17869": read only 0 of
8192 bytes

i guess it is maybe page header/ metadata not the whole file is zero bytes.
the data can be recovered then from the blogs?
i may be corrected :)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-04-08 10:01:24 Re: Could not read block 0 in file
Previous Message Magnus Hagander 2022-04-08 09:54:16 Re: Could not read block 0 in file