Bug #3090 server crash
Submitted: 7 Mar 2004 5:01 Modified: 8 Mar 2004 9:49
Reporter: Bob Bishop Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.0-alpha OS:FreeBSD (FreeBSD 5.2R)
Assigned to: Dean Ellis CPU Architecture:Any

[7 Mar 2004 5:01] Bob Bishop
Description:
Simple query with aggregate function crashes the server. From the error log:

Version: '4.1.0-alpha'  socket: '/tmp/mysql.sock'  port: 3306
mysqld got signal 11;
[...]
key_buffer_size=8388600
read_buffer_size=131072
sort_buffer_size=2097144
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K
bytes of memory

The system has 512MB

How to repeat:
mysql> create table t1 (i integer(10));
Query OK, 0 rows affected (0.00 sec)

mysql> create table t2 (j integer(10));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 values (5);
Query OK, 1 row affected (0.00 sec)

mysql> insert into t2 values (4);
Query OK, 1 row affected (0.01 sec)

mysql> select i+j from t1,t2;
+------+
| i+j  |
+------+
|    9 |
+------+
1 row in set (0.00 sec)

mysql> select i+max(j) from t1,t2;
ERROR 2013: Lost connection to MySQL server during query
[8 Mar 2004 9:49] Dean Ellis
I cannot repeat this with 4.1.2.  4.1.0 is quite old now, so update this if you encounter the problem again with a current release.