Broken CQRlog Installation

4 posts / 0 new
Last post
zs6pjh
Broken CQRlog Installation

Hi There

This refers to a discussion I started in New OS/CQRLOG Install and now Mysql Problems but copied to new topic here

Problems installing CQRLog on Ubuntu 16.04
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

Top
reply
Tue, 2018-07-24 23:01 #6
dj3ei
Seems to be a different problem.
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

Hi Anreas

Apologies if my response comes through Multiple times. New to this Forum. Been a HAM since 2000 and mostly played around with Windoze. Some time last year I installed UBUNTU 16.04 in a dual boot config and got my email working with Thunderbird. Since then I have tried over numerous occasions to get CQRlog working.

CQRlog currently tells me that it cannot open certain files because of insufficient rights. I could have installed some stuff in the wrong places.

How do I uninstall CQRlog and MYSQL Server 5.7, MySQL Client 5.7 and all the other dependencies and start from Fresh?

Pierre ZS6PJH

KX4FZ
Hi Pierre,

Hi Pierre,

You did not mention if you were trying to install cqrlog from the Ubuntu repository or the OK2CQR repository. The Ubuntu repository contains an older version of cqrlog, which I suspect won't work with MySQL 5.7.

This fixed my problem, however your problem sounds somewhat different.

Good Luck,

KX4FZ, Terry

oh1kh
Broken CQRlog Installation

Hi Perre!

Could you start cqrlog from console window with command:
cqrlog debug=1
and paste here first 30 lines.

From that we see that you have latest version and also some other information.

Do not try to run cqrlog as user "root" it will not work ok.

Log in as ordinary user, open console and type command shown above.

If you like to make "fresh" start (not reinstalling, but starting as user that never has used installed cqrlog) give command:
rm -rf ~/.config/cqrlog
before starting cqrlog from command line.

NOTE! this will delete all your logs !!

Your username must be in "dialout" group for using rig CAT/CI-V (to give right to use serial port)

Check that you have libmysqlclient-devel package installed. It is one of the main reasons that fails cqrlog.

--
Saku
OH1KH

zs6pjh
Hi Saku

Hi Saku
I have libmysqlclient-dev installed as I am trying to use mysql not MARIADB.
I tried cqrlog debug=1 and system said someting about failure to connect to server.
I then used the rm , I assume that this removed the config file .
Then CQRLOG DEBUG=1 , system said it will create new logs and run for a while then said
"TMySQL57Connection : Error executing query: Incorrect date value: '-01' for column 'fromdate' at row 1
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr"

I used Ctrl+C to break and cqrlog again...
Now it let me create new log etc...
I think it is working!

Thank you very much.
73 de Pierre ZS6PJH