commvault.com commvault.com
Solved

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

  • 20 September 2023
  • 4 replies
  • 269 views
I
Rank
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

Sunil
Rank
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
I
Rank
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.

Sunil
Rank
Userlevel 5
Badge +13

Excellent! Thanks for letting me know.

Y
Rank
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.

Reply


Terms & ConditionsCookie settings