if you drop this whole line:

but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead

to google search there will be many hits and possible fixes. It looks like database is corrupted.
One was happened because hard disk was full. How about yours? Check this in console with command:

df -h

And one because permissions to database files were somehow went wrong. To be sure for that give console command:

sudo chown -R name.name /home/name

Where "name" is your username.
Sudo is there in case there is files owned by root in your user directory. (Never run cqrlog as root!) If you have common cqrlog setup your database files are at your /home/name/.config/cqrlog/database folder and they will be checked with that command.
If you use system mysql server at localhost(or any other adderss) at port 3306 with cqrlog then you have to check server database files different way depending your setup.

One solution would be to export all qsos to adif. Then save all settings from "file/open or create new log/Utils/configuration/export". Then move your cqrlog files to save place. Shut down cqrlog first (then from console):

mv ~/.config/cqrlog ~/.config/cqrlog_save

Then start it again and it starts like you never had used it before. Create new log. Import settings to new log from "file/open or create new log/Utils/configuration/import" and last do adif import of all qsos.