tags 387481 + unreproducible moreinfo
stop
On 2006-09-15 [EMAIL PROTECTED] wrote:
> Package: mysql-server-5.0
> Version: 5.0.24a-3
>
> Hi,
> I have a database with at least three huge tables (4 int columns
> with 100M+ rows). Every time mysql is started by invoking
> "/etc/init.d/mysql start", the script just hangs before the message in
> the next line is printed.
> "Checking for corrupt, not cleanly closed and upgrade needing tables."
>
> Using mysql client, I find that mysqlcheck is running. But
> I thought this should be done in the background, with the script
> returning. This creates a problem when the system is rebooted, and the
> startup process just hangs there for half an hour waiting for it.
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 ("&"):
$ tail /etc/mysql/debian-start
# If you want to disable the check for crashed tables comment "mycheck" out.
echo "Checking for corrupt, not cleanly closed and upgrade needing tables."
(
mycheck;
myupgrade;
) &
exit 0
If it still hangs, please send me the output of "ps faxuwww" and
"mysqladmin processlist".
bye,
-christian-
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
