search

Azure / azure-cli

Azure Command-Line Interface
MIT License
4.03k stars 3.01k forks source link

az sql db import fails with 'too many 500 error responses' #16259

Open jonsamwell opened 3 years ago

jonsamwell commented 3 years ago

Describe the bug Using the az sql db import with a bacpac (with a size of 2.5mb) located in azure storage fails eventually after roughtly 30 minutes even if I import into a DB on a very powerful tier i.e. P6 or above. I've tried increasing the size of the blank database (P6) it is imported into but nothing works.

To Reproduce

Command arguments: ['sql', 'db', 'import', '-s', '***-sqlserver', '-n', '****-db', '-g', '*****-rg', '-u', '****@*****-sqlserver', '-p', '********', '--storage-key', 'se=2020-12-14T07%3A27%3A35Z&sp=racwd&spr=https&sv=2018-11-09&sr=b&sig=******', '--storage-key-type', 'SharedAccessKey', '--storage-uri', 'https://******.blob.core.windows.net/db-backups/blank.bacpac', '--debug']

Expected behavior The import operation runs to completion

Environment summary Running on AzureDevops hosted agent windows-latest

azure-cli                         2.15.1 *
core                              2.15.1 *
telemetry                          1.0.6
Extensions:
azure-devops                      0.18.0
Python (Windows) 3.6.8 (tags/v3.6.8:3c6b436a57, Dec 23 2018, 23:31:17) [MSC v.1916 32 bit (Intel)]

Additional context Debug logs

Event: CommandParser.OnGlobalArgumentsCreate [<function CLILogging.on_global_arguments at 0x039B5348>, <function OutputProducer.on_global_arguments at 0x03A4C7C8>, <function CLIQuery.on_global_arguments at 0x03A6B7C8>]
2020-12-14T06:29:08.1092925Z Event: CommandInvoker.OnPreCommandTableCreate []
2020-12-14T06:29:08.1093399Z Modules found from index for 'sql': ['azure.cli.command_modules.sql', 'azure.cli.command_modules.sqlvm']
2020-12-14T06:29:08.1093808Z Loading command modules:
2020-12-14T06:29:08.1094119Z Name                  Load Time    Groups  Commands
2020-12-14T06:29:08.1186216Z sql                       0.009        39       162
2020-12-14T06:29:08.1213901Z sqlvm                     0.003         4        17
2020-12-14T06:29:08.1214227Z Total (2)                 0.012        43       179
2020-12-14T06:29:08.1223965Z These extensions are not installed and will be skipped: ['azext_ai_examples']
2020-12-14T06:29:08.1224519Z Loading extensions:
2020-12-14T06:29:08.1224814Z Name                  Load Time    Groups  Commands  Directory
2020-12-14T06:29:08.1227278Z Total (0)                 0.000         0         0  
2020-12-14T06:29:08.1227589Z Loaded 42 groups, 179 commands.
2020-12-14T06:29:08.1227846Z Found a match in the command table.
2020-12-14T06:29:08.1228194Z Raw command  : sql db import
2020-12-14T06:29:08.1228649Z Command table: sql db import
2020-12-14T06:29:08.1229212Z Event: CommandInvoker.OnPreCommandTableTruncate [<function AzCliLogging.init_command_file_logging at 0x03E90738>]
2020-12-14T06:29:08.1247172Z az_command_data_logger : command args: sql db import -s {} -n {} -g {} -u {} -p {} --storage-key {} --storage-key-type {} --storage-uri {} --debug
2020-12-14T06:29:08.1247921Z metadata file logging enabled - writing logs to 'D:\a\_temp\.azclitask\commands'.
2020-12-14T06:29:08.1248892Z Event: CommandInvoker.OnPreArgumentLoad [<function register_global_subscription_argument.<locals>.add_subscription_parameter at 0x03EE8DF8>, <function register_global_query_examples_argument.<locals>.register_query_examples at 0x03EF1588>]
2020-12-14T06:29:08.4209961Z Event: CommandInvoker.OnPostArgumentLoad []
2020-12-14T06:29:08.4212012Z Event: CommandInvoker.OnPostCommandTableCreate [<function register_ids_argument.<locals>.add_ids_arguments at 0x03EF15D0>, <function register_cache_arguments.<locals>.add_cache_arguments at 0x03EF1660>]
2020-12-14T06:29:08.4220908Z Event: CommandInvoker.OnCommandTableLoaded []
2020-12-14T06:29:08.4223003Z Event: CommandInvoker.OnPreParseArgs []
2020-12-14T06:29:08.4236394Z Event: CommandInvoker.OnPostParseArgs [<function OutputProducer.handle_output_argument at 0x03A4C810>, <function CLIQuery.handle_query_parameter at 0x03A6B810>, <function register_global_query_examples_argument.<locals>.handle_example_parameter at 0x03EF1540>, <function register_ids_argument.<locals>.parse_ids_arguments at 0x03EF1618>]
2020-12-14T06:29:08.4252807Z Getting management service client client_type=SqlManagementClient
2020-12-14T06:29:08.4604930Z msrest.universal_http.requests : Configuring retry: max_retries=4, backoff_factor=0.8, max_backoff=90
2020-12-14T06:29:08.4618414Z AdalAuthentication.signed_session invoked by Track 1 SDK
2020-12-14T06:29:08.4618762Z Retrieving token from ADAL for resource 'https://management.core.windows.net/'
2020-12-14T06:29:08.4620263Z attempting to read file D:\a\_temp\.azclitask\accessTokens.json as utf-8-sig
2020-12-14T06:29:08.4631256Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - Authority:Performing instance discovery: ...
2020-12-14T06:29:08.4632427Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - Authority:Performing static instance discovery
2020-12-14T06:29:08.4632931Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - Authority:Authority validated via static instance discovery
2020-12-14T06:29:08.4633406Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - TokenRequest:Getting token with client credentials.
2020-12-14T06:29:08.4633966Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - TokenRequest:No user_id passed for cache query
2020-12-14T06:29:08.4634745Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - CacheDriver:finding with query keys: {'_clientId': '...'}
2020-12-14T06:29:08.4635425Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - CacheDriver:Looking for potential cache entries: {'_clientId': '...'}
2020-12-14T06:29:08.4636085Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - CacheDriver:Found 0 potential entries.
2020-12-14T06:29:08.4675707Z urllib3.connectionpool : Starting new HTTPS connection (1): login.microsoftonline.com:443
2020-12-14T06:29:08.8897603Z urllib3.connectionpool : https://login.microsoftonline.com:443 "POST /***/oauth2/token HTTP/1.1" 200 1689
2020-12-14T06:29:08.8922037Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - OAuth2Client:Get Token Server returned this correlation_id: 9845b511-692d-48ef-b97b-aed821ffa329
2020-12-14T06:29:08.8924403Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - CacheDriver:Adding entry AccessTokenId: b'byPXE3CfWl7Y1IcgxB1SkBzsf9kqRloDlNlZlTs/XBc='
2020-12-14T06:29:08.8926908Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - CacheDriver:Added entry is MRRT
2020-12-14T06:29:08.8929521Z msrest.http_logger : Request URL: 'https://management.azure.com/subscriptions/************/resourceGroups/******-rg/providers/Microsoft.Sql/servers/****-sqlserver/databases/***********/import?api-version=2020-02-02-preview'
2020-12-14T06:29:08.8932323Z msrest.http_logger : Request method: 'POST'
2020-12-14T06:29:08.8933617Z msrest.http_logger : Request headers:
2020-12-14T06:29:08.8934378Z msrest.http_logger :     'Accept': 'application/json'
2020-12-14T06:29:08.8935121Z msrest.http_logger :     'Content-Type': 'application/json; charset=utf-8'
2020-12-14T06:29:08.8936572Z msrest.http_logger :     'accept-language': 'en-US'
2020-12-14T06:29:08.8937397Z msrest.http_logger :     'Content-Length': '401'
2020-12-14T06:29:08.8938421Z msrest.http_logger :     'User-Agent': 'python/3.6.8 (Windows-10-10.0.14393-SP0) msrest/0.6.18 VSTS_8961e9d8-158f-493f-81de-cb2dc0abcdc5_Release__2030_5652_1 msrest_azure/0.6.3 azure-mgmt-sql/0.21.0 Azure-SDK-For-Python AZURECLI/2.15.1 (MSI)'
2020-12-14T06:29:08.8939565Z msrest.http_logger : Request body:
2020-12-14T06:29:08.8941012Z msrest.http_logger : {"storageKeyType": "SharedAccessKey", "storageKey": "?se=2020-12-14T07%3A27%3A35Z&sp=racwd&spr=https&sv=2018-11-09&sr=b&sig=p25*******", "storageUri": "https://*******.blob.core.windows.net/*****/******.bacpac", "administratorLogin": "*****admin@*******-sqlserver", "administratorLoginPassword": "********************"}
2020-12-14T06:29:08.8942471Z msrest.universal_http : Configuring redirects: allow=True, max=30
2020-12-14T06:29:08.8943268Z msrest.universal_http : Configuring request: timeout=100, verify=True, cert=None
2020-12-14T06:29:08.8944026Z msrest.universal_http : Configuring proxies: ''
2020-12-14T06:29:08.8944749Z msrest.universal_http : Evaluate proxies against ENV settings: True
2020-12-14T06:29:08.8977019Z urllib3.connectionpool : Starting new HTTPS connection (1): management.azure.com:443
2020-12-14T06:29:10.4686206Z urllib3.connectionpool : https://management.azure.com:443 "POST /subscriptions/*******/resourceGroups/*****-rg/providers/Microsoft.Sql/servers/****-sqlserver/databases/****-db/import?api-version=2020-02-02-preview HTTP/1.1" 202 65
2020-12-14T06:29:10.4709403Z msrest.http_logger : Response status: 202
2020-12-14T06:29:10.4710160Z msrest.http_logger : Response headers:
2020-12-14T06:29:10.4710716Z msrest.http_logger :     'Cache-Control': 'no-cache'
2020-12-14T06:29:10.4711265Z msrest.http_logger :     'Pragma': 'no-cache'
2020-12-14T06:29:10.4711778Z msrest.http_logger :     'Content-Length': '65'
2020-12-14T06:29:10.4712352Z msrest.http_logger :     'Content-Type': 'application/json; charset=utf-8'
2020-12-14T06:29:10.4712666Z msrest.http_logger :     'Expires': '-1'
2020-12-14T06:29:10.4713460Z msrest.http_logger :     'Location': 'https://management.azure.com/subscriptions/*******/providers/Microsoft.Sql/locations/uksouth/importExportOperationResults/*****7-c741-4783-8afe-*****-******?api-version=2020-02-02-preview'
2020-12-14T06:29:10.4714037Z msrest.http_logger :     'Retry-After': '15'
2020-12-14T06:29:10.4715120Z msrest.http_logger :     'Azure-AsyncOperation': 'https://management.azure.com/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-4783-8afe-b26b71af8d39-******-sqlserver?api-version=2020-02-02-preview'
2020-12-14T06:29:10.4715760Z msrest.http_logger :     'x-ms-request-id': 'd3489d8c-8845-4ac8-9677-5de8edcb0715'
2020-12-14T06:29:10.4716395Z msrest.http_logger :     'Server': 'Microsoft-HTTPAPI/2.0'
2020-12-14T06:29:10.4716968Z msrest.http_logger :     'x-ms-ratelimit-remaining-subscription-writes': '1198'
2020-12-14T06:29:10.4717918Z msrest.http_logger :     'x-ms-correlation-request-id': '3b9f9b28-ac0e-46c2-aa0d-b074820cb6a4'
2020-12-14T06:29:10.4719885Z msrest.http_logger :     'x-ms-routing-request-id': 'EASTUS2:20201214T062910Z:3b9f9b28-ac0e-46c2-aa0d-b074820cb6a4'
2020-12-14T06:29:10.4720324Z msrest.http_logger :     'Strict-Transport-Security': 'max-age=31536000; includeSubDomains'
2020-12-14T06:29:10.4720653Z msrest.http_logger :     'X-Content-Type-Options': 'nosniff'
2020-12-14T06:29:10.4720966Z msrest.http_logger :     'Date': 'Mon, 14 Dec 2020 06:29:09 GMT'
2020-12-14T06:29:10.4721227Z msrest.http_logger : Response content:
2020-12-14T06:29:10.4721546Z msrest.http_logger : {"operation":"Import","startTime":"2020-12-14T06:29:10.3967857Z"}

It goes on trying the importExportOperationResults call for about 20 minutes then fails with the below:

2020-12-14T06:59:27.8589252Z AdalAuthentication.signed_session invoked by Track 1 SDK
2020-12-14T06:59:27.8590880Z Retrieving token from ADAL for resource 'https://management.core.windows.net/'
2020-12-14T06:59:27.8596301Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - Authority:Performing instance discovery: ...
2020-12-14T06:59:27.8597448Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - Authority:Performing static instance discovery
2020-12-14T06:59:27.8598750Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - Authority:Authority validated via static instance discovery
2020-12-14T06:59:27.8600859Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - TokenRequest:Getting token with client credentials.
2020-12-14T06:59:27.8602215Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - TokenRequest:No user_id passed for cache query
2020-12-14T06:59:27.8602963Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - CacheDriver:finding with query keys: {'_clientId': '...'}
2020-12-14T06:59:27.8603718Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - CacheDriver:Looking for potential cache entries: {'_clientId': '...'}
2020-12-14T06:59:27.8604684Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - CacheDriver:Found 0 potential entries.
2020-12-14T06:59:27.8647318Z urllib3.connectionpool : Starting new HTTPS connection (1): login.microsoftonline.com:443
2020-12-14T06:59:28.1619805Z urllib3.connectionpool : https://login.microsoftonline.com:443 "POST /***/oauth2/token HTTP/1.1" 200 1689
2020-12-14T06:59:28.1644387Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - OAuth2Client:Get Token Server returned this correlation_id: *******-****-****-9bdd-b5f94b7f2f76
2020-12-14T06:59:28.1646547Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - CacheDriver:Adding entry AccessTokenId: b'vVpYwxNizJBbHb0ntJySnOsFZdWZALKzc5znOQBrBnU='
2020-12-14T06:59:28.1648582Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - CacheDriver:Added entry is MRRT
2020-12-14T06:59:28.1650509Z msrest.http_logger : Request URL: 'https://management.azure.com/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview'
2020-12-14T06:59:28.1652469Z msrest.http_logger : Request method: 'GET'
2020-12-14T06:59:28.1653634Z msrest.http_logger : Request headers:
2020-12-14T06:59:28.1655125Z msrest.http_logger :     'Accept': 'application/json'
2020-12-14T06:59:28.1656830Z msrest.http_logger :     'x-ms-client-request-id': '*******-****-****-b319-000d3a0551a1'
2020-12-14T06:59:28.1657950Z msrest.http_logger :     'User-Agent': 'python/3.6.8 (Windows-10-10.0.14393-SP0) msrest/0.6.18 VSTS_*******-****-****-81de-cb2dc0abcdc5_Release__2030_5652_1 msrest_azure/0.6.3 azure-mgmt-sql/0.21.0 Azure-SDK-For-Python AZURECLI/2.15.1 (MSI)'
2020-12-14T06:59:28.1658972Z msrest.http_logger : Request body:
2020-12-14T06:59:28.1659664Z msrest.http_logger : None
2020-12-14T06:59:28.1660326Z msrest.universal_http : Configuring redirects: allow=True, max=30
2020-12-14T06:59:28.1661145Z msrest.universal_http : Configuring request: timeout=100, verify=True, cert=None
2020-12-14T06:59:28.1662227Z msrest.universal_http : Configuring proxies: ''
2020-12-14T06:59:28.1663002Z msrest.universal_http : Evaluate proxies against ENV settings: True
2020-12-14T06:59:28.3958964Z urllib3.connectionpool : https://management.azure.com:443 "GET /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview HTTP/1.1" 500 162
2020-12-14T06:59:28.3961722Z urllib3.util.retry : Incremented Retry for (url='/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview'): Retry(total=3, connect=4, read=4, redirect=None, status=None)
2020-12-14T06:59:28.3965467Z urllib3.connectionpool : Retry: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview
2020-12-14T06:59:28.3967173Z urllib3.connectionpool : Resetting dropped connection: management.azure.com
2020-12-14T06:59:28.6273991Z urllib3.connectionpool : https://management.azure.com:443 "GET /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview HTTP/1.1" 500 162
2020-12-14T06:59:28.6276885Z urllib3.util.retry : Incremented Retry for (url='/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview'): Retry(total=2, connect=4, read=4, redirect=None, status=None)
2020-12-14T06:59:30.2294117Z urllib3.connectionpool : Retry: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview
2020-12-14T06:59:30.2296374Z urllib3.connectionpool : Resetting dropped connection: management.azure.com
2020-12-14T06:59:30.4845931Z urllib3.connectionpool : https://management.azure.com:443 "GET /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview HTTP/1.1" 500 162
2020-12-14T06:59:30.4848771Z urllib3.util.retry : Incremented Retry for (url='/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview'): Retry(total=1, connect=4, read=4, redirect=None, status=None)
2020-12-14T06:59:33.6865849Z urllib3.connectionpool : Retry: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview
2020-12-14T06:59:33.6866864Z urllib3.connectionpool : Resetting dropped connection: management.azure.com
2020-12-14T06:59:33.9581367Z urllib3.connectionpool : https://management.azure.com:443 "GET /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview HTTP/1.1" 500 162
2020-12-14T06:59:33.9583704Z urllib3.util.retry : Incremented Retry for (url='/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview'): Retry(total=0, connect=4, read=4, redirect=None, status=None)
2020-12-14T06:59:40.3596690Z urllib3.connectionpool : Retry: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview
2020-12-14T06:59:40.3599139Z urllib3.connectionpool : Resetting dropped connection: management.azure.com
2020-12-14T06:59:40.8507337Z urllib3.connectionpool : https://management.azure.com:443 "GET /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview HTTP/1.1" 500 162
2020-12-14T06:59:40.8513462Z msrest.exceptions : Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',))
2020-12-14T06:59:41.4262179Z azure.cli.core.util.handle_exception is called with an exception:
2020-12-14T06:59:41.4275348Z Traceback (most recent call last):
2020-12-14T06:59:41.4275986Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\adapters.py", line 449, in send
2020-12-14T06:59:41.4276992Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-6alwzak1\urllib3\connectionpool.py", line 734, in urlopen
2020-12-14T06:59:41.4278912Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-6alwzak1\urllib3\connectionpool.py", line 734, in urlopen
2020-12-14T06:59:41.4279443Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-6alwzak1\urllib3\connectionpool.py", line 734, in urlopen
2020-12-14T06:59:41.4279783Z   [Previous line repeated 1 more time]
2020-12-14T06:59:41.4280233Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-6alwzak1\urllib3\connectionpool.py", line 714, in urlopen
2020-12-14T06:59:41.4280681Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-6alwzak1\urllib3\util\retry.py", line 399, in increment
2020-12-14T06:59:41.4281479Z urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',))
2020-12-14T06:59:41.4282226Z 
2020-12-14T06:59:41.4282465Z During handling of the above exception, another exception occurred:
2020-12-14T06:59:41.4282648Z 
2020-12-14T06:59:41.4282895Z Traceback (most recent call last):
2020-12-14T06:59:41.4283223Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\universal_http\requests.py", line 142, in send
2020-12-14T06:59:41.4283604Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\sessions.py", line 533, in request
2020-12-14T06:59:41.4284000Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\sessions.py", line 646, in send
2020-12-14T06:59:41.4284387Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\adapters.py", line 507, in send
2020-12-14T06:59:41.4285104Z requests.exceptions.RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',))
2020-12-14T06:59:41.4285706Z 
2020-12-14T06:59:41.4285899Z During handling of the above exception, another exception occurred:
2020-12-14T06:59:41.4286098Z 
2020-12-14T06:59:41.4286236Z Traceback (most recent call last):
2020-12-14T06:59:41.4286732Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 977, in __call__
2020-12-14T06:59:41.4287135Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\polling\poller.py", line 183, in result
2020-12-14T06:59:41.4287556Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\polling\poller.py", line 201, in wait
2020-12-14T06:59:41.4287990Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\polling\poller.py", line 152, in _start
2020-12-14T06:59:41.4288502Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-3kvwg7c4\msrestazure\polling\arm_polling.py", line 390, in run
2020-12-14T06:59:41.4288941Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-3kvwg7c4\msrestazure\polling\arm_polling.py", line 415, in _poll
2020-12-14T06:59:41.4289368Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-3kvwg7c4\msrestazure\polling\arm_polling.py", line 443, in update_status
2020-12-14T06:59:41.4289831Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-3kvwg7c4\msrestazure\polling\arm_polling.py", line 470, in request_status
2020-12-14T06:59:41.4290236Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\service_client.py", line 336, in send
2020-12-14T06:59:41.4290656Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\__init__.py", line 197, in run
2020-12-14T06:59:41.4291046Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\__init__.py", line 150, in send
2020-12-14T06:59:41.4291465Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\requests.py", line 72, in send
2020-12-14T06:59:41.4291928Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\requests.py", line 137, in send
2020-12-14T06:59:41.4292570Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\__init__.py", line 150, in send
2020-12-14T06:59:41.4293000Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\requests.py", line 193, in send
2020-12-14T06:59:41.4293393Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\universal_http\requests.py", line 333, in send
2020-12-14T06:59:41.4293989Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\universal_http\requests.py", line 145, in send
2020-12-14T06:59:41.4294403Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\exceptions.py", line 51, in raise_with_traceback
2020-12-14T06:59:41.4294854Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\universal_http\requests.py", line 142, in send
2020-12-14T06:59:41.4295289Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\sessions.py", line 533, in request
2020-12-14T06:59:41.4295871Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\sessions.py", line 646, in send
2020-12-14T06:59:41.4296292Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\adapters.py", line 507, in send
2020-12-14T06:59:41.4297141Z msrest.exceptions.ClientRequestError: Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',))
2020-12-14T06:59:41.4299532Z 
2020-12-14T06:59:41.4299768Z During handling of the above exception, another exception occurred:
2020-12-14T06:59:41.4300011Z 
2020-12-14T06:59:41.4300165Z Traceback (most recent call last):
2020-12-14T06:59:41.4301060Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-2lthyver\knack\cli.py", line 215, in invoke
2020-12-14T06:59:41.4301488Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 654, in execute
2020-12-14T06:59:41.4301978Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 717, in _run_jobs_serially
2020-12-14T06:59:41.4302460Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 710, in _run_job
2020-12-14T06:59:41.4303461Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-o9e7nicr\six.py", line 703, in reraise
2020-12-14T06:59:41.4303887Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 699, in _run_job
2020-12-14T06:59:41.4304300Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 981, in __call__
2020-12-14T06:59:41.4304802Z   File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\arm.py", line 134, in handle_long_running_operation_exception
2020-12-14T06:59:41.4306260Z knack.util.CLIError: Deployment failed. Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',))
2020-12-14T06:59:41.4306949Z 
2020-12-14T06:59:41.4307893Z cli.azure.cli.core.azclierror : Deployment failed. Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',))
2020-12-14T06:59:41.4309744Z Deployment failed. Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',))
2020-12-14T06:59:41.4310714Z Event: Cli.PostExecute [<function AzCliLogging.deinit_cmd_metadata_logging at 0x03E90858>]
2020-12-14T06:59:41.4311083Z az_command_data_logger : exit code: 1
2020-12-14T06:59:41.4311489Z Command ran in 1833.466 seconds (init: 0.131, invoke: 1833.334)
2020-12-14T06:59:41.4715396Z telemetry.save : Save telemetry record of length 16973 in cache
2020-12-14T06:59:42.3405689Z telemetry.check : Returns Positive.
2020-12-14T06:59:42.3406182Z telemetry.main : Begin creating telemetry upload process.
2020-12-14T06:59:42.3406903Z telemetry.process : Creating upload process: "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\python.exe C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\azure\cli\telemetry\__init__.pyc D:\a\_temp\.azclitask"
2020-12-14T06:59:42.3407641Z telemetry.process : Return from creating process
2020-12-14T06:59:42.3407962Z telemetry.main : Finish creating telemetry upload process.
2020-12-14T06:59:42.3408305Z Import completed
2020-12-14T06:59:43.2308863Z Removed firewall rule
2020-12-14T06:59:43.3187023Z [command]C:\windows\system32\cmd.exe /D /S /C ""C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\wbin\az.cmd" account clear"
ghost commented 3 years ago

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @azureSQLGitHub.

Issue Details
**Describe the bug** Using the `az sql db import` with a bacpac (with a size of 2.5mb) located in azure storage fails eventually after roughtly 30 minutes. I've tried increasing the size of the blank database it is imported into but nothing works. **To Reproduce** ``` Command arguments: ['sql', 'db', 'import', '-s', '***-sqlserver', '-n', '****-db', '-g', '*****-rg', '-u', '****@*****-sqlserver', '-p', '********', '--storage-key', 'se=2020-12-14T07%3A27%3A35Z&sp=racwd&spr=https&sv=2018-11-09&sr=b&sig=******', '--storage-key-type', 'SharedAccessKey', '--storage-uri', 'https://******.blob.core.windows.net/db-backups/blank.bacpac', '--debug'] ``` **Expected behavior** The import operation runs to completion **Environment summary** Running on AzureDevops hosted agent windows-latest ``` azure-cli 2.15.1 * core 2.15.1 * telemetry 1.0.6 Extensions: azure-devops 0.18.0 Python (Windows) 3.6.8 (tags/v3.6.8:3c6b436a57, Dec 23 2018, 23:31:17) [MSC v.1916 32 bit (Intel)] ``` **Additional context** Debug logs ``` Event: CommandParser.OnGlobalArgumentsCreate [, , ] 2020-12-14T06:29:08.1092925Z Event: CommandInvoker.OnPreCommandTableCreate [] 2020-12-14T06:29:08.1093399Z Modules found from index for 'sql': ['azure.cli.command_modules.sql', 'azure.cli.command_modules.sqlvm'] 2020-12-14T06:29:08.1093808Z Loading command modules: 2020-12-14T06:29:08.1094119Z Name Load Time Groups Commands 2020-12-14T06:29:08.1186216Z sql 0.009 39 162 2020-12-14T06:29:08.1213901Z sqlvm 0.003 4 17 2020-12-14T06:29:08.1214227Z Total (2) 0.012 43 179 2020-12-14T06:29:08.1223965Z These extensions are not installed and will be skipped: ['azext_ai_examples'] 2020-12-14T06:29:08.1224519Z Loading extensions: 2020-12-14T06:29:08.1224814Z Name Load Time Groups Commands Directory 2020-12-14T06:29:08.1227278Z Total (0) 0.000 0 0 2020-12-14T06:29:08.1227589Z Loaded 42 groups, 179 commands. 2020-12-14T06:29:08.1227846Z Found a match in the command table. 2020-12-14T06:29:08.1228194Z Raw command : sql db import 2020-12-14T06:29:08.1228649Z Command table: sql db import 2020-12-14T06:29:08.1229212Z Event: CommandInvoker.OnPreCommandTableTruncate [] 2020-12-14T06:29:08.1247172Z az_command_data_logger : command args: sql db import -s {} -n {} -g {} -u {} -p {} --storage-key {} --storage-key-type {} --storage-uri {} --debug 2020-12-14T06:29:08.1247921Z metadata file logging enabled - writing logs to 'D:\a\_temp\.azclitask\commands'. 2020-12-14T06:29:08.1248892Z Event: CommandInvoker.OnPreArgumentLoad [.add_subscription_parameter at 0x03EE8DF8>, .register_query_examples at 0x03EF1588>] 2020-12-14T06:29:08.4209961Z Event: CommandInvoker.OnPostArgumentLoad [] 2020-12-14T06:29:08.4212012Z Event: CommandInvoker.OnPostCommandTableCreate [.add_ids_arguments at 0x03EF15D0>, .add_cache_arguments at 0x03EF1660>] 2020-12-14T06:29:08.4220908Z Event: CommandInvoker.OnCommandTableLoaded [] 2020-12-14T06:29:08.4223003Z Event: CommandInvoker.OnPreParseArgs [] 2020-12-14T06:29:08.4236394Z Event: CommandInvoker.OnPostParseArgs [, , .handle_example_parameter at 0x03EF1540>, .parse_ids_arguments at 0x03EF1618>] 2020-12-14T06:29:08.4252807Z Getting management service client client_type=SqlManagementClient 2020-12-14T06:29:08.4604930Z msrest.universal_http.requests : Configuring retry: max_retries=4, backoff_factor=0.8, max_backoff=90 2020-12-14T06:29:08.4618414Z AdalAuthentication.signed_session invoked by Track 1 SDK 2020-12-14T06:29:08.4618762Z Retrieving token from ADAL for resource 'https://management.core.windows.net/' 2020-12-14T06:29:08.4620263Z attempting to read file D:\a\_temp\.azclitask\accessTokens.json as utf-8-sig 2020-12-14T06:29:08.4631256Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - Authority:Performing instance discovery: ... 2020-12-14T06:29:08.4632427Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - Authority:Performing static instance discovery 2020-12-14T06:29:08.4632931Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - Authority:Authority validated via static instance discovery 2020-12-14T06:29:08.4633406Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - TokenRequest:Getting token with client credentials. 2020-12-14T06:29:08.4633966Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - TokenRequest:No user_id passed for cache query 2020-12-14T06:29:08.4634745Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - CacheDriver:finding with query keys: {'_clientId': '...'} 2020-12-14T06:29:08.4635425Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - CacheDriver:Looking for potential cache entries: {'_clientId': '...'} 2020-12-14T06:29:08.4636085Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - CacheDriver:Found 0 potential entries. 2020-12-14T06:29:08.4675707Z urllib3.connectionpool : Starting new HTTPS connection (1): login.microsoftonline.com:443 2020-12-14T06:29:08.8897603Z urllib3.connectionpool : https://login.microsoftonline.com:443 "POST /***/oauth2/token HTTP/1.1" 200 1689 2020-12-14T06:29:08.8922037Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - OAuth2Client:Get Token Server returned this correlation_id: 9845b511-692d-48ef-b97b-aed821ffa329 2020-12-14T06:29:08.8924403Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - CacheDriver:Adding entry AccessTokenId: b'byPXE3CfWl7Y1IcgxB1SkBzsf9kqRloDlNlZlTs/XBc=' 2020-12-14T06:29:08.8926908Z adal-python : 9845b511-692d-48ef-b97b-aed821ffa329 - CacheDriver:Added entry is MRRT 2020-12-14T06:29:08.8929521Z msrest.http_logger : Request URL: 'https://management.azure.com/subscriptions/************/resourceGroups/******-rg/providers/Microsoft.Sql/servers/****-sqlserver/databases/***********/import?api-version=2020-02-02-preview' 2020-12-14T06:29:08.8932323Z msrest.http_logger : Request method: 'POST' 2020-12-14T06:29:08.8933617Z msrest.http_logger : Request headers: 2020-12-14T06:29:08.8934378Z msrest.http_logger : 'Accept': 'application/json' 2020-12-14T06:29:08.8935121Z msrest.http_logger : 'Content-Type': 'application/json; charset=utf-8' 2020-12-14T06:29:08.8936572Z msrest.http_logger : 'accept-language': 'en-US' 2020-12-14T06:29:08.8937397Z msrest.http_logger : 'Content-Length': '401' 2020-12-14T06:29:08.8938421Z msrest.http_logger : 'User-Agent': 'python/3.6.8 (Windows-10-10.0.14393-SP0) msrest/0.6.18 VSTS_8961e9d8-158f-493f-81de-cb2dc0abcdc5_Release__2030_5652_1 msrest_azure/0.6.3 azure-mgmt-sql/0.21.0 Azure-SDK-For-Python AZURECLI/2.15.1 (MSI)' 2020-12-14T06:29:08.8939565Z msrest.http_logger : Request body: 2020-12-14T06:29:08.8941012Z msrest.http_logger : {"storageKeyType": "SharedAccessKey", "storageKey": "?se=2020-12-14T07%3A27%3A35Z&sp=racwd&spr=https&sv=2018-11-09&sr=b&sig=p25*******", "storageUri": "https://*******.blob.core.windows.net/*****/******.bacpac", "administratorLogin": "*****admin@*******-sqlserver", "administratorLoginPassword": "********************"} 2020-12-14T06:29:08.8942471Z msrest.universal_http : Configuring redirects: allow=True, max=30 2020-12-14T06:29:08.8943268Z msrest.universal_http : Configuring request: timeout=100, verify=True, cert=None 2020-12-14T06:29:08.8944026Z msrest.universal_http : Configuring proxies: '' 2020-12-14T06:29:08.8944749Z msrest.universal_http : Evaluate proxies against ENV settings: True 2020-12-14T06:29:08.8977019Z urllib3.connectionpool : Starting new HTTPS connection (1): management.azure.com:443 2020-12-14T06:29:10.4686206Z urllib3.connectionpool : https://management.azure.com:443 "POST /subscriptions/*******/resourceGroups/*****-rg/providers/Microsoft.Sql/servers/****-sqlserver/databases/****-db/import?api-version=2020-02-02-preview HTTP/1.1" 202 65 2020-12-14T06:29:10.4709403Z msrest.http_logger : Response status: 202 2020-12-14T06:29:10.4710160Z msrest.http_logger : Response headers: 2020-12-14T06:29:10.4710716Z msrest.http_logger : 'Cache-Control': 'no-cache' 2020-12-14T06:29:10.4711265Z msrest.http_logger : 'Pragma': 'no-cache' 2020-12-14T06:29:10.4711778Z msrest.http_logger : 'Content-Length': '65' 2020-12-14T06:29:10.4712352Z msrest.http_logger : 'Content-Type': 'application/json; charset=utf-8' 2020-12-14T06:29:10.4712666Z msrest.http_logger : 'Expires': '-1' 2020-12-14T06:29:10.4713460Z msrest.http_logger : 'Location': 'https://management.azure.com/subscriptions/*******/providers/Microsoft.Sql/locations/uksouth/importExportOperationResults/*****7-c741-4783-8afe-*****-******?api-version=2020-02-02-preview' 2020-12-14T06:29:10.4714037Z msrest.http_logger : 'Retry-After': '15' 2020-12-14T06:29:10.4715120Z msrest.http_logger : 'Azure-AsyncOperation': 'https://management.azure.com/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-4783-8afe-b26b71af8d39-******-sqlserver?api-version=2020-02-02-preview' 2020-12-14T06:29:10.4715760Z msrest.http_logger : 'x-ms-request-id': 'd3489d8c-8845-4ac8-9677-5de8edcb0715' 2020-12-14T06:29:10.4716395Z msrest.http_logger : 'Server': 'Microsoft-HTTPAPI/2.0' 2020-12-14T06:29:10.4716968Z msrest.http_logger : 'x-ms-ratelimit-remaining-subscription-writes': '1198' 2020-12-14T06:29:10.4717918Z msrest.http_logger : 'x-ms-correlation-request-id': '3b9f9b28-ac0e-46c2-aa0d-b074820cb6a4' 2020-12-14T06:29:10.4719885Z msrest.http_logger : 'x-ms-routing-request-id': 'EASTUS2:20201214T062910Z:3b9f9b28-ac0e-46c2-aa0d-b074820cb6a4' 2020-12-14T06:29:10.4720324Z msrest.http_logger : 'Strict-Transport-Security': 'max-age=31536000; includeSubDomains' 2020-12-14T06:29:10.4720653Z msrest.http_logger : 'X-Content-Type-Options': 'nosniff' 2020-12-14T06:29:10.4720966Z msrest.http_logger : 'Date': 'Mon, 14 Dec 2020 06:29:09 GMT' 2020-12-14T06:29:10.4721227Z msrest.http_logger : Response content: 2020-12-14T06:29:10.4721546Z msrest.http_logger : {"operation":"Import","startTime":"2020-12-14T06:29:10.3967857Z"} ``` It goes on trying the `importExportOperationResults` call for about 20 minutes then fails with the below: ``` 2020-12-14T06:59:27.8589252Z AdalAuthentication.signed_session invoked by Track 1 SDK 2020-12-14T06:59:27.8590880Z Retrieving token from ADAL for resource 'https://management.core.windows.net/' 2020-12-14T06:59:27.8596301Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - Authority:Performing instance discovery: ... 2020-12-14T06:59:27.8597448Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - Authority:Performing static instance discovery 2020-12-14T06:59:27.8598750Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - Authority:Authority validated via static instance discovery 2020-12-14T06:59:27.8600859Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - TokenRequest:Getting token with client credentials. 2020-12-14T06:59:27.8602215Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - TokenRequest:No user_id passed for cache query 2020-12-14T06:59:27.8602963Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - CacheDriver:finding with query keys: {'_clientId': '...'} 2020-12-14T06:59:27.8603718Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - CacheDriver:Looking for potential cache entries: {'_clientId': '...'} 2020-12-14T06:59:27.8604684Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - CacheDriver:Found 0 potential entries. 2020-12-14T06:59:27.8647318Z urllib3.connectionpool : Starting new HTTPS connection (1): login.microsoftonline.com:443 2020-12-14T06:59:28.1619805Z urllib3.connectionpool : https://login.microsoftonline.com:443 "POST /***/oauth2/token HTTP/1.1" 200 1689 2020-12-14T06:59:28.1644387Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - OAuth2Client:Get Token Server returned this correlation_id: *******-****-****-9bdd-b5f94b7f2f76 2020-12-14T06:59:28.1646547Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - CacheDriver:Adding entry AccessTokenId: b'vVpYwxNizJBbHb0ntJySnOsFZdWZALKzc5znOQBrBnU=' 2020-12-14T06:59:28.1648582Z adal-python : *******-****-****-9bdd-b5f94b7f2f76 - CacheDriver:Added entry is MRRT 2020-12-14T06:59:28.1650509Z msrest.http_logger : Request URL: 'https://management.azure.com/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview' 2020-12-14T06:59:28.1652469Z msrest.http_logger : Request method: 'GET' 2020-12-14T06:59:28.1653634Z msrest.http_logger : Request headers: 2020-12-14T06:59:28.1655125Z msrest.http_logger : 'Accept': 'application/json' 2020-12-14T06:59:28.1656830Z msrest.http_logger : 'x-ms-client-request-id': '*******-****-****-b319-000d3a0551a1' 2020-12-14T06:59:28.1657950Z msrest.http_logger : 'User-Agent': 'python/3.6.8 (Windows-10-10.0.14393-SP0) msrest/0.6.18 VSTS_*******-****-****-81de-cb2dc0abcdc5_Release__2030_5652_1 msrest_azure/0.6.3 azure-mgmt-sql/0.21.0 Azure-SDK-For-Python AZURECLI/2.15.1 (MSI)' 2020-12-14T06:59:28.1658972Z msrest.http_logger : Request body: 2020-12-14T06:59:28.1659664Z msrest.http_logger : None 2020-12-14T06:59:28.1660326Z msrest.universal_http : Configuring redirects: allow=True, max=30 2020-12-14T06:59:28.1661145Z msrest.universal_http : Configuring request: timeout=100, verify=True, cert=None 2020-12-14T06:59:28.1662227Z msrest.universal_http : Configuring proxies: '' 2020-12-14T06:59:28.1663002Z msrest.universal_http : Evaluate proxies against ENV settings: True 2020-12-14T06:59:28.3958964Z urllib3.connectionpool : https://management.azure.com:443 "GET /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview HTTP/1.1" 500 162 2020-12-14T06:59:28.3961722Z urllib3.util.retry : Incremented Retry for (url='/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview'): Retry(total=3, connect=4, read=4, redirect=None, status=None) 2020-12-14T06:59:28.3965467Z urllib3.connectionpool : Retry: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview 2020-12-14T06:59:28.3967173Z urllib3.connectionpool : Resetting dropped connection: management.azure.com 2020-12-14T06:59:28.6273991Z urllib3.connectionpool : https://management.azure.com:443 "GET /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview HTTP/1.1" 500 162 2020-12-14T06:59:28.6276885Z urllib3.util.retry : Incremented Retry for (url='/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview'): Retry(total=2, connect=4, read=4, redirect=None, status=None) 2020-12-14T06:59:30.2294117Z urllib3.connectionpool : Retry: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview 2020-12-14T06:59:30.2296374Z urllib3.connectionpool : Resetting dropped connection: management.azure.com 2020-12-14T06:59:30.4845931Z urllib3.connectionpool : https://management.azure.com:443 "GET /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview HTTP/1.1" 500 162 2020-12-14T06:59:30.4848771Z urllib3.util.retry : Incremented Retry for (url='/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview'): Retry(total=1, connect=4, read=4, redirect=None, status=None) 2020-12-14T06:59:33.6865849Z urllib3.connectionpool : Retry: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview 2020-12-14T06:59:33.6866864Z urllib3.connectionpool : Resetting dropped connection: management.azure.com 2020-12-14T06:59:33.9581367Z urllib3.connectionpool : https://management.azure.com:443 "GET /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview HTTP/1.1" 500 162 2020-12-14T06:59:33.9583704Z urllib3.util.retry : Incremented Retry for (url='/subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview'): Retry(total=0, connect=4, read=4, redirect=None, status=None) 2020-12-14T06:59:40.3596690Z urllib3.connectionpool : Retry: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview 2020-12-14T06:59:40.3599139Z urllib3.connectionpool : Resetting dropped connection: management.azure.com 2020-12-14T06:59:40.8507337Z urllib3.connectionpool : https://management.azure.com:443 "GET /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview HTTP/1.1" 500 162 2020-12-14T06:59:40.8513462Z msrest.exceptions : Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',)) 2020-12-14T06:59:41.4262179Z azure.cli.core.util.handle_exception is called with an exception: 2020-12-14T06:59:41.4275348Z Traceback (most recent call last): 2020-12-14T06:59:41.4275986Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\adapters.py", line 449, in send 2020-12-14T06:59:41.4276992Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-6alwzak1\urllib3\connectionpool.py", line 734, in urlopen 2020-12-14T06:59:41.4278912Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-6alwzak1\urllib3\connectionpool.py", line 734, in urlopen 2020-12-14T06:59:41.4279443Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-6alwzak1\urllib3\connectionpool.py", line 734, in urlopen 2020-12-14T06:59:41.4279783Z [Previous line repeated 1 more time] 2020-12-14T06:59:41.4280233Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-6alwzak1\urllib3\connectionpool.py", line 714, in urlopen 2020-12-14T06:59:41.4280681Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-6alwzak1\urllib3\util\retry.py", line 399, in increment 2020-12-14T06:59:41.4281479Z urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',)) 2020-12-14T06:59:41.4282226Z 2020-12-14T06:59:41.4282465Z During handling of the above exception, another exception occurred: 2020-12-14T06:59:41.4282648Z 2020-12-14T06:59:41.4282895Z Traceback (most recent call last): 2020-12-14T06:59:41.4283223Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\universal_http\requests.py", line 142, in send 2020-12-14T06:59:41.4283604Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\sessions.py", line 533, in request 2020-12-14T06:59:41.4284000Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\sessions.py", line 646, in send 2020-12-14T06:59:41.4284387Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\adapters.py", line 507, in send 2020-12-14T06:59:41.4285104Z requests.exceptions.RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',)) 2020-12-14T06:59:41.4285706Z 2020-12-14T06:59:41.4285899Z During handling of the above exception, another exception occurred: 2020-12-14T06:59:41.4286098Z 2020-12-14T06:59:41.4286236Z Traceback (most recent call last): 2020-12-14T06:59:41.4286732Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 977, in __call__ 2020-12-14T06:59:41.4287135Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\polling\poller.py", line 183, in result 2020-12-14T06:59:41.4287556Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\polling\poller.py", line 201, in wait 2020-12-14T06:59:41.4287990Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\polling\poller.py", line 152, in _start 2020-12-14T06:59:41.4288502Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-3kvwg7c4\msrestazure\polling\arm_polling.py", line 390, in run 2020-12-14T06:59:41.4288941Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-3kvwg7c4\msrestazure\polling\arm_polling.py", line 415, in _poll 2020-12-14T06:59:41.4289368Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-3kvwg7c4\msrestazure\polling\arm_polling.py", line 443, in update_status 2020-12-14T06:59:41.4289831Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-3kvwg7c4\msrestazure\polling\arm_polling.py", line 470, in request_status 2020-12-14T06:59:41.4290236Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\service_client.py", line 336, in send 2020-12-14T06:59:41.4290656Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\__init__.py", line 197, in run 2020-12-14T06:59:41.4291046Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\__init__.py", line 150, in send 2020-12-14T06:59:41.4291465Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\requests.py", line 72, in send 2020-12-14T06:59:41.4291928Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\requests.py", line 137, in send 2020-12-14T06:59:41.4292570Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\__init__.py", line 150, in send 2020-12-14T06:59:41.4293000Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\pipeline\requests.py", line 193, in send 2020-12-14T06:59:41.4293393Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\universal_http\requests.py", line 333, in send 2020-12-14T06:59:41.4293989Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\universal_http\requests.py", line 145, in send 2020-12-14T06:59:41.4294403Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\exceptions.py", line 51, in raise_with_traceback 2020-12-14T06:59:41.4294854Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-k34ct6ah\msrest\universal_http\requests.py", line 142, in send 2020-12-14T06:59:41.4295289Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\sessions.py", line 533, in request 2020-12-14T06:59:41.4295871Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\sessions.py", line 646, in send 2020-12-14T06:59:41.4296292Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-cbtdz5ps\requests\adapters.py", line 507, in send 2020-12-14T06:59:41.4297141Z msrest.exceptions.ClientRequestError: Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',)) 2020-12-14T06:59:41.4299532Z 2020-12-14T06:59:41.4299768Z During handling of the above exception, another exception occurred: 2020-12-14T06:59:41.4300011Z 2020-12-14T06:59:41.4300165Z Traceback (most recent call last): 2020-12-14T06:59:41.4301060Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-2lthyver\knack\cli.py", line 215, in invoke 2020-12-14T06:59:41.4301488Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 654, in execute 2020-12-14T06:59:41.4301978Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 717, in _run_jobs_serially 2020-12-14T06:59:41.4302460Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 710, in _run_job 2020-12-14T06:59:41.4303461Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-o9e7nicr\six.py", line 703, in reraise 2020-12-14T06:59:41.4303887Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 699, in _run_job 2020-12-14T06:59:41.4304300Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\__init__.py", line 981, in __call__ 2020-12-14T06:59:41.4304802Z File "C:\Users\VSSADM~1\AppData\Local\Temp\pip-unpacked-wheel-84ckl4fg\azure\cli\core\commands\arm.py", line 134, in handle_long_running_operation_exception 2020-12-14T06:59:41.4306260Z knack.util.CLIError: Deployment failed. Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',)) 2020-12-14T06:59:41.4306949Z 2020-12-14T06:59:41.4307893Z cli.azure.cli.core.azclierror : Deployment failed. Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',)) 2020-12-14T06:59:41.4309744Z Deployment failed. Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/********-****-416f-9713-01ffa7505a59/providers/Microsoft.Sql/locations/uksouth/importExportAzureAsyncOperation/*******-****-****-8afe-b26b71af8d39-*****-dev-sqlserver?api-version=2020-02-02-preview (Caused by ResponseError('too many 500 error responses',)) 2020-12-14T06:59:41.4310714Z Event: Cli.PostExecute [] 2020-12-14T06:59:41.4311083Z az_command_data_logger : exit code: 1 2020-12-14T06:59:41.4311489Z Command ran in 1833.466 seconds (init: 0.131, invoke: 1833.334) 2020-12-14T06:59:41.4715396Z telemetry.save : Save telemetry record of length 16973 in cache 2020-12-14T06:59:42.3405689Z telemetry.check : Returns Positive. 2020-12-14T06:59:42.3406182Z telemetry.main : Begin creating telemetry upload process. 2020-12-14T06:59:42.3406903Z telemetry.process : Creating upload process: "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\python.exe C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\azure\cli\telemetry\__init__.pyc D:\a\_temp\.azclitask" 2020-12-14T06:59:42.3407641Z telemetry.process : Return from creating process 2020-12-14T06:59:42.3407962Z telemetry.main : Finish creating telemetry upload process. 2020-12-14T06:59:42.3408305Z Import completed 2020-12-14T06:59:43.2308863Z Removed firewall rule 2020-12-14T06:59:43.3187023Z [command]C:\windows\system32\cmd.exe /D /S /C ""C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\wbin\az.cmd" account clear" ```
Author: jonsamwell
Assignees: -
Labels: `SQL`, `Service Attention`
Milestone: -
yonzhan commented 3 years ago

sql

binarysenator commented 3 years ago

I've seen this same behaviour from Azure DevOps CLI Step. (windows-2019 hosted agent) and it was working fine and then in the last couple of weeks it has stopped working with the same error.

petender commented 3 years ago

Still noticing the same as @binarysenator from Azure DevOps CLI - worked fine up to a few weeks back, I think it changed beginning this year - no specific error message, the "import db" job keeps running and eventually times out after 30min

MichaelEbert commented 1 year ago

Does this happen with the powershell command New-AzSqlDatabaseImport as well, or is it specific to CLI? If it happens with powershell as well, does the operation appear in the azure portal? If so, what is the status there?