Hi!
>>>>> "Ekaterina" == Ekaterina Ivannikova <kate@stripped>
> writes:
Ekaterina> Hi All,
Ekaterina> This is a repost of my letter which I sent a couple of days ago to mysql
Ekaterina> mailing list with some additional info. Any advice is much appreciated,
Ekaterina> and I do need this problem solved soon. Please help.
Ekaterina> I am experiencing repeated hangs of mysqld 3.22.32 on FreeBSD 4.1-RELEASE,
Ekaterina> mysqld is compiled from the ports with native threads. It starts ok, works
Ekaterina> for some time and then hangs. Hangs are caused by htdig web indexing
> software
Ekaterina> accessing mysql thru apache php3.0.16 module. They are absolutely
> repeatable,
Ekaterina> it just takes mysql different time to hang.
Ekaterina> Release: mysql-3.22.32 (Source distribution)
<cut>
The only way I can think of to find out what's wrong is to compile
MySQL with debugging (--with-debug=full) and start mysqld withing gdb.
When MySQL stops responding, you can do a break and do
info threads
thread 1
bt
thread 2
bt
The above assumes that gdb works with threads on FreeBSD 4.1 (I don't
know if this is the case).
Could you also try if MySQL 3.23.x works better; If there is a bug,
we would rather fix this in 3.23, as 3.23 will declared as a stable
relase pretty soon!
Regards,
Monty
