az sql db import fails with 'too many 500 error responses'
- Dominant language
- Python
- Stars
- 4.6k
- Forks
- 3.5k
- Avg merge
- 3d 2h
- Merged PRs (30d)
- 60
Description
**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 [, , ]
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"
```
Contributor guide
Assessment
This issue has not been assessed yet.