[Bug 1201669] Re: unable to start any service via upstart script, sysvinit scripts work fine though

[Aaron Brady]

I have this problem after installing mysql-server - it's like the job is
not picked up. Doing a `kill -HUP 1` causes things to work how they
should, and then I can start and stop the mysql job.

I am running within an LXC container on Precise.

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to upstart in Ubuntu.
https://bugs.launchpad.net/bugs/1201669

Title:
  unable to start any service via upstart script, sysvinit scripts work
  fine though

Status in “upstart” package in Ubuntu:
  Incomplete

Bug description:
  NOTE: I originally filed this against mysql-server, but in reality
  what I'm seeing affects pretty much every upstart job.  I can't start
  them, stop them, or query them.  I can do fine if I delete the upstart
  script causing 'service' to fall back to sysvinit scripts in
  /etc/init.d/ however.

  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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/upstart/+bug/1201669/+subscriptions