[OSCI] 7.0.mos-new.install-deb fails because mysql service can't start

Bug #1475288 reported by Ilya Tyaptin
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fuel for OpenStack
Fix Released
High
Alexander Tsamutali

Bug Description

In Ceilometer patches jenkis job 7.0.mos-new.install-deb fails, because mysql service can't start and it hangs on service restart. As a result ssh loses connection during the installing ceilometer services via ssh.

2015-07-17 12:06:24 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-07-17 12:06:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
/usr/bin/mysqladmin: connect to server at 'localhost' failed

Errors from mysql log:
http://paste.openstack.org/show/383249/

Mysql server version is 5.6.23.

[1] http://osci-jenkins.srt.mirantis.net:8080/job/7.0.mos-new.install-deb/893/console
[2] Log duplication for the case if job will be deleted http://paste.mirantis.net/show/750/
[3] Review - https://review.fuel-infra.org/#/c/9347/

Changed in fuel:
status: New → Confirmed
importance: Undecided → High
assignee: nobody → Fuel DevOps (fuel-devops)
milestone: none → 7.0
Changed in fuel:
assignee: Fuel DevOps (fuel-devops) → Alexander Tsamutali (astsmtl)
summary: - [OSCI] 7.0.mos-new.install-deb fails because ssh lost connection
+ [OSCI] 7.0.mos-new.install-deb fails because mysql service can't start
description: updated
Revision history for this message
Ivan Berezovskiy (iberezovskiy) wrote :

If we remove file /etc/mysql/conf.d/wsrep.cnf, service mysql start to work. So, the issue could be fixed in runtests.sh script.

Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Related fix merged to openstack-build/ceilometer-build (openstack-ci/fuel-7.0/2015.1.0)

Reviewed: https://review.fuel-infra.org/9407
Submitter: Igor Yozhikov <email address hidden>
Branch: openstack-ci/fuel-7.0/2015.1.0

Commit: f1d3994392d898e55ebf26d15ca81fdfd76308ce
Author: Ivan Udovichenko <email address hidden>
Date: Fri Jul 17 09:18:58 2015

Remove patch from Ceilometer source package

  Remove disable-kafka.patch because of changes which were
  made directly to the code [1]..

  [1] Change-Id: I8d460b3c73167ee38db76d3b902dffc19212682b

  Fix runtests.sh script to work with mysql:
  remove /etc/mysql/conf.d/wsrep.cnf file
  Related-bug: #1475288

Change-Id: Ieb5de54841e9f23e7bfff8deef2a2ba3b5227ffb

Changed in fuel:
status: Confirmed → Fix Committed
Revision history for this message
Alexander Tsamutali (astsmtl) wrote :

You can skip installation of mysql-wsrep-common-5.6 with `--no-install-recommends' option to apt-get.

Changed in fuel:
status: Fix Committed → Fix Released
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.