FS based Backup ends with a warning: Could not back up [0] folders and [1] files. the dumpbased backup goes fine.
In de PostGresBackupChild.log I see :
2309890 233f02 09/20 14:15:56 2109431 ClBackupFile::OpenFilesForBackup(7033) - failed to stat path '/data/postgres/13/wal/inst1/archive_status/000000060000000000000045.ready', errno=2, error=No such file or directory
There are no *.ready files in that dir or elsewhere. Every time I try the backup again I will see a similar message, but with an other filename. The number goes up.
Any idea on how to troubleshoot this?
Best answer by Sunil
Hi @ITBODBA
The files under archive_status are temporary files. If they are causing failures in your log backups frequently, you can add this folder to ignore list by below procedure.
You can ignore failed files inside archive status during a backup operation by creating the sPGDirIgnoreList additional setting as shown in the following table. The backup operation will be marked as successful.
The files under archive_status are temporary files. If they are causing failures in your log backups frequently, you can add this folder to ignore list by below procedure.
You can ignore failed files inside archive status during a backup operation by creating the sPGDirIgnoreList additional setting as shown in the following table. The backup operation will be marked as successful.
I have actually same problem but it hasnt archive folder.I have added to same addtional setings but ı got same error again.
443930 6c61a 11/03 14:51:35 84891 ClBackupFile::OpenFilesForBackup(7234) - failed to stat path '/pg_data/14/main/base/16393/21154423', errno=2, error=No such file or directory 443930 6c61a 11/03 14:51:35 84891 ClBackupFile::OpenFilesForBackup(7802) - 1 files in a row failed to be backed up. 443930 6c61a 11/03 14:53:09 84891 ClBackupFile::OpenFilesForBackup(7234) - failed to stat path '/pg_data/14/main/base/16393/21152873.2', errno=2, error=No such file or directory 443930 6c61a 11/03 14:53:09 84891 ClBackupFile::OpenFilesForBackup(7802) - 1 files in a row failed to be backed up. 443930 6c61a 11/03 14:53:23 84891 ClBackupFile::OpenFilesForBackup(7234) - failed to stat path '/pg_data/14/main/base/16393/21156310', errno=2, error=No such file or directory 443930 6c61a 11/03 14:53:23 84891 ClBackupFile::OpenFilesForBackup(7802) - 1 files in a row failed to be backed up.
