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
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Ran into major problems with a badly build 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 [lmktest]> 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. |
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 [lmktest]> 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. |
| 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 [lmktest]> 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. |
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: {code} 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 [lmktest]> 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) {code} Trying to do an EXPLAIN EXTENDED on the query also crashes mariadb. |
| 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: {code} 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 [lmktest]> 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) {code} Trying to do an EXPLAIN EXTENDED on the query also crashes mariadb. |
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: {code} 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) {code} Trying to do an EXPLAIN EXTENDED on the query also crashes mariadb. |
| Link |
This issue is duplicated by |
| Fix Version/s | N/A [ 14700 ] | |
| Resolution | Duplicate [ 3 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 76401 ] | MariaDB v4 [ 150614 ] |