database-restore - Azure Database for PostgreSQL:从 Azure Backup Vault 还原 LTR 备份时出现“InvalidInputs”错误
问题描述
我正在尝试使用 Azure Backup Vault 还原长期保留 (LTR) Azure Database for PostgreSQL 数据库备份,如这些文章中所述:
- https://docs.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql(备份配置步骤)
- https://download.microsoft.com/download/9/1/9/91990314-33bd-4eaa-a084-d1f7e6175ee1/AzBkpPostgres_ManualPermissions.docx(由上述文章间接链接)
LTR 备份完成没有问题,但是,将它们还原到 Azure Database for PostgreSQL 资源会导致“InvalidInputs”错误:
在活动日志中:
"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"
},
恢复到 Azure 存储帐户会导致此错误:
"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"
},
我已尝试使用 Azure Database for PostgreSQL 版本 10 和 11。该azure_backup
角色被授予以下权限:
ALTER USER azure_backup WITH CREATEDB;
GRANT azure_pg_admin TO azure_backup;
任何见解或帮助表示赞赏。
谢谢!
解决方案
推荐阅读
- uwp - 使用 JSON.NET 在 Win 10 Mobile 上序列化 Contacts.Contact 时出现奇怪的行为
- python - 3 点牛顿科茨公开规则
- electron - electron:如何在提交到苹果商店之前测试一个 MAS 包?
- c++ - 派生类调用使用非继承成员的继承函数
- ios - 在其他动态框架中使用动态框架的正确方法是什么?
- assembly - 将位置 2,4,6,8,n-2 的数字更改为负数
- r - 手动创建树状图:如何修复 plot.hclust 中的“'合并'矩阵包含无效内容”?
- c++ - 有没有办法转换矢量
在恒定时间内int? - typescript - @UseGuards 和 NestJS 中的中间件有什么区别
- recursion - f# 生成下一个值函数