Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10369

Simple select or explain crashes mariadb with signal 11 with NOT IN ( NULL , 'data' )

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 10.1.12, 10.1.14
    • Fix Version/s: N/A
    • Component/s: Parser
    • Labels:
      None
    • Environment:
      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

        1. error.log
          4 kB
          Lars Mikkelsen
        2. server.cnf
          3 kB
          Lars Mikkelsen

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              lmk@netic.dk Lars Mikkelsen
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.