MySQL Flexible Server upgrade from 5.7 to 8

Question

MySQL Flexible Server upgrade from 5.7 to 8

Bhargav 0

I am attempting to upgrade a MySQL Flexible Server from version 5.7 to 8.0 using the Azure Portal. However, I encountered the following error during the process:

"An unexpected error occurred while processing the request. Tracking ID: '0db84bf1-c99d-4349-a341-12714576270e'"

Could you please assist in resolving this issue or provide guidance on the correct upgrade steps?

Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-12T11:52:09.2033333+00:00
Hi Bhargav,
It looks like you're encountering an issue while upgrading your Azure Database for MySQL Flexible Server from version 5.7 to 8.0. Based on similar cases, here are some steps to troubleshoot and resolve the issue:

Possible Causes & Solutions

Check Upgrade Compatibility

Before upgrading, ensure your database schema is compatible with MySQL 8.0 using the MySQL Upgrade Checker Tool.

Some stored procedures or reserved keywords may cause validation errors.

Validate Database Schema in Azure Portal

Azure provides a built-in validation tool in the portal to check for compatibility issues before upgrading.

If validation fails, review the errors and make necessary adjustments.

Avoid Simultaneous Configuration Changes

When upgrading, do not modify other properties of the database in the same request.

If you attempted to change settings alongside the upgrade, retry the upgrade separately.

Check Azure Service Health & Logs

Visit the Azure Service Health Dashboard to check for any ongoing issues in your region.

Review Azure Activity Logs for more details on why the upgrade failed.

Retry the Upgrade

If the upgrade failed due to a transient issue, retry the process after ensuring all prerequisites are met.

Would you like help checking specific compatibility issues before retrying the upgrade?
Bhargav 0 Reputation points

2025-05-12T12:20:29.1933333+00:00

checkForServerUpgrade don't provide any errors and azure portal failed in validation
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-12T12:26:24.9166667+00:00

Hi Bhargav
Could you please share the details in the private message ,Thank you.
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-14T10:03:24.2533333+00:00

Hi Bhargav,

I request you to go through the below document,

Perform a planned major version upgrade from MySQL 5.7 to MySQL 8.0 using the Azure portal for General Purpose and Business Critical SKU servers,

Perform a planned major version upgrade from MySQL 5.7 to MySQL 8.0 using the Azure portal for Burstable SKU servers

reference links:https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade#perform-a-planned-major-version-upgrade-from-mysql-57-to-mysql-80-using-the-azure-portal-for-general-purpose-and-business-critical-sku-servers

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade#perform-a-planned-major-version-upgrade-from-mysql-57-to-mysql-80-using-the-azure-portal-for-burstable-sku-servers
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-15T05:34:58.94+00:00

Hi Bhargav,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.

In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-16T04:18:41.79+00:00

Hi Bhargav,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.

In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Bhargav 0 Reputation points

2025-05-16T04:35:40.7133333+00:00

Hi @Narendra Pakkirigari
I've tried using the Azure Portal, but nothing seems to be working.
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-16T10:06:50.7866667+00:00

Hi Bhargav,

Thanks for letting me know,

Could you please share the error message over the private message.
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-19T03:51:33.7033333+00:00

Hi Bhargav,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.

In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Bhargav 0 Reputation points

2025-05-19T05:01:10.2333333+00:00

Hello, I had already shared the portal validation error screenshot earlier. Although the issue is not resolved yet

1 answer

Your answer

Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-12T11:52:09.2033333+00:00

Hi Bhargav,
It looks like you're encountering an issue while upgrading your Azure Database for MySQL Flexible Server from version 5.7 to 8.0. Based on similar cases, here are some steps to troubleshoot and resolve the issue:

Possible Causes & Solutions

Check Upgrade Compatibility

Before upgrading, ensure your database schema is compatible with MySQL 8.0 using the MySQL Upgrade Checker Tool.

Some stored procedures or reserved keywords may cause validation errors.

Validate Database Schema in Azure Portal

Azure provides a built-in validation tool in the portal to check for compatibility issues before upgrading.

If validation fails, review the errors and make necessary adjustments.

Avoid Simultaneous Configuration Changes

When upgrading, do not modify other properties of the database in the same request.

If you attempted to change settings alongside the upgrade, retry the upgrade separately.

Check Azure Service Health & Logs

Visit the Azure Service Health Dashboard to check for any ongoing issues in your region.

Review Azure Activity Logs for more details on why the upgrade failed.

Retry the Upgrade

If the upgrade failed due to a transient issue, retry the process after ensuring all prerequisites are met.

Would you like help checking specific compatibility issues before retrying the upgrade?
Bhargav 0 Reputation points

2025-05-12T12:20:29.1933333+00:00

checkForServerUpgrade don't provide any errors and azure portal failed in validation
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-12T12:26:24.9166667+00:00

Hi Bhargav
Could you please share the details in the private message ,Thank you.
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-14T10:03:24.2533333+00:00

Hi Bhargav,

I request you to go through the below document,

Perform a planned major version upgrade from MySQL 5.7 to MySQL 8.0 using the Azure portal for General Purpose and Business Critical SKU servers,

Perform a planned major version upgrade from MySQL 5.7 to MySQL 8.0 using the Azure portal for Burstable SKU servers

reference links:https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade#perform-a-planned-major-version-upgrade-from-mysql-57-to-mysql-80-using-the-azure-portal-for-general-purpose-and-business-critical-sku-servers

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade#perform-a-planned-major-version-upgrade-from-mysql-57-to-mysql-80-using-the-azure-portal-for-burstable-sku-servers
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-15T05:34:58.94+00:00

Hi Bhargav,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.

In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-16T04:18:41.79+00:00

Hi Bhargav,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.

In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Bhargav 0 Reputation points

2025-05-16T04:35:40.7133333+00:00

Hi @Narendra Pakkirigari
I've tried using the Azure Portal, but nothing seems to be working.
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-16T10:06:50.7866667+00:00

Hi Bhargav,

Thanks for letting me know,

Could you please share the error message over the private message.
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-19T03:51:33.7033333+00:00

Hi Bhargav,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.

In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Bhargav 0 Reputation points

2025-05-19T05:01:10.2333333+00:00

Hello, I had already shared the portal validation error screenshot earlier. Although the issue is not resolved yet

Answer 1

Narendra Pakkirigari 475 Microsoft External Staff Moderator

Burstable SKU is not able to support major version upgrade due to the performance limitation of this SKU.

If you need to perform a major version upgrade on your Azure Database for MySQL Flexible Server instance and are currently using Burstable SKU, one temporary solution would be to upgrade to General Purpose or Business Critical SKU, perform the upgrade, and then switch back to Burstable SKU.

Upgrading to a higher SKU might involve a change in pricing and might result in increased costs for your deployment. However, since the upgrade process is not expected to take a long time, the added costs shouldn't be significant.

Bhargav 0 Reputation points

2025-05-26T12:02:05.4933333+00:00

it is already on General Purpose
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator

2025-05-26T12:30:47.81+00:00

Hi Bhargav,,

Thanks for letting me know,

To proceed with a major version upgrade of your Azure Database for MySQL – Flexible Server (e.g., from MySQL 5.7 to 8.0), please raise a support request via the Azure portal using the steps below:

To request support for upgrading your Azure Database for MySQL Flexible Server to a newer major version, please log in to the Azure portal and navigate to Help + support, then click Create a support request. For the issue type, select Technical, and for the service, choose Azure Database for MySQL Flexible Server. Under problem type, select Server Configuration or Version Management, and then choose Upgrade major version as the problem subtype. In the description box, include details such as your current MySQL version, the version you want to upgrade to, and a brief note requesting guidance on how to perform the upgrade. Once the request is submitted, Azure support will review it and assist you with the upgrade process.

Share via

MySQL Flexible Server upgrade from 5.7 to 8

Possible Causes & Solutions

1 answer

Your answer