search

microsoft / WSL

Issues found on WSL
https://docs.microsoft.com/windows/wsl
MIT License
17.43k stars 822 forks source link

MariaDB fails to start after Windows Updates #8475

Open Delicious-Bacon opened 2 years ago

Delicious-Bacon commented 2 years ago

Version

WSL version: 0.58.3.0 WSLg version: 1.0.33 MSRDC version: 1.2.2924 Direct3D version: 1.601.0 Windows version: 10.0.22000.708

WSL Version

Kernel Version

5.10.102.1

Distro Version

Ubuntu 22.04

Other Software

sudo mariadb --version

Repro Steps

Not sure how to trigger this, but it happens after Windows Updates.

I can boot up the MariaDB service only after purging and reinstalling MySQL and MariaDB. See here: https://github.com/microsoft/WSL/issues/3631#issuecomment-1145856044 https://github.com/microsoft/WSL/issues/3631#issuecomment-1147183917

Also check this thread for more info: https://stackoverflow.com/questions/72474571/ubuntu-22-04-mariadb-starting-mariadb-database-server-mariadbd-fail

This is the second time it's happened this week. I can't rely on WSL if this keeps happening.

Expected Behavior

MariaDB is supposed to work on a Linux distro. In fact, it works until I get a Windows Update and then fails to start.

Actual Behavior

sudo service mariadb restart

sudo mysqld --verbose --user root

Diagnostic Logs

No response

ghost commented 2 years ago

Hello! Where exactly is the database file stored? Is it under /mnt/c/...?

Delicious-Bacon commented 2 years ago

Hello! Where exactly is the database file stored? Is it under /mnt/c/...?

It is under /var/lib/mysql.

grooverdan commented 2 years ago

The error is crash recovery is MDEV-28870. This bug occurs when there was a crash during ddl and dml. #8443 causes a MariaDB assertion which would be a ddl crash. Is there a workload running during the upgrade?

Do you have the MariaDB logs from immediately before the failed crash recovery (something that shows a crash of sorts, or maybe just a hard kill of the server) that could narrow this down? This might show how Windows update is shutting down MariaDB.

22.04 (jammy) is listed as the Distro Version but the MariaDB logs are showing focal. Is the distro correct?

atn-prabhu commented 2 years ago

Same kernel in Windows 11 Home version 21H2 OS Build 22000.978

Experiencing MariaDB crash multiple times - with the same error messages.

Noticed that the same distro/kernel is running in my Windows 10 laptop without any issue. I even Exported from Win10 and imported the distro into Windows 11 - the database crashes.

Working fine in : Windows 10 Home version 21H2 OS Build 19044.2006

digitist commented 2 years ago

Believe I'm also now experiencing this issue in 21H2. I thought it had to do with rebooting and perhaps MariaDB not handling the signal to gracefully shutdown, but I tried shutting it down through XAMPP before reboot and problem of crashed DB persists. My next step was to drop XAMPP and move to running as service in WSL, but sounds like this isn't a solution either...

grooverdan commented 2 years ago

@digitist the same level of detail with versions as the original bug report with concrete log messages would add value to your comment.

The logs here show MDEV-28870 as the cause, and this is a data corruption bug.

Restoring from backup and running on a MariaDB version at or above 10.6.9, 10.7.5, 10.8.4, 10.9.2, 10.10.1.