MySQL error

2 posts / 0 new
Last post
AE4WX
MySQL error

I'm unable to get CQRLOG to start due to a MySQL error. I am running Ubunti 22.04 LTS. Any thoughts? Tnx 73 de AE4WX

Here is the mysql.err file:

2024-03-30T13:13:12.170130Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 11688
2024-03-30T13:13:12.174064Z 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-03-30T13:13:12.174069Z 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.
2024-03-30T13:13:12.177218Z 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: 42b62c61-ee97-11ee-8fed-6c3c8cfda0f4.
2024-03-30T13:13:12.179879Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-03-30T13:13:12.179971Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-30T13:13:12.179982Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-30T13:13:12.180213Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-03-30T13:19:34.702089Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 12023
2024-03-30T13:19:34.703357Z 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-03-30T13:19:34.703365Z 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.
2024-03-30T13:19:34.708945Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-03-30T13:19:34.709053Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-30T13:19:34.709066Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-30T13:19:34.709314Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-03-30T13:20:44.037444Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 12311
2024-03-30T13:20:44.038341Z 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-03-30T13:20:44.038346Z 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.
2024-03-30T13:20:44.043431Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-03-30T13:20:44.043712Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-30T13:20:44.043726Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-30T13:20:44.043957Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-03-30T13:25:34.847326Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 13572
2024-03-30T13:25:34.847836Z 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-03-30T13:25:34.847841Z 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.
2024-03-30T13:25:34.852829Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-03-30T13:25:34.852948Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-30T13:25:34.852965Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-30T13:25:34.853180Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1)

oh1kh
MySQL error

2024-03-30T13:13:12.170130Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 11688

You have mysql and Cqrlog needs MariaDB.

You should install MaridB https://www.cqrlog.com/comment/8349#comment-8349

--
Saku
OH1KH