SQL Start

3 posts / 0 new
Last post
w9jun
SQL Start

2022-11-09T12:52:41.795835Z 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-09T12:52:41.795916Z 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-09T12:52:41.818532Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-11-09T12:52:41.819372Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-11-09T12:52:41.819517Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-11-09T12:52:41.821184Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31-0ubuntu0.22.04.1) (Ubuntu).
2022-11-09T12:53:21.508289Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.22.04.1) starting as process 30720
2022-11-09T12:53:21.514999Z 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-09T12:53:21.515040Z 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-09T12:53:21.537789Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-11-09T12:53:21.538501Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-11-09T12:53:21.538680Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-11-09T12:53:21.540379Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31-0ubuntu0.22.04.1) (Ubuntu).
2022-11-09T13:06:45.546665Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.22.04.1) starting as process 3054
2022-11-09T13:06:45.554868Z 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-09T13:06:45.554958Z 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-09T13:06:45.582584Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-11-09T13:06:45.583454Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-11-09T13:06:45.583608Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-11-09T13:06:45.585377Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31-0ubuntu0.22.04.1) (Ubuntu).

oh1kh
SQL start

Hi!
Seems that you have Mysql 8.0 installed. Cqrlog needs MariaDB server/ client installed instead.
Installing MariaDB will remove Mysql 8.

This is the most common bug with Ubuntus.

--
Saku
OH1KH

w9jun
SQL Start

Thanks,

I have fixed that issue.

Don Porter, W9JUN