Hi
On 2006-09-15 _________ wrote:
> On Thu, Sep 14, 2006 at 11:55:44PM +0200, Christian Hammers wrote:
> >
> > Can you check if the output of the following command differs on your server?
> >
> > md5sum /usr/share/mysql/debian-start.inc.sh /etc/mysql/debian-start
> > /etc/init.d/mysql
> >
> > ce5dc68c4d5108db26593207d53b6aa1 /usr/share/mysql/debian-start.inc.sh
> > 5c0b9fdf52c91b4bf5e74f8d4b8ae2d2 /etc/mysql/debian-start
> > beca0a2a4eb72cc4362d2c5ab6348d8e /etc/init.d/mysql
> >
> > If it does do "apt-get --reinstall install mysql-server-5.0" as the current
> > package should be ok. The mysqlcheck may block your clients from accessing
> > the tables (in this case uncomment it) but the script itself ends
> > immediately as you can see at with ampersand ("&"):
> I have checked the files.
>
> ce5dc68c4d5108db26593207d53b6aa1 /usr/share/mysql/debian-start.inc.sh
> 4fcd158aa1843dfbc7b84fabd2499ad1 /etc/mysql/debian-start
> 976f24ea60c8c70e7decab79682a3d47 /etc/init.d/mysql
>
> /etc/mysql/debian-start is consistent with the conffile data of the package. I
> tried reinstalling, but no effect. It also matches the file I retrieved from
> the
> dpkg file.
But /etc/mysql/debian-start contains this block?
(
mycheck;
myupgrade;
) &
> I have made a minor change to /etc/init.d/mysql, just adding a nice before
> mysqld_safe, as follows:
>
> nice -n 19 /usr/bin/mysqld_safe > /dev/null 2>&1 &
BTW, you can do that in /etc/mysql/my.cnf, too:
[mysqld_safe]
nice = 0
> > If it still hangs, please send me the output of "ps faxuwww" and
> > "mysqladmin processlist".
> >
> > bye,
> >
> > -christian-
> [EMAIL PROTECTED]:~# mysqladmin processlist
> +----+------------------+-----------+-------+---------+------+--------------+-------------------------------+
> | Id | User | Host | db | Command | Time | State |
> Info |
> +----+------------------+-----------+-------+---------+------+--------------+-------------------------------+
> | 3 | debian-sys-maint | localhost | login | Query | 302 | Sending data |
> CHECK TABLE `login2005` FAST |
> | 4 | root | localhost | | Query | 0 | |
> show processlist |
> +----+------------------+-----------+-------+---------+------+--------------+-------------------------------+
>
> I have removed irrelevant entries from the following process list. (We have
> over
> 60000 processes running. Not what you would want. )
>
> [EMAIL PROTECTED]:~# ps faxuwww
> USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
> root 2550 0.0 0.0 25820 1276 ? Ss Sep14 0:07
> /usr/sbin/sshd
> root 93277 0.0 0.0 36772 2676 ? Ss 10:44 0:00 \_ sshd:
> wens [priv]
> wens 93331 0.0 0.0 36900 2012 ? S 10:44 0:00 | \_
> sshd: [EMAIL PROTECTED]/120
> wens 93332 0.0 0.0 15592 3704 pts/120 Ss 10:44 0:00 | \_
> -bash
> root 93451 0.0 0.0 15076 3444 pts/120 S 10:44 0:00 |
> \_ /bin/bash
> root 94655 0.0 0.0 42180 11364 pts/120 S+ 10:46 0:00 |
> \_ apt-get --reinstall install mysql-server-5.0
> root 95456 0.0 0.0 8992 3516 pts/120 S+ 10:46 0:00 |
> \_ /usr/bin/dpkg --status-fd 13 --configure mysql-server-5.0
> root 95458 0.0 0.0 33856 11080 pts/120 S+ 10:46 0:00 |
> \_ /usr/bin/perl -w /usr/share/debconf/frontend
> /var/lib/dpkg/info/mysql-server-5.0.postinst configure 5.0.24a-3
> root 95478 0.0 0.0 9196 1576 pts/120 S+ 10:46 0:00 |
> \_ /bin/bash -e /var/lib/dpkg/info/mysql-server-5.0.postinst
> configure 5.0.24a-3
> root 95688 0.0 0.0 9172 1496 pts/120 S+ 10:46 0:00 |
> \_ /bin/sh /usr/sbin/invoke-rc.d mysql start
> root 95714 0.0 0.0 9244 1580 pts/120 S+ 10:46 0:00 |
> \_ /bin/bash /etc/init.d/mysql start
> root 95754 0.0 0.0 9156 1496 pts/120 SN+ 10:46 0:00 |
> \_ /bin/sh /usr/bin/mysqld_safe
> mysql 95845 45.2 0.2 163884 41768 pts/120 SNl+ 10:46 3:53 |
> \_ /usr/sbin/mysqld --basedir=/usr
> --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid
> --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
> root 95847 0.0 0.0 4856 596 pts/120 SN+ 10:46 0:00 |
> \_ logger -p daemon.err -t mysqld_safe -i -t
> mysqld
>
Funnily there is no /etc/mysql/debian-start script in this ps output although I
see it in the processlist. Seems you censored too much :)
Maybe "apt-get --reinstall" hangs although "/etc/init.d/mysql restat", which
I always tested, does not. I have to check that...
bye,
-christian-
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
