database errors on install in debian testing

8 posts / 0 new
Last post
OE5JWL
database errors on install in debian testing

When install version 2.5.2, I find some errors in the database subdirectory of cqrlog.
See the log contents of mysql.err below:

2022-09-07 18:30:06 0 [Note] InnoDB: The first data file './ibdata1' did not exist. A new tablespace will be created!
2022-09-07 18:30:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-07 18:30:06 0 [Note] InnoDB: Number of pools: 1
2022-09-07 18:30:06 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-09-07 18:30:06 0 [Note] InnoDB: Using liburing
2022-09-07 18:30:06 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2022-09-07 18:30:06 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-07 18:30:06 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-07 18:30:06 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
2022-09-07 18:30:06 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 100663296 bytes
2022-09-07 18:30:07 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2022-09-07 18:30:07 0 [Note] InnoDB: New log file created, LSN=10313
2022-09-07 18:30:07 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2022-09-07 18:30:07 0 [Note] InnoDB: Doublewrite buffer created
2022-09-07 18:30:07 0 [Note] InnoDB: 128 rollback segments are active.
2022-09-07 18:30:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-07 18:30:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-07 18:30:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-09-07 18:30:07 0 [Note] InnoDB: 10.6.9 started; log sequence number 0; transaction id 3
2022-09-07 18:30:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-07 18:30:07 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2022-09-07 18:30:07 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-09-07 18:30:07 0 [Note] Server socket created on IP: '::'.
2022-09-07 18:30:07 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-07 18:30:07 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-07 18:30:07 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.9-MariaDB-1' socket: '/home/hans/.config/cqrlog/database/sock' port: 64000 Debian buildd-unstable
2022-09-07 18:30:10 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2022-09-07 18:30:10 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`bands` index `band` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`dxclusters` index `description` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`iota_list` index `iota_nr` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`iota_list` index `pref` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`dxcc_ref` index `pref` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`dxcc_ref` index `adif` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`qslmgr` index `callsign` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`qslmgr` index `fromdate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`log_list` index `log_nr` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `main_index` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `callsign` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `name` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `qth` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `adif` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `idcall` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:11 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `band` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `club_nr1` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `club_nr2` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `club_nr3` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `club_nr4` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `club_nr5` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`notes` index `callsign` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`profiles` index `nr` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club1` index `club_nr` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club1` index `fromdate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club1` index `todate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club1` index `clubcall` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club2` index `club_nr` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:12 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club2` index `fromdate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club2` index `todate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club2` index `clubcall` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club3` index `club_nr` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club3` index `fromdate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club3` index `todate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club3` index `clubcall` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club4` index `club_nr` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club4` index `fromdate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club4` index `todate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club4` index `clubcall` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club5` index `club_nr` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club5` index `fromdate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club5` index `todate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:13 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`club5` index `clubcall` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:14 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`zipcode1` index `zip` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:14 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`zipcode2` index `zip` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:14 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`zipcode3` index `zip` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:14 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`dxcc_id` index `adif` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:14 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`log_changes` index `id_cqrlog_main` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:14 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`call_alert` index `id` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2022-09-07 18:30:14 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`call_alert` index `callsign` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.

Any solution for that?
'73
OE5JWL

oh1kh
database errors on install in debian testing

HI!

Using testing OS may cause problems.

Can you create a new log #002 in "Database connection" window ?

If you can and can add a new qso to that (and you have proper backups of your #001 log) you just can import your backup to log #002 and start using it.

That is the most easiest way to get forward.

--
Saku
OH1KH

OE5JWL
The reported errors do not

The reported errors do not lead to unuseable system. I can creat a log and enter qso's.
The question is, do the errors lead to restricted system functionality?

woec
OE5JWL

oh1kh
The reported errors do not

Good question!

I would do following:

Copy ~/.config/cqrlog with all files and folders to safe place
(cp -a ~/.config/cqrlog /run/media/saku/my_usb_stick )

Then remove ~/.config/cqrlog and start Cqrlog. It will say it is the first time.. etc.
After creating and opening log #001 test that qso can be saved.
Close cqrlog and look at the error file then.

If there are no such errors present now delete ~/.config/cqrlog and restore saved ~/.config/cqrlog to it's original place.
Start Cqrlog and do Utlis/config/export in "Database connection" window, then open the log and do full adif export from log. Close Cqrlog.

Again delete ~/.config/cqrlog (you still have the backup copy) and start CQrlog and let it create log #001.
Before opening first log do utlis/config/import from just saved file.
After that open log and do adif import.

Now you should have all qsos with all configurations in fresh log.

--
Saku
OH1KH

OE5JWL
The reported errors do not

The reported errors do not lead to unuseable system. I can create a log and enter qso's.
The question is, do the errors lead to restricted system functionality?

woec
OE5JWL

oh1kh
The reported errors do not

Good question, no answer!

Just do your backups often.

How ever it would be interesting to know if errors disappear when doing a clean start without ~/.config/cqrlog folder.

--
Saku
OH1KH

OE5JWL
Hi,

Hi,
I tried what you suggested - move .config/cqrlog away and doing a clean start. Nothing changes! - Same errors in mysql.err logfile.
Johann
OE5JWL

oh1kh
The reported errors do not

HI!

I did some Googling with your erros

The most often seen error:
https://dba.stackexchange.com/questions/54608/innodb-error-table-mysql-i...

And "cant find file":
https://jira.mariadb.org/browse/MDEV-23660

You can try those, or just leave it as is if all works.

--
Saku
OH1KH