PostgreSQL - Flexible server backup jobs failing

Question

PostgreSQL - Flexible server backup jobs failing

T B 40 Microsoft External Staff

How can I troubleshoot jobs on stuck on failed state here: https://learn.microsoft.com/en-us/azure/backup/manage-backup-vault#manage-backup-jobs?

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-02-20T20:10:36.48+00:00

Hi @T B

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-02-21T19:47:42.2866667+00:00

Hi @T B

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-02-20T20:10:36.48+00:00

Hi @T B

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-02-21T19:47:42.2866667+00:00

Hi @T B

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Hi @Anonymous

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that Flexible server backup scheduled jobs failing__.__

Possible causes for the backup Fail:

1. Inner error code: ServerNotReadyForLongTermBackup

Cause: Resource isn't in a valid state to perform the backup operation.

Recommended action: Validate if the PostgreSQL - Flexible server has the following properties in its resource JSON script: "state": "Ready". If not present, wait for the state to change or fix the PostgreSQL - Flexible server properties to make it ready for backup.

2. Inner error code: ResourceGroupNotFound

Cause: Resource group isn't found.

Recommended action: Stop protection for the backup instance to avoid failures.

3. Inner error code: AuthorizationFailed

Cause: Required permissions aren't present to perform the backup operation.

Recommended action: Assign the appropriate permissions and retrigger the backup operation.

4. Inner error code: UserErrorMaxConcurrentOperationLimitReached

Cause: Limit to the number of backups that can be performed on a backup instance has reached to maximum.

Recommended action: The recommended backup frequency for backing up a server is Weekly. If you need frequent backups for achieving your RPO requirement, try to trigger a backup operation after the current backup job is complete.

5. Inner error code: UserErrorMSIMissingPermissions

Cause: The required set of permissions aren't present to perform the restore operation.

Recommended action: Assign the appropriate permissions and retrigger the backup operation.

Please see below documentation links, it might be helpful.

Troubleshoot Azure Database for PostgreSQL - Flexible server backup - Azure Backup | Microsoft Learn

Back up Azure Database for PostgreSQL Flexible server with long-term retention - Azure Backup | Microsoft Learn

I hope this is helpful! Please let me know if you have any other questions or clarifications.

Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-03-04T00:54:23.2+00:00

Hi @T B

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

PostgreSQL - Flexible server backup jobs failing

1 answer

Your answer