Upgraded from Ubuntu 20.04 to 22.04 and now having problems - HELP!

3 posts / 0 new
Last post
w7ck
Upgraded from Ubuntu 20.04 to 22.04 and now having problems - HELP!

After upgrade, CQRLog can't open my logbook databases.

Here's a print of the last 20 or so lines from mysql.err

Is it true that 22.04 no longer supports MySQL and everyone has to move to MariaDB? I don't even know how to do that yet. Once MySQL has been remove (not sure how) and MariaDB installed, will CQRLog be able to open my old log files?

Here's last few lines of mysql.err

2022-09-16 9:36:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-16 9:36:50 0 [Note] InnoDB: Number of pools: 1
2022-09-16 9:36:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-09-16 9:36:50 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2022-09-16 9:36:50 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-16 9:36:50 0 [Note] InnoDB: 128 rollback segments are active.
2022-09-16 9:36:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-16 9:36:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-16 9:36:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-09-16 9:36:50 0 [Note] InnoDB: 10.6.7 started; log sequence number 271561010; transaction id 148947
2022-09-16 9:36:50 0 [Note] InnoDB: Loading buffer pool(s) from /home/norm/.config/cqrlog/database/ib_buffer_pool
2022-09-16 9:36:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-16 9:36:50 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2022-09-16 9:36:50 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-09-16 9:36:50 0 [Note] Server socket created on IP: '::'.
2022-09-16 9:36:50 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2022-09-16 9:36:50 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2022-09-16 9:36:50 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.7-MariaDB-2ubuntu1.1' socket: '/home/norm/.config/cqrlog/database/sock' port: 64000 Ubuntu 22.04
2022-09-16 9:36:50 0 [Note] InnoDB: Buffer pool(s) load completed at 220916 9:36:50

w7ck
Sorry folks for the duplicate

Sorry folks for the duplicate posts and for not reading down thru previous posts.

I was able to resolve the issue by running the following:

sudo apt-get install mariadb-client-10.6 mariadb-server-10.6 libmariadb3 libssl-dev libmariadb-dev-compat

followed by:

sudo apt autoremove

Everything seems to be working fine now.....

SM6USS
SM6USS's picture
Great!

Great that you manage to fix it. :-)
Thanks for the info abt how you did it!

Member of: SK6AW & SK6AL
Lifemember of: SSA (Swedish bureau)