Bug #3090 server crash

• Submitted: 7 Mar 2004 5:01
• Modified: 8 Mar 2004 9:49
• Reporter: Bob Bishop
• Status: Can't repeat
• 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.