Solved

PostgreSQL V15 - First FSBasedBackupSet instance backup problem

  • 6 November 2023
  • 4 replies
  • 461 views

Userlevel 1
Badge +3

Hello everyone, when I run the backup of the FSBasedBackupSet instance it returns the following error:

Description: PostgreSQL Database: [~Exception in [PGFsBackup :: SetDBInBackupMode] Type:[POSTGRE_EXCEPTION] Msg:[Could not put the Cluster in backup mode]~] Data Backup Failed.

Checking the commvault logs gives a timeout exactly 5 minutes after sending the command.
This command can take up to more than 15 minutes...
 
1461668 164da4 11/06 11:13:23 735019 SetDBInBackupMode() - Executing query => SELECT pg_backup_start('pgida_backup_5432_735019_1699280003', false)
1461668 164da4 11/06 11:13:23 735019 QueryPostgres() - Sent query [SELECT pg_backup_start('pgida_backup_5432_735019_1699280003', false)] to Server
1461668 164da4 11/06 11:18:24 735019 QueryPostgres() - Failed to get query output from connection service

 

I would like to know if there was a way to increase this timeout on the Commvault side.
Do you know if this is possible?

icon

Best answer by Damian Andre 7 November 2023, 00:39

View original

4 replies

Userlevel 7
Badge +23

Hey @Marcos Silva,

You have a keen eye in those logs ;)

I’ll preface by saying I’m no PostgreSQL expert but this one caught my eye.

 

I searched for previous cases, and I see two camps.

  1. There is a PostGreSQL setting which may help
    1. SET statement_timeout = 0
  2. There is a hotfix for FR32 which seems to be solving this issue - see highlighted line
     

That update is likely in maintenance releases of other supported releases - not sure which version you are running currently?

Userlevel 3
Badge +7

Hi @Marcos Silva ,

Like @Damian Andre said, this is taken care with a hotfix in hot fix pack 23. Please update to 11.32.23

 

Regards,

Meera

Userlevel 1
Badge +3

Thank you very much I will check and get back to you later!!

Userlevel 1
Badge +3

Applied the correction as reported by @Damian Andre  , it worked normally. Thanks.

Reply