[Bug 1201669] [NEW] mysql service unable to start via upstart script

[Launchpad Bug Tracker]

You have been subscribed to a public bug:

Installed mysql-server meta package which pulled in mysql-server-5.5 and
mysql-server-core-5.5 which created both an upstart script (attached)
and a sysvinit script.

When starting mysql via the service command, the presense of the upstart
script causes that script to be used in preference of the sysvinit
script.  The problem is, with the upstart script present in /etc/init,
it is impossible to start or stop the mysql service:

bladernr at klaatu:~/development/devstack$ sudo service mysql status
status: Unknown job: mysql
bladernr at klaatu:~/development/devstack$ sudo service mysql restart
stop: Unknown job: mysql
start: Unknown job: mysql
bladernr at klaatu:~/development/devstack$ sudo service mysql stop
stop: Unknown job: mysql

Now, if I remove the upstart script causing service to fall back on the
sysvinit script, I am able to stop, start and do other things with the
mysql service:

bladernr at klaatu:~/development/devstack$ sudo mv /etc/init/mysql.conf .
bladernr at klaatu:~/development/devstack$ sudo service mysql status
 * /usr/bin/mysqladmin  Ver 8.42 Distrib 5.5.31, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version		5.5.31-0ubuntu1-log
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/run/mysqld/mysqld.sock
Uptime:			5 hours 27 min 56 sec

Threads: 1  Questions: 572  Slow queries: 432  Opens: 421  Flush tables: 1  Open tables: 41  Queries per second avg: 0.029
bladernr at klaatu:~/development/devstack$ sudo service mysql restart
 * Stopping MySQL database server mysqld                                                                                                      [ OK ] 
 * Starting MySQL database server mysqld                                                                                                      [ OK ] 
 * Checking for tables which need an upgrade, are corrupt or were 
not closed cleanly.


So the problem appears to be with the upstart job on Saucy.

I tried this also on a second machine running raring with mysql-
server-5.5 (5.5.31-0ubuntu0.13.04.1) and mysql-server-core-5.5
(5.5.31-0ubuntu0.14.04.1) and am able to successfully start and stop the
mysql service using the upstart script via service:

bladernr at garbagescow:~$ find /etc -name mysql.conf
/etc/init/mysql.conf
bladernr at garbagescow:~$ sudo service mysql restart
mysql stop/waiting
mysql start/running, process 5825

ProblemType: Bug
DistroRelease: Ubuntu 13.10
Package: mysql-server 5.5.31-0ubuntu1
ProcVersionSignature: Ubuntu 3.10.0-2.11-generic 3.10.0
Uname: Linux 3.10.0-2-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.10.2-0ubuntu4
Architecture: amd64
Date: Mon Jul 15 18:04:22 2013
InstallationDate: Installed on 2012-03-15 (487 days ago)
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Alpha amd64 (20120307)
Logs.var.log.daemon.log:
 
MarkForUpload: True
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: False
PackageArchitecture: all
SourcePackage: mysql-5.5
UpgradeStatus: Upgraded to saucy on 2013-06-22 (23 days ago)

** Affects: upstart (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apparmor apport-bug saucy
-- 
mysql service unable to start via upstart script
https://bugs.launchpad.net/bugs/1201669
You received this bug notification because you are a member of Ubuntu Foundations Bugs, which is subscribed to upstart in Ubuntu.