[MDEV-27814] Mariadb_Upgrade_Wizard fails from 10.5 to 10.6 Created: 2022-02-11  Updated: 2022-02-11

Status: Open
Project: MariaDB Server
Component/s: Platform Windows, Upgrades
Affects Version/s: 10.6.5
Fix Version/s: 10.6

Type: Bug Priority: Major
Reporter: Joan Samà Camí Assignee: Rucha Deodhar
Resolution: Unresolved Votes: 0
Labels: Migration, upgrade
Environment:

Windows

Attachments: PNG File MicrosoftTeams-image (8).png     File P201600204.err    
Issue Links:
Problem/Incident
is caused by MDEV-8334 Rename utf8 to utf8mb3 Closed

 Description   

The mariadb_upgrade_wizard process fails upgrading to any 10.6.x if "old_mode=" is configured on my.ini.
Removing old_mode the upgrade works fine and can be set again after the update has finished.
The problem is when upgrading from 10.5 to 10.6, the wizard does not ends and the service is still pointing to 10.5.
I attach the error message and the server's log.
Hope this will help.

 Comments   
Comment by Vladislav Vaintroub [ 2022-02-11 ]

I'm reassigning this to rucha174, since it seems caused by MDEV-8334 UTF8_IS_UTF8MB3 or whatever the name for it was. I'm unfamiliar with it. But please reassign back if it is turns out MDEV-8334 was not the reason.

Rather than fixing it for Windows only ( which I could do) it should be ensured than upgrade starts and runs successfully if empty "old_mode=" was explicitly set in the config file everywhere, not on Windows only. The variable is not deprecated, empty value is still valid and was former default, so users do not have to remove it from my.ini/cnf

This way all other upgrades would succeed, also the Linux ones.

Perhaps, it will be enough only to set the variable explicitly inside the upgrade sql scripts, but rucha174 will know it better

Generated at Thu Feb 08 09:55:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.