Package: mysql-server-core-5.1
Version: 5.1.49-3
Severity: normal
Hi, today I made an aptitude full-upgrade with no warnings on a different
machine
which had the mysql failure message problem.
I do not explicitly use mysql on this machine, only automatic stuff is
installed,
nameley mysql-server-core-5.1 but not mysql-server-5.1.
The upgrade reported no warnings about mysql, but the file /etc/init.d/mysql
has not been upgraded.
Nonetheless to say I do not remember having modified the init.d/mysql file.
(I attach a copy of the current one.)
.... so exactly the same problem on a second machine. (More on this later, from
my third machine.)
regards, ric
------------------------ INFO
-------------------------------------------------------------------
majorana:~# cat /var/log/apt/term.log|egrep -i -C1 'mysql'
Unpacking replacement libqt4-help ...
Preparing to replace mysql-common 5.1.49-1 (using
.../mysql-common_5.1.49-3_all.deb) ...
Unpacking replacement mysql-common ...
Preparing to replace libmysqlclient16 5.1.49-1 (using
.../libmysqlclient16_5.1.49-3_i386.deb) ...
Unpacking replacement libmysqlclient16 ...
Preparing to replace libqt4-sql-mysql 4:4.6.3-1+b1 (using
.../libqt4-sql-mysql_4%3a4.6.3-4_i386.deb) ...
Unpacking replacement libqt4-sql-mysql ...
Preparing to replace libqt4-sql-sqlite 4:4.6.3-1+b1 (using
.../libqt4-sql-sqlite_4%3a4.6.3-4_i386.deb) ...
--
Unpacking replacement modemmanager ...
Preparing to replace mysql-server-core-5.1 5.1.49-1 (using
.../mysql-server-core-5.1_5.1.49-3_i386.deb) ...
Unpacking replacement mysql-server-core-5.1 ...
Preparing to replace wpasupplicant 0.6.10-2 (using
.../wpasupplicant_0.6.10-2.1_i386.deb) ...
--
Setting up libqt4-help (4:4.6.3-4) ...
Setting up mysql-common (5.1.49-3) ...
Setting up libmysqlclient16 (5.1.49-3) ...
Setting up libqt4-sql-mysql (4:4.6.3-4) ...
Setting up libqt4-sql-sqlite (4:4.6.3-4) ...
--
Setting up modemmanager (0.4+git.20100624t180933.6e79d15-2) ...
Setting up mysql-server-core-5.1 (5.1.49-3) ...
Setting up wpasupplicant (0.6.10-2.1) ...
majorana:~# ls /etc/init.d/mysql.dpkg-dist
ls: cannot access /etc/init.d/mysql.dpkg-dist: No such file or directory
majorana:~# head -n 25 /etc/init.d/mysql|cat -n
1 #!/bin/bash
2 #
3 ### BEGIN INIT INFO
4 # Provides: mysql
5 # Required-Start: $remote_fs $syslog
6 # Required-Stop: $remote_fs $syslog
7 # Should-Start: $network $named $time
8 # Should-Stop: $network $named $time
9 # Default-Start: 2 3 4 5
10 # Default-Stop: 0 1 6
11 # Short-Description: Start and stop the mysql database server daemon
12 # Description: Controls the main MySQL database server daemon
"mysqld"
13 # and its wrapper script "mysqld_safe".
14 ### END INIT INFO
15 #
16 set -e
17 set -u
18 ${DEBIAN_SCRIPT_DEBUG:+ set -v -x}
19
20 test -x /usr/sbin/mysqld || exit 0
21
22 . /lib/lsb/init-functions
23
24 SELF=$(cd $(dirname $0); pwd -P)/$(basename $0)
25 CONF=/etc/mysql/my.cnf
majorana:~# cat /var/log/daemon.log|egrep -i mysql
Jan 9 17:24:09 majorana /etc/init.d/mysql[1718]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 9 17:24:09 majorana /etc/init.d/mysql[1718]: /etc/init.d/mysql: line 75:
/usr/bin/mysqladmin: No such file or directory
Jan 9 17:24:09 majorana /etc/init.d/mysql[1718]:
Jan 15 09:50:50 majorana /etc/init.d/mysql[1725]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 15 09:50:50 majorana /etc/init.d/mysql[1725]: /etc/init.d/mysql: line 75:
/usr/bin/mysqladmin: No such file or directory
Jan 15 09:50:50 majorana /etc/init.d/mysql[1725]:
Jan 15 11:54:56 majorana /etc/init.d/mysql[1825]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 15 11:54:56 majorana /etc/init.d/mysql[1825]: /etc/init.d/mysql: line 75:
/usr/bin/mysqladmin: No such file or directory
Jan 15 11:54:56 majorana /etc/init.d/mysql[1825]:
Jan 15 11:56:13 majorana /etc/init.d/mysql[1679]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 15 11:56:13 majorana /etc/init.d/mysql[1679]: /etc/init.d/mysql: line 75:
/usr/bin/mysqladmin: No such file or directory
Jan 15 11:56:13 majorana /etc/init.d/mysql[1679]:
majorana:~# aptitude search mysql-server
p mysql-server - MySQL database server
(metapackage depending on the latest ve
v mysql-server-5.0 -
c mysql-server-5.1 - MySQL database server
binaries and system database setup
v mysql-server-core -
v mysql-server-core-5.0 -
i A mysql-server-core-5.1 - MySQL database server
binaries
v virtual-mysql-server -
majorana:~#
-- System Information:
Debian Release: 6.0
APT prefers testing
APT policy: (900, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-5-686 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages mysql-server-core-5.1 depends on:
ii libc6 2.11.2-7 Embedded GNU C Library: Shared lib
ii libgcc1 1:4.4.5-8 GCC support library
ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3
ii libwrap0 7.6.q-19 Wietse Venema's TCP wrappers libra
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
mysql-server-core-5.1 recommends no packages.
mysql-server-core-5.1 suggests no packages.
-- no debconf information
#!/bin/bash
#
### BEGIN INIT INFO
# Provides: mysql
# Required-Start: $remote_fs $syslog
# Required-Stop: $remote_fs $syslog
# Should-Start: $network $named $time
# Should-Stop: $network $named $time
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: Start and stop the mysql database server daemon
# Description: Controls the main MySQL database server daemon "mysqld"
# and its wrapper script "mysqld_safe".
### END INIT INFO
#
set -e
set -u
${DEBIAN_SCRIPT_DEBUG:+ set -v -x}
test -x /usr/sbin/mysqld || exit 0
.. /lib/lsb/init-functions
SELF=$(cd $(dirname $0); pwd -P)/$(basename $0)
CONF=/etc/mysql/my.cnf
MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
# priority can be overriden and "-s" adds output to stderr
ERR_LOGGER="logger -p daemon.err -t /etc/init.d/mysql -i"
# Safeguard (relative paths, core dumps..)
cd /
umask 077
# mysqladmin likes to read /root/.my.cnf. This is usually not what I want
# as many admins e.g. only store a password without a username there and
# so break my scripts.
export HOME=/etc/mysql/
## Fetch a particular option from mysql's invocation.
#
# Usage: void mysqld_get_param option
mysqld_get_param() {
/usr/sbin/mysqld --print-defaults \
| tr " " "\n" \
| grep -- "--$1" \
| tail -n 1 \
| cut -d= -f2
}
## Do some sanity checks before even trying to start mysqld.
sanity_checks() {
# check for config file
if [ ! -r /etc/mysql/my.cnf ]; then
log_warning_msg "$0: WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz"
echo "WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz" | $ERR_LOGGER
fi
# check for diskspace shortage
datadir=`mysqld_get_param datadir`
if LC_ALL=C BLOCKSIZE= df --portability $datadir/. | tail -n 1 | awk '{ exit ($4>4096) }'; then
log_failure_msg "$0: ERROR: The partition with $datadir is too full!"
echo "ERROR: The partition with $datadir is too full!" | $ERR_LOGGER
exit 1
fi
}
## Checks if there is a server running and if so if it is accessible.
#
# check_alive insists on a pingable server
# check_dead also fails if there is a lost mysqld in the process list
#
# Usage: boolean mysqld_status [check_alive|check_dead] [warn|nowarn]
mysqld_status () {
ping_output=`$MYADMIN ping 2>&1`; ping_alive=$(( ! $? ))
ps_alive=0
pidfile=`mysqld_get_param pid-file`
if [ -f "$pidfile" ] && ps `cat $pidfile` >/dev/null 2>&1; then ps_alive=1; fi
if [ "$1" = "check_alive" -a $ping_alive = 1 ] ||
[ "$1" = "check_dead" -a $ping_alive = 0 -a $ps_alive = 0 ]; then
return 0 # EXIT_SUCCESS
else
if [ "$2" = "warn" ]; then
echo -e "$ps_alive processes alive and '$MYADMIN ping' resulted in\n$ping_output\n" | $ERR_LOGGER -p daemon.debug
fi
return 1 # EXIT_FAILURE
fi
}
#
# main()
#
case "${1:-''}" in
'start')
sanity_checks;
# Start daemon
log_daemon_msg "Starting MySQL database server" "mysqld"
if mysqld_status check_alive nowarn; then
log_progress_msg "already running"
log_end_msg 0
else
# Could be removed during boot
test -e /var/run/mysqld || install -m 755 -o mysql -g root -d /var/run/mysqld
# Start MySQL!
/usr/bin/mysqld_safe > /dev/null 2>&1 &
# 6s was reported in #352070 to be too few when using ndbcluster
for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14; do
sleep 1
if mysqld_status check_alive nowarn ; then break; fi
log_progress_msg "."
done
if mysqld_status check_alive warn; then
log_end_msg 0
# Now start mysqlcheck or whatever the admin wants.
output=$(/etc/mysql/debian-start)
[ -n "$output" ] && log_action_msg "$output"
else
log_end_msg 1
log_failure_msg "Please take a look at the syslog"
fi
fi
;;
'stop')
# * As a passwordless mysqladmin (e.g. via ~/.my.cnf) must be possible
# at least for cron, we can rely on it here, too. (although we have
# to specify it explicit as e.g. sudo environments points to the normal
# users home and not /root)
log_daemon_msg "Stopping MySQL database server" "mysqld"
if ! mysqld_status check_dead nowarn; then
set +e
shutdown_out=`$MYADMIN shutdown 2>&1`; r=$?
set -e
if [ "$r" -ne 0 ]; then
log_end_msg 1
[ "$VERBOSE" != "no" ] && log_failure_msg "Error: $shutdown_out"
log_daemon_msg "Killing MySQL database server by signal" "mysqld"
killall -15 mysqld
server_down=
for i in 1 2 3 4 5 6 7 8 9 10; do
sleep 1
if mysqld_status check_dead nowarn; then server_down=1; break; fi
done
if test -z "$server_down"; then killall -9 mysqld; fi
fi
fi
if ! mysqld_status check_dead warn; then
log_end_msg 1
log_failure_msg "Please stop MySQL manually and read /usr/share/doc/mysql-server-5.1/README.Debian.gz!"
exit -1
else
log_end_msg 0
fi
;;
'restart')
set +e; $SELF stop; set -e
$SELF start
;;
'reload'|'force-reload')
log_daemon_msg "Reloading MySQL database server" "mysqld"
$MYADMIN reload
log_end_msg 0
;;
'status')
if mysqld_status check_alive nowarn; then
log_action_msg "$($MYADMIN version)"
else
log_action_msg "MySQL is stopped."
exit 3
fi
;;
*)
echo "Usage: $SELF start|stop|restart|reload|force-reload|status"
exit 1
;;
esac
