Upgrade issue from community 5.6 to PS 5.6 on Debian9
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
If you first install MySQL Community 5.6 on Debian 9 and then install PS 5.6, MySQL community keeps the mysql.service in a "masked" state which causes PS 5.6 to fail to start.
root@debian:
+ set -e
+ set -u
+ PERCONA_PREFIX=/usr
+ test -x /usr/sbin/mysqld
+ startup_timeout=900
+ stop_timeout=300
+ '[' -e /etc/default/mysql ']'
+ . /etc/default/mysql
++ startup_timeout=900
++ stop_timeout=300
+ . /lib/lsb/
+++ run-parts --lsbsysinit --list /lib/lsb/
++ for hook in $(run-parts --lsbsysinit --list /lib/lsb/
++ '[' -r /lib/lsb/
++ . /lib/lsb/
++ for hook in $(run-parts --lsbsysinit --list /lib/lsb/
++ '[' -r /lib/lsb/
++ . /lib/lsb/
+++ _use_systemctl=0
+++ '[' -d /run/systemd/system ']'
+++ prog=mysql
+++ service=
++++ systemctl -p LoadState --value show mysql.service
+++ state=masked
+++ '[' masked = masked ']'
+++ exit 0
root@debian:
masked
The fix is simply to unmask:
root@debian:
Removed /etc/systemd/
root@debian:
[ ok ] Starting mysql (via systemctl): mysql.service.
Originally I had installed:
root@debian:
ii mysql-apt-config 0.8.7-1 all Auto configuration for MySQL APT Repo.
ii mysql-client 5.6.37-1debian9 amd64 MySQL Client meta package depending on latest version
ii mysql-common 5.8+1.0.2 all MySQL database common files, e.g. /etc/mysql/my.cnf
ii mysql-community
ii mysql-community
then I installed PS 5.6:
root@debian:
ii libperconaserve
ii percona-release 0.1-4.stretch all Package to install Percona gpg key and APT repo
ii percona-
ii percona-
ii percona-
I suggest the install script checks for the existence of a masked mysql.service entry and deal with it appropriately.
tags: | added: pkg |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-3733