2013-07-16 13:55:14 |
Jeff Lane |
description |
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@klaatu:~/development/devstack$ sudo service mysql status
status: Unknown job: mysql
bladernr@klaatu:~/development/devstack$ sudo service mysql restart
stop: Unknown job: mysql
start: Unknown job: mysql
bladernr@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@klaatu:~/development/devstack$ sudo mv /etc/init/mysql.conf .
bladernr@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@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@garbagescow:~$ find /etc -name mysql.conf
/etc/init/mysql.conf
bladernr@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) |
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@klaatu:~/development/devstack$ sudo service mysql status
status: Unknown job: mysql
bladernr@klaatu:~/development/devstack$ sudo service mysql restart
stop: Unknown job: mysql
start: Unknown job: mysql
bladernr@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@klaatu:~/development/devstack$ sudo mv /etc/init/mysql.conf .
bladernr@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@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@garbagescow:~$ find /etc -name mysql.conf
/etc/init/mysql.conf
bladernr@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) |
|