Public bug reported:

Ubuntu Release
Description:    Ubuntu 20.04 LTS
Release:        20.04

Package Version
mariadb-server-10.3:
  Installed: 1:10.3.22-1ubuntu1
  Candidate: 1:10.3.22-1ubuntu1
  Version table:
 *** 1:10.3.22-1ubuntu1 500
        500 http://ap-southeast-2.ec2.archive.ubuntu.com/ubuntu focal/universe 
amd64 Packages
        100 /var/lib/dpkg/status

When using galera with MariaDB, MariaDB fails to start with the
following error:

mariadb.service - MariaDB 10.3.22 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor 
preset: enabled)
     Active: failed (Result: exit-code) since Tue 2020-06-23 13:19:06 UTC; 9s 
ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 1143 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d 
/var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 1155 ExecStartPre=/bin/sh -c systemctl unset-environment 
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 1157 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && 
VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-envir>

Jun 23 13:19:06 hostname systemd[1]: Starting MariaDB 10.3.22 database server...
Jun 23 13:19:06 hostname sh[1158]: /usr/bin/galera_recovery: 71: cannot create 
/tmp/wsrep_recovery.xBNq83: Permission denied
Jun 23 13:19:06 hostname systemd[1]: mariadb.service: Control process exited, 
code=exited, status=1/FAILURE
Jun 23 13:19:06 hostname systemd[1]: mariadb.service: Failed with result 
'exit-code'.
Jun 23 13:19:06 hostname systemd[1]: Failed to start MariaDB 10.3.22 database 
server.

This appears to be happening because 20.04 LTS has "fs.protected_regular
= 1" by default and "galera_recovery" in MariaDB 10.3 doesn't support
this. It has been fixed upstream in MariaDB 10.5
(https://github.com/MariaDB/server/pull/1417/files) but hasn't been
backported to 10.3.22.

Applying the fix to /usr/bin/galera_recovery fixes the issue.

J

** Affects: mariadb-10.3 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1884780

Title:
  MariaDB fails to start when using galera cluster on 20.04 LTS

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mariadb-10.3/+bug/1884780/+subscriptions

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to