Forwarded to devs logrotate: my_print_defaults: unknown option '--mariadbd' with MariaDB 10.5

[obendev]

User name: obendev

TITLE

logrotate: my_print_defaults: unknown option '--mariadbd' with MariaDB 10.5

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Plesk Obsidian v18.0.30_build1800200914.12 os_Ubuntu 18.04

PROBLEM DESCRIPTION

In MariaDB version 10.5, my_print_defaults gets called with the option --mariadb, instead of --mysqld

MDEV-22569: Run bin/mariadbd instead of bin/mysqld · MariaDB/server@7803601

Replace all references to /usr/sbin/mysqld (and bin and libexec) with mariadbd, so that the binary server will always be 'mariadbd'. Also update all places that reference the server binary...

github.com

MariaDB/server

STEPS TO REPRODUCE

Upgrade to the latest MariaDB version using curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash (Installing MariaDB .deb Files)

ACTUAL RESULT

Plesk doesn't know --mariadb

EXPECTED RESULT

Plesk should know --mariadb

ANY ADDITIONAL INFORMATION



YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[IgorG]

From developer:

Before:

root@a10-52-55-192:~# grep -r my_print_defaults /etc/logrotate.* /opt/psa/etc/logrotate.*
root@a10-52-55-192:~# grep -r -- --mariadb /etc/logrotate.* /opt/psa/etc/logrotate.*
root@a10-52-55-192:~# grep -r -- --mysqld /etc/logrotate.* /opt/psa/etc/logrotate.*
root@a10-52-55-192:~#

After upgrading to MariaDB 10.5:

root@a10-52-55-192:~# curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
[info] Repository file successfully written to /etc/apt/sources.list.d/mariadb.list
[info] Adding trusted package signing keys...
[info] Running apt-get update...
[info] Done adding trusted package signing keys
root@a10-52-55-192:~# apt-get install mariadb-server mariadb-client
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  galera-4 libdbd-mysql-perl libdbi-perl libmariadb3 libpcre2-8-0 libreadline5 mariadb-client-10.5 mariadb-client-core-10.5 mariadb-common mariadb-server-10.5 mariadb-server-core-10.5
  socat
Suggested packages:
  libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl mariadb-test
The following packages will be REMOVED:
  mysql-client-5.7 mysql-client-core-5.7 mysql-server mysql-server-5.7 mysql-server-core-5.7
The following NEW packages will be installed:
  galera-4 libdbd-mysql-perl libdbi-perl libmariadb3 libpcre2-8-0 libreadline5 mariadb-client mariadb-client-10.5 mariadb-client-core-10.5 mariadb-common mariadb-server
  mariadb-server-10.5 mariadb-server-core-10.5 socat
0 upgraded, 14 newly installed, 5 to remove and 170 not upgraded.
Need to get 23.5 MB of archives.
After this operation, 42.9 MB of additional disk space will be used.
Do you want to continue? [Y/n]
...

The keywords are only encountered in MariaDB 10.5 packages:

root@a10-52-55-192:~# grep -r my_print_defaults /etc/logrotate.* /opt/psa/etc/logrotate.*
/etc/logrotate.d/mysql-server:          if [ -f `my_print_defaults --mariadbd | grep -oP "pid-file=\K[^$]+"` ]; then
root@a10-52-55-192:~# grep -r -- --mariadb /etc/logrotate.* /opt/psa/etc/logrotate.*
/etc/logrotate.d/mysql-server:          if [ -f `my_print_defaults --mariadbd | grep -oP "pid-file=\K[^$]+"` ]; then
root@a10-52-55-192:~# grep -r -- --mysqld /etc/logrotate.* /opt/psa/etc/logrotate.*
root@a10-52-55-192:~# dpkg -S /etc/logrotate.d/mysql-server
mariadb-server-10.5: /etc/logrotate.d/mysql-server

Also, the keywords are not encountered in Plesk codebase.
So I don't see any issues or problems caused by Plesk here.

 

[obendev]

fyi

[MDEV-22659] Create one single unified and optimal logrotate config - Jira

jira.mariadb.org

danblack said it's safe to use a workaround in a prod environment: logrotate reports "my_print_defaults: unknown option '--mariadbd'"