"error": "failure copying files (data transfer failure on directory '/var/lib/pgsql/9.3/data')",

220 views
Skip to first unread message

dch...@wingspan.com

unread,
Jun 10, 2016, 10:28:21 AM6/10/16
to Barman, Backup and Recovery Manager for PostgreSQL
Hi Guys,

I am having an issue where files are being missed ( probably ) due to the 2 hour backup times. This is causing the backups to fail.

I have attached the log & diagnose files in the hopes that you can make some recommendations.

file has vanished: "/var/lib/pgsql/9.3/data/base/21206239/28954381_init"
file has vanished: "/var/lib/pgsql/9.3/data/base/21206239/28954382"
file has vanished: "/var/lib/pgsql/9.3/data/base/21206239/28954382_init"
file has vanished: "/var/lib/pgsql/9.3/data/base/21206239/28954383"
file has vanished: "/var/lib/pgsql/9.3/data/base/21206239/28954383_init"
rsync error: some files/attrs were not transferred (see previous errors) (code 23) at main.c(1505) [generator=3.0.6]


diagnose.txt
barman.conf
qa.conf

MP

unread,
Jun 13, 2016, 11:54:32 AM6/13/16
to Barman, Backup and Recovery Manager for PostgreSQL
Can confirm with 1.6.1. But there are more analysed points:
1] its failing only on 1 server from 10 for me (using 9.3-9.5)
2] sometimes even 2+ hours long backup dont fails (50:50 chance)
3] server with bigger datasize dont fail even with 4 hours backup

Both servers has 130+GB database cluster with 9.3.9+.

Dne pátek 10. června 2016 16:28:21 UTC+2 dch...@wingspan.com napsal(a):
barman_diag.txt
Reply all
Reply to author
Forward
0 new messages