Can not load local database

2 posts / 0 new
Last post
Can not load local database

Trying to revert to using local database (not via 3306 port). Gets the following error from mysql.err;

2022-10-10 0:12:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-10-10 0:12:48 0 [Note] InnoDB: Number of pools: 1
2022-10-10 0:12:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-10-10 0:12:48 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2022-10-10 0:12:48 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-10 0:12:48 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300594304,300594304
2022-10-10 0:12:48 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 300594304 between the checkpoint 300594304 and the end 300594316.
2022-10-10 0:12:48 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-10-10 0:12:48 0 [Note] InnoDB: Starting shutdown...
2022-10-10 0:12:48 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-10 0:12:48 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-10 0:12:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-10 0:12:48 0 [ERROR] Unknown/unsupported storage engine: innodb
2022-10-10 0:12:48 0 [ERROR] Aborting

Help appreciated.

73 de Olaf - LA3RK

PS Transferred the log to a local server, but connection seems to slow to be practical, generates a lot of delays and tried to revert to the local database, but got the above error.

Can not load local database

Hi Olaf!

If local database (localhost : 3306) is slow there is serious error(s) in system, I think.
I suspect running a SQL thread from ~/.config/cqrlog/database does not change situation.

Anyhow. If you had log at localhost 3306 server it is best to run full adif backup with Database connection/utils/configuration export from every log.
Then start Cqrlog with "save log data to local machine" cheked and create a new clean log. Test it wit few fake qso, then delete them.

If it seems to work then restart cqrlog and while in database connection window (log not yet opened) make utils/configuration/import, then open the log and do adif import and start to use the new log.