[Bug 812423] [NEW] mysql upstart job hangs if database directory not mounted

[Jo Liss]

Public bug reported:

[I think this might be a bug. Copied from
http://serverfault.com/questions/291003/mysql-upstart-job-hangs-if-
database-directory-not-mounted ]

I have mysqld pointed to an external volume:

    $ cat /etc/mysql/conf.d/data_joliss.cnf 
    [mysqld]
    datadir=/mnt/data_joliss/mysql

This is working fine in general. But sometimes the volume is not
mounted, for whatever reason. In those cases, mysqld fails like it
should:

    # mysqld
    110716 14:17:42 [Warning] Can't create test file /mnt/data_joliss/mysql/opinionated-programmer.lower-test
    110716 14:17:42 [Warning] Can't create test file /mnt/data_joliss/mysql/opinionated-programmer.lower-test
    mysqld: Can't change dir to '/mnt/data_joliss/mysql/' (Errcode: 2)
    110716 14:17:42 [ERROR] Aborting
    
    110716 14:17:42 [Note] mysqld: Shutdown complete

However, the upstart job on Ubuntu 11.04 (`start mysql` or `service start mysql`) simply waits (hangs) indefinitely without outputting anything. The strace isn't telling me anything, but if anybody cares to take a look:
strace -fv start mysql => https://gist.github.com/1086397

I would like the `mysql` upstart job to just report an error and
terminate rather than hanging. How do I do this?

(Background: I have an EC2 instance with an extra EBS volume to store
permanent data. If the EBS volume is not available at boot time, the
system hangs waiting for mysql, and I cannot even SSH into it to fix the
problem -- so now my instance has become completely unusable. I would
like it to just continue booting, even without a MySQL server.)

----------------

Ubuntu 11.04 on EC2, ami-06ad526f

mysql-server-core-5.1:
  Installed: 5.1.54-1ubuntu4
  Candidate: 5.1.54-1ubuntu4
  Version table:
 *** 5.1.54-1ubuntu4 0
        500 http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
        100 /var/lib/dpkg/status

ProblemType: Bug
DistroRelease: Ubuntu 11.04
Package: upstart 0.9.7-1
ProcVersionSignature: Ubuntu 2.6.38-8.42-virtual 2.6.38.2
Uname: Linux 2.6.38-8-virtual i686
Architecture: i386
Date: Mon Jul 18 17:13:55 2011
Ec2AMI: ami-06ad526f
Ec2AMIManifest: (unknown)
Ec2AvailabilityZone: us-east-1a
Ec2InstanceType: t1.micro
Ec2Kernel: aki-407d9529
Ec2Ramdisk: unavailable
ExecutablePath: /sbin/initctl
ProcEnviron:
 SHELL=/bin/bash
 PATH=(custom, user)
 LC_COLLATE=POSIX
 LANG=en_US.UTF-8
 LC_TIME=POSIX
SourcePackage: upstart
UpgradeStatus: No upgrade log present (probably fresh install)

** Affects: mysql-5.1 (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: apport-bug ec2-images i386 natty

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in Ubuntu.
https://bugs.launchpad.net/bugs/812423

Title:
  mysql upstart job hangs if database directory not mounted

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/812423/+subscriptions