Bug#453127:
Will this correction be ported to the stable distribution. One of our production server with the myhuge.cnf has just hang up this morning. We just killed the find process. Preinst code: if [ -n `find $cvt_datadir -name '*.ISM' 2/dev/null` ]; then pidfile=`cvt_get_param pid-file` if [ $pidfile ] [ -f $pidfile ]; then server_pid=`cat $pidfile` if [ $server_pid ] ps $server_pid /dev/null 21; then server_running=yes fi fi # to be sure mysqld --print-defaults output: mysqld --print-defaults mysqld would have been started with the following arguments: --port=3306 --socket=/var/run/mysqld/mysqld.sock --skip-locking --key_buffer=256M --max_allowed_packet=1M --table_cache=2048 --sort_buffer_size=2M --read_buffer_size=2M --read_rnd_buffer_size=8M --myisam_sort_buffer_size=64M --thread_cache_size=48 --query_cache_size=48M --thread_concurrency=8 --server-id=1 --innodb_buffer_pool_size=64M --max_connections=400 --long_query_time=1 --log-slow-queries=/var/log/mysql/sq.log --log-queries-not-using-indexes=/var/log/mysql/ni.log --log-error=/var/log/mysql/error.log --ft_min_word_len=1 Thank you for your work. -- -- Gregory Boddin -- get2future sprl mobile: +32 485 201 442 office: +32 2 771 77 10 fax: +32 2 416 63 64 http://www.g2f.be -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#453127: [debian-mysql] Bug#453127:
Am Dienstag, den 08.01.2008, 09:29 +0100 schrieb gregory: Will this correction be ported to the stable distribution. One of our production server with the myhuge.cnf has just hang up this morning. We just killed the find process. It seems to affect more people than I initially thought, so I'll put it on the TODO list for an update in the next etch point release. Norbert -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#453127: [debian-mysql] Bug#453127: mysql-common: preinst breaks on upgrade if datadir not set
Am Dienstag, den 27.11.2007, 10:18 -0500 schrieb Edward Allcutt: I've also prepared a fix to the preinst which checks that the datadir exists before running find: Good catch, thanks. Patch applied. Norbert -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#453127: mysql-common: preinst breaks on upgrade if datadir not set
Package: mysql-common Version: 5.0.32-7etch1 Severity: normal I run multiple mysqld instances on the same machine. Each uses a separate config file. None of them use /etc/mysql/my.cnf which doesn't exist on this system. On upgrade, the mysql-common preinst gets the datadir from /etc/mysql/my.cnf (mysqld --print-defaults | ...) then runs find on the result. Since there is no my.cnf the resultant shell variable is empty and find uses $PWD (which seems to be /). As this was taking rather a long time I just killed find. I've worked around this by creating a dummy my.cnf containing a fake datadir entry. I've also prepared a fix to the preinst which checks that the datadir exists before running find: --- mysql-common.preinst2007-11-27 10:00:14.0 -0500 +++ mysql-common.preinst.fixed 2007-11-27 10:17:25.0 -0500 @@ -150,7 +150,7 @@ if [ $1 = upgrade ] [ -x /usr/sbin/mysqld ]; then cvt_datadir=`cvt_get_param datadir` # test for ISAM tables, which we must convert NOW - if [ -n `find $cvt_datadir -name '*.ISM' 2/dev/null` ]; then + if [ -n $cvt_datadir ] [ -d $cvt_datadir ] [ -n `find $cvt_datadir -name '*.ISM' 2/dev/null` ]; then pidfile=`cvt_get_param pid-file` if [ $pidfile ] [ -f $pidfile ]; then server_pid=`cat $pidfile` -- System Information: Debian Release: 4.0 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.18-5-686 Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8) -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]