CQRLOG won't open.

3 posts / 0 new
Last post
nh6hi
CQRLOG won't open.

Did an update to my ubuntu 17.04 64 bit and then tried to run CQRLOG. Got a message to save mysql.err and now I don't know what to do. I get the login window but the logs are missing and cancel is the only option. The mysql.err file is attached below:

73 & Aloha from Kauai Hawaii

Jim NH6HI

2017-10-10T23:12:45.332347Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-10-10T23:12:45.332396Z 0 [Warning] Changed limits: max_connections: 214 (requested 256)
2017-10-10T23:12:45.477687Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2017-10-10T23:12:45.477719Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-10-10T23:12:45.478824Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-0ubuntu0.17.04.1) starting as process 3289 ...
2017-10-10T23:12:45.482341Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-10-10T23:12:45.482357Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-10-10T23:12:45.482362Z 0 [Note] InnoDB: Uses event mutexes
2017-10-10T23:12:45.482365Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-10-10T23:12:45.482369Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-10-10T23:12:45.482372Z 0 [Note] InnoDB: Using Linux native AIO
2017-10-10T23:12:45.482610Z 0 [Note] InnoDB: Number of pools: 1
2017-10-10T23:12:45.482683Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-10-10T23:12:45.483740Z 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2017-10-10T23:12:45.487546Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-10-10T23:12:45.488545Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-10-10T23:12:45.506888Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-10T23:12:45.553597Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-10-10T23:12:45.553668Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-10-10T23:12:45.600137Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-10-10T23:12:45.601307Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-10-10T23:12:45.601321Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-10-10T23:12:45.601897Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 4689949
2017-10-10T23:12:45.602025Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/nh6hi/.config/cqrlog/database/ib_buffer_pool
2017-10-10T23:12:45.602252Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-10-10T23:12:45.603256Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-10-10T23:12:45.603315Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-10-10T23:12:45.603323Z 0 [Note] Server hostname (bind-address): '*'; port: 64000
2017-10-10T23:12:45.603352Z 0 [Note] IPv6 is available.
2017-10-10T23:12:45.603367Z 0 [Note] - '::' resolves to '::';
2017-10-10T23:12:45.603380Z 0 [Note] Server socket created on IP: '::'.
2017-10-10T23:12:45.606959Z 0 [Warning] Failed to open optimizer cost constant tables

2017-10-10T23:12:45.607123Z 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2017-10-10T23:12:45.607211Z 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2017-10-10T23:12:45.607312Z 0 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2017-10-10T23:12:45.607336Z 0 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2017-10-10T23:12:45.607354Z 0 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2017-10-10T23:12:45.607373Z 0 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2017-10-10T23:12:45.607394Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2017-10-10T23:12:45.607412Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2017-10-10T23:12:45.607433Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2017-10-10T23:12:45.607452Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2017-10-10T23:12:45.607471Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2017-10-10T23:12:45.607489Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
2017-10-10T23:12:45.607507Z 0 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
2017-10-10T23:12:45.607525Z 0 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
2017-10-10T23:12:45.607543Z 0 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
2017-10-10T23:12:45.607561Z 0 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2017-10-10T23:12:45.607578Z 0 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
2017-10-10T23:12:45.607596Z 0 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2017-10-10T23:12:45.607614Z 0 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
2017-10-10T23:12:45.607632Z 0 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
2017-10-10T23:12:45.607649Z 0 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2017-10-10T23:12:45.607666Z 0 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
2017-10-10T23:12:45.607706Z 0 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
2017-10-10T23:12:45.607727Z 0 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2017-10-10T23:12:45.607744Z 0 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
2017-10-10T23:12:45.607764Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2017-10-10T23:12:45.607782Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2017-10-10T23:12:45.607800Z 0 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2017-10-10T23:12:45.607817Z 0 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
2017-10-10T23:12:45.607835Z 0 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2017-10-10T23:12:45.607853Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2017-10-10T23:12:45.607880Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2017-10-10T23:12:45.607900Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2017-10-10T23:12:45.607919Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2017-10-10T23:12:45.607939Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2017-10-10T23:12:45.607957Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2017-10-10T23:12:45.607975Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2017-10-10T23:12:45.607995Z 0 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2017-10-10T23:12:45.608013Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2017-10-10T23:12:45.608031Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2017-10-10T23:12:45.608051Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2017-10-10T23:12:45.608071Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2017-10-10T23:12:45.608089Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2017-10-10T23:12:45.608108Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2017-10-10T23:12:45.608128Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2017-10-10T23:12:45.608146Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2017-10-10T23:12:45.608166Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure
2017-10-10T23:12:45.608183Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure
2017-10-10T23:12:45.608210Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure
2017-10-10T23:12:45.608232Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure
2017-10-10T23:12:45.608251Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure
2017-10-10T23:12:45.608271Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure
2017-10-10T23:12:45.608290Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure
2017-10-10T23:12:45.608309Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure
2017-10-10T23:12:45.608328Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure
2017-10-10T23:12:45.608345Z 0 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2017-10-10T23:12:45.608361Z 0 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2017-10-10T23:12:45.608378Z 0 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2017-10-10T23:12:45.608395Z 0 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2017-10-10T23:12:45.608413Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2017-10-10T23:12:45.608431Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2017-10-10T23:12:45.608448Z 0 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2017-10-10T23:12:45.608473Z 0 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2017-10-10T23:12:45.608492Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure
2017-10-10T23:12:45.608529Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure
2017-10-10T23:12:45.608549Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure
2017-10-10T23:12:45.608568Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure
2017-10-10T23:12:45.608595Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure
2017-10-10T23:12:45.608607Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure
2017-10-10T23:12:45.608619Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure
2017-10-10T23:12:45.608632Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure
2017-10-10T23:12:45.608643Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure
2017-10-10T23:12:45.608656Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure
2017-10-10T23:12:45.608668Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure
2017-10-10T23:12:45.608681Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure
2017-10-10T23:12:45.608694Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure
2017-10-10T23:12:45.608707Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure
2017-10-10T23:12:45.608720Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure
2017-10-10T23:12:45.608732Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure
2017-10-10T23:12:45.608744Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure
2017-10-10T23:12:45.608756Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure
2017-10-10T23:12:45.608768Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure
2017-10-10T23:12:45.608780Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure
2017-10-10T23:12:45.608793Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure
2017-10-10T23:12:45.608804Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure
2017-10-10T23:12:45.608816Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure
2017-10-10T23:12:45.608828Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure
2017-10-10T23:12:45.608840Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure
2017-10-10T23:12:45.608851Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure
2017-10-10T23:12:45.609190Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.19-0ubuntu0.17.04.1' socket: '/home/nh6hi/.config/cqrlog/database/sock' port: 64000 (Ubuntu)
2017-10-10T23:12:45.609208Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-10-10T23:12:45.609212Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-10-10T23:12:45.614345Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171010 13:12:45
2017-10-10T23:12:45.632237Z 0 [Note] End of list of non-natively partitioned tables

nh6hi
CQRLOG won't open

Did some more reading... looks like CQRLOG is looking for v.5.1 and I have 5.7

nh6hi@nh6hi-mobile:~$ apt-cache show mysql-server | grep Version
Version: 5.7.19-0ubuntu0.17.04.1
Version: 5.7.17-0ubuntu1

nh6hi@nh6hi-mobile:~$ cqrlog --debug=1

**** DEBUG LEVEL 1 ****

SSL libraries:
/lib/x86_64-linux-gnu/libssl.so.1.0.0
/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient:
FATAL ERROR: Can not get MySQL client library version version!
Setting to default version (5.1)
**********************************
MySQL version assigned: 5.1
**********************************
Loaded 109995 LoTW users
Loaded 109532 eQSL users
Loaded 42968 SCP calls
*
User home directory: /home/nh6hi/
Program home directory: /home/nh6hi/.config/cqrlog/
Data directory: /home/nh6hi/.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.1
*
56 us states loaded

nh6hi
Fixed

Yahoo! got it!
apt-get install libmariadbclient-dev-compat did the trick

Aloha & Mahalo for this forum
Jim NH6HI