tokudb upgrade fails during the 5.6 -> 5.7 upgrade

Bug #1533580 reported by Tomislav Plavcic
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.6
Invalid
High
Tomislav Plavcic
5.7
Fix Released
High
Tomislav Plavcic

Bug Description

On deb distributions if you have Percona Server 5.5 installed and run:
apt-get install percona-server-server-5.6

It will automatically give you option to remove the 5.5 packages and install 5.6 version. The same thing works between 5.6 and 5.7 unless tokudb package is installed.

In case you run:
apt-get install percona-server-server-5.7

Tokudb package won't get marked for upgrade:
root@trusty:~# apt-get install percona-server-server-5.7
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
  libjemalloc1 libperconaserverclient18 libperconaserverclient18.1
  percona-server-common-5.5 percona-server-common-5.6
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  percona-server-client-5.7 percona-server-common-5.7
The following packages will be REMOVED:
  percona-server-client-5.6 percona-server-server-5.6
  percona-server-tokudb-5.6
The following NEW packages will be installed:
  percona-server-client-5.7 percona-server-common-5.7
  percona-server-server-5.7
0 upgraded, 3 newly installed, 3 to remove and 0 not upgraded.
Need to get 18.7 MB of archives.
After this operation, 34.5 MB of additional disk space will be used.
Do you want to continue? [Y/n]

or if you add the tokudb package to the list, upgrade will fail:
root@trusty:~# apt-get install percona-server-server-5.7 percona-server-tokudb-5.7
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
  libperconaserverclient18 libperconaserverclient18.1
  percona-server-common-5.5 percona-server-common-5.6
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  percona-server-client-5.7 percona-server-common-5.7
The following packages will be REMOVED:
  percona-server-client-5.6 percona-server-server-5.6
  percona-server-tokudb-5.6
The following NEW packages will be installed:
  percona-server-client-5.7 percona-server-common-5.7
  percona-server-server-5.7 percona-server-tokudb-5.7
0 upgraded, 4 newly installed, 3 to remove and 0 not upgraded.
Need to get 21.3 MB of archives.
After this operation, 45.4 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://192.168.5.9/apt/ trusty/main percona-server-common-5.7 amd64 5.7.10-1rc1-1.trusty [204 kB]
Get:2 http://192.168.5.9/apt/ trusty/main percona-server-client-5.7 amd64 5.7.10-1rc1-1.trusty [1,527 kB]
Get:3 http://192.168.5.9/apt/ trusty/main percona-server-server-5.7 amd64 5.7.10-1rc1-1.trusty [17.0 MB]
Get:4 http://192.168.5.9/apt/ trusty/main percona-server-tokudb-5.7 amd64 5.7.10-1rc1-1.trusty [2,609 kB]
Fetched 21.3 MB in 6s (3,140 kB/s)
Preconfiguring packages ...
(Reading database ... 35441 files and directories currently installed.)
Removing percona-server-tokudb-5.6 (5.6.27-76.0-1.trusty) ...
Removing percona-server-server-5.6 (5.6.27-76.0-1.trusty) ...
 * Stopping MySQL (Percona Server) mysqld [ OK ]
Removing percona-server-client-5.6 (5.6.27-76.0-1.trusty) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Selecting previously unselected package percona-server-common-5.7.
(Reading database ... 35178 files and directories currently installed.)
Preparing to unpack .../percona-server-common-5.7_5.7.10-1rc1-1.trusty_amd64.deb ...
Unpacking percona-server-common-5.7 (5.7.10-1rc1-1.trusty) ...
Selecting previously unselected package percona-server-client-5.7.
Preparing to unpack .../percona-server-client-5.7_5.7.10-1rc1-1.trusty_amd64.deb ...
Unpacking percona-server-client-5.7 (5.7.10-1rc1-1.trusty) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Setting up percona-server-common-5.7 (5.7.10-1rc1-1.trusty) ...
Selecting previously unselected package percona-server-server-5.7.
(Reading database ... 35295 files and directories currently installed.)
Preparing to unpack .../percona-server-server-5.7_5.7.10-1rc1-1.trusty_amd64.deb ...
.
Unpacking percona-server-server-5.7 (5.7.10-1rc1-1.trusty) ...
Selecting previously unselected package percona-server-tokudb-5.7.
Preparing to unpack .../percona-server-tokudb-5.7_5.7.10-1rc1-1.trusty_amd64.deb ...
Unpacking percona-server-tokudb-5.7 (5.7.10-1rc1-1.trusty) ...
Processing triggers for ureadahead (0.100.0-16) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Setting up percona-server-client-5.7 (5.7.10-1rc1-1.trusty) ...
Setting up percona-server-server-5.7 (5.7.10-1rc1-1.trusty) ...
Installing new version of config file /etc/default/mysql ...
Installing new version of config file /etc/init.d/mysql ...

 * Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
 * Run the following commands to create these functions:

 mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
 mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
 mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

 * See http://www.percona.com/doc/percona-server/5.7/management/udf_percona_toolkit.html for more details

No directory, logging in with HOME=/
.151216 16:14:01 mysqld_safe mysqld_safe must be run as root for setting transparent huge pages!
.................................................................................................

Tags: pkg
Changed in percona-server:
assignee: nobody → Tomislav Plavcic (tplavcic)
importance: Undecided → High
Revision history for this message
Tomislav Plavcic (tplavcic) wrote :

PR: https://github.com/percona/percona-server/pull/310
Just info: when doing upgrades with existing tokudb package "sudo apt-get install percona-server-server-5.7 percona-server-tokudb-5.7" is needed (so both packages named).
This is because the server package doesn't depend on tokudb package - so currently I don't see how this can be simplified.

Changed in percona-server:
status: Triaged → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-956

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.