Solved

PostgreSQL temporary files

  • 2 May 2024
  • 1 reply
  • 25 views

Badge +3

Hello Commvault Community,

 

On one of the PostgreSQL agents, a full backup job ends with a status of ‘Completed with errors’.

PostGresBackupChild.log

30386 76b9 04/14 21:02:05 454909 ConnectGroupInternal: setsockopt failed. Error [0xECCC005F:{CQiSocket::SetSockOpt(567)/ErrNo.95.(Operation not supported)}]
30386 76b2 04/14 21:02:06 454909 ClBackupFile::OpenFilesForBackup(7033) - failed to stat path '/pgdbs/ksef/pgdata/tablespaces/ksef_data/PG_14_202107181/16389/pg_internal.init', errno=2, error=No such file or directory
30386 76b2 04/14 21:02:06 454909 ClBackupFile::UseIndexForFailedFiles(13358) - Will not store failed file information in index as this is not a file system backup. 
30386 76b2 04/14 21:02:06 454909 ClBackupFile::OpenFilesForBackup(7601) - 1 files in a row failed to be backed up.
30386 76b2 04/14 21:02:06 454909 ClBackupFile::OpenFilesForBackup(7033) - failed to stat path '/pgdbs/ksef/pgdata/tablespaces/ksef_data/PG_14_202107181/16389/t21_900557245', errno=2, error=No such file or directory
30386 76b2 04/14 21:02:06 454909 ClBackupFile::OpenFilesForBackup(7033) - failed to stat path '/pgdbs/ksef/pgdata/tablespaces/ksef_data/PG_14_202107181/16389/t21_900557248', errno=2, error=No such file or directory
30386 76b2 04/14 21:02:06 454909 ClBackupFile::OpenFilesForBackup(7033) - failed to stat path '/pgdbs/ksef/pgdata/tablespaces/ksef_data/PG_14_202107181/16389/t21_900557249', errno=2, error=No such file or directory
30386 76b2 04/14 21:02:06 454909 ClBackupFile::OpenFilesForBackup(7601) - 3 files in a row failed to be backed up.


I have searched the documentation, but it is not specified what exactly Commvault considers to be temporary files.

"„You can ignore more files during a backup operation by creating the sPGDirIgnoreList additional setting and setting its value as the name of files or folders in a comma separated list that you want to ignore.” - is not specified here too.

https://documentation.commvault.com/additionalsetting/details?name=%22sPGDirIgnoreList%22&ids21

 

I have two questions. What exactly does Commvault consider to be temporary files? Whether there is a list of these files?

"Each table and index is stored in a separate file. For ordinary relations, these files are named after the table or index’s filenode number, which can be found in pg_class.relfilenode. But for temporary relations, the file name is of the form tBBB_FFF, where BBB is the backend ID of the backend which created the file, and FFF is the filenode number."

https://www.postgresql.org/docs/current/storage-file-layout.html


Regards,
Michał
 

icon

Best answer by ganeshkishan 2 May 2024, 14:30

View original

1 reply

Badge

Hi Michal,


The backup is completing with error in your case as few files are failed to backup.

By default, we ignore files missing from the below folders during a backup operation and mark the job as successful if all the failed files are from below directories:

  • pg_subtrans

  • pgsql_tmp

  • pg_clog

  • pg_xact


If the failed files in your case can be safely ignored, you can set the sPGDirIgnoreList additional setting by referring to below link.

https://documentation.commvault.com/2023e/expert/backup_troubleshooting_01.html#psql0015-fs-based-backup-operation-might-complete-with-errors-if-a-file-is-missing-during-a-backup-operation

Thanks,
Ganesh Kishan

Reply