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

[dch...@wingspan.com]

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]

[MP]

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):