Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.1.12, 10.1.14
-
None
-
Oracle Linux 7.2, Mariadb 10.1.12/Mariadb 10.1.14,
Kernel 4.1.12-37.5.1.el7uek.x86_64
Mariadb installed from mariadb.org centos packages.
2 cpu, 32 GB virtual machine
Description
Ran into major problems with a query as it crashed the database.
Tested on Mariadb version 10.1.12 and 10.1.14
Table definition:
CREATE TABLE `field_data_field_computed_family_id` (
|
`entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
|
`bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
|
`deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
|
`entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
|
`revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
|
`language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
|
`delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
|
`field_computed_family_id_value` varchar(32) DEFAULT NULL,
|
PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
|
KEY `entity_type` (`entity_type`),
|
KEY `bundle` (`bundle`),
|
KEY `deleted` (`deleted`),
|
KEY `entity_id` (`entity_id`),
|
KEY `revision_id` (`revision_id`),
|
KEY `language` (`language`),
|
KEY `field_computed_family_id_value` (`field_computed_family_id_value`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8
|
|
10 rows inserted:
|
MariaDB [test]> select * from field_data_field_computed_family_id ;
|
+-------------+---------+---------+-----------+-------------+----------+-------+--------------------------------+
|
| entity_type | bundle | deleted | entity_id | revision_id | language | delta | field_computed_family_id_value |
|
+-------------+---------+---------+-----------+-------------+----------+-------+--------------------------------+
|
| node | product | 0 | 195 | 195 | und | 0 | NULL |
|
| node | product | 0 | 196 | 196 | und | 0 | 1007261 |
|
| node | product | 0 | 197 | 197 | und | 0 | 1007261 |
|
| node | product | 0 | 198 | 198 | und | 0 | 1007261 |
|
| node | product | 0 | 199 | 199 | und | 0 | 1010901 |
|
| node | product | 0 | 200 | 200 | und | 0 | 1017561 |
|
| node | product | 0 | 201 | 201 | und | 0 | 1019562 |
|
| node | product | 0 | 202 | 202 | und | 0 | 1025560 |
|
| node | product | 0 | 203 | 203 | und | 0 | 1025561 |
|
| node | product | 0 | 204 | 204 | und | 0 | 1025561 |
|
+-------------+---------+---------+-----------+-------------+----------+-------+--------------------------------+
|
10 rows in set (0.00 sec)
|
|
MariaDB [test]> select count(*) from field_data_field_computed_family_id where field_computed_family_id_value NOT IN ( NULL, '1017561');
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [test]> \! systemctl start mariadb
|
MariaDB [test]> select count(*) from field_data_field_computed_family_id where field_computed_family_id_value NOT IN ( '1017561');
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 3
|
Current database: test
|
|
+----------+
|
| count(*) |
|
+----------+
|
| 8 |
|
+----------+
|
1 row in set (0.01 sec)
|
Trying to do an EXPLAIN EXTENDED on the query also crashes mariadb.
Attachments
Issue Links
- is duplicated by
-
MDEV-10020 InnoDB NOT IN Query Crash When One Item Is NULL
- Closed