mysql start script reports an error although server starts correcly

gerryino · 10-08-2008, 11:30 AM

Hi, my machine is a debian etch, no packages from other release installed.

After an upgrade, mysql server (v. 5.0) has started to give a fake error return value while starting.
Despite that it starts correctly and works great the return value is not true.

The drawback is that dpkg is assuming the installation went bad, so it leaves the package status half-configured.

Every time i update or add some package, it tries to finish the install (and fails of course).

i've tried a /bin/bash -x /etc/init.d/mysql start, but i can't debug it
Maybe i nedd to force the package status?

Code:

+ set -e
+ set -u
+ test -x /usr/sbin/mysqld
+ . /lib/lsb/init-functions
++ FANCYTTY=
++ '[' -e /etc/lsb-base-logging.sh ']'
++ true
+++ dirname /etc/init.d/mysql
++ cd /etc/init.d
++ pwd -P
++ basename /etc/init.d/mysql
+ SELF=/etc/init.d/mysql
+ CONF=/etc/mysql/my.cnf
+ MYADMIN='/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf'
+ ERR_LOGGER='logger -p daemon.err -t /etc/init.d/mysql -i'
+ cd /
+ umask 077
+ export HOME=/etc/mysql/
+ HOME=/etc/mysql/
+ case "${1:-''}" in
+ sanity_checks
+ '[' '!' -r /etc/mysql/my.cnf ']'
+ grep -q '^expire.logs.days' /etc/mysql/my.cnf
++ mysqld_get_param datadir
++ /usr/sbin/mysqld --print-defaults
++ tr ' ' '\n'
++ grep -- --datadir
++ tail -n 1
++ cut -d= -f2
+ datadir=
+ LC_ALL=C
+ BLOCKSIZE=
+ df --portability /.
+ tail -n 1
+ awk '{ exit ($4>4096) }'
+ log_daemon_msg 'Starting MySQL database server' mysqld
+ '[' -z 'Starting MySQL database server' ']'
+ '[' -z mysqld ']'
+ echo -n 'Starting MySQL database server: mysqld'
+ mysqld_status check_alive nowarn
++ /usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping
+ ping_output='/usr/bin/mysqladmin: connect to server at '\''localhost'\'' failed
error: '\''Can'\''t connect to local MySQL server through socket '\''/var/run/mysqld/mysqld.sock'\'' (2)'\''
Check that mysqld is running and that the socket: '\''/var/run/mysqld/mysqld.sock'\'' exists!'
+ ping_alive=0
+ ps_alive=0
++ mysqld_get_param pid-file
++ /usr/sbin/mysqld --print-defaults
++ tr ' ' '\n'
++ grep -- --pid-file
++ tail -n 1
++ cut -d= -f2
+ pidfile=
+ '[' -f '' ']'
+ '[' check_alive = check_alive -a 0 = 1 ']'
+ '[' check_alive = check_dead -a 0 = 0 -a 0 = 0 ']'
+ '[' nowarn = warn ']'
+ return 1
+ for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14
+ sleep 1
+ /usr/bin/mysqld_safe
+ mysqld_status check_alive nowarn
++ /usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping
+ ping_output='mysqld is alive'
+ ping_alive=1
+ ps_alive=0
++ mysqld_get_param pid-file
++ /usr/sbin/mysqld --print-defaults
++ tr ' ' '\n'
++ grep -- --pid-file
++ tail -n 1
++ cut -d= -f2
+ pidfile=
+ '[' -f '' ']'
+ '[' check_alive = check_alive -a 1 = 1 ']'
+ return 0
+ break
+ mysqld_status check_alive warn
++ /usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping
+ ping_output='mysqld is alive'
+ ping_alive=1
+ ps_alive=0
++ mysqld_get_param pid-file
++ /usr/sbin/mysqld --print-defaults
++ grep -- --pid-file
++ tail -n 1
++ cut -d= -f2
++ tr ' ' '\n'
+ pidfile=
+ '[' -f '' ']'
+ '[' check_alive = check_alive -a 1 = 1 ']'
+ return 0
+ log_end_msg 0
+ '[' -z 0 ']'
+ log_use_fancy_output
+ TPUT=/usr/bin/tput
+ EXPR=/usr/bin/expr
+ '[' xxterm '!=' xdumb ']'
+ '[' -x /usr/bin/tput ']'
+ '[' -x /usr/bin/expr ']'
+ /usr/bin/tput hpa 60
+ /usr/bin/tput setaf 1
+ '[' -z ']'
+ FANCYTTY=1
+ case "$FANCYTTY" in
+ true
++ /usr/bin/tput setaf 1
+ RED='[31m'
++ /usr/bin/tput op
+ NORMAL='[39;49m'
+ '[' 0 -eq 0 ']'
+ echo .
+ return 0
++ mysqlcheck -s
+ output='You forgot to give the arguments! Please see mysqlcheck --help
for more information.'