Azure ARM依赖数据库子句

Question

我有以下资源在ARM

{
    "name": "[parameters('dbServerName')]",
    "type": "Microsoft.Sql/servers",
    "location": "[resourceGroup().location]",
    "tags": {
      "displayName": "SqlServer"
    },
    "apiVersion": "2014-04-01-preview",
    "properties": {
      "administratorLogin": "[parameters('dbuser')]",
      "administratorLoginPassword": "[parameters('dbpassword')]",
      "version": "12.0"
    },
    "resources": [
      {
        "name": "[parameters('dbName')]",
        "type": "databases",
        "location": "[resourceGroup().location]",
        "tags": {
          "displayName": "[parameters('dbName')]"
        },
        "apiVersion": "2014-04-01-preview",
        "dependsOn": [
          "[parameters('dbServerName')]"
        ],
        "properties": {
          "edition": "[parameters('edition')]",
          "collation": "[parameters('collation')]",
          "maxSizeBytes": "[parameters('maxSizeBytes')]",
          "requestedServiceObjectiveName": "[parameters('requestedServiceObjectiveName')]"
        }
      },
      {
        "name": "[parameters('hivedbName')]",
        "type": "databases",
        "location": "[resourceGroup().location]",
        "tags": {
          "displayName": "[parameters('hivedbName')]"
        },
        "apiVersion": "2014-04-01-preview",
        "dependsOn": [
          "[parameters('dbServerName')]"
        ],
        "properties": {
          "edition": "[parameters('edition')]",
          "collation": "[parameters('collation')]",
          "maxSizeBytes": "[parameters('maxSizeBytes')]",
          "requestedServiceObjectiveName": "[parameters('requestedServiceObjectiveName')]"
        }
      },
      {
        "name": "[parameters('ooziedbName')]",
        "type": "databases",
        "location": "[resourceGroup().location]",
        "tags": {
          "displayName": "[parameters('ooziedbName')]"
        },
        "apiVersion": "2014-04-01-preview",
        "dependsOn": [
          "[parameters('dbServerName')]"
        ],
        "properties": {
          "edition": "[parameters('edition')]",
          "collation": "[parameters('collation')]",
          "maxSizeBytes": "[parameters('maxSizeBytes')]",
          "requestedServiceObjectiveName": "[parameters('requestedServiceObjectiveName')]"
        }
      },
      {
        "type": "firewallrules",
        "apiVersion": "2014-04-01-preview",
        "dependsOn": [
          "[parameters('dbServerName')]"
        ],
        "location": "[resourceGroup().location]",
        "name": "AllowAllWindowsAzureIps",
        "properties": {
          "endIpAddress": "0.0.0.0",
          "startIpAddress": "0.0.0.0"
        }
      }
    ]
  },

想要在上面有另一个资源依赖，所以我试着在下一个资源

的依赖中添加以下内容

[concat('Microsoft.Sql/servers,'/',parameters('dbServerName'),'/databases/',parameters('hivedbName'))]

但是得到以下错误:

New-AzureRmResourceGroupDeployment : 4:46:59 PM - Error: Code=InvalidTemplate; Message=Deployment template validation failed: 'Circular dependency detected on resource: '/subscriptions/######/resourceGroups/QA/providers/Microsoft.Sql/servers/sparkqa/databases/SparkQAHive'.

Then I try

"dependsOn": [
      "[concat('Microsoft.Sql/servers/', parameters('dbServerName'))]",
      "[concat('Microsoft.Sql/servers,'/',parameters('dbServerName'),'/databases/',parameters('hivedbName'))]"
    ],

但是它仍然在concat('Microsoft.Sql/servers,'/',parameters('dbServerName'),'/databases/',parameters('hivedbName'))创建之前开始部署资源

这是完整的模板https://paste.fedoraproject.org/454465/14767382/raw/

谁知道这是怎么回事?

Answer 1

您应该依赖于实际的资源，而不仅仅是sql server名称:

            "dependsOn": [
                "[concat('Microsoft.Sql/servers/', parameters('serverName'))]"
            ],

Answer 2

使用以下格式可以很好地工作:

"dependsOn": ["[resourceId('Microsoft.Sql/servers/databases', variables('serverName'), variables('dbName'))]"],