MySQL 4.1.19 server setup got stuck in a loop

[Mark Cullen]

Gergo Szakal wrote:
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
Yep, very odd.

I have done another fresh install and did not run in to this problem at all!

A very hard to trigger bug somewhere?