Apache package doesn't install but required by zabbix

[Dennis Dmitriev]

Jenkins CI job: http://jenkins-product.srt.mirantis.net:8080/view/5.1_swarm/job/5.1_fuelmain.system_test.ubuntu.thread_2/46/ , test 'deploy_simple_zabbix'.

Puppet failed to install mysql-client on node-3 because higher version had already been installed:

============
2014-11-14T09:02:46.707772+00:00 err: Could not update: Execution of '/usr/bin/apt-get -q -y -o DPkg::Options::=--force-confold --force-yes install mysql-client-5.5=5.5.37-0ubuntu0.12.04.1' returned 100: Reading package lists...

===============================
root@node-3:~# dpkg -l |grep mysql
ii libdbd-mysql-perl 4.020-1build2 Perl5 database interface to the MySQL database
ii libmysqlclient18 5.5.37-0ubuntu0.12.04.1 MySQL database client library
iU mysql-client-5.5 5.5.37-0ubuntu0.12.04.1 MySQL database client binaries
ii mysql-client-5.6 5.6.16-ubuntu4 MySQL database client binaries
iU mysql-client-core-5.5 5.5.37-0ubuntu0.12.04.1 MySQL database core client binaries
ii mysql-client-core-5.6 5.6.16-ubuntu4 MySQL database core client binaries
ii mysql-common 5.5.37-0ubuntu0.12.04.1 MySQL database common files, e.g. /etc/mysql/my.cnf
rc mysql-server-5.5 5.5.37-0ubuntu0.12.04.1 MySQL database server binaries and system database setup
rc mysql-server-wsrep-5.6 5.6.16-ubuntu4 MySQL database server binaries and system database setup
ii mysql-server-wsrep-core-5.6 5.6.16-ubuntu4 MySQL database server binaries
ii mysql-wsrep-common-5.6 5.6.16-ubuntu4 MySQL 5.6 specific common files, e.g. /etc/mysql/conf.d/my-5.6.cnf
ii php5-mysql 5.3.10-1ubuntu3.12 MySQL module for php5
ii zabbix-server-mysql 1:2.2.2-ubuntu1 network monitoring solution - server (using MySQL)

======== apt-get log:
http://paste.openstack.org/show/133212/

======== manual run apt-get:
root@node-3:~# /usr/bin/apt-get -q -y -o DPkg::Options::=--force-confold --force-yes install mysql-client-5.5=5.5.37-0ubuntu0.12.04.1
Reading package lists...
Building dependency tree...
Reading state information...
mysql-client-5.5 is already the newest version.
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mysql-client-5.6 : Breaks: mysql-client-5.5 but 5.5.37-0ubuntu0.12.04.1 is to be installed
                    Breaks: virtual-mysql-client
 mysql-client-core-5.6 : Breaks: mysql-client-5.5 but 5.5.37-0ubuntu0.12.04.1 is to be installed
                         Breaks: mysql-client-core-5.5 but 5.5.37-0ubuntu0.12.04.1 is to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

[Stanislaw Bogatkin (sbogatkin)]

Dennis, mysql isn't root problem in that case.
Problem, according to logs is in apache2 service that doesn't started cause appropriate package won't installed. And next problems with mysql caused by that apache2 problem.

[Dennis Dmitriev (ddmitriev)]

Sure, there is an another promlem with apache2, which caused puppet dependency failure.

But how it is connected to *package* dependency failure?

You may see the following in the puppet.log from node-3, which caused mysql components v5.6 to install (please see the full apt-get log from the node: http://paste.openstack.org/show/133212/ )

======================= puppet.log
Fri Nov 14 09:02:05 +0000 2014 Puppet (debug): Executing '/usr/bin/dpkg-query -W --showformat '${Status} ${Package} ${Version} :DESC: ${Description}\n:DESC:\n' mysql-server-wsrep-5.6'
Fri Nov 14 09:02:05 +0000 2014 Puppet (debug): Got version '5.6.16-ubuntu4' for package 'mysql-server-wsrep-5.6' from the versions file
Fri Nov 14 09:02:05 +0000 2014 Puppet (debug): Installing package mysql-server-wsrep-5.6 from purged to 5.6.16-ubuntu4
Fri Nov 14 09:02:05 +0000 2014 Puppet (debug): Executing '/usr/bin/apt-get -q -y -o DPkg::Options::=--force-confold --force-yes install mysql-server-wsrep-5.6=5.6.16-ubuntu4'

Then, manifest for 'mysql-client' started to install mysql-client with the exactly version 5.5:

============ puppet.log
Fri Nov 14 09:02:46 +0000 2014 Puppet (err): Could not update: Execution of '/usr/bin/apt-get -q -y -o DPkg::Options::=--force-confold --force-yes install mysql-client-5.5=5.5.37-0ubuntu0.12.04.1' returned 100: Reading package lists...
...
The following extra packages will be installed:
  mysql-client-core-5.5
The following packages will be REMOVED:
  mysql-client-5.6 mysql-client-core-5.6 mysql-server-wsrep-5.6
The following NEW packages will be installed:
  mysql-client-5.5 mysql-client-core-5.5
0 upgraded, 2 newly installed, 3 to remove and 0 not upgraded.

But had no success:

==== puppet.log
dpkg: dependency problems prevent configuration of mysql-client-5.5:
 mysql-client-5.5 depends on mysql-client-core-5.5; however:
  Package mysql-client-core-5.5 is not configured yet.
 mysql-client-5.6 (5.6.16-ubuntu4) breaks mysql-client-5.5 and is installed.
 mysql-client-core-5.6 (5.6.16-ubuntu4) breaks mysql-client-5.5 and is installed.
 mysql-client-5.6 (5.6.16-ubuntu4) breaks virtual-mysql-client and is installed.
  mysql-client-5.5 (5.5.37-0ubuntu0.12.04.1) provides virtual-mysql-client.
dpkg: error processing mysql-client-5.5 (--configure):
 dependency problems - leaving unconfigured

[Dennis Dmitriev (ddmitriev)]

Looks like the issue with packages has been resolved in the build#17.

{u'build_id': u'2014-11-16_21-00-23', u'ostf_sha': u'64cb59c681658a7a55cc2c09d079072a41beb346', u'build_number': u'17', u'auth_required': True, u'nailgun_sha': u'2fc6fc4261092a591779a8fb7e3fb1623c6abb85', u'production': u'docker', u'api': u'1.0', u'fuelmain_sha': u'b118fa4475833ce031ef189ce280772c676fa1c9', u'astute_sha': u'702af3db6f5bca92525bc8322d7d5d7675ec857e', u'feature_groups': [u'mirantis'], u'release': u'5.1.1', u'release_versions': {u'2014.1.3-5.1.1': {u'VERSION': {u'build_id': u'2014-11-16_21-00-23', u'ostf_sha': u'64cb59c681658a7a55cc2c09d079072a41beb346', u'build_number': u'17', u'api': u'1.0', u'nailgun_sha': u'2fc6fc4261092a591779a8fb7e3fb1623c6abb85', u'production': u'docker', u'fuelmain_sha': u'b118fa4475833ce031ef189ce280772c676fa1c9', u'astute_sha': u'702af3db6f5bca92525bc8322d7d5d7675ec857e', u'feature_groups': [u'mirantis'], u'release': u'5.1.1', u'fuellib_sha': u'0d3909b9a291880af28dbe48b9c7d25215aa98ea'}}}, u'fuellib_sha': u'0d3909b9a291880af28dbe48b9c7d25215aa98ea'}

[Stanislaw Bogatkin (sbogatkin)]

I'll check it.

[Tomasz 'Zen' Napierala (tzn)]

Changing to "confirmed" instead of triaged as there is no workaround yet

[Stanislaw Bogatkin (sbogatkin)]

Status 'Triaged' by itself doesn't assume that there is any workaround. It assume that developer have all information for start working on bug and inderstand how to fix it. All that information is in that thread. That case just can't have workaround, cause there are need to just fix some puppet code.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/5.1
Review: https://review.openstack.org/135271

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/135271
Committed: https://git.openstack.org/cgit/stackforge/fuel-library/commit/?id=5a12ac04bfa34a2cb84ae52162af093039d1f42b
Submitter: Jenkins
Branch: stable/5.1

commit 5a12ac04bfa34a2cb84ae52162af093039d1f42b
Author: Stanislaw Bogatkin <email address hidden>
Date: Tue Nov 18 15:38:51 2014 +0300

    Call http server package before calling http server service.

    To start http server service we need to assure that package which
    realize that service is installed.

    Change-Id: I35d8015b82582b236e572b9ce92f5b52d34f6994
    Closes-Bug: #1392799

[Dennis Dmitriev (ddmitriev)]

{u'build_id': u'2014-11-23_21-01-00', u'ostf_sha': u'64cb59c681658a7a55cc2c09d079072a41beb346', u'build_number': u'34', u'auth_required': True, u'nailgun_sha': u'7580f6341a726c2019f880ae23ff3f1c581fd850', u'production': u'docker', u'api': u'1.0', u'fuelmain_sha': u'0fe3db7475b9f8b287c5b59cba94c9a40a8d8101', u'astute_sha': u'dade74af41d4972fe05a1c16ae1db2a2e60c6715', u'feature_groups': [u'mirantis'], u'release': u'5.1.1', u'release_versions':
Fix released.
{u'2014.1.3-5.1.1': {u'VERSION': {u'build_id': u'2014-11-23_21-01-00', u'ostf_sha': u'64cb59c681658a7a55cc2c09d079072a41beb346', u'build_number': u'34', u'api': u'1.0', u'nailgun_sha': u'7580f6341a726c2019f880ae23ff3f1c581fd850', u'production': u'docker', u'fuelmain_sha': u'0fe3db7475b9f8b287c5b59cba94c9a40a8d8101', u'astute_sha': u'dade74af41d4972fe05a1c16ae1db2a2e60c6715', u'feature_groups': [u'mirantis'], u'release': u'5.1.1', u'fuellib_sha': u'444339cae21c369c1d95e96c1059d4099077138e'}}}, u'fuellib_sha': u'444339cae21c369c1d95e96c1059d4099077138e'}