-
Bug
-
Resolution: Unresolved
-
Undefined
-
None
-
CentOS Stream 9
-
Yes
-
Moderate
-
Regression
-
rhel-sst-cs-databases
-
5
-
False
-
-
None
-
CentOS Stream
-
None
-
None
-
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
- install mariadb-server
- run mysql_install_db
Expected results
mysql_install_db succeeds
Actual results
mysql_install_db fails
- blocks
-
RDO-241 mariadb-10.11is breaking all RDO releases on CS9
- Closed
- is blocked by
-
RHEL-40862 [Tracker] Rebase MariaDB to version 10.11.xx in RHEL 8
- In Progress
-
RHEL-40863 [Tracker] Rebase MariaDB to version 10.11.xx in RHEL 9
- In Progress