[#MDEV-9187] Signal 11 after a SELECT

Comment by Sergei Petrunia [ 2015-11-25 ]

Interesting part of the mysqld.log file:

/lib64/libc.so.6() [0x312c689d64]

/lib64/libc.so.6(memmove+0x7e) [0x312c68391e]

/usr/sbin/mysqld(well_formed_copy_nchars(charset_info_st const*, char*, unsigned int, charset_info_st const*, char const*, unsigned int, unsigned int, char const**, char const**, char const**)+0x1c9) [0x649889]

/usr/sbin/mysqld(Field_blob::store(char const*, unsigned int, charset_info_st const*)+0x156) [0x721186]

/usr/sbin/mysqld(get_column_range_cardinality(Field*, st_key_range*, st_key_range*, unsigned int)+0x135) [0x644965]

/usr/sbin/mysqld(calculate_cond_selectivity_for_table(THD*, TABLE*, Item*)+0x8b6) [0x810b66]

/usr/sbin/mysqld() [0x52b0b1]

/usr/sbin/mysqld(JOIN::optimize_inner()+0x6e1) [0x6217f1]

It crashes inside the EITS code, where it is trying to estimates selectivity based on EITS data

Comment by Sergei Petrunia [ 2015-11-25 ]

~~MDEV-7383~~ and ~~MDEV-9097~~ are recent fixes for EITS code. They are in MariaDB 10.0.23. Here, we have Affects version(s): 10.0.21. I am not sure that these fixes have anything common with this bug, though.

Comment by Elena Stepanova [ 2015-11-27 ]

Ninpo,

There are applicant, contact, owner tables which are used in the query, directly or indirectly, and are not present in create-tables.info. Could you please also paste their structures?

Thanks.

Comment by Alex Boag-Munroe [ 2015-11-28 ]

Certainly:

| applicant | CREATE TABLE `applicant` (

  `applicantID` int(11) NOT NULL AUTO_INCREMENT,

  `applicantActive` varchar(10) NOT NULL,

  `contactID` int(11) NOT NULL,

  `applicantType` varchar(2) NOT NULL,

  `recordLocked` tinyint(1) unsigned NOT NULL,

  `otherAgentsApplicant` smallint(1) NOT NULL DEFAULT '0',

  `otherAgentsApplicantName` varchar(50) DEFAULT NULL,

  `gradingID` tinyint(4) NOT NULL,

  `dateExpires` date NOT NULL,

  `dateCreated` datetime NOT NULL,

  `recordCreatedBy` int(11) NOT NULL,

  `applicantStatus` varchar(40) NOT NULL,

  `onMailingList` tinyint(1) NOT NULL,

  `mailoutFrequency` smallint(6) NOT NULL,

  `mailoutLastDate` datetime NOT NULL,

  `autoMatch` tinyint(1) unsigned NOT NULL,

  `jhAutoMatch` tinyint(1) unsigned NOT NULL,

  `applicantOnCallList` tinyint(1) unsigned NOT NULL,

  `followUpRequired` tinyint(1) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`applicantID`),

  KEY `contactID` (`contactID`),

  KEY `applicantActive` (`applicantActive`),

  KEY `onMailingList` (`onMailingList`),

  KEY `applicantOnCallList` (`applicantOnCallList`),

  KEY `dateCreated` (`dateCreated`),

  KEY `gradingID` (`gradingID`),

  KEY `applicantType` (`applicantType`),

  KEY `applicantStatus` (`applicantStatus`),

  KEY `applicantActiveTypeStatus` (`applicantActive`,`applicantType`,`applicantStatus`),

  KEY `onMailingList_2` (`onMailingList`,`applicantActive`,`applicantType`,`applicantStatus`),

  KEY `applicantExpires` (`applicantActive`,`applicantStatus`,`dateExpires`),

  KEY `followUpRequired` (`followUpRequired`)

) ENGINE=InnoDB AUTO_INCREMENT=115437 DEFAULT CHARSET=latin1

| contact | CREATE TABLE `contact` (

  `contactID` int(11) NOT NULL AUTO_INCREMENT,

  `contactActive1` varchar(10) NOT NULL,

  `primaryPartyID` int(11) NOT NULL DEFAULT '0',

  `primaryPartyType` char(1) NOT NULL,

  `ownerID1` int(11) NOT NULL,

  `recordLocked1` tinyint(1) NOT NULL,

  `officeID1` int(11) NOT NULL,

  `contactViewName` varchar(100) NOT NULL,

  `contactViewAnchor` varchar(100) NOT NULL,

  `defaultEmail` tinyint(1) NOT NULL,

  `defaultTelephone` tinyint(1) NOT NULL,

  `defaultPost` tinyint(1) NOT NULL,

  `defaultTextMessage` tinyint(1) NOT NULL,

  `doNotEmail` smallint(1) NOT NULL,

  `doNotTelephone` smallint(1) NOT NULL,

  `doNotPost` smallint(1) NOT NULL,

  `doNotTextMessage` smallint(1) NOT NULL,

  `validEmail` tinyint(1) unsigned NOT NULL,

  `sourceID` tinyint(4) NOT NULL,

  `emailValidated` tinyint(1) unsigned NOT NULL DEFAULT '0',

  `websiteRegistration` tinyint(4) unsigned NOT NULL,

  `password` varchar(80) DEFAULT NULL,

  `solicitorID` int(11) unsigned DEFAULT NULL,

  `proofOfIdentity` varchar(50) DEFAULT NULL,

  `proofOfAddress` varchar(50) DEFAULT NULL,

  `applicantNotRequired` tinyint(1) unsigned DEFAULT NULL,

  `moveitRegistered` tinyint(1) unsigned NOT NULL DEFAULT '0',

  `dateLastContacted` datetime NOT NULL,

  `dateCreated` datetime NOT NULL,

  `recordCreatedBy` int(11) NOT NULL,

  `dateUpdated` datetime NOT NULL,

  `recordUpdatedBy` int(11) NOT NULL,

  PRIMARY KEY (`contactID`),

  KEY `contactActive` (`contactActive1`,`contactID`),

  KEY `contactID` (`contactID`,`primaryPartyID`,`primaryPartyType`),

  KEY `contactID_2` (`contactID`,`primaryPartyType`,`primaryPartyID`),

  KEY `primaryPartyID_2` (`primaryPartyID`,`primaryPartyType`),

  KEY `primaryPartyID` (`primaryPartyType`,`primaryPartyID`),

  KEY `dateUpdated` (`dateUpdated`)

) ENGINE=InnoDB AUTO_INCREMENT=143603 DEFAULT CHARSET=latin1 |

| owner | CREATE TABLE `owner` (

  `ownerID` int(11) NOT NULL AUTO_INCREMENT,

  `ownerActive1` varchar(10) NOT NULL,

  `contactID` int(11) NOT NULL,

  `primaryOwner` tinyint(1) unsigned NOT NULL,

  `ownerType` varchar(15) NOT NULL,

  `ownershipPercentage` decimal(5,2) unsigned NOT NULL,

  `portfolioID` int(11) unsigned NOT NULL,

  PRIMARY KEY (`ownerID`,`contactID`),

  KEY `contactID` (`contactID`),

  KEY `ownerID` (`ownerID`,`contactID`,`ownerActive1`),

  KEY `ownerType` (`ownerType`),

  KEY `portfolioID` (`portfolioID`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=21855 DEFAULT CHARSET=latin1 |

Comment by Elena Stepanova [ 2015-11-30 ]

... and yet three more tables (now they seem to be the last ones):
individual, company, prospect.

I don't see it being asked before – can you, by any chance, provide the data dump of the schema? it would make things much easier.
You could upload it to ftp.askmonty.org/private – this way only MariaDB developers will have access to it.

If you can't do it due to confidentiality reasons, please run and paste the output of the following statements:

show index in adhoc;

show index in adhoc_email;

show index in adhoc_recipient_email;

show index in applicant;

show index in company;

show index in contact;

show index in individual;

show index in mailout_created;

show index in mailout_pending;

show index in owner;

show index in owner_potential;

show index in prospect;

It might help us generate a somewhat similar data layout. Doing it totally randomly didn't bring any result so far.
Thanks.

Comment by Alex Boag-Munroe [ 2015-11-30 ]

| individual | CREATE TABLE `individual` (

  `individualID` int(11) NOT NULL AUTO_INCREMENT,

  `addressee` varchar(255) DEFAULT NULL,

  `dear` varchar(255) DEFAULT NULL,

  `addressName` varchar(50) DEFAULT NULL,

  `addressNumber` varchar(30) DEFAULT NULL,

  `addressStreet` varchar(100) DEFAULT NULL,

  `address2` varchar(100) DEFAULT NULL,

  `address3` varchar(100) DEFAULT NULL,

  `address4` varchar(100) DEFAULT NULL,

  `addressPostcode` varchar(15) DEFAULT NULL,

  `country` varchar(100) DEFAULT NULL,

  `contactType1` varchar(20) DEFAULT NULL,

  `contactNumber1` varchar(50) DEFAULT NULL,

  `contactType2` varchar(20) DEFAULT NULL,

  `contactNumber2` varchar(50) DEFAULT NULL,

  `contactType3` varchar(20) DEFAULT NULL,

  `contactNumber3` varchar(50) DEFAULT NULL,

  `emailAddress` varchar(100) DEFAULT NULL,

  `contactNotes` text,

  PRIMARY KEY (`individualID`),

  KEY `emailAddress` (`emailAddress`),

  KEY `contactNumber1` (`contactNumber1`),

  KEY `contactNumber2` (`contactNumber2`),

  KEY `contactNumber3` (`contactNumber3`)

) ENGINE=InnoDB AUTO_INCREMENT=98055 DEFAULT CHARSET=latin1 |

| company | CREATE TABLE `company` (

  `companyID` int(11) NOT NULL AUTO_INCREMENT,

  `addressee` varchar(255) DEFAULT NULL,

  `dear` varchar(255) DEFAULT NULL,

  `companyName` varchar(100) DEFAULT NULL,

  `companyBranchName` varchar(100) DEFAULT NULL,

  `companyCategoryID` tinyint(4) NOT NULL DEFAULT '0',

  `addressName` varchar(50) DEFAULT NULL,

  `addressNumber` varchar(30) DEFAULT NULL,

  `addressStreet` varchar(100) DEFAULT NULL,

  `address2` varchar(100) DEFAULT NULL,

  `address3` varchar(100) DEFAULT NULL,

  `address4` varchar(100) DEFAULT NULL,

  `addressPostcode` varchar(15) DEFAULT NULL,

  `country` varchar(100) DEFAULT NULL,

  `contactType1` varchar(20) DEFAULT NULL,

  `contactNumber1` varchar(50) DEFAULT NULL,

  `contactType2` varchar(20) DEFAULT NULL,

  `contactNumber2` varchar(50) DEFAULT NULL,

  `contactType3` varchar(20) DEFAULT NULL,

  `contactNumber3` varchar(50) DEFAULT NULL,

  `emailAddress` varchar(100) DEFAULT NULL,

  `websiteAddress` varchar(100) DEFAULT NULL,

  `contactNotes` text,

  PRIMARY KEY (`companyID`),

  KEY `emailAddress` (`emailAddress`),

  KEY `contactNumber1` (`contactNumber1`),

  KEY `contactNumber2` (`contactNumber2`),

  KEY `contactNumber3` (`contactNumber3`)

) ENGINE=InnoDB AUTO_INCREMENT=2475 DEFAULT CHARSET=latin1 |

| prospect | CREATE TABLE `prospect` (

  `prospectID` int(11) NOT NULL AUTO_INCREMENT,

  `prospectName` varchar(255) DEFAULT NULL,

  `companyName` varchar(100) DEFAULT NULL,

  `addressName` varchar(50) DEFAULT NULL,

  `addressNumber` varchar(5) DEFAULT NULL,

  `addressStreet` varchar(50) DEFAULT NULL,

  `address2` varchar(50) DEFAULT NULL,

  `address3` varchar(50) DEFAULT NULL,

  `address4` varchar(50) DEFAULT NULL,

  `addressPostcode` varchar(15) DEFAULT NULL,

  `country` varchar(100) DEFAULT NULL,

  `contactType1` varchar(20) DEFAULT NULL,

  `contactNumber1` varchar(50) DEFAULT NULL,

  `emailAddress` varchar(100) DEFAULT NULL,

  `contactNotes` text,

  `prospectStatus` varchar(20) NOT NULL,

  PRIMARY KEY (`prospectID`),

  KEY `prospectStatus` (`prospectStatus`),

  KEY `emailAddress` (`emailAddress`),

  KEY `contactNumber1` (`contactNumber1`)

) ENGINE=InnoDB AUTO_INCREMENT=60557 DEFAULT CHARSET=latin1 |

Comment by Elena Stepanova [ 2015-11-30 ]

Thanks. How about SHOW INDEX, as described above (or the data dump, if we are lucky)?

Comment by Alex Boag-Munroe [ 2015-11-30 ]

I can't do a data dump unfortunately. The query that ran is one that runs every night, it's just this once it decided to trip over itself, which is odd. Though in the mean time I've set the optimizer use condition selectivity to 2, to ensure it can't fall over there again.

I can do the show index information for you:

MariaDB [jb_hymanhill]> show index in adhoc;

+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| adhoc |          0 | PRIMARY  |            1 | mailoutID   | A         |         241 |     NULL | NULL   |      | BTREE      |         |               |

+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

1 row in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in adhoc_email;

+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table       | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| adhoc_email |          0 | PRIMARY  |            1 | mailoutID   | A         |         184 |     NULL | NULL   |      | BTREE      |         |               |

+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

1 row in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in adhoc_recipient_email;

+-----------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table                 | Non_unique | Key_name  | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+-----------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| adhoc_recipient_email |          1 | status    |            1 | status      | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |

| adhoc_recipient_email |          1 | mailoutID |            1 | mailoutID   | A         |         847 |     NULL | NULL   |      | BTREE      |         |               |

| adhoc_recipient_email |          1 | uniqueID  |            1 | uniqueID    | A         |         847 |     NULL | NULL   |      | BTREE      |         |               |

| adhoc_recipient_email |          1 | uniqueID  |            2 | uniqueType  | A         |         847 |     NULL | NULL   |      | BTREE      |         |               |

+-----------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

4 rows in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in applicant;

+-----------+------------+---------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table     | Non_unique | Key_name                  | Seq_in_index | Column_name         | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+-----------+------------+---------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| applicant |          0 | PRIMARY                   |            1 | applicantID         | A         |        2331 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | contactID                 |            1 | contactID           | A         |        2331 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | applicantActive           |            1 | applicantActive     | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | onMailingList             |            1 | onMailingList       | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | applicantOnCallList       |            1 | applicantOnCallList | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | dateCreated               |            1 | dateCreated         | A         |        2331 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | gradingID                 |            1 | gradingID           | A         |          10 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | applicantType             |            1 | applicantType       | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | applicantStatus           |            1 | applicantStatus     | A         |          20 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | applicantActiveTypeStatus |            1 | applicantActive     | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | applicantActiveTypeStatus |            2 | applicantType       | A         |          12 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | applicantActiveTypeStatus |            3 | applicantStatus     | A         |          54 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | onMailingList_2           |            1 | onMailingList       | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | onMailingList_2           |            2 | applicantActive     | A         |          12 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | onMailingList_2           |            3 | applicantType       | A         |          24 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | onMailingList_2           |            4 | applicantStatus     | A         |          68 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | applicantExpires          |            1 | applicantActive     | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | applicantExpires          |            2 | applicantStatus     | A         |          38 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | applicantExpires          |            3 | dateExpires         | A         |        2331 |     NULL | NULL   |      | BTREE      |         |               |

| applicant |          1 | followUpRequired          |            1 | followUpRequired    | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |

+-----------+------------+---------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

20 rows in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in company;

+---------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table   | Non_unique | Key_name       | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+---------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| company |          0 | PRIMARY        |            1 | companyID      | A         |          78 |     NULL | NULL   |      | BTREE      |         |               |

| company |          1 | emailAddress   |            1 | emailAddress   | A         |          78 |     NULL | NULL   | YES  | BTREE      |         |               |

| company |          1 | contactNumber1 |            1 | contactNumber1 | A         |          78 |     NULL | NULL   | YES  | BTREE      |         |               |

| company |          1 | contactNumber2 |            1 | contactNumber2 | A         |          26 |     NULL | NULL   | YES  | BTREE      |         |               |

| company |          1 | contactNumber3 |            1 | contactNumber3 | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |

+---------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

5 rows in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in contact;

+---------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table   | Non_unique | Key_name         | Seq_in_index | Column_name      | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+---------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| contact |          0 | PRIMARY          |            1 | contactID        | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | contactActive    |            1 | contactActive1   | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | contactActive    |            2 | contactID        | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | contactID        |            1 | contactID        | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | contactID        |            2 | primaryPartyID   | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | contactID        |            3 | primaryPartyType | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | contactID_2      |            1 | contactID        | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | contactID_2      |            2 | primaryPartyType | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | contactID_2      |            3 | primaryPartyID   | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | primaryPartyID_2 |            1 | primaryPartyID   | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | primaryPartyID_2 |            2 | primaryPartyType | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | primaryPartyID   |            1 | primaryPartyType | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | primaryPartyID   |            2 | primaryPartyID   | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

| contact |          1 | dateUpdated      |            1 | dateUpdated      | A         |        3311 |     NULL | NULL   |      | BTREE      |         |               |

+---------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

14 rows in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in individual;

+------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table      | Non_unique | Key_name       | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| individual |          0 | PRIMARY        |            1 | individualID   | A         |        1335 |     NULL | NULL   |      | BTREE      |         |               |

| individual |          1 | emailAddress   |            1 | emailAddress   | A         |        1335 |     NULL | NULL   | YES  | BTREE      |         |               |

| individual |          1 | contactNumber1 |            1 | contactNumber1 | A         |        1335 |     NULL | NULL   | YES  | BTREE      |         |               |

| individual |          1 | contactNumber2 |            1 | contactNumber2 | A         |         667 |     NULL | NULL   | YES  | BTREE      |         |               |

| individual |          1 | contactNumber3 |            1 | contactNumber3 | A         |          43 |     NULL | NULL   | YES  | BTREE      |         |               |

+------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

5 rows in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in mailout_created;

+-----------------+------------+----------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table           | Non_unique | Key_name | Seq_in_index | Column_name      | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+-----------------+------------+----------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| mailout_created |          0 | PRIMARY  |            1 | mailoutCreatedID | A         |        1438 |     NULL | NULL   |      | BTREE      |         |               |

+-----------------+------------+----------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

1 row in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in mailout_pending;

+-----------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table           | Non_unique | Key_name       | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+-----------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| mailout_pending |          0 | PRIMARY        |            1 | applicantID    | A         |          13 |     NULL | NULL   |      | BTREE      |         |               |

| mailout_pending |          0 | PRIMARY        |            2 | profileID      | A         |          13 |     NULL | NULL   |      | BTREE      |         |               |

| mailout_pending |          0 | PRIMARY        |            3 | mailoutMethod  | A         |          13 |     NULL | NULL   |      | BTREE      |         |               |

| mailout_pending |          1 | mailoutMethod  |            1 | mailoutMethod  | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |

| mailout_pending |          1 | deliveryOption |            1 | deliveryOption | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |

| mailout_pending |          1 | mailoutFormat  |            1 | mailoutFormat  | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |

| mailout_pending |          1 | instantSendID  |            1 | instantSendID  | A         |          13 |     NULL | NULL   | YES  | BTREE      |         |               |

+-----------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

7 rows in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in owner;

+-------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table | Non_unique | Key_name    | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+-------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| owner |          0 | PRIMARY     |            1 | ownerID      | A         |         266 |     NULL | NULL   |      | BTREE      |         |               |

| owner |          0 | PRIMARY     |            2 | contactID    | A         |         266 |     NULL | NULL   |      | BTREE      |         |               |

| owner |          1 | contactID   |            1 | contactID    | A         |         266 |     NULL | NULL   |      | BTREE      |         |               |

| owner |          1 | ownerID     |            1 | ownerID      | A         |         266 |     NULL | NULL   |      | BTREE      |         |               |

| owner |          1 | ownerID     |            2 | contactID    | A         |         266 |     NULL | NULL   |      | BTREE      |         |               |

| owner |          1 | ownerID     |            3 | ownerActive1 | A         |         266 |     NULL | NULL   |      | BTREE      |         |               |

| owner |          1 | ownerType   |            1 | ownerType    | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |

| owner |          1 | portfolioID |            1 | portfolioID  | A         |         266 |     NULL | NULL   |      | BTREE      |         |               |

+-------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

8 rows in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in owner_potential;

+-----------------+------------+-----------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table           | Non_unique | Key_name  | Seq_in_index | Column_name          | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+-----------------+------------+-----------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| owner_potential |          0 | PRIMARY   |            1 | potentialOwnerID     | A         |          32 |     NULL | NULL   |      | BTREE      |         |               |

| owner_potential |          1 | contactID |            1 | contactID            | A         |          32 |     NULL | NULL   |      | BTREE      |         |               |

| owner_potential |          1 | dept      |            1 | department           | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |

| owner_potential |          1 | dept      |            2 | potentialOwnerActive | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |

+-----------------+------------+-----------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

4 rows in set (0.00 sec)

MariaDB [jb_hymanhill]> show index in prospect;

+----------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table    | Non_unique | Key_name       | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+----------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| prospect |          0 | PRIMARY        |            1 | prospectID     | A         |         198 |     NULL | NULL   |      | BTREE      |         |               |

| prospect |          1 | prospectStatus |            1 | prospectStatus | A         |           1 |     NULL | NULL   |      | BTREE      |         |               |

| prospect |          1 | emailAddress   |            1 | emailAddress   | A         |         198 |     NULL | NULL   | YES  | BTREE      |         |               |

| prospect |          1 | contactNumber1 |            1 | contactNumber1 | A         |         198 |     NULL | NULL   | YES  | BTREE      |         |               |

+----------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

4 rows in set (0.00 sec)

MariaDB [jb_hymanhill]>

Comment by Elena Stepanova [ 2015-12-01 ]

Ninpo, thanks for the data.

If it happened only once, how did you find out it was this exact query that crashed? You don't have either general log or audit log enabled, and there were 11 threads connected at the time of the crash, could it be any other connection?
Also, the attached query plan – is it from the crashed query, or from now when it runs normally?

Comment by Alex Boag-Munroe [ 2015-12-01 ]

Hi Elena,

We have various overnight crons and this mailout batch is one of them. Right before this SELECT query is run, the script logs a timestamp into another table which was the last entry in the binary log, with sync binlog enabled. The timestamp matches exactly the time in the log when the SIG11 happens.

I realise there's a small chance it wasn't this query, but evidence so far suggests it's most likely. TEXT data type, joins, etc in the trace, the time of the crash, etc.

The query plan is for the query that I believe crashed, with optimizer use condition selectivity set to 5, with histograms enabled, single precision, max size. OUCS is now set to 2.

Many thanks for your efforts so far.

Comment by Elena Stepanova [ 2015-12-01 ]

Ninpo, psergey,

While looking into it obsessively, I noticed something truly weird in the attached query plan.
If we look at the plan itself, it appears that all tables belong to the schema jb_hymanhill.
But the generated pseudo-query in the warning after the plan contains one reference to another schema: `jb7_hymanhill`.`mailout_created`. Only once, even though the table appears in two parts of UNION in the original query, in seemingly identical fashion, without schema name specification.

I'm at loss and will appreciate any input in this regard.

Comment by Alex Boag-Munroe [ 2015-12-02 ]

That is odd. I'm afraid all I can offer is that jb7_hymanhill does not exist as a schema.

Comment by Alex Boag-Munroe [ 2016-02-25 ]

As per IRC conversation with @elenst our read slave, also on 10.0.21 crashed recently.

Trace:

160216  9:54:26 [ERROR] mysqld got signal 11 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help

diagnose the problem, but since we have already crashed,

something is definitely wrong and this may fail.

Server version: 10.0.21-MariaDB-log

key_buffer_size=1073741824

read_buffer_size=1048576

max_used_connections=351

max_threads=352

thread_count=18

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1776406 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x7fb25fbf6008

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong...

stack_bottom = 0x7fbc76c92cf0 thread_stack 0x48000

(my_addr_resolve failure: fork)

/usr/sbin/mysqld(my_print_stacktrace+0x2b) [0xb7f84b]

/usr/sbin/mysqld(handle_fatal_signal+0x398) [0x72b758]

/lib64/libpthread.so.0() [0x3acf20f790]

/lib64/libc.so.6() [0x3acee89dbb]

/lib64/libc.so.6(memmove+0x7e) [0x3acee8391e]

/usr/sbin/mysqld(well_formed_copy_nchars(charset_info_st const*, char*, unsigned int, charset_info_st const*, char const*, unsigned int, unsigned int, char const**, char const**, char const**)+0x1c9) [0x649889]

/usr/sbin/mysqld(Field_blob::store(char const*, unsigned int, charset_info_st const*)+0x156) [0x721186]

/usr/sbin/mysqld(get_column_range_cardinality(Field*, st_key_range*, st_key_range*, unsigned int)+0x135) [0x644965]

/usr/sbin/mysqld(calculate_cond_selectivity_for_table(THD*, TABLE*, Item*)+0x8b6) [0x810b66]

/usr/sbin/mysqld() [0x52b0b1]

/usr/sbin/mysqld(JOIN::optimize_inner()+0x6e1) [0x6217f1]

/usr/sbin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0xd8) [0x623f48]

/usr/sbin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x28d) [0x62780d]

/usr/sbin/mysqld() [0x5cd9d6]

/usr/sbin/mysqld(mysql_execute_command(THD*)+0x5090) [0x5d8fe0]

/usr/sbin/mysqld() [0x5da9d7]

/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x1d0d) [0x5dce4d]

/usr/sbin/mysqld(do_handle_one_connection(THD*)+0x453) [0x69a2d3]

/usr/sbin/mysqld(handle_one_connection+0x42) [0x69a3a2]

/lib64/libpthread.so.0() [0x3acf207a51]

/lib64/libc.so.6(clone+0x6d) [0x3aceee89ad]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x7fbc70ea9020): is an invalid pointer

Connection ID (thread ID): 305989178

Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=off,materialization=on,in_to_exists=on,semijoin=off,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=off,mrr_sort_keys=on,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on

Comment by Elena Stepanova [ 2016-02-25 ]

We discussed this issue at length with psergey. By his expert opinion, as well as by my numerous experiments, the provided query does not get the server crashed this way.
However, I was able to reproduce the problem with a different test case. I got a crash on a 10.0.21 build, although it is a matter of luck – another build with same cmake options on the same sources does not crash; however, valgrind warnings are reproducible reliably. They are different for 10.0.21 and the current 10.0 tree, but they are still there. Below are all variations that I got.

Important note: my test case only works (fails) with optimizer_use_condition_selectivity >= 3. The initial crash happened with optimizer_use_condition_selectivity=5, so it fits. However, the stack trace in the comment above was presumably received with optimizer_use_condition_selectivity=2. While fixing this issue please check if it's possible to get the problem with optimizer_use_condition_selectivity=2, and if so, please make sure that your fix handles it as well.

Test case
--source include/have_innodb.inc

set optimizer_use_condition_selectivity=3;
set use_stat_tables = preferably;

CREATE TABLE t1 (f1 TEXT) ENGINE=InnoDB;
INSERT INTO t1 VALUES ('foo'),('bar');
ANALYZE TABLE t1;
SELECT * FROM t1 WHERE f1 <> 'qux';

Here is an example of a stack trace on 10.0.21. This one is from a non-simplified case, but I had the same with the simplified one, just don't have that stack trace anymore.

Crash on 10.0.21 debug build
# 2016-02-25T05:59:25 [18553] #3 <signal handler called>
# 2016-02-25T05:59:25 [18553] #4 0x00007fd47681ff9b in __memmove_ssse3 () from /lib64/libc.so.6
# 2016-02-25T05:59:25 [18553] #5 0x000000000070acd6 in well_formed_copy_nchars (to_cs=0x16d9660 <my_charset_latin1>, to=0x7fd38f392730 "", to_length=38571, from_cs=0x16d9660 <my_charset_latin1>, from=0x7fd4766a4e6b "", from_length=38571, nchars=38571, well_formed_error_pos=0x7fd4766a44f0, cannot_convert_error_pos=0x7fd4766a44e8, from_end_pos=0x7fd4766a44e0) at /src/10.0-bug/sql/sql_string.cc:981
# 2016-02-25T05:59:25 [18553] #6 0x00000000008401ba in Field_blob::store (this=0x7fd38f2b3e88, from=0x7fd4766a4e6b "", length=38571, cs=0x16d9660 <my_charset_latin1>) at /src/10.0-bug/sql/field.cc:7384
# 2016-02-25T05:59:25 [18553] #7 0x0000000000840d24 in Field_blob::set_key_image (this=0x7fd38f2b3e88, buff=0x7fd4766a4e69 "\253\226", length=0) at /src/10.0-bug/sql/field.cc:7583
# 2016-02-25T05:59:25 [18553] #8 0x000000000096aae7 in store_key_image_to_rec (field=0x7fd38f2b3e88, ptr=0x7fd4766a4e69 "\253\226", len=0) at /src/10.0-bug/sql/opt_range.cc:3798
# 2016-02-25T05:59:25 [18553] #9 0x0000000000704d77 in get_column_range_cardinality (field=0x7fd38f2b3e88, min_endp=0x7fd4766a46b0, max_endp=0x0, range_flag=6) at /src/10.0-bug/sql/sql_statistics.cc:3571
# 2016-02-25T05:59:25 [18553] #10 0x0000000000969be1 in records_in_column_ranges (param=0x7fd4766a4d10, idx=0, tree=0x7fd38f2ff4b0) at /src/10.0-bug/sql/opt_range.cc:3421
# 2016-02-25T05:59:25 [18553] #11 0x000000000096a46b in calculate_cond_selectivity_for_table (thd=0x7fd3a47cfb70, table=0x7fd38f2c6070, cond=0x7fd38f24f330) at /src/10.0-bug/sql/opt_range.cc:3656
# 2016-02-25T05:59:25 [18553] #12 0x00000000006aa01c in make_join_statistics (join=0x7fd38f2261c8, tables_list=..., conds=0x7fd38f24f330, keyuse_array=0x7fd38f2264e0) at /src/10.0-bug/sql/sql_select.cc:3964
# 2016-02-25T05:59:25 [18553] #13 0x00000000006a0f82 in JOIN::optimize_inner (this=0x7fd38f2261c8) at /src/10.0-bug/sql/sql_select.cc:1337
# 2016-02-25T05:59:25 [18553] #14 0x000000000069fea6 in JOIN::optimize (this=0x7fd38f2261c8) at /src/10.0-bug/sql/sql_select.cc:1022
# 2016-02-25T05:59:25 [18553] #15 0x00000000006a7c42 in mysql_select (thd=0x7fd3a47cfb70, rref_pointer_array=0x7fd3a47d3e38, tables=0x7fd38f228ba0, wild_num=0, fields=..., conds=0x7fd38f24f330, og_num=8, order=0x7fd38f24fe10, group=0x7fd38f24f578, having=0x7fd38f24fb88, proc_param=0x0, select_options=2147781376, result=0x7fd38f2261a8, unit=0x7fd3a47d34d0, select_lex=0x7fd3a47d3bc0) at /src/10.0-bug/sql/sql_select.cc:3294
# 2016-02-25T05:59:25 [18553] #16 0x000000000069e0df in handle_select (thd=0x7fd3a47cfb70, lex=0x7fd3a47d3408, result=0x7fd38f2261a8, setup_tables_done_option=0) at /src/10.0-bug/sql/sql_select.cc:373
# 2016-02-25T05:59:25 [18553] #17 0x0000000000672b0f in execute_sqlcom_select (thd=0x7fd3a47cfb70, all_tables=0x7fd38f228ba0) at /src/10.0-bug/sql/sql_parse.cc:5274
# 2016-02-25T05:59:25 [18553] #18 0x000000000066afad in mysql_execute_command (thd=0x7fd3a47cfb70) at /src/10.0-bug/sql/sql_parse.cc:2562
# 2016-02-25T05:59:25 [18553] #19 0x0000000000675635 in mysql_parse (thd=0x7fd3a47cfb70, rawbuf=0x7fd38f247088 "SELECT -122 AS ifield1, alias1.`col_datetime_nokey` AS field1, alias1.`col_varchar_key` AS cfield1, CONCAT( alias1.`col_varchar_key`, alias1.`col_varchar_key` ) AS cfield2 FROM ( ( SELECT SQ1_alias1.* FROM `A` AS SQ1_alias1 ) AS alias1, `view_B` AS alias2 ) WHERE alias1.`col_varchar_nokey` <> 's' AND ( alias1.`col_varchar_key` LIKE '%a%' OR alias1.`col_varchar_key` LIKE '%b%') GROUP BY ifield1, field1, cfield1, cfield2 HAVING ifield1 < 4 ORDER BY field1, cfield1, cfield2, ifield1 LIMIT 1 OFFSET 2 /* QUERY_NO 1023 CON_ID 13 / / TRANSFORM_OUTCOME_UNORDERED_MATCH */", length=571, parser_state=0x7fd4766a86a0) at /src/10.0-bug/sql/sql_parse.cc:6531
# 2016-02-25T05:59:25 [18553] #20 0x0000000000668217 in dispatch_command (command=COM_QUERY, thd=0x7fd3a47cfb70, packet=0x7fd3a47e1831 " SELECT -122 AS ifield1, alias1.`col_datetime_nokey` AS field1, alias1.`col_varchar_key` AS cfield1, CONCAT( alias1.`col_varchar_key`, alias1.`col_varchar_key` ) AS cfield2 FROM ( ( SELECT SQ1_alias1.* FROM `A` AS SQ1_alias1 ) AS alias1, `view_B` AS alias2 ) WHERE alias1.`col_varchar_nokey` <> 's' AND ( alias1.`col_varchar_key` LIKE '%a%' OR alias1.`col_varchar_key` LIKE '%b%') GROUP BY ifield1, field1, cfield1, cfield2 HAVING ifield1 < 4 ORDER BY field1, cfield1, cfield2, ifield1 LIMIT 1 OFFSET 2 /* QUERY_NO 1023 CON_ID 13 / / TRANSFORM_OUTCOME_UNORDERED_MATCH */", packet_length=572) at /src/10.0-bug/sql/sql_parse.cc:1308
# 2016-02-25T05:59:25 [18553] #21 0x0000000000667504 in do_command (thd=0x7fd3a47cfb70) at /src/10.0-bug/sql/sql_parse.cc:999
# 2016-02-25T05:59:25 [18553] #22 0x0000000000784765 in do_handle_one_connection (thd_arg=0x7fd3a49dce70) at /src/10.0-bug/sql/sql_connect.cc:1378
# 2016-02-25T05:59:25 [18553] #23 0x00000000007844d7 in handle_one_connection (arg=0x7fd3a49dce70) at /src/10.0-bug/sql/sql_connect.cc:1293
# 2016-02-25T05:59:25 [18553] #24 0x00007fd4784440a4 in start_thread () from /lib64/libpthread.so.0
# 2016-02-25T05:59:25 [18553] #25 0x00007fd4767d804d in clone () from /lib64/libc.so.6

Valgrind warnings on 10.0.21 (commit 0403790722e3941779ccea26e85fcd818e2320b5)
==12344== Thread 19:
==12344== Conditional jump or move depends on uninitialised value(s)
==12344== at 0x83FE6E: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7329)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344== by 0x66AFAC: mysql_execute_command(THD*) (sql_parse.cc:2562)
==12344== by 0x675634: mysql_parse(THD, char, unsigned int, Parser_state*) (sql_parse.cc:6531)
==12344== by 0x668216: dispatch_command(enum_server_command, THD, char, unsigned int) (sql_parse.cc:1308)
==12344== by 0x667503: do_command(THD*) (sql_parse.cc:999)
==12344==
==12344== Conditional jump or move depends on uninitialised value(s)
==12344== at 0x840017: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7358)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344== by 0x66AFAC: mysql_execute_command(THD*) (sql_parse.cc:2562)
==12344== by 0x675634: mysql_parse(THD, char, unsigned int, Parser_state*) (sql_parse.cc:6531)
==12344== by 0x668216: dispatch_command(enum_server_command, THD, char, unsigned int) (sql_parse.cc:1308)
==12344== by 0x667503: do_command(THD*) (sql_parse.cc:999)
==12344==
==12344==
==12344== Conditional jump or move depends on uninitialised value(s)
==12344== at 0x5C4E13: String::alloc(unsigned int) (sql_string.h:274)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344== by 0x66AFAC: mysql_execute_command(THD*) (sql_parse.cc:2562)
==12344== by 0x675634: mysql_parse(THD, char, unsigned int, Parser_state*) (sql_parse.cc:6531)
==12344== by 0x668216: dispatch_command(enum_server_command, THD, char, unsigned int) (sql_parse.cc:1308)
==12344==
==12344== Conditional jump or move depends on uninitialised value(s)
==12344== at 0x708D9D: String::real_alloc(unsigned int) (sql_string.cc:37)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344== by 0x66AFAC: mysql_execute_command(THD*) (sql_parse.cc:2562)
==12344== by 0x675634: mysql_parse(THD, char, unsigned int, Parser_state*) (sql_parse.cc:6531)
==12344==
==12344== Conditional jump or move depends on uninitialised value(s)
==12344== at 0x708DC4: String::real_alloc(unsigned int) (sql_string.cc:38)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344== by 0x66AFAC: mysql_execute_command(THD*) (sql_parse.cc:2562)
==12344== by 0x675634: mysql_parse(THD, char, unsigned int, Parser_state*) (sql_parse.cc:6531)
==12344==
==12344== Conditional jump or move depends on uninitialised value(s)
==12344== at 0x708DE5: String::real_alloc(unsigned int) (sql_string.cc:41)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344== by 0x66AFAC: mysql_execute_command(THD*) (sql_parse.cc:2562)
==12344== by 0x675634: mysql_parse(THD, char, unsigned int, Parser_state*) (sql_parse.cc:6531)
==12344==
==12344== Conditional jump or move depends on uninitialised value(s)
==12344== at 0xE351D4: my_malloc (my_malloc.c:95)
==12344== by 0x708E18: String::real_alloc(unsigned int) (sql_string.cc:46)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344== by 0x66AFAC: mysql_execute_command(THD*) (sql_parse.cc:2562)
==12344==
==12344== Conditional jump or move depends on uninitialised value(s)
==12344== at 0x4C2918D: malloc (in /usr/lib64/valgrind/vgpreload_memcheck-amd64-linux.so)
==12344== by 0xE45F41: sf_malloc (safemalloc.c:115)
==12344== by 0xE35200: my_malloc (my_malloc.c:100)
==12344== by 0x708E18: String::real_alloc(unsigned int) (sql_string.cc:46)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344==
==12344==
==12344== Use of uninitialised value of size 8
==12344== at 0xE45FB2: sf_malloc (safemalloc.c:130)
==12344== by 0xE35200: my_malloc (my_malloc.c:100)
==12344== by 0x708E18: String::real_alloc(unsigned int) (sql_string.cc:46)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344==
==12344== Use of uninitialised value of size 8
==12344== at 0xE45FC4: sf_malloc (safemalloc.c:131)
==12344== by 0xE35200: my_malloc (my_malloc.c:100)
==12344== by 0x708E18: String::real_alloc(unsigned int) (sql_string.cc:46)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344==
==12344==
==12344== Use of uninitialised value of size 8
==12344== at 0xE45FD6: sf_malloc (safemalloc.c:132)
==12344== by 0xE35200: my_malloc (my_malloc.c:100)
==12344== by 0x708E18: String::real_alloc(unsigned int) (sql_string.cc:46)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344==
==12344== Use of uninitialised value of size 8
==12344== at 0xE45FE8: sf_malloc (safemalloc.c:133)
==12344== by 0xE35200: my_malloc (my_malloc.c:100)
==12344== by 0x708E18: String::real_alloc(unsigned int) (sql_string.cc:46)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344== by 0x672B0E: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5274)
==12344==
==12344==
==12344== Conditional jump or move depends on uninitialised value(s)
==12344== at 0x4C2F919: memset (in /usr/lib64/valgrind/vgpreload_memcheck-amd64-linux.so)
==12344== by 0xE460FE: sf_malloc (safemalloc.c:165)
==12344== by 0xE35200: my_malloc (my_malloc.c:100)
==12344== by 0x708E18: String::real_alloc(unsigned int) (sql_string.cc:46)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344==
==12344== Conditional jump or move depends on uninitialised value(s)
==12344== at 0x4C2F95D: memset (in /usr/lib64/valgrind/vgpreload_memcheck-amd64-linux.so)
==12344== by 0xE460FE: sf_malloc (safemalloc.c:165)
==12344== by 0xE35200: my_malloc (my_malloc.c:100)
==12344== by 0x708E18: String::real_alloc(unsigned int) (sql_string.cc:46)
==12344== by 0x5C4E2C: String::alloc(unsigned int) (sql_string.h:276)
==12344== by 0x840072: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7359)
==12344== by 0x840D23: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7583)
==12344== by 0x96AAE6: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3798)
==12344== by 0x704DFB: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3580)
==12344== by 0x969BE0: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3421)
==12344== by 0x96A46A: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3656)
==12344== by 0x6AA01B: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12344== by 0x6A0F81: JOIN::optimize_inner() (sql_select.cc:1337)
==12344== by 0x69FEA5: JOIN::optimize() (sql_select.cc:1022)
==12344== by 0x6A7C41: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12344== by 0x69E0DE: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12344==
....

Valgrind warnings on current 10.0 commit 5f2f3c4fa81851b45dcee33601f14e05f6407333
==12451== Invalid read of size 1
==12451== at 0x4C2FD24: __GI_memmove (in /usr/lib64/valgrind/vgpreload_memcheck-amd64-linux.so)
==12451== by 0x70D61D: well_formed_copy_nchars(charset_info_st const, char, unsigned int, charset_info_st const, char const, unsigned int, unsigned int, char const, char const, char const**) (sql_string.cc:981)
==12451== by 0x843F75: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7413)
==12451== by 0x844ADF: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7612)
==12451== by 0x96F1B1: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3821)
==12451== by 0x70720B: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3702)
==12451== by 0x96E2A2: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3444)
==12451== by 0x96EB35: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3679)
==12451== by 0x6ABFFB: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12451== by 0x6A2F61: JOIN::optimize_inner() (sql_select.cc:1339)
==12451== by 0x6A1E85: JOIN::optimize() (sql_select.cc:1024)
==12451== by 0x6A9C21: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12451== by 0x6A0030: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)
==12451== by 0x6748E3: execute_sqlcom_select(THD, TABLE_LIST) (sql_parse.cc:5304)
==12451== by 0x66CCCC: mysql_execute_command(THD*) (sql_parse.cc:2562)
==12451== by 0x67746A: mysql_parse(THD, char, unsigned int, Parser_state*) (sql_parse.cc:6565)
==12451== Address 0x166455ff is 1 bytes before a block of size 42,524 alloc'd
==12451== at 0x4C291E0: malloc (in /usr/lib64/valgrind/vgpreload_memcheck-amd64-linux.so)
==12451== by 0xE4CEED: sf_malloc (safemalloc.c:115)
==12451== by 0xE3C1D4: my_malloc (my_malloc.c:100)
==12451== by 0x70B760: String::real_alloc(unsigned int) (sql_string.cc:46)
==12451== by 0x5C697A: String::alloc(unsigned int) (sql_string.h:276)
==12451== by 0x843E2E: Field_blob::store(char const, unsigned int, charset_info_st const) (field.cc:7388)
==12451== by 0x844ADF: Field_blob::set_key_image(unsigned char const*, unsigned int) (field.cc:7612)
==12451== by 0x96F1B1: store_key_image_to_rec(Field, unsigned char, unsigned int) (opt_range.cc:3821)
==12451== by 0x70720B: get_column_range_cardinality(Field, st_key_range, st_key_range*, unsigned int) (sql_statistics.cc:3702)
==12451== by 0x96E2A2: records_in_column_ranges(PARAM, unsigned int, SEL_ARG) (opt_range.cc:3444)
==12451== by 0x96EB35: calculate_cond_selectivity_for_table(THD, TABLE, Item*) (opt_range.cc:3679)
==12451== by 0x6ABFFB: make_join_statistics(JOIN, List<TABLE_LIST>&, Item, st_dynamic_array*) (sql_select.cc:3964)
==12451== by 0x6A2F61: JOIN::optimize_inner() (sql_select.cc:1339)
==12451== by 0x6A1E85: JOIN::optimize() (sql_select.cc:1024)
==12451== by 0x6A9C21: mysql_select(THD, Item*, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3294)
==12451== by 0x6A0030: handle_select(THD, LEX, select_result*, unsigned long) (sql_select.cc:373)

Comment by Igor Babaev [ 2016-11-15 ]

I close the bug as the most probable duplicate of mdev-9628.
(I failed to reproduced it anyway.)

[MDEV-9187] Signal 11 after a SELECT Created: 2015-11-25 Updated: 2016-11-15 Resolved: 2016-11-15
Status:	Closed
Project:	MariaDB Server
Component/s:	Optimizer
Affects Version/s:	10.0.21, 10.0, 10.1
Fix Version/s:	10.0.29

[MDEV-9187] Signal 11 after a SELECT Created: 2015-11-25 Updated: 2016-11-15 Resolved: 2016-11-15