5 messages in com.mysql.lists.bugsmysql 3.22.32 hangs on FreeBSD 4.1 (l...| From | Sent On | Attachments |
|---|---|---|
| Ekaterina Ivannikova | 13 Oct 2000 00:27 | |
| sas...@mysql.com | 13 Oct 2000 09:17 | |
| Michael Widenius | 13 Oct 2000 11:42 | |
| Thimble Smith | 14 Oct 2000 18:43 | |
| Ekaterina Ivannikova | 16 Oct 2000 02:28 |
| Subject: | mysql 3.22.32 hangs on FreeBSD 4.1 (long) |
|---|---|
| From: | Michael Widenius (mon...@mysql.com) |
| Date: | 10/13/2000 11:42:49 AM |
| List: | com.mysql.lists.bugs |
Hi!
"Ekaterina" == Ekaterina Ivannikova <ka...@gutatelecom.ru> 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