Hello,
I had CQRLOG working under Kubuntu 18.04 and then I messed up my OS by removing a package unrelated to CQRLOG. I decided to do a clean re-install of the OS and applications. Now when I try to start CQRLOG, it does not connect to the database. Here is the console output when I try to start in debug mode:
terry@TERRYSPC8:~$ cqrlog -debug=1
(cqrlog:2807): Gtk-WARNING **: 09:40:22.867: Unable to locate theme engine in module_path: "adwaita",
(cqrlog:2807): Gtk-WARNING **: 09:40:22.870: Unable to locate theme engine in module_path: "adwaita",
**** DEBUG LEVEL 1 ****
SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20.3.9
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 93636 LoTW users
Loaded 98114 eQSL users
Loaded 48268 SCP calls
*
User home directory: /home/terry/
Program home directory: /home/terry/.config/cqrlog/
Data directory: /home/terry/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.7
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/terry/.config/cqrlog/database/mysql.cnf --datadir=/home/terry/.config/cqrlog/database/ --socket=/home/terry/.config/cqrlog/database/sock --port=64000
Trying to connect to database
mysqld: [ERROR] Could not open required defaults file: /home/terry/.config/cqrlog/database/mysql.cnf
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!
TMySQL57Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:2
Trying to connect to database
TMySQL57Connection : Server connect failed.
.
.
.
Trying:7
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:8
NOTE: The mysql.cnf does exist in my database folder!
The mysql libraries are installed as shown below:
terry@TERRYSPC8:/$ sudo find -name libmysqlclient.*
find: ‘./proc/2553/task/2553/net’: Invalid argument
find: ‘./proc/2553/net’: Invalid argument
find: ‘./proc/2554/task/2554/net’: Invalid argument
find: ‘./proc/2554/net’: Invalid argument
./usr/lib/x86_64-linux-gnu/libmysqlclient.so.20.3.9
./usr/lib/x86_64-linux-gnu/libmysqlclient.so.20
./usr/lib/x86_64-linux-gnu/libmysqlclient.a
./usr/lib/x86_64-linux-gnu/libmysqlclient.so
Can anyone give me an idea on why it is not making a connection to the database?
Thanks,
Terry
Hi Terry,
it seems MySQL cannot find the configuration file. You can use my own mysql.cnf and copy it to /home/terry/.config/cqrlog/database directory.
I could not add file with cnf extension so I added _.txt to the end of the file. Please remove it, first.
73 Petr
File:
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr,
Thanks for the file, but the problem still exists. I am considering changing the OS to the Ubuntu 18.04 distro instead of the Kubuntu, especially if you think that may help. I do like the KDE desktop better, but I think this PC will be dedicated to the ham shack so I can get used to the other desktop just for ham radio programs (cqrlog, fldigi, and maybe wsjtx). I will reply back here if I continue to have problems after I make that change.
KX4FZ, Terry
There is something weird about your file
/home/terry/.config/cqrlog/database/mysql.cnf. I'm not convinced complete re-install is required.Have you tried to check whether the directories above that exist and belong to the right user?
You could also try to create a complete new user and see whether cqrlog runs well for that user.
As a mostly equivalent, faster, but more brutal experiment, you could try moving the cqrlog directory out of where cqrlog looks for it, like this:
This will move all databases to the side, too. While the data is still present, cqrlog will no longer find it, so this results in some kind of amnesia: All your logs will seem gone. But possibly, this will cure your problem.
If that does cure your problem, ask again for instructions how to re-surrect your previous log data (unless you have none of those).
Apologies for the copy paste. I am new to linux and tried to install CQRlog but do not know what direction anymore.
CQRlog mysql.err. Any assistance will be greatly appreciated.
Pierre
171126 13:10:25 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
171126 13:10:25 [Note] InnoDB: Using mutexes to ref count buffer pool pages
171126 13:10:25 [Note] InnoDB: The InnoDB memory heap is disabled
171126 13:10:25 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
171126 13:10:25 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
171126 13:10:25 [Note] InnoDB: Compressed tables use zlib 1.2.8
171126 13:10:25 [Note] InnoDB: Using Linux native AIO
171126 13:10:25 [Note] InnoDB: Using CPU crc32 instructions
171126 13:10:25 [Note] InnoDB: Initializing buffer pool, size = 80.0M
171126 13:10:25 [Note] InnoDB: Completed initialization of buffer pool
171126 13:10:25 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
171126 13:10:25 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
171126 13:10:25 [Note] InnoDB: Database physically writes the file full: wait...
171126 13:10:25 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
171126 13:10:26 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
171126 13:10:26 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
171126 13:10:26 [Warning] InnoDB: New log files created, LSN=45781
171126 13:10:26 [Note] InnoDB: Doublewrite buffer not found: creating new
171126 13:10:26 [Note] InnoDB: Doublewrite buffer created
171126 13:10:26 [Note] InnoDB: 128 rollback segment(s) are active.
171126 13:10:26 [Warning] InnoDB: Creating foreign key constraint system tables.
171126 13:10:26 [Note] InnoDB: Foreign key constraint system tables created
171126 13:10:26 [Note] InnoDB: Creating tablespace and datafile system tables.
171126 13:10:26 [Note] InnoDB: Tablespace and datafile system tables created.
171126 13:10:26 [Note] InnoDB: Waiting for purge to start
171126 13:10:26 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 0
171126 13:10:26 [Note] Plugin 'FEEDBACK' is disabled.
171126 13:10:26 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
171126 13:10:26 [Note] Server socket created on IP: '::'.
171126 13:10:26 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
171126 13:10:26 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
171126 13:10:26 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
171126 13:10:26 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
171126 13:10:26 [Note] Reading of all Master_info entries succeded
171126 13:10:26 [Note] Added new Master_info '' to hash table
171126 13:10:26 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.31-MariaDB-0ubuntu0.16.04.2' socket: '/home/pierre/.config/cqrlog/database/sock' port: 64000 Ubuntu 16.04
2017-11-26 13:10:29 7f9558750700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:29 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
2017-11-26 13:10:30 7f9558750700 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.
171126 13:19:37 [Note] /usr/sbin/mysqld: Normal shutdown
171126 13:19:37 [Note] InnoDB: FTS optimize thread exiting.
171126 13:19:37 [Note] InnoDB: Starting shutdown...
171126 13:19:38 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
171126 13:19:39 [Note] InnoDB: Shutdown completed; log sequence number 10358871
171126 13:19:39 [Note] /usr/sbin/mysqld: Shutdown complete
171126 13:20:08 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
171126 13:20:08 [Note] InnoDB: Using mutexes to ref count buffer pool pages
171126 13:20:08 [Note] InnoDB: The InnoDB memory heap is disabled
171126 13:20:08 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
171126 13:20:08 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
171126 13:20:08 [Note] InnoDB: Compressed tables use zlib 1.2.8
171126 13:20:08 [Note] InnoDB: Using Linux native AIO
171126 13:20:08 [Note] InnoDB: Using CPU crc32 instructions
171126 13:20:08 [Note] InnoDB: Initializing buffer pool, size = 80.0M
171126 13:20:08 [Note] InnoDB: Completed initialization of buffer pool
171126 13:20:08 [Note] InnoDB: Highest supported file format is Barracuda.
171126 13:20:08 [Note] InnoDB: 128 rollback segment(s) are active.
171126 13:20:08 [Note] InnoDB: Waiting for purge to start
171126 13:20:08 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 10358871
171126 13:20:08 [Note] Plugin 'FEEDBACK' is disabled.
171126 13:20:08 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
171126 13:20:08 [Note] Server socket created on IP: '::'.
171126 13:20:08 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
171126 13:20:08 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
171126 13:20:08 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
171126 13:20:08 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
171126 13:20:08 [Note] Reading of all Master_info entries succeded
171126 13:20:08 [Note] Added new Master_info '' to hash table
171126 13:20:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.31-MariaDB-0ubuntu0.16.04.2' socket: '/home/pierre/.config/cqrlog/database/sock' port: 64000 Ubuntu 16.04
2017-11-26 13:20:09 7fc1e2ad0700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
171126 13:27:00 [Note] /usr/sbin/mysqld: Normal shutdown
171126 13:27:00 [Note] InnoDB: FTS optimize thread exiting.
171126 13:27:00 [Note] InnoDB: Starting shutdown...
171126 13:27:00 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
171126 13:27:02 [Note] InnoDB: Shutdown completed; log sequence number 10467208
171126 13:27:02 [Note] /usr/sbin/mysqld: Shutdown complete
Hello, zs6pjh,
yours seems to be a problem different from the one discussed here. At least I can see no similarity. So I suggest you please open a new topic by itself for your particular problem.
At least in my thinking, that would make things more orderly. Reduce QRM for everybody, so to speak.
In that new topic, kindly also describe which Linux version you are using, how you installed cqrlog, and, more importantly, how you installed MariaDB or MySQL. Which of those two you are using, which versions of all of the above you are using - that info would also help.
Also (in the new topic, please): In which way is cqrlog itself mis-behaving? What did you do, how did you expect cqrlog to respond, what actually did happen?
I'm not sure, but those lines from that rather hidden error file may be harmless. They also look rather old; I speculate "171126" could mean the date 2017-11-26. I found similar remnants on my PC, but my cqrlog works.
Regards,
Andreas, DJ3EI
Sorry, I have been busy on some other projects and haven't been able to check back here for a few days.
I just wanted to thank everyone for trying to help me and giving me ideas to try.
I just re-read my original post and realized that I forgot to include some vital information, I was trying to install CQRLOG v.2.0 from the Ubuntu repositories. It started working perfectly when I installed the latest version from the ok2cqr repository. My guess is that CQRLOG v2.0 requires an earlier version of mysql (v5.6?) than is installed with later versions of Ubuntu (mysql v.5.7).
Thanks again,
KX4FZ, Terry