Hello CQRLOG,
yesterday I switched from MySQL- to MariaDB-Server.
All was okay. CQRLOG was working.
Later the day I checked "mysql.err" again - some strange messages in there.
I solved this doing reinstall from backup (settings and adif).
Then all was okay again.
Just some messages are still there:
2020-04-27 7:35:25 140008684309632 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2020-04-27 7:35:25 140008684309632 [Note] Server socket created on IP: '::'.
2020-04-27 7:35:25 140008684309632 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2020-04-27 7:35:25 140008683923200 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2020-04-27 7:35:25 140008684309632 [Note] Reading of all Master_info entries succeeded
2020-04-27 7:35:25 140008684309632 [Note] Added new Master_info '' to hash table
2020-04-27 7:35:25 140008684309632 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.44-MariaDB-0ubuntu0.18.04.1' socket: '/home/martin/.config/cqrlog/database/sock' port: 64000 Ubuntu 18.04
2020-04-27 07:35:26 7f564fda3700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
So missing tables: mysql.servers, mysql.time_zone_leap_second, mysql.gtid_slave_pos, mysql"."innodb_table_stats ??
System is:
Linux martin-workstation 5.3.0-46-generic #38~18.04.1-Ubuntu SMP Tue Mar 31 04:17:56 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
cqrlog 2.4.0 118, selfcompiled
73 de Martin, DL1MTG
HI Martin!
Does these affect to usage of cqrlog, or are they just there but cqrlog works?
I have very seldom peeked mysql.err file, almost ever, mainly because I use the "real" mysql server at localhost:3306.
Yesterday I was testing "save log data to local machine" and that starts mysqld_safe. It seems that I have similar errors in err log:
2020-04-28 9:10:09 0 [Note] Recovering after a crash using tc.log
2020-04-28 9:10:09 0 [Note] Starting crash recovery...
2020-04-28 9:10:09 0 [Note] Crash recovery finished.
2020-04-28 9:10:09 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2020-04-28 9:10:09 0 [Note] Server socket created on IP: '::'.
2020-04-28 9:10:09 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2020-04-28 9:10:09 6 [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")
2020-04-28 9:10:09 0 [Note] Reading of all Master_info entries succeeded
2020-04-28 9:10:09 0 [Note] Added new Master_info '' to hash table
2020-04-28 9:10:09 0 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.3.22-MariaDB' socket: '/home/saku/.config/cqrlog/database/sock' port: 64000 MariaDB Server
But everything works here, how ever.
--
Saku
OH1KH
Hello Saku,
cqrlog ist working - no affect found.
The problem is solved now.
Seems to be a migration fault from Oracle/mysql to MariaDB/mysql. It is up to the linux distribution guys :-)
cqrlog is working fine!
Sorry for the wasted time.
73 de Martin, DL1MTG
--
73 de Martin, DL1MTG