Bug #8965 MySQL Server gets Signal 11 on disconnect

• Submitted: 4 Mar 2005 23:36
• Modified: 6 Mar 2005 6:48
• Reporter: Kalle Ravn
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.21
• OS: Linux (Suse Linux)
• CPU Architecture: Any

[4 Mar 2005 23:36] Kalle Ravn

Description:
The MySQL server crashes and leaves only "mysqld got signal 11" in error log.

It appears that when the mysql client disconnects, the server needs to check its hostname somewhere.

I'm not a c/c++ techie, and can't produce a backtrace, but follow the instructs below.

How to repeat:
1. Remove all DNS-servers from network interfaces, and all hardcoded host names for the client server in /etc/hosts .
2. Connect from a remote machine to the server.
3. Perform 0 or more querys
4. Disconnect
5. Watch in the servers error log that it is restarting.

Suggested fix:
Don't know, but remove the hostname requirement somewhere.

[4 Mar 2005 23:41] Kalle Ravn

Entered wrong version... it is 4.0.21, not 4.0.23

[6 Mar 2005 6:48] MySQL Verification Team

I wasn't able to repeat with a server built with latest BK source,
I removed the hostname server from /etc/hosts and connected
from a Windows machine:

C:\mysql\bin>mysql -h192.168.0.77 -umiguel -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.24-debug-log

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

mysql> show databases;
+---------------+
| Database      |
+---------------+
| bug8613       |
| mysql         |
| mysql_support |
| t0            |
| t1            |
| t5            |
| test          |
| test64        |
+---------------+
8 rows in set (0.08 sec)

mysql> exit
Bye

C:\mysql\bin>mysql -h192.168.0.77 -umiguel -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.24-debug-log

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

mysql> exit
Bye

C:\mysql\bin>mysqladmin -h192.168.0.77 -umiguel -p ping
Enter password: ********
mysqld is alive

C:\mysql\bin>