Bug#387481: mysql-server-5.0: startup blocks when checking huge databases

2006-09-19 Thread Christian Hammers
tags 387481 + confirmed tags 387481 - unreproducible stop At least I found the problem: while applying some unrelated LSB-compliance patches the init script was changed to call debian-start with output=$( /etc/mysql/debian-start ) This method of calling a script seems to prevent the backgr

Bug#387481: mysql-server-5.0: startup blocks when checking huge databases

2006-09-15 Thread 蔡鎮宇
Hi again On Fri, Sep 15, 2006 at 10:38:23AM +0200, Christian Hammers wrote: > But /etc/mysql/debian-start contains this block? > ( > mycheck; > myupgrade; > ) & Yes it does. > Funnily there is no /etc/mysql/debian-start script in this ps output although > I > see it in the processlist. S

Bug#387481: mysql-server-5.0: startup blocks when checking huge databases

2006-09-15 Thread Christian Hammers
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 > > > >

Bug#387481: mysql-server-5.0: startup blocks when checking huge databases

2006-09-14 Thread 蔡鎮宇
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

Bug#387481: mysql-server-5.0: startup blocks when checking huge databases

2006-09-14 Thread Christian Hammers
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"

Bug#387481: mysql-server-5.0: startup blocks when checking huge databases

2006-09-14 Thread Christian Hammers
Hi On 2006-09-15 [EMAIL PROTECTED] wrote: > 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 wai

Bug#387481: mysql-server-5.0: startup blocks when checking huge databases

2006-09-14 Thread wens
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, no