ubuntu 22.04 -> 24.04: Data Dictionary initialization failed (solved)

2 posts / 0 new
Last post
dd0ul
dd0ul's picture
ubuntu 22.04 -> 24.04: Data Dictionary initialization failed (solved)

Moin,

I updated my linux box from Ubuntu 22.04 to 24.04. Bur cqrlog won't start any longer. There is a problem with the database, but the directory ~/.config/cqrlog/ looks good so far.

2024-12-20T15:46:48.075039Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40-0ubuntu0.24.04.1) starting as process 87455
2024-12-20T15:46:48.076464Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-12-20T15:46:48.076476Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-12-20T15:46:48.090093Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-12-20T15:46:48.090207Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-12-20T15:46:48.090234Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-12-20T15:46:48.091014Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.40-0ubuntu0.24.04.1) (Ubuntu).
2024-12-20T15:51:13.948278Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40-0ubuntu0.24.04.1) starting as process 90632
2024-12-20T15:51:13.949345Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-12-20T15:51:13.949358Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-12-20T15:51:13.967778Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-12-20T15:51:13.967929Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-12-20T15:51:13.967949Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-12-20T15:51:13.968408Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.40-0ubuntu0.24.04.1) (Ubuntu).

Database version is 8.0:
renner@solaris:~$ dpkg --list | grep mysql
rc akonadi-backend-mysql 4:24.12.0-0zneon+24.04+noble+release+build19 amd64 MySQL storage backend for Akonadi
ii default-mysql-server 1.1.0build1 all MySQL database server binaries and system database setup (metapackage)
ii libmysqlclient21:amd64 8.0.40-0ubuntu0.24.04.1 amd64 MySQL database client library
ii libqt5sql5-mysql:amd64 5.15.16+p24.04+vrelease+git20241207.0024-0 amd64 Qt 5 MySQL database driver
ii libreoffice-sdbc-mysql 4:24.2.7-0ubuntu0.24.04.1 amd64 MariaDB/MySQL SDBC driver for LibreOffice
ii mariadb-common 1:10.11.8-0ubuntu0.24.04.1 all MariaDB database common files (e.g. /etc/mysql/mariadb.conf.d/)
ii mysql-client-8.0 8.0.40-0ubuntu0.24.04.1 amd64 MySQL database client binaries
ii mysql-client-core-8.0 8.0.40-0ubuntu0.24.04.1 amd64 MySQL database core client binaries
ii mysql-common 5.8+1.1.0build1 all MySQL database common files, e.g. /etc/mysql/my.cnf
ii mysql-server-8.0 8.0.40-0ubuntu0.24.04.1 amd64 MySQL database server binaries and system database setup
ii mysql-server-core-8.0 8.0.40-0ubuntu0.24.04.1 amd64 MySQL database server binaries

Any hint?

vy73 de Micha, DD0UL

dd0ul
dd0ul's picture
Solved by replacing mysql with mariadb

Moin,

today I saw that kontact (the KDE mailclient) won't start. I isolated the database as the problem. So I replaced mysql 8.0 with mariadb 10.11. Now kontact and cqrlog are operating as they should.

root@solaris:~# pkcon install mariadb-server
Resolving [=========================]
Testing changes [=========================]
Finished [ ] (0%)
The following packages have to be installed:
galera-4-26.4.16-2build4.amd64 Replication framework for transactional applications
libconfig-inifiles-perl-3.000003-2.all read .ini-style configuration files
libdbd-mysql-perl-4.052-1ubuntu3.amd64 Perl5 database interface to the MariaDB/MySQL database
libdbi-perl-1.643-4build3.amd64 Perl Database Interface (DBI)
libterm-readkey-perl-2.38-2build4.amd64 perl module for simple terminal control
mariadb-client-1:10.11.8-0ubuntu0.24.04.1.amd64 MariaDB database client binaries
mariadb-client-core-1:10.11.8-0ubuntu0.24.04.1.amd64 MariaDB database core client binaries
mariadb-plugin-provider-bzip2-1:10.11.8-0ubuntu0.24.04.1.amd64 BZip2 compression support in the server and storage engines
mariadb-plugin-provider-lz4-1:10.11.8-0ubuntu0.24.04.1.amd64 LZ4 compression support in the server and storage engines
mariadb-plugin-provider-lzma-1:10.11.8-0ubuntu0.24.04.1.amd64 LZMA compression support in the server and storage engines
mariadb-plugin-provider-lzo-1:10.11.8-0ubuntu0.24.04.1.amd64 LZO compression support in the server and storage engines
mariadb-plugin-provider-snappy-1:10.11.8-0ubuntu0.24.04.1.amd64 Snappy compression support in the server and storage engines
mariadb-server-1:10.11.8-0ubuntu0.24.04.1.amd64 MariaDB database server binaries
mariadb-server-core-1:10.11.8-0ubuntu0.24.04.1.amd64 MariaDB database core server files
The following packages have to be removed:
default-mysql-server-1.1.0build1.all MySQL database server binaries and system database setup (metapackage)
mysql-client-8.0-8.0.40-0ubuntu0.24.04.1.amd64 MySQL database client binaries
mysql-client-core-8.0-8.0.40-0ubuntu0.24.04.1.amd64 MySQL database core client binaries
mysql-server-8.0-8.0.40-0ubuntu0.24.04.1.amd64 MySQL database server binaries and system database setup
mysql-server-core-8.0-8.0.40-0ubuntu0.24.04.1.amd64 MySQL database server binaries
Proceed with changes? [N/y] y

[=========================]
Installing [=========================]
Loading cache [=========================]
Downloading packages [=========================]
Running [=========================]
Removing packages [=========================]
Installing packages [=========================]
Removing packages [=========================]
Installing packages [=========================]
Finished [=========================]
root@solaris:~#

vy73 de Micha, DD0UL