Skip to main content
commvault.com commvault.com
Solved

PostgreSQL V15 - First FSBasedBackupSet instance backup problem

M
Byte
Forum|alt.badge.img+4

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?

Best answer by Damian Andre

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?

View original
Did this answer your question?

4 replies

Damian Andre
Vaulter
Forum|alt.badge.img+23
  • Damian AndreVaulter
  • Vaulter
  • 1306 replies
  • Answer
  • November 6, 2023

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?

M
1 person likes this
  • M
    Marcos Silva
Meera
Vaulter
Forum|alt.badge.img+7
  • MeeraVaulter
  • Vaulter
  • 70 replies
  • November 7, 2023

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

Meera
M
Byte
Forum|alt.badge.img+4

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

M
1 person likes this
  • M
    Marcos Silva
M
Byte
Forum|alt.badge.img+4

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

Damian Andre
1 person likes this
  • Damian Andre
    Damian Andre

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings