[MDEV-31637] Impossible to upgrade MariaDB (either 10.X / 11.X) on Windows. Created: 2023-07-06  Updated: 2023-08-11  Resolved: 2023-08-01

Status: Closed
Project: MariaDB Server
Component/s: Upgrades
Fix Version/s: 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2, 11.2.1

Type: Task Priority: Critical
Reporter: LACROIX Aurélien Assignee: Oleg Smirnov
Resolution: Duplicate Votes: 0
Labels: None

Attachments: Text File mysql_upgrade_service.MariaDB.log    
Issue Links:
Duplicate
duplicates MDEV-30639 Upgrade to 10.6 and later does not wo... Closed
Relates
relates to MDEV-31891 Unable to upgrade on Windows Closed

 Description   

Hi everyone,

On Windows, I'm trying to update MariaDB either to 10.11.4 or 11.0.2, and I got the same result, the "upgrade_wizard" is stuck on step 5 and is waiting for the service to start.
I try to use “E:\SYSAPP\WEB\MariaDB_10_11_4\bin\mysql_upgrade_service.exe --service=MariaDB" ==> It fails with the same as the upgrade_wizard.

I also tried to do it manually:

By running “E:\SYSAPP\WEB\MariaDB_10_11_4\bin\mysqld.exe --defaults-file=F:\MariaDB\my.ini --loose-innodb-fast-shutdown=1 --enable-named-pipe --socket=mysql_upgrade_service_3080 --skip-slave-start"

==>I’ve remove the “skip-networking” because it solved the problems where the command bellow couldn’t see the services running "E:\SYSAPP\WEB\MariaDB_10_11_4\bin\mysqladmin.exe --protocol=pipe --socket=mysql_upgrade_service_3080 ping --no-beep" ==> seems to work if the “skip-networking” is missing.

Then I run: "E:\SYSAPP\WEB\MariaDB11\bin\mysql_upgrade.exe -P 3308 -v" just to check
And it says back:
“Looking for 'mariadb.exe' as: E:\SYSAPP\WEB\MariaDB_10_11_4\bin\mariadb.exe
The system cannot find the file specified.
Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
FATAL ERROR: Upgrade failed”

There are no user permissions issues, because I used admin access to run this. All the files are in the correct folder, i think there is an issue inside the ".exe" that's not working properly.

Can someone check this, i read other comments about that on the MariaDB website, so I'm not the only one.

Thanks for your help.



 Comments   
Comment by Oleg Smirnov [ 2023-08-01 ]

Almost certainly this is the same case as MDEV-30639. It will be fixed in the upcoming releases.

Comment by David Charleston [ 2023-08-10 ]

@Oleg Smirnov When cirka can we expect the "upcoming releases"?

I'm experiencing this exact issue going from 10.10.2 to 10.11.4

Comment by Sergei Golubchik [ 2023-08-11 ]

Any day now

Generated at Thu Feb 08 10:25:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.