Azure Database for PostgreSQL: "InvalidInputs" error restoring an LTR backup from Azure Backup Vault

Question

I am trying to restore an long-term retention (LTR) Azure Database for PostgreSQL database backup using Azure Backup Vault as described in these articles:

• https://docs.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql (backup configuration steps)
• https://download.microsoft.com/download/9/1/9/91990314-33bd-4eaa-a084-d1f7e6175ee1/AzBkpPostgres_ManualPermissions.docx (indirectly linked by the above article)

The LTR backups are completing without issues, however, restoring them to the Azure Database for PostgreSQL resource leads to an "InvalidInputs" error:

With this in the Activity Log:

    "properties": {
        "statusMessage": "{"status":"Failed","error":{"code":"ResourceOperationFailure","message":"The resource operation completed with terminal provisioning state 'Failed'.","details":[{"code":"InvalidInputs","message":"","additionalInfo":[{"type":"UserFacingError","info":{"message":"","recommendedAction":[""],"code":"InvalidInputs","target":"","isRetryable":false,"isUserError":false,"properties":{"ActivityId":"a7a2867e-8889-41c4-a5cf-37fd1394d3d6-Ibz"}}}]}]}}",
        "eventCategory": "Administrative",
        "entity": "/subscriptions/XXXXXXXXXX/resourceGroups/poc-rg/providers/Microsoft.DataProtection/backupVaults/XXXXXXXXXXpoc-psql-bv-2/backupInstances/XXXXXXXXXXpoc-psql-2-backup_restore_test_2",
        "message": "Microsoft.DataProtection/backupVaults/backupInstances/ValidateRestore/action",
        "hierarchy": "30ff29b8-a165-42a0-a594-f726229a5954"
    },

Restoring to an Azure Storage Account leads to this error:

    "properties": {
        "statusMessage": "{"status":"Failed","error":{"code":"ResourceOperationFailure","message":"The resource operation completed with terminal provisioning state 'Failed'.","details":[{"code":"SMAWTeeInternalError","message":"Microsoft Azure Backup encountered an internal error.","additionalInfo":[{"type":"UserFacingError","info":{"message":"Microsoft Azure Backup encountered an internal error.","recommendedAction":["Wait for a few minutes and then try the operation again. If the issue persists, please contact Microsoft support."],"code":"SMAWTeeInternalError","target":"","isRetryable":false,"isUserError":false,"properties":{"ActivityId":"a7a2867e-8889-41c4-a5cf-37fd1394d3dd-Ibz"}}}]}]}}",
        "eventCategory": "Administrative",
        "entity": "/subscriptions/XXXXXXXXXX/resourceGroups/poc-rg/providers/Microsoft.DataProtection/backupVaults/XXXXXXXXXXpoc-psql-bv-2/backupInstances/XXXXXXXXXXpoc-psql-2-backup_restore_test_2",
        "message": "Microsoft.DataProtection/backupVaults/backupInstances/ValidateRestore/action",
        "hierarchy": "30ff29b8-a165-42a0-a594-f726229a5954"
    },

I have tried with both Azure Database for PostgreSQL versions 10 and 11. The azure_backup role is granted the following permissions:

ALTER USER azure_backup WITH CREATEDB;
GRANT azure_pg_admin TO azure_backup;

Any insight or help is appreciated.

Thanks!

question from:https://stackoverflow.com/questions/65926891/azure-database-for-postgresql-invalidinputs-error-restoring-an-ltr-backup-fro

Answer 1

Waitting for answers