Обсуждение: BUG #16408: We are facing issue while taking the backup using pgbackrest 2.22 version

Поиск
Список
Период
Сортировка

BUG #16408: We are facing issue while taking the backup using pgbackrest 2.22 version

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      16408
Logged by:          Brajendra Pratap Singh
Email address:      singh.bpratap766@gmail.com
PostgreSQL version: 10.11
Operating system:   CentOS 6.9
Description:

We are facing the below error in pgbackrest backup log while the backup
failed :

ERROR: [074]: raised from local-11 protocol: unable to move

'/apayrman/pgbackrest/backup/odbserver/20200430-055502F/pg_tblspc/58339/PG_10_201707211/58347/82334143.gz.pgbackrest.tmp'
to
'/apayrman/pgbackrest/backup/odbserver/20200430-055502F/pg_tblspc/58339/PG_10_201707211/58347/82334143.gz':
[2] No such file or directory .

INFO: backup command end: aborted with exception [074] .

During the same time we saw the below mentioned error in postgresql log.

WARNING: aborting backup due to backend exiting before pg_stop_backup was
called .

Postgresql version : 10.11
Pgbackrest version : 2.22

Please let me know if any further detail required it will be my pleasure.

Thanks 
Bpsingh


Re: BUG #16408: We are facing issue while taking the backup usingpgbackrest 2.22 version

От
David Steele
Дата:
On 5/1/20 4:27 PM, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      16408
> Logged by:          Brajendra Pratap Singh
> Email address:      singh.bpratap766@gmail.com
> PostgreSQL version: 10.11
> Operating system:   CentOS 6.9
> Description:
> 
> We are facing the below error in pgbackrest backup log while the backup
> failed :
> 
> ERROR: [074]: raised from local-11 protocol: unable to move
>
'/apayrman/pgbackrest/backup/odbserver/20200430-055502F/pg_tblspc/58339/PG_10_201707211/58347/82334143.gz.pgbackrest.tmp'
> to
> '/apayrman/pgbackrest/backup/odbserver/20200430-055502F/pg_tblspc/58339/PG_10_201707211/58347/82334143.gz':
> [2] No such file or directory .
> 
> INFO: backup command end: aborted with exception [074] .
> 
> During the same time we saw the below mentioned error in postgresql log.
> 
> WARNING: aborting backup due to backend exiting before pg_stop_backup was
> called .
> 
> Postgresql version : 10.11
> Pgbackrest version : 2.22
> 
> Please let me know if any further detail required it will be my pleasure.

You have now reported this issue three times without paying any 
attention to my responses the first two times you reported it.

This is most assuredly not a PostgreSQL issue. The error you see in the 
logs is because pgBackRest closes the connection that is running the 
backup once is encounters the problem. PostgreSQL is merely reporting 
that the backup never completed, which is true.

Please follow the advice at 
https://github.com/pgbackrest/pgbackrest/issues/1019 and respond there 
if you are still seeing the issue.

Regards,
-- 
-David
david@pgmasters.net