mysql-server-5.1 starts before filesystem is mounted (karmic)

[Gernot Pansy]

On my setup with an different partition for the mysql data the server is started before the filesystem is mounted. Starting the server after booting works without problems. My extra partition is on a lvm which also holds the root partition.

fstab:
=====
#/dev/vg1/var
UUID=7e2ba06c-0294-4aaa-98c3-18aa86c01004 /mnt/var xfs noatime 0 2

my.cnf:
======
datadir = /mnt/var/mysql

syslog:
======
Oct 22 21:19:37 hollywood kernel: [ 18.271254] Ending clean XFS mount for filesystem: dm-2
Oct 22 21:19:38 hollywood /etc/init.d/mysql[1714]: ERROR: The partition with /mnt/var/mysql is too full!
Oct 22 21:19:39 hollywood kernel: [ 19.910926] XFS mounting filesystem dm-3
Oct 22 21:19:39 hollywood mysqld_safe: Starting mysqld daemon with databases from /mnt/var/mysql
Oct 22 21:19:39 hollywood wpa_supplicant[1446]: CTRL-EVENT-SCAN-RESULTS
Oct 22 21:19:39 hollywood wpa_supplicant[1446]: Trying to associate with 00:1b:2f:d5:88:80 (SSID='TFGP' freq=2452 MHz)
Oct 22 21:19:39 hollywood kernel: [ 20.176999] ndiswrapper (iw_set_auth:1602): invalid cmd 12
Oct 22 21:19:39 hollywood mysqld: 091022 21:19:39 [Warning] Can't create test file /mnt/var/mysql/hollywood.lower-test
Oct 22 21:19:39 hollywood mysqld: 091022 21:19:39 [Warning] Can't create test file /mnt/var/mysql/hollywood.lower-test
Oct 22 21:19:39 hollywood mysqld: #007/usr/sbin/mysqld: Can't change dir to '/mnt/var/mysql/' (Errcode: 2)
Oct 22 21:19:39 hollywood mysqld: 091022 21:19:39 [ERROR] Aborting
Oct 22 21:19:39 hollywood mysqld:
Oct 22 21:19:39 hollywood mysqld: 091022 21:19:39 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 22 21:19:39 hollywood mysqld:
Oct 22 21:19:39 hollywood mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Oct 22 21:19:40 hollywood acpid: client connected from 1725[0:0]
Oct 22 21:19:40 hollywood kernel: [ 21.164472] Ending clean XFS mount for filesystem: dm-3
Oct 22 21:19:40 hollywood kernel: [ 21.338747] XFS mounting filesystem dm-4
Oct 22 21:19:41 hollywood wpa_supplicant[1446]: Association request to the driver failed
Oct 22 21:19:41 hollywood wpa_supplicant[1446]: Associated with 00:1b:2f:d5:88:80
Oct 22 21:19:41 hollywood wpa_supplicant[1446]: CTRL-EVENT-CONNECTED - Connection to 00:1b:2f:d5:88:80 completed (auth) [id=0 id_str=]
Oct 22 21:19:41 hollywood kernel: [ 21.588762] ADDRCONF(NETDEV_CHANGE): wlan0: link becomes ready
Oct 22 21:19:42 hollywood kernel: [ 22.690264] Ending clean XFS mount for filesystem: dm-4
Oct 22 21:19:42 hollywood avahi-daemon[1335]: Registering new address record for fe80::219:5bff:fe0a:a69c on wlan0.*.
Oct 22 21:19:43 hollywood kernel: [ 23.891420] XFS mounting filesystem dm-5

[Diogo Matsubara (matsubara)]

Marked Launchpad task as invalid since this is not a Launchpad bug

[Chuck Short (zulcss)]

Which version of mysql is this?

Regards
chuck

[Gernot Pansy (notz)]

installed packages mysql packages:

dpkg -l | grep mysql
ii libdbd-mysql-perl 4.011-1ubuntu1 A Perl5 database interface to the MySQL data
ii libmysqlclient15off 5.1.30really5.0.83-0ubuntu3 MySQL database client library
ii libmysqlclient16 5.1.37-1ubuntu5 MySQL database client library
ii libqt4-sql-mysql 4.5.3really4.5.2-0ubuntu1 Qt 4 MySQL database driver
ii mysql-client-5.1 5.1.37-1ubuntu5 MySQL database client binaries
ii mysql-common 5.1.37-1ubuntu5 MySQL database common files (e.g. /etc/mysql
ii mysql-server 5.1.37-1ubuntu5 MySQL database server (metapackage depending
ii mysql-server-5.1 5.1.37-1ubuntu5 MySQL database server binaries
ii mysql-server-core-5.1 5.1.37-1ubuntu5 MySQL database core server files
ii php5-mysql 5.2.10.dfsg.1-2ubuntu5 MySQL module for php5
ii python-mysqldb 1.2.2-10 A Python interface to MySQL

[Chuck Short (zulcss)]

Thanks Ill try to reproduce this later.

Regards
chuck

[Andrea Torre (andtor)]

Weird as it sounds, I got around the issue moving up the relevant entry in fstab (/dev/sda7), and positioning it just between / and swap mounting. I must warn, however, that mysqld seldom does not start anyway and I cannot isolate the cause for such a random behaviour. Hope this helps.

fstab
----------
proc /proc proc defaults 0 0
# Entry for /dev/sda5 :
UUID=c8977b47-2247-4000-ae0d-8ada0daa0090 / ext4 errors=remount-ro 0 1
/dev/sda7 /media/STORAGE ext4 auto,defaults 0 2
# Entry for /dev/sda6 :
UUID=ffc31c20-17fa-4acd-8249-343643570986 none swap sw 0 0
/dev/scd0 /media/cdrom0 udf,iso9660 user,noauto,exec,utf8 0 0
/dev/sda3 /media/DATA ntfs-3g defaults,locale=it_IT.UTF-8 0 0

dpkg -l | grep mysql
--------------------------
ii libdbd-mysql-perl 4.011-1ubuntu1 A Perl5 database interface to the MySQL data
ii libmysqlclient15off 5.1.30really5.0.83-0ubuntu3 MySQL database client library
ii libmysqlclient16 5.1.37-1ubuntu5 MySQL database client library
ii mysql-admin 5.0r12-1ubuntu2 GUI tool for intuitive MySQL administration
ii mysql-client-5.1 5.1.37-1ubuntu5 MySQL database client binaries
ii mysql-common 5.1.37-1ubuntu5 MySQL database common files (e.g. /etc/mysql
ii mysql-gui-tools-common 5.0r12-1ubuntu2 Architecture independent files for MySQL GUI
ii mysql-query-browser 5.0r12-1ubuntu2 Official GUI tool to query MySQL database
ii mysql-server-5.1 5.1.37-1ubuntu5 MySQL database server binaries
ii mysql-server-core-5.1 5.1.37-1ubuntu5 MySQL database core server files

[Chuck Short (zulcss)]

Can you check to see if this is fixed in lucid?

Thanks
chuck

[Chuck Short (zulcss)]

We'd like to figure out what's causing this bug for you, but we haven't heard back from you in a while. Could you please provide the requested information? Thanks!

[Andrea Torre (andtor)]

Sorry for having not replied earlier. I haven't tried Lucid yet. However I had to reinstall Karmic a couple of months ago and since then the issue has appeared only once, even though the pc is booted daily.

Regards
Andrea

[Andrea Torre (andtor)]

Upgraded to Lucid two weeks ago. Everything runs smooth since then.

Regards
Andrea

 dpkg -l | grep mysql
------------------
ii libdbd-mysql-perl 4.012-1ubuntu1 A Perl5 database interface to the MySQL data
ii libmysqlclient15off 5.1.30really5.0.83-0ubuntu3 MySQL database client library
ii libmysqlclient16 5.1.41-3ubuntu12.1 MySQL database client library
ii mysql-admin 5.0r14+openSUSE-2build1 GUI tool for intuitive MySQL administration
ii mysql-client-5.1 5.1.41-3ubuntu12.1 MySQL database client binaries
ii mysql-client-core-5.1 5.1.41-3ubuntu12.1 MySQL database core client binaries
ii mysql-common 5.1.41-3ubuntu12.1 MySQL database common files (e.g. /etc/mysql
ii mysql-gui-tools-common 5.0r14+openSUSE-2build1 Architecture independent files for MySQL GUI
ii mysql-query-browser 5.0r14+openSUSE-2build1 Official GUI tool to query MySQL database
ii mysql-server 5.1.41-3ubuntu12.1 MySQL database server (metapackage depending
ii mysql-server-5.1 5.1.41-3ubuntu12.1 MySQL database server binaries
ii mysql-server-core-5.1 5.1.41-3ubuntu12.1 MySQL database core server files
ii mysql-workbench-oss 5.1.18-1ubu904 MySQL Workbench

[Launchpad Janitor (janitor)]

[Expired for mysql-dfsg-5.1 (Ubuntu) because there has been no activity for 60 days.]