Re: pg_basebackup -x/X doesn't play well with archive_mode & wal_keep_segments

On Thu, Feb 12, 2015 at 11:13 AM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
>>I started getting these errors after upgrading from 9.2.8 to 9.2.10.
>>Is it something critical that requires version downgrade or I can just
>>ignore that errors?
>
> What errors are you getting in precisely which circumstances? You're using pg-receivexlog?

Errors like this one

pg_receivexlog: could not create archive status file
"/mnt/archive/wal/archive_status/00000004000002AF000000B7.done": No
such file or directory
pg_receivexlog: disconnected..

on

Linux xyz 3.2.0-76-generic #111-Ubuntu SMP
PostgreSQL 9.2.10

Yes, I use pg_receivexlog. I also use a wrapper/watchdog script around
pg_receivexlog which tracks failures and restarts the latter.

The WAL files time correlates with the pg_receivexlog failures.

postgres(at)xyz:~$ ls -ltr /mnt/archive/wal/ | tail
-rw------- 1 postgres postgres 16777216 Feb 12 10:58 00000004000002B600000011
-rw------- 1 postgres postgres 16777216 Feb 12 11:02 00000004000002B600000012
-rw------- 1 postgres postgres 16777216 Feb 12 11:06 00000004000002B600000013
-rw------- 1 postgres postgres 16777216 Feb 12 11:11 00000004000002B600000014
-rw------- 1 postgres postgres 16777216 Feb 12 11:15 00000004000002B600000015
-rw------- 1 postgres postgres 16777216 Feb 12 11:19 00000004000002B600000016
-rw------- 1 postgres postgres 16777216 Feb 12 11:23 00000004000002B600000017
-rw------- 1 postgres postgres 16777216 Feb 12 11:27 00000004000002B600000018
-rw------- 1 postgres postgres 16777216 Feb 12 11:30 00000004000002B600000019
-rw------- 1 postgres postgres 16777216 Feb 12 11:32
00000004000002B60000001A.partial

postgres(at)xyz:~$ cat /var/log/pgcookbook/manage_pitr-wal.log | tail
Thu Feb 12 11:15:18 PST 2015 ERROR manage_pitr.sh: Problem occured
during WAL archiving: pg_receivexlog: could not create archive status
file "/mnt/archive/wal/archive_status/00000004000002B600000015.done":
No such file or directory
pg_receivexlog: disconnected..
Thu Feb 12 11:19:33 PST 2015 ERROR manage_pitr.sh: Problem occured
during WAL archiving: pg_receivexlog: could not create archive status
file "/mnt/archive/wal/archive_status/00000004000002B600000016.done":
No such file or directory
pg_receivexlog: disconnected..
Thu Feb 12 11:23:38 PST 2015 ERROR manage_pitr.sh: Problem occured
during WAL archiving: pg_receivexlog: could not create archive status
file "/mnt/archive/wal/archive_status/00000004000002B600000017.done":
No such file or directory
pg_receivexlog: disconnected..
Thu Feb 12 11:27:32 PST 2015 ERROR manage_pitr.sh: Problem occured
during WAL archiving: pg_receivexlog: could not create archive status
file "/mnt/archive/wal/archive_status/00000004000002B600000018.done":
No such file or directory
pg_receivexlog: disconnected..
Thu Feb 12 11:30:34 PST 2015 ERROR manage_pitr.sh: Problem occured
during WAL archiving: pg_receivexlog: could not create archive status
file "/mnt/archive/wal/archive_status/00000004000002B600000019.done":
No such file or directory
pg_receivexlog: disconnected..

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979
gray(dot)ru(at)gmail(dot)com