Database Problem

3 posts / 0 new
Last post
KI0EB
Database Problem

Hello,
I just tried to install cqrlog on a linux mint machine. I got the dialog box: "Database problem". Below is the info frmo the mysql.errfile.

Any recommendations will be welcome.

thanks
Kevin Fontes

2022-11-19T18:37:51.632797Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.22.04.1) starting as process 3019
2022-11-19T18:37:51.651119Z 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.
2022-11-19T18:37:51.651195Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-11-19T18:37:51.712303Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 461d916c-6839-11ed-a369-4cbb58dcc23c.
2022-11-19T18:37:51.767443Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-11-19T18:37:51.767941Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-11-19T18:37:51.768040Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-11-19T18:37:51.769502Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31-0ubuntu0.22.04.1) (Ubuntu).
2022-11-19T18:38:46.556726Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.22.04.1) starting as process 3036
2022-11-19T18:38:46.560984Z 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.
2022-11-19T18:38:46.561017Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-11-19T18:38:46.575741Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-11-19T18:38:46.576435Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-11-19T18:38:46.576542Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-11-19T18:38:46.577658Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31-0ubuntu0.22.04.1) (Ubuntu).
2022-11-19T18:58:44.936066Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.22.04.1) starting as process 4922
2022-11-19T18:58:44.985712Z 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.
2022-11-19T18:58:44.985784Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-11-19T18:58:45.068313Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-11-19T18:58:45.068633Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-11-19T18:58:45.068670Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-11-19T18:58:45.069676Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31-0ubuntu0.22.04.1) (Ubuntu).
2022-11-19T19:17:03.945669Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.22.04.1) starting as process 5461
2022-11-19T19:17:03.949964Z 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.
2022-11-19T19:17:03.949998Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-11-19T19:17:03.964291Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-11-19T19:17:03.964653Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-11-19T19:17:03.964711Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-11-19T19:17:03.965888Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31-0ubuntu0.22.04.1) (Ubuntu).
2022-11-19T19:21:56.624676Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.22.04.1) starting as process 6265
2022-11-19T19:21:56.653618Z 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.
2022-11-19T19:21:56.653654Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-11-19T19:21:56.748262Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-11-19T19:21:56.748586Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-11-19T19:21:56.748630Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-11-19T19:21:56.756273Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31-0ubuntu0.22.04.1) (Ubuntu).
2022-11-19T19:30:06.303721Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.22.04.1) starting as process 3083
2022-11-19T19:30:06.330476Z 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.
2022-11-19T19:30:06.330627Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-11-19T19:30:06.404683Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-11-19T19:30:06.405762Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-11-19T19:30:06.405871Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-11-19T19:30:06.407314Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31-0ubuntu0.22.04.1) (Ubuntu).

oh1kh
Database Problem

HI Kevin!
Here is the problem: "Shutdown complete (mysqld 8.0.31-0ubuntu0.22.04.1)"
That has recently happened so many times.

There is an error in Ubuntu based linuxes. Packet managers do installation packets with mysql 8.0 as dependency of Cqrlog.

How ever Cqrlog needs MariaDB instead.

Install MariaDB server and client with your packet manager. That should remove Mysql 8.0 and after that Cqrlog should start.

--
Saku
OH1KH

lx2gt
Hello,

Hello,

People should report such bugs to their distribution. For Ubuntu I found an existing one on launchpad: https://bugs.launchpad.net/ubuntu/+source/cqrlog/+bug/1872002

The more people who mark the bug that it is affecting them, the better.

73 de Luc, LX2GT