Bug #5793 can't connect to mysql server via non-loopback interface
Submitted: 29 Sep 2004 5:28 Modified: 8 Nov 2004 1:40
Reporter: Sergey Aleshin Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.0.20, 3.23.58 OS:FreeBSD (FreeBSD 5.3beta4)
Assigned to: Assigned Account CPU Architecture:Any

[29 Sep 2004 5:28] Sergey Aleshin
Description:
I have some troubles trying to connect to mysql server:

[asg@rcd ~]$ mysql -h server -u ics -p ics
Enter password:
ERROR 2013: Lost connection to MySQL server during query
[asg@rcd ~]$ mysql -h localhost -u ics -p ics
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye

In server .err file:

/usr/local/libexec/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail

key_buffer_size=8388600
record_buffer=131072
sort_buffer=2097144
max_used_connections=18
max_connections=100
threads_connected=18
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation

040929 10:19:33  mysqld restarted

How to repeat:
Just install FreeBSD 5.3beta4, than any version of mysql from ports (i'v tested with 3.23.58 and 4.0.20) and try to connect to server via non-loopback interface.

Suggested fix:
Unknown
[8 Oct 2004 1:40] Matthew Lord
Hi Sergey,

Thank you for your bug report!

Did you use the SKIP_DNS_CHECK=yes  build option?  Does the crash occur when only using IP 
addresses?  There have been known problems with the FreeBSD gethostbyname() function.

Unfortunately we do not have any machines running such a nascent version of FreeBSD so any
help you can offer would be appreciated.  I would be willing to provide my public ssh key as well
if you would like me to take a look myself.

Best Regards
[14 Feb 2005 22:54] Bugs System
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".