[Update] Update cluster from 9.1 to 9.2 failed on upgrade package [mysql-server-wsrep-5.6]

[Ilya Bumarskov]

Fuel 9.2 snapshot-id#580

Steps to reproduce:
   - Deploy 9.1 env with following nodes:
         * Controller
         * Compute, cinder
         * Compute, cinder
   - Install mos-playbooks tool on master (yum install -y http://mirror.fuel-infra.org/mos-repos/centos/mos9.0-centos7/snapshots/proposed-latest/x86_64/Packages/mos-release-9.2-0.1.beta.el7.noarch.rpm && yum install -y mos-playbooks)
   - Execute preparation playbooks (ansible-playbook playbooks/mos9_prepare_fuel.yml && ansible-playbook playbooks/mos9_prepare_env.yml -e '{"env_id":1, "snapshot_repo":"9.0-2016-12-01-010323"}')
   - Update fuel node (ansible-playbook playbooks/update_fuel.yml -e '{"rebuild_bootstrap":false}')
   - Update env (fuel2 update install --env 1 --repos mos9.2)

Observed behavior:
Deployment has failed. All nodes are finished. Failed tasks: Task[pkg_upgrade/2] Stopping the deployment process!
(/Stage[main]/Osnailyfacter::Upgrade::Pkg_upgrade/Package[mysql-server-wsrep-5.6]/ensure) E: Sub-process /usr/bin/dpkg returned an error code (1)

[Anton Chevychalov (achevychalov)]

Something goes wrong with mysql update

(Reading database ... 111311 files and directories currently installed.)
Removing mysql-client-core-5.6 (5.6.33-0~u14.04+mos1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
(Reading database ... 111306 files and directories currently installed.)
Preparing to unpack .../mysql-client-5.6_5.6.34-0~u14.04+mos2_amd64.deb ...
Unpacking mysql-client-5.6 (5.6.34-0~u14.04+mos2) over (5.6.33-0~u14.04+mos1) ...
Preparing to unpack .../mysql-server-wsrep-5.6_5.6.34-0~u14.04+mos2_amd64.deb ...
 * Reloading AppArmor profiles
Skipping profile in /etc/apparmor.d/disable: usr.sbin.rsyslogd
   ...done.
Unpacking mysql-server-wsrep-5.6 (5.6.34-0~u14.04+mos2) over (5.6.33-0~u14.04+mos1) ...
dpkg: error processing archive /var/cache/apt/archives/mysql-server-wsrep-5.6_5.6.34-0~u14.04+mos2_amd64.deb (--unpack):
 trying to overwrite '/usr/share/mysql/czech/errmsg.sys', which is also in package mysql-server-wsrep-core-5.6 5.6.33-0~u14.04+mos1
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
 * Reloading AppArmor profiles
Skipping profile in /etc/apparmor.d/disable: usr.sbin.rsyslogd
   ...done.
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-wsrep-5.6_5.6.34-0~u14.04+mos2_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

[Fuel Devops McRobotson (fuel-devops-robot)]

Fix proposed to branch: 9.0
Change author: Ivan Suzdal <email address hidden>
Review: https://review.fuel-infra.org/29094

[Fuel Devops McRobotson (fuel-devops-robot)]

Reviewed: https://review.fuel-infra.org/29094
Submitter: Pkgs Jenkins <email address hidden>
Branch: 9.0

Commit: 7596ec1ef98d6191728082cbb3f436f08a1476d7
Author: Ivan Suzdal <email address hidden>
Date: Thu Dec 1 13:59:21 2016

Add replace for mysql-server-wsrep-5.6 package

Change-Id: I50f43b066c7be9043234af4451212df159dbd41d
Closes-Bug: #1646460

[Fuel Devops McRobotson (fuel-devops-robot)]

Fix proposed to branch: 9.0
Change author: Dmitry Teselkin <email address hidden>
Review: https://review.fuel-infra.org/29118

[Ilya Bumarskov (ibumarskov)]

Verified on snapshot-id #584