Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.1
-
None
-
2021-10, 2021-11
Description
A query was discovered that can kill the MariaDB process:
MariaDB [nn]> alter table t engine='innodb';
|
Query OK, 0 rows affected (0.118 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [nn]> SELECT sum(0+0)-sum(0+0) from t;
|
+-------------------+
|
| sum(0+0)-sum(0+0) |
|
+-------------------+
|
| NULL |
|
+-------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [nn]> alter table t engine='columnstore';
|
Query OK, 0 rows affected (0.094 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [nn]> SELECT sum(0+0)-sum(0+0) from t;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [nn]>
|
|
|
Here are some variations on the same query:
|
MariaDB [nn]> select sum(null) from t;
|
+-----------+
|
| sum(null) |
|
+-----------+
|
| NULL |
|
+-----------+
|
1 row in set (0.042 sec)
|
|
|
MariaDB [nn]> select sum(null)-sum(null) from t;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
|
|
MariaDB [nn]> select avg(null)-avg(null) from t;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
Looking in the mariadb.err file:
210518 12:38:21 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
...
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
A query was discovered that can kill the MariaDB process:
{{monospaced text}} MariaDB [nn]> alter table t engine='innodb'; Query OK, 0 rows affected (0.118 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [nn]> SELECT sum(0+0)-sum(0+0) from t; +-------------------+ | sum(0+0)-sum(0+0) | +-------------------+ | NULL | +-------------------+ 1 row in set (0.000 sec) MariaDB [nn]> alter table t engine='columnstore'; Query OK, 0 rows affected (0.094 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [nn]> SELECT sum(0+0)-sum(0+0) from t; ERROR 2013 (HY000): Lost connection to MySQL server during query MariaDB [nn]> Here are some variations on the same query: MariaDB [nn]> select sum(null) from t; +-----------+ | sum(null) | +-----------+ | NULL | +-----------+ 1 row in set (0.042 sec) MariaDB [nn]> select sum(null)-sum(null) from t; ERROR 2013 (HY000): Lost connection to MySQL server during query MariaDB [nn]> select avg(null)-avg(null) from t; ERROR 2013 (HY000): Lost connection to MySQL server during query {{monospaced text}} Looking in the mariadb.err file: {{monospaced text}} 210518 12:38:21 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary ... {{monospaced text}} |
A query was discovered that can kill the MariaDB process:
{noformat} MariaDB [nn]> alter table t engine='innodb'; Query OK, 0 rows affected (0.118 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [nn]> SELECT sum(0+0)-sum(0+0) from t; +-------------------+ | sum(0+0)-sum(0+0) | +-------------------+ | NULL | +-------------------+ 1 row in set (0.000 sec) MariaDB [nn]> alter table t engine='columnstore'; Query OK, 0 rows affected (0.094 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [nn]> SELECT sum(0+0)-sum(0+0) from t; ERROR 2013 (HY000): Lost connection to MySQL server during query MariaDB [nn]> Here are some variations on the same query: MariaDB [nn]> select sum(null) from t; +-----------+ | sum(null) | +-----------+ | NULL | +-----------+ 1 row in set (0.042 sec) MariaDB [nn]> select sum(null)-sum(null) from t; ERROR 2013 (HY000): Lost connection to MySQL server during query MariaDB [nn]> select avg(null)-avg(null) from t; ERROR 2013 (HY000): Lost connection to MySQL server during query {noformat} Looking in the mariadb.err file: {noformat} 210518 12:38:21 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary ... {noformat} |
| Fix Version/s | Icebox [ 22302 ] |
| Rank | Ranked higher |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Fix Version/s | 6.1.2 [ 26035 ] | |
| Fix Version/s | Icebox [ 22302 ] |
| Rank | Ranked higher |
| Assignee | Gregory Dorman [ gdorman ] |
| Assignee | Gregory Dorman [ gdorman ] | Alexander Barkov [ bar ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Alexander Barkov [ bar ] | Denis Khalikov [ JIRAUSER48434 ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Sprint | 2021-10 [ 549 ] |
| Rank | Ranked higher |
| Status | In Review [ 10002 ] | In Testing [ 10301 ] |
| Assignee | Denis Khalikov [ JIRAUSER48434 ] | Daniel Lee [ dleeyh ] |
| Sprint | 2021-10 [ 549 ] | 2021-10, 2021-11 [ 549, 567 ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Testing [ 10301 ] | Closed [ 6 ] |
| Fix Version/s | 6.2.2 [ 27000 ] |
| Zendesk Related Tickets | 115526 |