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.
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 &
Even if I revert the change, it still hangs.
> 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
Best regards,
wens
P.S. The architecure is x86_64, if it matters.
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
