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

From: 江川潔 <egawa(at)apteq(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Subject: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216
Date: 2020-11-25 02:01:37
Message-ID: CAH0xBbFZJ_NvWxNSfAMOnVYbVDwfMH-LOsAysABoFvPRN8EWPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks,
Kiyoshi

postgres.conf:
wal_level = replica
archive_mode = on
archive_command = 'copy "%p" "D:\\BKUP\\pg_archivedir\\PostgreSQL_DEV\\%f"'

recover.conf:
restore_command = 'copy "D:\\BKUP\\pg_archivedir\\PostgreSQL_DEV" "%p"'

C:\Users\tkgsys>pg_ctl -D D:\PostgreSQL_RCV start
サーバの起動完了を待っています....2020-11-25 10:12:22.330 JST [7572] LOG: listening on
IPv6 address "::", port 5434
2020-11-25 10:12:22.331 JST [7572] LOG: listening on IPv4 address
"0.0.0.0", port 5434
2020-11-25 10:12:22.393 JST [7792] LOG: database system was interrupted;
last known up at 2020-11-24 11:01:00 JST
2020-11-25 10:12:22.858 JST [7792] LOG: starting archive recovery
D:\BKUP\pg_archivedir\PostgreSQL_DEV\000000010000000000000056.00000028.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000005A.00000028.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000005D.00000028.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\000000010000000000000060.00000060.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\000000010000000000000064.00000060.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\000000010000000000000068.00000028.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006B
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006B.00000060.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006C
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006D
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006E
.D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006F
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006F.00000060.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\000000010000000000000070
1 個のファイルをコピーしました。
2020-11-25 10:12:23.569 JST [7792] FATAL: archive file
"00000001000000000000006F" has wrong size: 67118648 instead of 16777216
2020-11-25 10:12:23.571 JST [7572] LOG: startup process (PID 7792) exited
with exit code 1
2020-11-25 10:12:23.572 JST [7572] LOG: aborting startup due to startup
process failure
2020-11-25 10:12:23.576 JST [7572] LOG: database system is shut down
待機処理が停止されました
pg_ctl: サーバを起動できませんでした。
ログ出力を確認してください。

C:\Users\tkgsys>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2020-11-25 03:47:42 Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216
Previous Message Dave Greeko 2020-11-25 01:33:31 Re: libpq Prepared Statement with dynamic IN operator