Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
986 questions
An unexpected error occured while processing the request. Tracking ID
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 47%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mike Sarafidis
1
Reputation point
I have a powershell script that I had successfully used a couple of days before and created a MySQL Flex database.
I tried to create another database and I was getting an error regarding admin login. I have made some efforts until I understand that "-" are not supported at admin username. After fixing this issue I am getting the following error while trying to create the database.
"An unexpected error occured while processing the request. Tracking ID: XXXX"
StackTrace : at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate_Call(HttpRequestMessage request, Func`3 onOk, Func`3 onDefault, IEventListener eventListener, ISendAsync sender)
at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate_Call(HttpRequestMessage request, Func`3 onOk, Func`3 onDefault, IEventListener eventListener, ISendAsync sender)
at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate(String subscriptionId, String resourceGroupName, String serverName, IServerAutoGenerated body, Func`3 onOk, Func`3 onDefault, IEventListener eventList
ener, ISendAsync sender)
at Microsoft.Azure.PowerShell.Cmdlets.MySql.Cmdlets.NewAzMySqlFlexibleServer_CreateExpanded.ProcessRecordAsync()
Any Ideas?
Azure Database for MySQL
Windows for business Windows Server User experience PowerShell
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 74%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rich Matheisen 47,901 Reputation points2023-02-05T22:12:42.8+00:00 A stack trace isn't much help without the accompanying error and the script that produces the error.
Is this any help? https://learn.microsoft.com/en-us/answers/questions/520226/(internalservererror)-an-unexpected-error-occured
-
Mike Sarafidis 1 Reputation point
2023-02-06T05:56:17.2433333+00:00 I am trying to create a new MySQL flex server with the following powershell script
New-AzMySqlFlexibleServer -Name $dbname -ResourceGroupName $ResourceGroupName -Location $Location ` -AdministratorUserName $adminname -AdministratorLoginPassword $password ` -Sku Standard_B1s -SkuTier Burstable -Version "5.7" -StorageInMb 20480 -Zone 1 -BackupRetentionDay 7 -StorageAutogrow Enabled ` -Vnet $vnet.Name -Subnet $MysqlSubnet.Name -PrivateDnsZone $Zone.ResourceIdand this is the complete error outcome
New-AzMySqlFlexibleServer_CreateExpanded: C:\Users\mike\Documents\PowerShell\Modules\Az.MySql\1.0.0\custom\New-AzMySqlFlexibleServer.ps1:376:9 Line | 376 | $Server = Az.MySql.internal\New-AzMySqlFlexibleServer @PSBoun … | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | An unexpected error occured while processing the request. Tracking ID: 'dd05c1dc-7f55-4dde-99e5-7d1571fcaf21' Creating database flexibleserverdb... WARNING: New-AzMySqlFlexibleServerDatabase_Create is not found. The most similar Azure PowerShell command is: New-AzMySqlFlexibleServerDatabase WARNING: The intelligent recommendation feature is in preview. Help us improve it by sharing your experience: https://go.microsoft.com/fwlink/?linkid=2202436 New-AzMySqlFlexibleServerDatabase_Create: C:\Users\mike\Documents\PowerShell\Modules\Az.MySql\1.0.0\custom\New-AzMySqlFlexibleServer.ps1:384:9 Line | 384 | $null = New-AzMySqlFlexibleServerDatabase -Name $DEFAULT_DB_N … | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | The server 'theka-mysql-flex-production' does not exist or in unexpected status. Exception: C:\Users\mike\Documents\PowerShell\Modules\Az.MySql\1.0.0\custom\New-AzMySqlFlexibleServer.ps1:391:9 Line | 391 | $Server.DatabaseName = $DEFAULT_DB_NAME | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | The property 'DatabaseName' cannot be found on this object. Verify that the property exists and can be set. ErrorRecord : The property 'DatabaseName' cannot be found on this object. Verify that the property exists and can be set. WasThrownFromThrowStatement : True TargetSite : Void CheckActionPreference(System.Management.Automation.Language.FunctionContext, System.Exception) Message : The property 'DatabaseName' cannot be found on this object. Verify that the property exists and can be set. Data : {[System.Management.Automation.Interpreter.InterpretedFrameInfo, System.Management.Automation.Interpreter.InterpretedFrameInfo[]]} InnerException : HelpLink : Source : System.Management.Automation HResult : -2146233087 StackTrace : at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception) at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) TargetSite : Message : [ServerNotExist] : The server 'theka-mysql-flex-production' does not exist or in unexpected status. Data : {} InnerException : HelpLink : Source : HResult : -2146233088 StackTrace : StatusCode : OK Code : InternalServerError RequestMessage : Method: GET, RequestUri: 'https://management.azure.com/subscriptions/xxxxxxxxxxxxxxxx/providers/Microsoft.DBforMySQL/locations/francecentral/azureAsyncOperation/94035ce9-7a0d-4fca-8991-3966436d08f7?api-ver sion=2021-05-01', Version: 1.1, Content: <null>, Headers: { Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyIsImtpZCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyJ9.eyJhdWQiOiJodHRwczovL21hbmFnZW1lbnQuY29yZS53aW5kb3dzLm5ldC8iLCJpc3Mi GtCdXF0SmRRcGd6dU9XSzFUcHNIelNDL3BlNEVLM1FNVHRwdUZNK1VDalhGZ1R3eHBDTC9RNlBJc2ZrYlVNY2FyeTJ0L252V094SGFPbXpEV2JFPSIsImFtciI6WyJwd2QiLCJyc2EiLCJtZmEiXSwiYXBwaWQiOiIxOTUwYTI1OC0yMjdiLTRlMzEtYTljZi03MTc0OTU5NDVmYzIiLCJhcHBpZGFjci I6IjAiLCJkZXZpY2VpZCI6IjE2ZDFjZmQyLTNkOGYtNDRkYy04YjBhLTFmNjFlYWM0OTdjMCIsImZhbWlseV9uYW1lIjoiU2FyYWZpZGlzIiwiZ2l2ZW5fbmFtZSI6Ik1pa2UiLCJncm91cHMiOlsiZDg0MDAwYzYtOWVhMy00ZDI3LWFlOGItNDBmZjYyNGVmZWU3IiwiNzMwZGI0MTItMzNkNi00Y2I xLThlMGQtNDE5MDk2NDQxNzg3IiwiYjBjMDMwM2UtYmVkNS00NTMwLWJmNmQtMmVlODczYzgxZTRhIiwiNTU5NmUwNGEtNWNjZi00NTUwLTlmZDctZjBjNjZmMWMwMTRiIiwiYjM2MTM3ODgtOTliYS00ZGU5LWI4MmQtM2I2NzllMTY5NDhiIiwiMTc1NDE4YzAtODQ2MS00OGUyLTk1ZTktMTA2Y2I5 YzYzZWIwIl0sImlwYWRkciI6IjEwOS4yNDIuNzYuMjU0IiwibmFtZSI6Ik1pa2UgU2FyYWZpZGlzIiwib2lkIjoiMGU4NDQyN2MtNWEwNC00NTVhLTg1ZTgtNDU5Y2EwODEyZGMxIiwicHVpZCI6IjEwMDNCRkZEQUIxRTRBN0IiLCJyaCI6IjAuQVY0QUJSRU9QS3VTUTAyZzFDaDU2c05SVUVaSWYza 0F1dGRQdWtQYXdmajJNQk5lQUZvLiIsInNjcCI6InVzZXJfaW1wZXJzb25hdGlvbiIsInN1YiI6Imt6WDByQ1VYMUc2OF9YNFZ0MWFac01QRWN1cGxmQ2hkQlNrS3l0Q0JaMlEiLCJ0aWQiOiIzYzBlMTEwNS05MmFiLTRkNDMtYTBkNC0yODc5ZWFjMzUxNTAiLCJ1bmlxdWVfbmFtZSI6InNhcmFmaW Rpc0BzZW1pdHJvbi5nciIsInVwbiI6InNhcmFmaWRpc0BzZW1pdHJvbi5nciIsInV0aSI6IkdIQWU2VmV0aVVteXpQX1JGNERyQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbIjYyZTkwMzk0LTY5ZjUtNDIzNy05MTkwLTAxMjE3NzE0NWUxMCIsImI3OWZiZjRkLTNlZjktNDY4OS04MTQzLTc2YjE5NGU 4NTUwOSJdLCJ4bXNfY2MiOlsiQ1AxIl0sInhtc190Y2R0IjoxNDIyMTEwMDQwfQ.p8kYrPCIrsCyF3-DAuaU3UByihPZMgXwAZGol6qzubhGf6NSpKE_DyLgRFQJ2JmDSQSWXgkG7houB-s09Vpvbjo5YxkEqbQNF0qAZ2DLf42eyuz4mj-B-_kHqG3YmJqi57GYE2NK32O2Oesc63Qt8UokIHxsfY0wu } ResponseHeaders : {[Cache-Control, System.String[]], [Pragma, System.String[]], [Retry-After, System.String[]], [X-Content-Type-Options, System.String[]]…} ResponseBody : {"name":"94035ce9-7a0d-4fca-8991-3966436d08f7","status":"Failed","startTime":"2023-02-06T05:48:47.55Z","error":{"code":"InternalServerError","message":"An unexpected error occured while processing the request. Tracking ID: 'd d05c1dc-7f55-4dde-99e5-7d1571fcaf21'"}} ClientRequestId : RequestId : dd05c1dc-7f55-4dde-99e5-7d1571fcaf21 Message : An unexpected error occured while processing the request. Tracking ID: 'dd05c1dc-7f55-4dde-99e5-7d1571fcaf21' Action : TargetSite : Void MoveNext() Data : {} InnerException : HelpLink : Source : Az.MySql.private HResult : -2146233088 StackTrace : at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate_Call(HttpRequestMessage request, Func`3 onOk, Func`3 onDefault, IEventListener eventListener, ISendAsync sender) at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate_Call(HttpRequestMessage request, Func`3 onOk, Func`3 onDefault, IEventListener eventListener, ISendAsync sender) at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate(String subscriptionId, String resourceGroupName, String serverName, IServerAutoGenerated body, Func`3 onOk, Func`3 onDefault, IEventListener eventList ener, ISendAsync sender) at Microsoft.Azure.PowerShell.Cmdlets.MySql.Cmdlets.NewAzMySqlFlexibleServer_CreateExpanded.ProcessRecordAsync() -
Mike Sarafidis 1 Reputation point
2023-02-06T06:30:55.54+00:00 @Rich Matheisen Regarding your provided link, I have tried to delete the whole resource group and recreate all the resources from the scratch and it always stops at the above error.
Sign in to comment
Sign in to answer