Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.5.9
-
None
-
Ubuntu 18.04
Description
We use mariadb galera managed by systemd on Ubuntu 18.04. There is datadir set to environment in systemd config:
Environment='MYSQLD_MULTI_INSTANCE=--defaults-file=/etc/mysql/mariadb-%I.cnf \
|
--pid-file=/var/run/mariadb-%I/mariadb.pid \
|
--port=%I \
|
--socket=/var/run/mariadb-%I/mariadb.sock \
|
--datadir=/var/lib/mariadb-%I \
|
--tmpdir=/run/mariadb-%I'
|
I've needed to add one server into cluster but it keep failing. I've check logs and found this line:
necy1 -innobackupex-move: [00] 2021-02-23 17:08:48 Error: Move file ibdata1 to /var/lib/mysql/ibdata1 failed: Destination file exists
|
This is default datadir, which we don't use. innobackupex-move seems to ignore environment settings. After adding datadir into mariadb config file innobackupex-move and whole process succeded.
wsrep_sst_method is set to mariabackup
I've added systemd config file for mariadb service.
Attachments
Issue Links
- relates to
-
MDEV-23580 galera_3nodes.galera_ipv6_rsync_section MTR failed: WSREP_SST: [ERROR] rsync daemon port '16008' has been taken
- Closed