Solved

Postgres database FS bases backup Warning "Could not back up [0] folders and [1] files"

  • 20 September 2023
  • 4 replies
  • 233 views

Badge +1

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?

icon

Best answer by Sunil 20 September 2023, 16:35

View original

4 replies

Badge

Hi,

 

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.

Userlevel 5
Badge +13

Excellent! Thanks for letting me know.

Badge +1

Thank you Sunil, I have put in the advanced setting to ignore the archive_status dir and now the backup is completed without warnings.

Userlevel 5
Badge +13

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.

 

https://documentation.commvault.com/2023e/expert/21723_backup_troubleshooting.html#resolution-2-01

Resolution 2

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.

For instructions on how to add additional settings from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.

Property

Value

Name

sPGDirIgnoreList

Category

PostGres

Type

String

Value

archive_status

Reply