MySQL Bugs: #11911: 4.1 hangs on connections on freebsd

Bug #11911	4.1 hangs on connections on freebsd
Submitted:	13 Jul 2005 12:26	Modified:	9 Apr 2008 9:17
Reporter:	Aleksey Kishkin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1.12	OS:	FreeBSD (FreeBSD 4.10)
Assigned to:		CPU Architecture:	Any

Description:
As our customer reported:

I am attempting to do upgrade from 4.0.20 to 4.1.12. 4.0.20 is a binary provided by mysql, and 4.1.12 is downloaded from your website: mysql-debug-4.1.12-unknown-freebsd4.7-i386

When I start the mysql daemon I am unable to connect with locally written applications. The hang on connect. If I go in on a socket to get into mysql, I see they're waiting on login:

mysql> show processlist;
+----+----------------------+--------------------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+----------------------+--------------------+------+---------+------+-------+------------------+
| 2 | unauthenticated user | 192.168.68.130:26509 | NULL | Connect | NULL | login | NULL |
| 3 | unauthenticated user | 192.168.68.130:14958 | NULL | Connect | NULL | login | NULL |
| 4 | unauthenticated user | 192.168.68.130:20733 | NULL | Connect | NULL | login | NULL |
| 5 | unauthenticated user | 192.168.68.130:15285 | NULL | Connect | NULL | login | NULL |

.. etc

If I telnet to the port, I see get nothing

# telnet 0 3000
Trying 0.0.0.0...
Connected to 0.
Escape character is '^]'.

^]
telnet> close
Connection closed.

As opposed to our 4.0 version of the server:

# telnet 0 3306
Trying 0.0.0.0...
Connected to 0.
Escape character is '^]'.
+
4.0.20-log=&#65533;tscxTwy|,Connection closed by foreign host.

How to repeat:
run mysql server on freebsd, check by telnet if server responds

installed freebsd ,recompiled kernel  and setup mysql according customer's report, but still cannot reproduce it.

Hi!  I'm setting this bug report to "Can't Repeat" status, because we have been unable to repeat the problem in any way on this end.  If anyone has more information that may make this bug reproducible outside of the original context, then please let us know.

Thank you,

Timothy

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Many thanks for writing a bug report.

This won't occur by using newer versions of FreeBSD and MySQL. I will close this bug report now.