Package: mysql-server-5.0 Version: 5.0.36-1 Severity: grave Justification: renders package unusable
After an apt-get upgrade, any apt-get operation hangs while mysql-server-5.0 tries to configure itself. Adding a "set -x" at the top of the postinst script produces the following output: (Note: zh-TW.Big5 locale for the first few lines) # apt-get install 讀取套件清單中... 完成 了解套件依存關係中... 完成 更新 0 個套件,新安裝 0 個套件,刪除 0 個套件,另不更新 96 個套件。 2 個套件沒有完全安裝或刪除完畢。 需要下載 0B 的檔案。 解壓縮後將消耗 0B 的空間。 正在設定 mysql-server-5.0 (5.0.36-1) ... + . /usr/share/debconf/confmodule ++ '[' '!' '' ']' ++ PERL_DL_NONLAZY=1 ++ export PERL_DL_NONLAZY ++ '[' '' ']' ++ exec /usr/share/debconf/frontend /var/lib/dpkg/info/mysql-server-5.0.postinst configure 5.0.32-10 + . /usr/share/debconf/confmodule ++ '[' '!' 1 ']' ++ '[' -z '' ']' ++ exec ++ '[' '' ']' ++ exec ++ DEBCONF_REDIR=1 ++ export DEBCONF_REDIR + '[' -n '' ']' + export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/X11R6/bin:/.software/local/.admin/bins/bin:/usr/bin/X11:/usr/games:/opt/bin:/home/acli/bin:/sbin:/usr/sbin:/bin:/usr/bin + PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/X11R6/bin:/.software/local/.admin/bins/bin:/usr/bin/X11:/usr/games:/opt/bin:/home/acli/bin:/sbin:/usr/sbin:/bin:/usr/bin + ERR_LOGGER='logger -p daemon.err -t mysqld_safe -i' + MYSQL_BOOTSTRAP='/usr/sbin/mysqld --bootstrap --user=mysql --skip-grant-tables --skip-bdb --skip-innodb ' + set +e + invoke stop + '[' -x /usr/sbin/invoke-rc.d ']' + invoke-rc.d mysql stop Stopping MySQL database server: mysqld. + set -e + case "$1" in + mysql_cnf=/etc/mysql/my.cnf + mysql_datadir=/usr/share/mysql + mysql_statedir=/var/lib/mysql + mysql_rundir=/var/run/mysqld + mysql_logdir=/var/log + mysql_cfgdir=/etc/mysql + mysql_newlogdir=/var/log/mysql + mysql_upgradedir=/var/lib/mysql-upgrade + for dir in DATADIR LOGDIR + '[' DATADIR = DATADIR ']' + targetdir=/var/lib/mysql + savelink=/var/lib/mysql-upgrade/DATADIR.link + '[' -L /var/lib/mysql-upgrade/DATADIR.link ']' + rmdir /var/lib/mysql-upgrade + true + for dir in DATADIR LOGDIR + '[' LOGDIR = DATADIR ']' + targetdir=/var/log/mysql + savelink=/var/lib/mysql-upgrade/LOGDIR.link + '[' -L /var/lib/mysql-upgrade/LOGDIR.link ']' + rmdir /var/lib/mysql-upgrade + true + '[' '!' -d /var/lib/mysql -a '!' -L /var/lib/mysql ']' + '[' '!' -d /var/lib/mysql/mysql -a '!' -L /var/lib/mysql/mysql ']' + '[' '!' -d /var/log/mysql -a '!' -L /var/log/mysql ']' + set +e + chown -R 0.0 /usr/share/mysql + chown -R mysql /var/lib/mysql + chown -R mysql /var/run/mysqld + chown -R mysql:adm /var/log/mysql + chmod 2750 /var/log/mysql + for i in log err + touch /var/log/mysql.log + chown mysql:adm /var/log/mysql.log + chmod 0640 /var/log/mysql.log + for i in log err + touch /var/log/mysql.err + chown mysql:adm /var/log/mysql.err + chmod 0640 /var/log/mysql.err + set -e + db_set mysql-server/postrm_remove_database false + _db_cmd 'SET mysql-server/postrm_remove_database' false + IFS=' ' + printf '%s\n' 'SET mysql-server/postrm_remove_database false' + IFS=' ' + read -r _db_internal_line + RET='value set' + case ${_db_internal_line%%[ ]*} in + return 0 + touch /var/lib/mysql/debian-5.0.flag + db_get mysql-server-5.0/need_sarge_compat_done + _db_cmd 'GET mysql-server-5.0/need_sarge_compat_done' + IFS=' ' + printf '%s\n' 'GET mysql-server-5.0/need_sarge_compat_done' + IFS=' ' + read -r _db_internal_line + RET=true + case ${_db_internal_line%%[ ]*} in + return 0 + '[' true = false ']' + db_set mysql-server-5.0/need_sarge_compat_done true + _db_cmd 'SET mysql-server-5.0/need_sarge_compat_done' true + IFS=' ' + printf '%s\n' 'SET mysql-server-5.0/need_sarge_compat_done true' + IFS=' ' + read -r _db_internal_line + RET='value set' + case ${_db_internal_line%%[ ]*} in + return 0 + set +e + /bin/bash /usr/bin/mysql_install_db --rpm + logger -p daemon.err -t mysqld_safe -i + '[' 0 '!=' 0 ']' + set -e + dc=/etc/mysql/debian.cnf ++ fgrep mysql_upgrade /etc/mysql/debian.cnf + '[' -e /etc/mysql/debian.cnf -a -n '[mysql_upgrade]' ']' ++ sed -n 's/password *= *// p' /etc/mysql/debian.cnf ++ head -n 1 + pass=XsmHaP2TiQN9B6Xo + chown 0:0 /etc/mysql/debian.cnf + chmod 0600 /etc/mysql/debian.cnf ++ /bin/echo -e 'USE mysql\n' 'ALTER TABLE user CHANGE password Password varchar(41) collate utf8_bin NOT NULL default '\'''\''' + password_column_fix_query='USE mysql ALTER TABLE user CHANGE password Password varchar(41) collate utf8_bin NOT NULL default '\'''\''' ++ /bin/echo -e 'USE mysql\n' 'REPLACE INTO user SET ' ' host='\''localhost'\'', user='\''debian-sys-maint'\'', password=password('\''XsmHaP2TiQN9B6Xo'\''), ' ' Select_priv='\''Y'\'', Insert_priv='\''Y'\'', Update_priv='\''Y'\'', Delete_priv='\''Y'\'', ' ' Create_priv='\''Y'\'', Drop_priv='\''Y'\'', Reload_priv='\''Y'\'', Shutdown_priv='\''Y'\'', ' ' Process_priv='\''Y'\'', File_priv='\''Y'\'', Grant_priv='\''Y'\'', References_priv='\''Y'\'', ' ' Index_priv='\''Y'\'', Alter_priv='\''Y'\'' __EXTRA_PRIVS__' + replace_query='USE mysql REPLACE INTO user SET host='\''localhost'\'', user='\''debian-sys-maint'\'', password=password('\''XsmHaP2TiQN9B6Xo'\''), Select_priv='\''Y'\'', Insert_priv='\''Y'\'', Update_priv='\''Y'\'', Delete_priv='\''Y'\'', Create_priv='\''Y'\'', Drop_priv='\''Y'\'', Reload_priv='\''Y'\'', Shutdown_priv='\''Y'\'', Process_priv='\''Y'\'', File_priv='\''Y'\'', Grant_priv='\''Y'\'', References_priv='\''Y'\'', Index_priv='\''Y'\'', Alter_priv='\''Y'\'' __EXTRA_PRIVS__' ++ /bin/echo -e ', Show_db_priv='\''Y'\'' ' ', Super_priv='\''Y'\'' ' ', Create_tmp_table_priv='\''Y'\'' ' ', Lock_tables_priv='\''Y'\'' ' ', Execute_priv='\''Y'\'' ' ', Repl_slave_priv='\''Y'\'' ' ', Repl_client_priv='\''Y'\'' ' + extra_privs=', Show_db_priv='\''Y'\'' , Super_priv='\''Y'\'' , Create_tmp_table_priv='\''Y'\'' , Lock_tables_priv='\''Y'\'' , Execute_priv='\''Y'\'' , Repl_slave_priv='\''Y'\'' , Repl_client_priv='\''Y'\'' ' + echo 'USE mysql ALTER TABLE user CHANGE password Password varchar(41) collate utf8_bin NOT NULL default '\'''\''' + /usr/sbin/mysqld --bootstrap --user=mysql --skip-grant-tables --skip-bdb --skip-innodb + logger -p daemon.err -t mysqld_safe -i After this, the postinst script just sits there doing nothing. If I press ^C then the apt-get fails with an error. -- System Information: Debian Release: 4.0 APT prefers unstable APT policy: (500, 'unstable'), (500, 'stable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.4.28-ow1 Locale: LANG=zh_TW.Big5, LC_CTYPE=zh_TW.Big5 (charmap=BIG5) Versions of packages mysql-server-5.0 depends on: ii adduser 3.102 Add and remove users and groups ii debconf [debconf-2.0] 1.5.13 Debian configuration management sy ii libc6 2.3.6.ds1-13 GNU C Library: Shared libraries ii libdbi-perl 1.54-1 Perl5 database interface by Tim Bu ii libgcc1 1:4.1.1-21 GCC support library ii libmysqlclient15off 5.0.36-1 mysql database client library ii libncurses5 5.5-5 Shared libraries for terminal hand ii libreadline5 5.2-2 GNU readline and history libraries ii libstdc++6 4.1.1-21 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-13 Wietse Venema's TCP wrappers libra ii lsb-base 3.1-23.1 Linux Standard Base 3.1 init scrip ii mysql-client-5.0 5.0.36-1 mysql database client binaries ii mysql-common 5.0.36-1 mysql database common files (e.g. ii passwd 1:4.0.18.1-7 change and administer password and ii perl 5.8.8-7 Larry Wall's Practical Extraction ii psmisc 22.3-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3-13 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/need_sarge_compat: false mysql-server/error_setting_password: mysql-server-5.0/mysql_update_hints1: mysql-server-5.0/need_sarge_compat_done: true