Won't start after upgrade Ubuntu 16.04

14 posts / 0 new
Last post
PA1JIM
PA1JIM's picture
Won't start after upgrade Ubuntu 16.04

Got this error at start:
"Error during connection to database:
TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.7.11)."

Last 20 lines of mysql.err:

160421 21:23:48 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
160421 21:23:48 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
160421 21:23:48 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
160421 21:23:48 [Note] Reading of all Master_info entries succeded
160421 21:23:48 [Note] Added new Master_info '' to hash table
160421 21:23:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.24-MariaDB-7' socket: '/home/user/.config/cqrlog/database/sock' port: 64000 Ubuntu 16.04

PA1SBM
PA1SBM's picture
Hi Jim ,

Hi Jim ,

Are you running the 1.9.1 version of cqrlog?
I'll fire up my ubu 16.04 vm to see if it happens to me as well

73
Alex

PA1JIM
PA1JIM's picture
version 2.0.0 (001)

No, version 2.0.0 (001). I added the sudo add-apt-repository ppa:ok2cqr/ppa;sudo apt-get update on the old 14.04 LTS. But after the dist-upgrade I run in these problems.

73 de PA1JIM, Jim

ok2cqr
ok2cqr's picture
RE: version 2.0.0 (001)

Could you run cqrlog in a terminal with --debug=1 parameter, please? There will be more information what happened.

PA1JIM
PA1JIM's picture
debug=1

cqrlog --debug=1

**** DEBUG LEVEL 1 ****

Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.5
**********************************
Loaded 92970 LoTW users
Loaded 97971 eQSL users
Loaded 48268 SCP calls
/home/user/.config/cqrlog/database/PA1JIM.pid
Command:
kill 8160
*
User home directory: /home/user/
Program home directory: /home/user/.config/cqrlog/
Data directory: /home/user/.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.5
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/user/.config/cqrlog/database/mysql.cnf --datadir=/home/user/.config/cqrlog/database/ --socket=/home/user/.config/cqrlog/database/sock --port=64000
Trying to connect to database
160421 21:55:56 [Note] /usr/sbin/mysqld (mysqld 10.0.24-MariaDB-7) starting as process 9048 ...
TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.7.11).
Trying:1
Trying to connect to database
TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.7.11).
Trying:2
Trying to connect to database
TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.7.11).
Trying:3
Trying to connect to database
TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.7.11).
Trying:4
Trying to connect to database
TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.7.11).
Trying:5
Trying to connect to database
TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.7.11).
Trying:6
Trying to connect to database
TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.7.11).
Trying:7
Trying to connect to database
TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.7.11).
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
/home/user/.config/cqrlog/database/PA1JIM.pid
Command:
kill 9048
Invalid file handle
Closing ini file ...

73 de PA1JIM, Jim

ok2cqr
ok2cqr's picture
Re: debug=1

It seems you have installed two version of MySQL client libraries. Please remove the old version from old Ubuntu.

PA1JIM
PA1JIM's picture
CQRlog hijacked packages ;-)

At some point it seemed a good idea to reinstall CQRlog so I added again the ppa. But now there is nothing I can do with apt-get/dpkg because CQRlog is in the way:

sudo apt-get remove --purge libmysqlclient18
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
libbotan-1.10-0 libpq5
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
cqrlog
The following packages will be REMOVED:
libmysqlclient18* ubuntu-sdk-dev* ubuntu-sdk-ide*
The following packages will be upgraded:
cqrlog
1 upgraded, 0 newly installed, 3 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/7769 kB of archives.
After this operation, 829 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 359177 files and directories currently installed.)
Preparing to unpack .../cqrlog_2.0.0-1~xenial_amd64.deb ...
Unpacking cqrlog (2.0.0-1~xenial) over (2.0.0-1~trusty) ...
dpkg: warning: subprocess old post-removal script returned error exit status 1
dpkg: trying script from the new package instead ...
dpkg: error processing archive /var/cache/apt/archives/cqrlog_2.0.0-1~xenial_amd64.deb (--unpack):
subprocess new post-removal script returned error exit status 1
dpkg: error while cleaning up:
subprocess new post-removal script returned error exit status 1
Processing triggers for gnome-menus (3.13.3-6ubuntu3) ...
Processing triggers for desktop-file-utils (0.22-1ubuntu5) ...
Processing triggers for bamfdaemon (0.5.3~bzr0+16.04.20160415-0ubuntu1) ...
Rebuilding /usr/share/applications/bamf-2.index...
Processing triggers for mime-support (3.59ubuntu1) ...
Processing triggers for man-db (2.7.5-1) ...
Errors were encountered while processing:
/var/cache/apt/archives/cqrlog_2.0.0-1~xenial_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

sudo apt-get remove --purge cqrlog
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
cqrlog*
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 27,6 MB disk space will be freed.
Do you want to continue? [Y/n] y
dpkg: error processing package cqrlog (--purge):
package is in a very bad inconsistent state; you should
reinstall it before attempting a removal
Errors were encountered while processing:
cqrlog
E: Sub-process /usr/bin/dpkg returned an error code (1)

sudo apt-get install --reinstall cqrlog
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be upgraded:
cqrlog
1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/7769 kB of archives.
After this operation, 96,3 kB of additional disk space will be used.
Selecting previously unselected package cqrlog.
(Reading database ... 359177 files and directories currently installed.)
Preparing to unpack .../cqrlog_2.0.0-1~xenial_amd64.deb ...
Unpacking cqrlog (2.0.0-1~xenial) over (2.0.0-1~trusty) ...
dpkg: warning: subprocess old post-removal script returned error exit status 1
dpkg: trying script from the new package instead ...
dpkg: error processing archive /var/cache/apt/archives/cqrlog_2.0.0-1~xenial_amd64.deb (--unpack):
subprocess new post-removal script returned error exit status 1
dpkg: error while cleaning up:
subprocess new post-removal script returned error exit status 1
Processing triggers for gnome-menus (3.13.3-6ubuntu3) ...
Processing triggers for desktop-file-utils (0.22-1ubuntu5) ...
Processing triggers for bamfdaemon (0.5.3~bzr0+16.04.20160415-0ubuntu1) ...
Rebuilding /usr/share/applications/bamf-2.index...
Processing triggers for mime-support (3.59ubuntu1) ...
Processing triggers for man-db (2.7.5-1) ...
Errors were encountered while processing:
/var/cache/apt/archives/cqrlog_2.0.0-1~xenial_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

Somehow I'm in a loop. Any ideas?

73 de PA1JIM, Jim

ok2cqr
ok2cqr's picture
Re: CQRlog hijacked packages ;-)

There is a bug in 1.9.1 deb package, something with postrm script. For me worked this:

sudo gedit /var/log/dpkg/status

There will be something like:

Package: cqrlog
Status: install ok installed
Priority: extra
Section: hamradio
Installed-Size: 25934
Maintainer: Ubuntu Developers
Architecture: amd64
Version: 1.7.3-1
Depends: libatk1.0-0 (>= 1.12.4), libc6 (>= 2.2.5), libcairo2 (>= 1.2.4), libgdk-pixbuf2.0-0 (>= 2.22.0), libglib2.0-0 (>= 2.12.0), libgtk2.0-0 (>= 2.24.0), libpango-1.0-0 (>= 1.14.0), libx11-6, libssl-dev, mariadb-server | mysql-server, mariadb-client | mysql-client, libhamlib2 (>= 1.2.10), libhamlib-utils (>= 1.2.10)
Description: Advanced logging program for hamradio operators
CQRLOG is an advanced ham radio logger based on MySQL embedded database.
Provides radio control based on hamlib libraries (currently support of 140+
radio types and models), DX cluster connection, HamQTH/QRZ callbook
(XML access), a grayliner, internal QSL manager database support and a most
accurate country resolution algorithm based on country tables developed by
OK1RR. CQRLOG is intended for daily general logging of HF, CW & SSB contacts
and strongly focused on easy operation and maintenance.
Original-Maintainer: Debian Hamradio Maintainers

Remove those lines, save the file and try to remove libmysqlclient18 again. It's not a clean solution but I don't know about anything better.

PA1JIM
PA1JIM's picture
Solved!

Thanks OK2CQR! Your fix did it. For future reference: the file I had to change was /var/lib/dpkg/status instead of /var/log/dpkg/status.

73 de PA1JIM, Jim

KE7TUB
KE7TUB's picture
My file "sudo gedit /var/log

My file "sudo gedit /var/log/dpkg/status" is empty. I'm on Ubuntu 16.04.

PA1JIM
PA1JIM's picture
/var/LIB/dpkg/status

Path must be /var/lib/dpkg/status (/var/LIB/dpkg/status)!

This solution works for me. Just run a update and upgrade and CQRlog is updated to 2.0.1 here.

73 de PA1JIM, Jim

PA1SBM
PA1SBM's picture
I just made a new Vbox and

I just made a new Vbox and installed the cqrlog from the default repository. 1.9.0
This standard install has the same problem. the libmysqlclient versio just seems to be too new
It's not the libmysqlclient18 which i run on linuxmint, but libmysqlclient20.

hope that helps

73
Alex

kb1fv
Fresh install, won't connect to mysql

Xubuntu 16.04, mariadb 10.0.24-7, cqrlog 2.0.1(001).

Last 20 lines of mysql err:

160525 22:41:30 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
160525 22:41:30 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
160525 22:41:31 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
160525 22:41:31 [Warning] InnoDB: New log files created, LSN=45781
160525 22:41:31 [Note] InnoDB: Doublewrite buffer not found: creating new
160525 22:41:31 [Note] InnoDB: Doublewrite buffer created
160525 22:41:31 [Note] InnoDB: 128 rollback segment(s) are active.
160525 22:41:31 [Warning] InnoDB: Creating foreign key constraint system tables.
160525 22:41:31 [Note] InnoDB: Foreign key constraint system tables created
160525 22:41:31 [Note] InnoDB: Creating tablespace and datafile system tables.
160525 22:41:31 [Note] InnoDB: Tablespace and datafile system tables created.
160525 22:41:31 [Note] InnoDB: Waiting for purge to start
160525 22:41:31 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 0
160525 22:41:31 [Note] Plugin 'FEEDBACK' is disabled.
160525 22:41:31 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
160525 22:41:31 [ERROR] Aborting

160525 22:41:31 [Note] InnoDB: FTS optimize thread exiting.
160525 22:41:31 [Note] InnoDB: Starting shutdown...
160525 22:41:33 [Note] InnoDB: Shutdown completed; log sequence number 1600607
160525 22:41:33 [Note] /usr/sbin/mysqld: Shutdown complete

cqrlog --debug=1

**** DEBUG LEVEL 1 ****

Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20
**************************
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/mdb/
Program home directory: /home/mdb/.config/cqrlog/
Data directory: /home/mdb/.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/mdb/.config/cqrlog/database/mysql.cnf --datadir=/home/mdb/.config/cqrlog/database/ --socket=/home/mdb/.config/cqrlog/database/sock --port=64000
Trying to connect to database
160525 22:48:27 [Note] /usr/sbin/mysqld (mysqld 10.0.24-MariaDB-7) starting as process 30538 ...
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:3
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:4
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:5
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:6
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:7
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:8

(cqrlog:30535): Gtk-WARNING **: Theme directory of theme oxygen has no size field

on5hb
on5hb's picture
Solved my problem when

Solved my problem when upgrading from Mint17 to Mint18.
After removing those lines, then sudo apt-get install cqrlog it installed and started perfectly!!

Yeah!!

Greetings, Bas. ON5HB