MySQL 4.1.19 server setup got stuck in a loop

[Gergo Szakal]

On Mon, 05 Jun 2006 22:54:32 +0100
Mark Cullen <mark.r.cullen at xxxxxxxxx> wrote:

Recently installed MySQL from pkgsrc (same way as you described) and cannot confirm, works flawlessly.

>Hi there,
>
>I just now installed MySQL 4.1.19 from pkgsrc, trying to set up a DF box 
>and see if I can get it all working properly before I even attempt to 
>migrate from FreeBSD 4.11. Anyway, I copied the rc script, mysqld, from 
>/usr/pkg/share/examples/rc.d/ to /usr/pkg/etc/rc.d, put "mysqld=yes" in 
>/etc/rc.conf and then proceeded to run `/usr/pkg/etc/rc.d/mysqld start`.
>
>As this was the first run, it appeared to run some kind of 
>initialisation / setup script:
>
>---
>df# /usr/pkg/etc/rc.d/mysqld start
>Initializing MySQL database system tables.
>Installing all prepared tables
>Fill help tables
>---
>
>It sat at "Fill help tables" for a rather long time:
>
>---
>load: 0.53  cmd: mysqld 76314 [running] 9.44u 29.35s 97% 7640k
>load: 0.90  cmd: mysqld 76314 [running] 31.43u 101.62s 76% 7644k
>load: 0.92  cmd: mysqld 76314 [running] 32.67u 105.74s 97% 7644k
>load: 0.92  cmd: mysqld 76314 [running] 32.91u 106.38s 95% 7644k
>load: 0.92  cmd: mysqld 76314 [running] 33.09u 106.98s 97% 7644k
>load: 0.92  cmd: mysqld 76314 [running] 33.34u 107.62s 97% 7644k
>load: 0.96  cmd: mysqld 76314 [running] 44.30u 141.85s 97% 7644k
>load: 0.96  cmd: mysqld 76314 [running] 44.85u 143.44s 97% 7644k
>load: 1.87  cmd: mysqld 76314 [running] 64.96u 206.69s 49% 7644k
>load: 1.87  cmd: mysqld 76314 [running] 65.33u 208.05s 44% 7644k
>---
>
>It was using 100% CPU time (the last couple I was compiling pure-ftpd, 
>so it didn't get it all). Anyway, at this point I did a `truss` on the 
>process (maybe I should have used ktrace?!) and got the following two 
>lines repeated, over and over:
>
>---
>sigprocmask(0x1,0x28391da0,0xbfafef10)           = 0 (0x0)
>sigprocmask(0x3,0xbfafef10,0x0)                  = 0 (0x0)
>---
>
>I'm not sure if that's any use to anyone? Any idea's what went wrong 
>here? I ctrl+c'd it and ran the script again and the server has actually 
>started just fine, and I can login at least (that's as far as I have 
>tested so far).
>
>DragonFly df.bone.servebeer.com 1.4.4-RELEASE DragonFly 1.4.4-RELEASE 
>#1: Sat Apr 22 10:46:47 PDT 2006 
>root@:/home/usr.obj/usr/src/sys/GENERIC  i386
>
>Any more info needed I will gladly provide it.
>
>Thanks,
>Mark