Error during connection to database

2 posts / 0 new
Last post
DL3LAR
Error during connection to database

Hi,

for some reason I pressed the wrong button in the logbook selection window during startup.
Now every time I tried to start a "Database connection" window appeared.
It asked for Server name (127.0.0.1), Port (64000), User name (cqrlog), password (blank)

Further down there are no more of my logs appearing.

If I press connect, an error window appears:
Error during connection to database: TMySQL57Connection : Server connect failed.

I looked up mysql.err, find a lot of errors, but if I scroll back, there had been there before, even while cqrlog was still running.

I would appreciate any hint to get back to normal work with cqrlog.

73, Rolf, DL3LAR
--
Here the recent error snapshot.


180218 9:48:29 [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.
180218 9:48:29 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180218 9:48:29 [Note] InnoDB: The InnoDB memory heap is disabled
180218 9:48:29 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180218 9:48:29 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180218 9:48:29 [Note] InnoDB: Compressed tables use zlib 1.2.8
180218 9:48:29 [Note] InnoDB: Using Linux native AIO
180218 9:48:29 [Note] InnoDB: Not using CPU crc32 instructions
180218 9:48:29 [Note] InnoDB: Initializing buffer pool, size = 80.0M
180218 9:48:29 [Note] InnoDB: Completed initialization of buffer pool
180218 9:48:29 [Note] InnoDB: Highest supported file format is Barracuda.
180218 9:48:30 [Note] InnoDB: 128 rollback segment(s) are active.
180218 9:48:30 [Note] InnoDB: Waiting for purge to start
180218 9:48:30 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 398678317
180218 9:48:30 [Note] Plugin 'FEEDBACK' is disabled.
180218 9:48:30 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
180218 9:48:30 [Note] Server socket created on IP: '::'.
180218 9:48:30 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
180218 9:48:30 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
180218 9:48:30 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
180218 9:48:30 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
180218 9:48:30 [Note] Reading of all Master_info entries succeded
180218 9:48:30 [Note] Added new Master_info '' to hash table
180218 9:48:30 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.33-MariaDB-0ubuntu0.16.04.1' socket: '/home/rolf/.config/cqrlog/database/sock' port: 64000 Ubuntu 16.04
2018-02-18 09:48:30 7f4066624700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
180218 9:48:56 [Note] /usr/sbin/mysqld: Normal shutdown
180218 9:48:57 [Note] InnoDB: FTS optimize thread exiting.
180218 9:48:57 [Note] InnoDB: Starting shutdown...
180218 9:48:57 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
180218 9:48:59 [Note] InnoDB: Shutdown completed; log sequence number 398678327
180218 9:49:00 [Note] /usr/sbin/mysqld: Shutdown complete

Versions: Ubuntu 16.04, cqrlog latest 2.20

DL3LAR
Error during connection to database

Ok, I found my mistake.

I un-checked "Save log data to local machine" by accident ... so cqrlog tried to connect to a remote database server.
After checking this box again, a window appeared saying "Local database is not running. Do you want to start it ?".

Confirming "yes", my log is back again running.

73, Rolf