Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: 江川潔 <egawa(at)apteq(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216
Date: 2020-11-25 03:47:42
Message-ID: X73T3uJYB026JP0+@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 25, 2020 at 11:01:37AM +0900, 江川潔 wrote:
> Hi,
>
> WAL log recovery was failed on wrong log record size. Could you please
> advise me what is wrong in the setting ? Any suggestions will be highly
> appreciated.

> 2020-11-25 10:12:23.569 JST [7792] FATAL: archive file
> "00000001000000000000006F" has wrong size: 67118648 instead of 16777216

Something is fishy with your WAL archive partition, so you had better
check its state, by for example using pg_waldump on each segment
archived. This error means that the file copied was basically 64MB in
size, while these are expected to be 16MB in this instance.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2020-11-25 10:35:34 Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216
Previous Message 江川潔 2020-11-25 02:01:37 archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216