Bug#367027: mysql-server-5.0: Init script fails with bogus error "The partition with /var/lib/mysql is too full"

[Farzad FARID]

Package: mysql-server-5.0
Version: 5.0.21-3
Severity: important
Tags: patch

Hi,

Starting mysql fails with this error:

# /etc/init.d/mysql start
/etc/init.d/mysql[20635]: ERROR: The partition with /var/lib/mysql is too full!

The error happens because I have set the env variable BLOCKSIZE=k, which
modifies df's output:

# LC_ALL=C df --portability /var/lib/mysql/. | tail -n 1
/dev/mapper/VG1-LV_VAR  3133140K  2017052K  1116088K      65% /var
# BLOCKSIZE= LC_ALL=C df --portability /var/lib/mysql/. | tail -n 1
/dev/mapper/VG1-LV_VAR   3133140   2017052   1116088      65% /var

Here is a patch:

--- /etc/init.d/mysql.orig      2006-05-12 23:51:07.000000000 +0200
+++ /etc/init.d/mysql   2006-05-12 23:51:35.000000000 +0200
@@ -45,7 +45,7 @@
   fi

   datadir=`mysqld_get_param datadir`
-  if LC_ALL=C df --portability $datadir/. | tail -n 1 | awk '{ exit ($4>4096) 
}'; then
+  if BLOCKSIZE= LC_ALL=C df --portability $datadir/. | tail -n 1 | awk '{ exit 
($4>4096) }'; then
     /bin/echo "ERROR: The partition with $datadir is too full!" | $ERR_LOGGER 
-s
     exit 1
   fi


 Regards

-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.16-1-686-smp
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=UTF-8)

Versions of packages mysql-server-5.0 depends on:
ii  adduser                       3.87       Add and remove users and groups
ii  debconf [debconf-2.0]         1.5.0      Debian configuration management sy
ii  libc6                         2.3.6-7    GNU C Library: Shared libraries
ii  libdbi-perl                   1.50-2     Perl5 database interface by Tim Bu
ii  libgcc1                       1:4.1.0-4  GCC support library
ii  libmysqlclient15off           5.0.21-3   mysql database client library
ii  libncurses5                   5.5-2      Shared libraries for terminal hand
ii  libreadline5                  5.1-7      GNU readline and history libraries
ii  libstdc++6                    4.1.0-4    The GNU Standard C++ Library v3
ii  libwrap0                      7.6.dbs-9  Wietse Venema's TCP wrappers libra
ii  mysql-client-5.0              5.0.21-3   mysql database client binaries
ii  mysql-common                  5.0.21-3   mysql database common files (e.g. 
ii  passwd                        1:4.0.15-7 change and administer password and
ii  perl                          5.8.8-4    Larry Wall's Practical Extraction 
ii  psmisc                        22.2-1     Utilities that use the proc filesy
ii  zlib1g                        1:1.2.3-11 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  mailx            1:8.1.2-0.20050715cvs-1 A simple mail user agent

-- debconf information:
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/start_on_boot: true
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/no_upgrade_with_isam_tables:
* mysql-server-5.0/mysql_install_db_notes:
  mysql-server-5.0/mysql_update_hints1:


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]