Uploaded image for project: 'RHEL'
  1. RHEL
  2. RHEL-25575

mysql_install_db fails because it fails to load provider_lz4.so

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Undefined Undefined
    • rhel-9.5.z
    • CentOS Stream 9
    • mariadb
    • Yes
    • Moderate
    • Regression
    • rhel-sst-cs-databases
    • 5
    • False
    • Hide

      None

      Show
      None
    • None
    • CentOS Stream
    • None
    • x86_64
    • None

      What were you trying to do that didn't work?

      The mysql_install_db command consistently fails. The command is executed right after mariadb-server is installed.

      ```
      $ sudo mysql_install_db --basedir=/usr --datadir=/var/lib/mysql --user=mysql
      Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...

      Installation of system tables failed!  Examine the logs in
      /var/log/mariadb/mariadb.log or /var/lib/mysql for more information.

      The problem could be conflicting information in an external
      my.cnf files. You can ignore these by doing:

          shell> /bin/mysql_install_db --defaults-file=~/.my.cnf

      You can also try to start the mariadbd daemon with:

          shell> /usr/libexec/mariadbd --skip-grant-tables --general-log &

      and use the command line tool /usr/bin/mariadb
      to connect to the mysql database and look at the grant tables:

          shell> /usr/bin/mariadb -u root mysql
          MariaDB> show tables;

      Try '/usr/libexec/mariadbd --help' if you have problems with paths.  Using
      --general-log gives you a log in /var/lib/mysql that may be helpful.

      The latest information about mysql_install_db is available at
      https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
      You can find the latest source at https://downloads.mariadb.org and
      the maria-discuss email list at https://launchpad.net/~maria-discuss

      Please check all of the above before submitting a bug report
      at https://mariadb.org/jira
      ```

      The command fails because provider_lz4.so can't be loaded.

      ```
      $ sudo cat /var/log/mariadb/mariadb.log
      2024-02-15  1:04:14 0 [ERROR] mariadbd: Can't open shared library '/usr/provider_lz4.so' (errno: 2, cannot open shared object file: No such file or directory)
      2024-02-15  1:04:14 0 [ERROR] Couldn't load plugins from 'provider_lz4.so'.
      2024-02-15  1:04:14 0 [ERROR] /usr/libexec/mariadbd: unknown variable 'provider_lz4=force_plus_permanent'
      2024-02-15  1:04:14 0 [ERROR] Aborting
      ```

      The direct trigger was `/etc/my.cnf.d/provider_lz4.cnf` added in the latest mariadb-server package, and the command succeeds if I remove that file.

      The problem is not seen if mariadb:10.11 module is disabled. The known version without this problem is 10.5.22-1 .

      Please provide the package NVR for which bug is seen:

      mariadb-10.11.6-1.module_el9+853+7b957b9b.x86_64
      mariadb-backup-10.11.6-1.module_el9+853+7b957b9b.x86_64
      mariadb-common-10.11.6-1.module_el9+853+7b957b9b.x86_64
      mariadb-connector-c-3.2.6-1.el9.x86_64
      mariadb-connector-c-config-3.2.6-1.el9.noarch
      mariadb-errmsg-10.11.6-1.module_el9+853+7b957b9b.x86_64
      mariadb-gssapi-server-10.11.6-1.module_el9+853+7b957b9b.x86_64
      mariadb-server-10.11.6-1.module_el9+853+7b957b9b.x86_64
      mariadb-server-utils-10.11.6-1.module_el9+853+7b957b9b.x86_64

      How reproducible:

      Always

      Steps to reproduce

      1. install mariadb-server
      2. run mysql_install_db

      Expected results

      mysql_install_db succeeds

      Actual results

      mysql_install_db fails

              mschorm@redhat.com Michal Schorm
              tkajinami Takashi Kajinami (Inactive)
              Michal Schorm Michal Schorm
              Jakub Heger Jakub Heger
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated: