Error during connection to database

5 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

Oz1akn
I have exactly same problem

I have exactly same problem on a new install...
Is it CQRlog or mysql problem?

Mogens

Oz1akn
It is a new install on a

It is a new install on a resently new upgrade of Linux mint.
During first time I ran CQRLOG I Think I oversaw something so now the program starts with a MySQL window.

Tried to uninstall both cqrlog and MySQL. Still same problem.

Where to seek for a solution?

File: 

DL3LAR
I have exactly same problem

Hello Mogens,

in your screenshot there is no checkmark at the checkbox "Save log data to local machine".
You should mark it and see, if you could go further.

73 de Rolf, DL3LAR