¿ªÔÆÌåÓý

CQRlog mySQL error


 

I just tried to open for the first time CQRlog on my freshly installed HamPC stick.

Unless the HamPi (where it worked without any problems last night), I got a severe mySQL error:

2022-08-21T19:23:00.188690Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.22.04.1) starting as process 7165
2022-08-21T19:23:00.191332Z 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-08-21T19:23:00.191354Z 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-08-21T19:23:00.197053Z 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: ab521026-2186-11ed-bccd-84a6c8e3985b.

Until here, only some warnings, not so important, but now:

2022-08-21T19:23:00.206528Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-08-21T19:23:00.206733Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-08-21T19:23:00.206770Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-21T19:23:00.207129Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.22.04.1) (Ubuntu).

The databases could not be created and the logbook cannot work.

For the moment, I don't know what should I do. Can anybody help me?

73
Udo, HB9ERD


 

¿ªÔÆÌåÓý



Hello Udo,

Considering HamPC is a customized version of Ubuntu 22.04 for X86 and not the usual focus of Raspberry Pi OS (and other distros) on Raspberry Pi hardware, it might be best to post this question to the dedicated email list for that ISO at [email protected] .? That said, if you search for "cqrlog 'Failed to find valid data directory'", you'll find several hits:

?? - ::? recommends to use MariaDB instead though this seems like a poor recommendation
?? - :: also recommends to switch to MariaDB
?? - :: again recommends to use MariaDB
?? - :: again recommends to use MariaDB


Seems pretty clear that the recommended solution is to switch databases.? That's strange to me so it might be worth asking on the HamPC email list if anyone has ever gotten CQRlog working on this image before.? This might be an issue with the ISO that needs to be corrected.

--David
KI6ZHD



On 08/21/2022 01:04 PM, Udo Isaenko wrote:

I just tried to open for the first time CQRlog on my freshly installed HamPC stick.

Unless the HamPi (where it worked without any problems last night), I got a severe mySQL error:

2022-08-21T19:23:00.188690Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.22.04.1) starting as process 7165
2022-08-21T19:23:00.191332Z 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-08-21T19:23:00.191354Z 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-08-21T19:23:00.197053Z 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: ab521026-2186-11ed-bccd-84a6c8e3985b.

Until here, only some warnings, not so important, but now:

2022-08-21T19:23:00.206528Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-08-21T19:23:00.206733Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-08-21T19:23:00.206770Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-21T19:23:00.207129Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.22.04.1) (Ubuntu).

The databases could not be created and the logbook cannot work.

For the moment, I don't know what should I do. Can anybody help me?

73
Udo, HB9ERD







 

Hello David

Thanks for the hints and sorry, I indeed clicked on the wrong mailing list address when I quickly described my problem. Later, I remarked my error and sent the same mail to the right list, and W3DJS wrote he will look for a solution.

So, this thread can be regarded as "closed" here on this list.

By the way, normally, MariaDB (as a free fork of mySQL) is always installed in Distros instead of the original mySQL, with a symlink from mysql to MariaDB. But I have to investigate this, probably, to be sure.

73
Udo, HB9ERD

Am 22.08.22 um 03:29 schrieb David Ranch:

Hello Udo,
Considering HamPC is a customized version of Ubuntu 22.04 for X86 and not the usual focus of Raspberry Pi OS (and other distros) on Raspberry Pi hardware, it might be best to post this question to the dedicated email list for that ISO at [email protected] .? That said, if you search for "cqrlog 'Failed to find valid data directory'", you'll find several hits:
?? - ::? recommends to use MariaDB instead though this seems like a poor recommendation
?? - :: also recommends to switch to MariaDB
?? - :: again recommends to use MariaDB
?? - :: again recommends to use MariaDB
Seems pretty clear that the recommended solution is to switch databases.? That's strange to me so it might be worth asking on the HamPC email list if anyone has *ever gotten* CQRlog working on this image before.? This might be an issue with the ISO that needs to be corrected.
--David
KI6ZHD
On 08/21/2022 01:04 PM, Udo Isaenko wrote:
I just tried to open for the first time CQRlog on my freshly installed HamPC stick.

Unless the HamPi (where it worked without any problems last night), I got a severe mySQL error:

2022-08-21T19:23:00.188690Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.22.04.1) starting as process 7165
2022-08-21T19:23:00.191332Z 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-08-21T19:23:00.191354Z 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-08-21T19:23:00.197053Z 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: ab521026-2186-11ed-bccd-84a6c8e3985b.

Until here, only some warnings, not so important, but now:

2022-08-21T19:23:00.206528Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-08-21T19:23:00.206733Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-08-21T19:23:00.206770Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-21T19:23:00.207129Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.22.04.1) (Ubuntu).

The databases could not be created and the logbook cannot work.

For the moment, I don't know what should I do. Can anybody help me?

73
Udo, HB9ERD