首页 > 解决方案 > 尝试创建 Azure SQL 逻辑服务器时出现 UpsertLogicalServerRequestAlreadyInProgress

问题描述

我有 Azure DevOpe 管道,它工作得很好,但昨天我突然出现了 showstopper 错误。管道没有给出错误,但没有创建 SQL 逻辑服务器。我删除了资源组中的所有资源。然后我再次执行管道。我收到“正在进行的逻辑服务器请求已在进行中,请稍后再试您的请求”错误。我已经 24 小时无法创建逻辑服务器。

我以为我可以从 Azure 门户取消部署,但我没有看到任何有错误的部署。我能做什么?

Azure DevOps 上的错误:

C:\windows\System32\WindowsPowerShell\v1.0\powershell.exe" -NoLogo -NoProfile -NonInteractive - 
ExecutionPolicy Unrestricted -Command ". 'D:\a\_temp\43a1dcab-bbff-4fd8-8cc7-5773945858fa.ps1'"
Import-Module -Name C:\Modules\az_4.3.0\Az.Accounts\1.9.1\Az.Accounts.psd1 -Global
Clear-AzContext -Scope Process
Clear-AzContext -Scope CurrentUser -Force -ErrorAction SilentlyContinue
Connect-AzAccount -ServicePrincipal -Tenant *** -Credential System.Management.Automation.PSCredential 
-Environment AzureCloud @processScope
Set-AzContext -SubscriptionId 0000000000000000000 -TenantId ***
strtempdigiopsdev
##[error]9:15:12 AM - The deployment 'TemplateMasterDeployment' failed with error(s). Showing 2 out 
of 2 error(s).
Status Message: The resource operation completed with terminal provisioning state 'Failed'. (Code: 
ResourceDeploymentFailure)
 - An ongoing logical server request is already in progress, please try your request again later. 
(Server Name: sql-srv-dev, RequestId: 2dea2656-e3dd-40b8-a7e0-c72cfe4e5bba, SubscriptionId: 
0000000000000000000 , ResourceGroup: rg-az-dev) 
(Code:UpsertLogicalServerRequestAlreadyInProgress)


Status Message: The resource operation completed with terminal provisioning state 'Failed'. (Code: 
ResourceDeploymentFailure)
 - At least one resource deployment operation failed. Please list deployment operations for details. 
Please see https://aka.ms/DeployOperations for usage details. (Code: DeploymentFailed)
   - {
  "status": "Failed",
  "error": {
  "code": "ResourceDeploymentFailure",
 "message": "The resource operation completed with terminal provisioning state 'Failed'.",
 "details": [
  {
    "code": "UpsertLogicalServerRequestAlreadyInProgress",
    "message": "An ongoing logical server request is already in progress, please try your request again later. (Server Name: sql-srv-dev, RequestId: 2dea2656-e3dd-40b8-a7e0-c72cfe4e5bba, SubscriptionId: 0000000000000000000 , ResourceGroup: rg-az-dev)"
  }
]

} } (代码:冲突)

标签: azureazure-devopsazure-resource-managerazure-sql-server

解决方案


推荐阅读