On Thu, Nov 27, 2003 at 06:25:38PM -0600, Dan Nelson wrote:
> In the last episode (Nov 27), Chris Elsworth said:
> > Most of the time, MySQL 4.0.16 runs absolutely fine on my FreeBSD 4.9
> > system. However, today, unexplicably, it's run into the same problem
> > 3 times now; a couple of the threads suddenly start eating 100% CPU
> > for no good reason while doing a SELECT. They'll sit there until I
> > kill them, which results in a lot of hair tearing as it comes back up
> > checking all the tables.
> > I haven't been able to produce a core despite sending it a SIGABRT,
> > but I'll try recompiling with -g (do the supplied binaries have this?)
> > soon.
> You can use the gcore command to create a coredump of a running program
> without killing it, and the pstack command (in ports) is handy for
> printing the stacks of all threads in a running process without even
> coring it. Once you get a stack trace, send it to
> freebsd-threads@stripped and/or here.
Please do post a strack trace here. I'd very curious to see what it
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 75 days, processed 2,959,075,536 queries (456/sec. avg)