[MDEV-21356] ERROR 1032 Can't find record when running simple, single-table query - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4.10, 10.4.11, 10.4(EOL)
Fix Version/s: 10.4.12, 10.5.1
Component/s: Optimizer
Labels:
None
Environment:
Linux

Description

We have a data-dependent hence non easily reproducible error on several tables, that results in a

ERROR 1032 (HY000): Can't find record in 'contact'

It started happening when we upgraded from 10.3.16 to 10.4.10 and is still active after we upgraded to 10.4.11.

It does resemble another issue that we saw earlier but (??) could not find when writing this, that implied a wrong execution plan but was supposedly fixed in 10.4.11.

We caught one that we could reproduce, at least a few times, here's what we thought of gathering. We have enough traces that we can possibly catch some more if needed and gather more data.

explain extended SELECT id FROM contact  WHERE 1=1  AND (first_name IS NOT NULL OR last_name IS NOT NULL OR email IS NOT NULL OR email_private IS NOT NULL OR phone IS NOT NULL OR mobile_phone IS NOT NULL) AND id != **redacted** AND (company_id =  **redacted**) AND (first_name = '**redacted**') AND (last_name = '**redacted**') AND email = '**redacted**' AND (gender = '**redacted**' OR gender IS NULL) AND (country_id = **redacted**) AND is_public=1 AND client_id IS NULL

--------------

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

| id   | select_type | table   | type         | possible_keys                                                                                                                                                                                                                                                                                                                                                                                                          | key                     | key_len | ref  | rows   | filtered | Extra                                                                      |

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

|    1 | SIMPLE      | contact | range|filter | PRIMARY,contact_company_id_company_id,ixFirst_name,ixLast_name,ixPhone,ixGender,ixFirstName,contact_country,ixCompanyActive,ixCompanyActiveCreatedAt,ixCompanyFunction,ixIdActiveCreatedAt,ixPublic,ixEmailPrivate,ixCompanyActivePublicCountry,ixCompanyActivePublic,ixCountry,ixIdActive,ixEmail,ixIdActiveCompany,ixFirstNameLastName,ixClient,ixFirstNameGenderActivePublic,ixFirstLastEmailActive,ixEmailFullText | ixEmail|ixCompanyActive | 776|9   | NULL | 2 (0%) |     0.23 | Using index condition; Using where; Rowid-ordered scan; Using rowid filter |

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

and here is the JSON version

  "query_block": {

    "select_id": 1,

    "table": {

      "table_name": "contact",

      "access_type": "range",

      "possible_keys": [

        "PRIMARY",

        "contact_company_id_company_id",

        "ixFirst_name",

        "ixLast_name",

        "ixPhone",

        "ixGender",

        "ixFirstName",

        "contact_country",

        "ixCompanyActive",

        "ixCompanyActiveCreatedAt",

        "ixCompanyFunction",

        "ixIdActiveCreatedAt",

        "ixPublic",

        "ixEmailPrivate",

        "ixCompanyActivePublicCountry",

        "ixCompanyActivePublic",

        "ixCountry",

        "ixIdActive",

        "ixEmail",

        "ixIdActiveCompany",

        "ixFirstNameLastName",

        "ixClient",

        "ixFirstNameGenderActivePublic",

        "ixFirstLastEmailActive",

        "ixEmailFullText"

],

      "key": "ixEmail",

      "key_length": "776",

      "used_key_parts": ["email", "id"],

      "rowid_filter": {

        "range": {

          "key": "ixCompanyActive",

          "used_key_parts": ["company_id"]

},

        "rows": 14,

        "selectivity_pct": 1.1e-4

},

      "rows": 2,

      "filtered": 0.2299,

      "index_condition": "contact.`id` <> **redacted** and contact.email = '**redacted**'",

      "attached_condition": "contact.company_id = **redacted** and contact.country_id = **redacted** and contact.is_public = 1 and (contact.first_name is not null or contact.last_name is not null or contact.email is not null or contact.email_private is not null or contact.phone is not null or contact.mobile_phone is not null) and contact.first_name = '**redacted**' and contact.last_name = '**redacted**' and (contact.gender = '**redacted**' or contact.gender is null) and contact.client_id is null",

      "mrr_type": "Rowid-ordered scan"

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

create_minified_table.sql.gz
2020-01-14 21:11
1.08 MB
Christophe Migliorini
failing_domain.txt
2020-01-15 13:59
20 kB
Antoine MARTIN

Issue Links

relates to

MDEV-21446 Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check with rowid_filter upon concurrent access to table

Closed

MDEV-19919 Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check

Closed

MDEV-20056 Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check

Closed

Activity

Ascending order - Click to sort in descending order

View 11 older comments

Elena Stepanova added a comment - 2020-01-15 14:15

Thanks. Domain ID was indeed the reason why it wasn't reproducible for me. It is now.

Elena Stepanova added a comment - 2020-01-15 14:15 Thanks. Domain ID was indeed the reason why it wasn't reproducible for me. It is now.

Elena Stepanova added a comment - 2020-01-15 19:04

Here is the test case reduced even further. It can be run via MTR with default MTR settings, or MySQL client on a server with default server options.

--source include/have_innodb.inc

CREATE TABLE event_whois_domain_minified (

  id int(11) unsigned NOT NULL AUTO_INCREMENT,

  domain varchar(255) NOT NULL,

  registrant_name varchar(255) DEFAULT NULL,

  registrant_organization varchar(255) DEFAULT NULL,

  registrant_street1 varchar(255) DEFAULT NULL,

  registrant_street2 varchar(255) DEFAULT NULL,

  registrant_street3 varchar(255) DEFAULT NULL,

  registrant_street4 varchar(255) DEFAULT NULL,

  registrant_street5 varchar(255) DEFAULT NULL,

  registrant_city varchar(255) DEFAULT NULL,

  registrant_postal_code varchar(255) DEFAULT NULL,

  registrant_country varchar(255) DEFAULT NULL,

  registrant_email varchar(255) DEFAULT NULL,

  registrant_telephone varchar(255) DEFAULT NULL,

  administrative_name varchar(255) DEFAULT NULL,

  administrative_organization varchar(255) DEFAULT NULL,

  administrative_street1 varchar(255) DEFAULT NULL,

  administrative_street2 varchar(255) DEFAULT NULL,

  administrative_street3 varchar(255) DEFAULT NULL,

  administrative_street4 varchar(255) DEFAULT NULL,

  administrative_street5 varchar(255) DEFAULT NULL,

  administrative_city varchar(255) DEFAULT NULL,

  administrative_postal_code varchar(255) DEFAULT NULL,

  administrative_country varchar(255) DEFAULT NULL,

  administrative_email varchar(255) DEFAULT NULL,

  administrative_telephone varchar(255) DEFAULT NULL,

  technical_name varchar(255) DEFAULT NULL,

  technical_organization varchar(255) DEFAULT NULL,

  technical_street1 varchar(255) DEFAULT NULL,

  technical_street2 varchar(255) DEFAULT NULL,

  technical_street3 varchar(255) DEFAULT NULL,

  technical_street4 varchar(255) DEFAULT NULL,

  technical_street5 varchar(255) DEFAULT NULL,

  technical_city varchar(255) DEFAULT NULL,

  technical_postal_code varchar(255) DEFAULT NULL,

  technical_country varchar(255) DEFAULT NULL,

  technical_email varchar(255) DEFAULT NULL,

  technical_telephone varchar(255) DEFAULT NULL,

  json longblob NOT NULL,

  timestamp timestamp NOT NULL DEFAULT current_timestamp(),

  PRIMARY KEY (id),

  KEY ixEventWhoisDomainDomain (domain),

  KEY ixEventWhoisDomainTimestamp (timestamp)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO event_whois_domain_minified (id, domain, registrant_name, registrant_organization, registrant_street1, registrant_street2, registrant_street3, registrant_street4, registrant_street5, registrant_city, registrant_postal_code, registrant_country, registrant_email, registrant_telephone, administrative_name, administrative_organization, administrative_street1, administrative_street2, administrative_street3, administrative_street4, administrative_street5, administrative_city, administrative_postal_code, administrative_country, administrative_email, administrative_telephone, technical_name, technical_organization, technical_street1, technical_street2, technical_street3, technical_street4, technical_street5, technical_city, technical_postal_code, technical_country, technical_email, technical_telephone, json, timestamp) VALUES

(60380, 'www.mailhost.i-dev.fr', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '', '2016-12-22 09:18:28'),

(60383, 'www.bestwestern.fr', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '', '2016-12-22 09:27:06'),

(80392, 'www.dfinitions.fr', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '', '2017-01-30 08:02:01'),

(80407, 'www.firma.o2.pl', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'AZ.pl Sp. z o.o.', 'Al. Papieża Jana Pawła II 19/2', null, null, null, null, '70-453 Szczecin', null, 'POLAND', null, '48914243780', '', '2017-01-30 08:24:51'),

(80551, 'www.mailhost.i-dev.fr', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '', '2017-01-30 10:00:56'),

(80560, 'www.blackmer-mouvex.com', 'MARIE-PIERRE PRODEAU', 'MOUVEX', '2 RUE DES CAILLOTES', null, null, null, null, 'AUXERRE', '89000', 'FRANCE', 'PRODEAU@MOUVEX.COM', null, 'MARIE-PIERRE PRODEAU', 'MOUVEX', '2 RUE DES CAILLOTES', null, null, null, null, 'AUXERRE', '89000', 'FRANCE', 'PRODEAU@MOUVEX.COM', '33 386498630', 'LAURENT SOUCHELEAU', 'MOUVEX', '2 RUE DES CAILLOTES', null, null, null, null, 'AUXERRE', '89000', 'FRANCE', 'SOUCHELEAU@MOUVEX.COM', '33 386498643', '', '2017-01-30 10:04:38'),

(80566, 'www.inup.com', 'MAXIMILIAN V. KETELHODT', null, 'SUELZBURGSTRASSE 158A', null, null, null, null, 'KOELN', '50937', 'GERMANY', 'ICANN@EXPIRES-2009.WEBCARE24.COM', '492214307580', 'MAXIMILIAN V. KETELHODT', null, 'SUELZBURGSTRASSE 158A', null, null, null, null, 'KOELN', '50937', 'GERMANY', 'ICANN@EXPIRES-2009.WEBCARE24.COM', '492214307580', 'MAXIMILIAN V. KETELHODT', null, 'SUELZBURGSTRASSE 158A', null, null, null, null, 'KOELN', '50937', 'GERMANY', 'ICANN@EXPIRES-2009.WEBCARE24.COM', '492214307580', '', '2017-01-30 10:08:29');

SET optimizer_switch='mrr=on,mrr_sort_keys=on';

SELECT * FROM event_whois_domain_minified WHERE 1 = 1 AND domain = 'www.mailhost.i-dev.fr' AND timestamp >= DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -1 MONTH) ORDER BY timestamp DESC;

10.4 2d4b6571 non-debug build

MariaDB [test]> SELECT * FROM event_whois_domain_minified WHERE 1 = 1 AND domain = 'www.mailhost.i-dev.fr' AND timestamp >= DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -1 MONTH) ORDER BY timestamp DESC;

ERROR 1032 (HY000): Can't find record in 'event_whois_domain_minified'

Execution plan
MariaDB [test]> EXPLAIN EXTENDED SELECT * FROM event_whois_domain_minified WHERE 1 = 1 AND domain = 'www.mailhost.i-dev.fr' AND timestamp >= DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -1 MONTH) ORDER BY timestamp DESC;
+------+-------------+-----------------------------+------------+------------------------------------------------------+------------------------------------------------------+---------+-------+---------+----------+------------------------------------------------------------------------+
\| id \| select_type \| table \| type \| possible_keys \| key \| key_len \| ref \| rows \| filtered \| Extra \|
+------+-------------+-----------------------------+------------+------------------------------------------------------+------------------------------------------------------+---------+-------+---------+----------+------------------------------------------------------------------------+
\| 1 \| SIMPLE \| event_whois_domain_minified \| ref\|filter \| ixEventWhoisDomainDomain,ixEventWhoisDomainTimestamp \| ixEventWhoisDomainDomain\|ixEventWhoisDomainTimestamp \| 767\|4 \| const \| 2 (14%) \| 14.29 \| Using index condition; Using where; Using filesort; Using rowid filter \|
+------+-------------+-----------------------------+------------+------------------------------------------------------+------------------------------------------------------+---------+-------+---------+----------+------------------------------------------------------------------------+
1 row in set, 1 warning (0.001 sec)

MariaDB [test]> show warnings;
+-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
\| Level \| Code \| Message \|
+-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
\| Note \| 1003 \| select `test`.`event_whois_domain_minified`.`id` AS `id`,`test`.`event_whois_domain_minified`.`domain` AS `domain`,`test`.`event_whois_domain_minified`.`registrant_name` AS `registrant_name`,`test`.`event_whois_domain_minified`.`registrant_organization` AS `registrant_organization`,`test`.`event_whois_domain_minified`.`registrant_street1` AS `registrant_street1`,`test`.`event_whois_domain_minified`.`registrant_street2` AS `registrant_street2`,`test`.`event_whois_domain_minified`.`registrant_street3` AS `registrant_street3`,`test`.`event_whois_domain_minified`.`registrant_street4` AS `registrant_street4`,`test`.`event_whois_domain_minified`.`registrant_street5` AS `registrant_street5`,`test`.`event_whois_domain_minified`.`registrant_city` AS `registrant_city`,`test`.`event_whois_domain_minified`.`registrant_postal_code` AS `registrant_postal_code`,`test`.`event_whois_domain_minified`.`registrant_country` AS `registrant_country`,`test`.`event_whois_domain_minified`.`registrant_email` AS `registrant_email`,`test`.`event_whois_domain_minified`.`registrant_telephone` AS `registrant_telephone`,`test`.`event_whois_domain_minified`.`administrative_name` AS `administrative_name`,`test`.`event_whois_domain_minified`.`administrative_organization` AS `administrative_organization`,`test`.`event_whois_domain_minified`.`administrative_street1` AS `administrative_street1`,`test`.`event_whois_domain_minified`.`administrative_street2` AS `administrative_street2`,`test`.`event_whois_domain_minified`.`administrative_street3` AS `administrative_street3`,`test`.`event_whois_domain_minified`.`administrative_street4` AS `administrative_street4`,`test`.`event_whois_domain_minified`.`administrative_street5` AS `administrative_street5`,`test`.`event_whois_domain_minified`.`administrative_city` AS `administrative_city`,`test`.`event_whois_domain_minified`.`administrative_postal_code` AS `administrative_postal_code`,`test`.`event_whois_domain_minified`.`administrative_country` AS `administrative_country`,`test`.`event_whois_domain_minified`.`administrative_email` AS `administrative_email`,`test`.`event_whois_domain_minified`.`administrative_telephone` AS `administrative_telephone`,`test`.`event_whois_domain_minified`.`technical_name` AS `technical_name`,`test`.`event_whois_domain_minified`.`technical_organization` AS `technical_organization`,`test`.`event_whois_domain_minified`.`technical_street1` AS `technical_street1`,`test`.`event_whois_domain_minified`.`technical_street2` AS `technical_street2`,`test`.`event_whois_domain_minified`.`technical_street3` AS `technical_street3`,`test`.`event_whois_domain_minified`.`technical_street4` AS `technical_street4`,`test`.`event_whois_domain_minified`.`technical_street5` AS `technical_street5`,`test`.`event_whois_domain_minified`.`technical_city` AS `technical_city`,`test`.`event_whois_domain_minified`.`technical_postal_code` AS `technical_postal_code`,`test`.`event_whois_domain_minified`.`technical_country` AS `technical_country`,`test`.`event_whois_domain_minified`.`technical_email` AS `technical_email`,`test`.`event_whois_domain_minified`.`technical_telephone` AS `technical_telephone`,`test`.`event_whois_domain_minified`.`json` AS `json`,`test`.`event_whois_domain_minified`.`timestamp` AS `timestamp` from `test`.`event_whois_domain_minified` where `test`.`event_whois_domain_minified`.`domain` = 'www.mailhost.i-dev.fr' and `test`.`event_whois_domain_minified`.`timestamp` >= <cache>(current_timestamp() + interval -1 month) order by `test`.`event_whois_domain_minified`.`timestamp` desc \|
+-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

On a debug build, it produces the assertion failure:

10.4 debug 2d4b6571
mysqld: /data/src/10.4/storage/innobase/row/row0sel.cc:3942: ICP_RESULT row_search_idx_cond_check(byte, row_prebuilt_t, const rec_t, const offset_t): Assertion `!prebuilt->index->is_primary()' failed.
200115 21:02:58 [ERROR] mysqld got signal 6 ;

#7 0x00007f6be96d2f12 in __GI___assert_fail (assertion=0x55f594a3a868 "!prebuilt->index->is_primary()", file=0x55f594a397a0 "/data/src/10.4/storage/innobase/row/row0sel.cc", line=3942, function=0x55f594a3d8e0 <row_search_idx_cond_check(unsigned char, row_prebuilt_t, unsigned char const, unsigned short const)::__PRETTY_FUNCTION__> "ICP_RESULT row_search_idx_cond_check(byte, row_prebuilt_t, const rec_t, const offset_t)") at assert.c:101
#8 0x000055f5942320d2 in row_search_idx_cond_check (mysql_rec=0x7f6b90058d58 "\377\377\377\377\377\334\353", prebuilt=0x7f6b901516d8, rec=0x7f6bdf12c084 "", offsets=0x7f6be40a26d0) at /data/src/10.4/storage/innobase/row/row0sel.cc:3942
#9 0x000055f5942360a2 in row_search_mvcc (buf=0x7f6b90058d58 "\377\377\377\377\377\334\353", mode=PAGE_CUR_GE, prebuilt=0x7f6b901516d8, match_mode=1, direction=0) at /data/src/10.4/storage/innobase/row/row0sel.cc:5257
#10 0x000055f59404652e in ha_innobase::index_read (this=0x7f6b90056b78, buf=0x7f6b90058d58 "\377\377\377\377\377\334\353", key_ptr=0x7f6b90225e1c "\334\353", key_len=4, find_flag=HA_READ_KEY_EXACT) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9296
#11 0x000055f594047851 in ha_innobase::rnd_pos (this=0x7f6b90056b78, buf=0x7f6b90058d58 "\377\377\377\377\377\334\353", pos=0x7f6b90225e1c "\334\353") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9797
#12 0x000055f593dfb665 in handler::ha_rnd_pos (this=0x7f6b90056b78, buf=0x7f6b90058d58 "\377\377\377\377\377\334\353", pos=0x7f6b90225e1c "\334\353") at /data/src/10.4/sql/handler.cc:2859
#13 0x000055f593c71105 in Mrr_ordered_rndpos_reader::get_next (this=0x7f6b90057030, range_info=0x7f6be40a3688) at /data/src/10.4/sql/multi_range_read.cc:885
#14 0x000055f593c72b56 in DsMrr_impl::dsmrr_next (this=0x7f6b90057008, range_info=0x7f6be40a3688) at /data/src/10.4/sql/multi_range_read.cc:1520
#15 0x000055f59405a02a in ha_innobase::multi_range_read_next (this=0x7f6b90056b78, range_info=0x7f6be40a3688) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:20377
#16 0x000055f593f8caa8 in QUICK_RANGE_SELECT::get_next (this=0x7f6b901a1690) at /data/src/10.4/sql/opt_range.cc:12160
#17 0x000055f593debbdb in find_all_keys (thd=0x7f6b90000af0, param=0x7f6be40a3930, select=0x7f6b9014fa30, fs_info=0x7f6b901a17e0, buffpek_pointers=0x7f6be40a3b30, tempfile=0x7f6be40a39c0, pq=0x0, found_rows=0x7f6b901a19c0) at /data/src/10.4/sql/filesort.cc:764
#18 0x000055f593dea13d in filesort (thd=0x7f6b90000af0, table=0x7f6b9018cc20, filesort=0x7f6b9014fd88, tracker=0x7f6b901d2a90, join=0x7f6b90015990, first_table_bit=1) at /data/src/10.4/sql/filesort.cc:267
#19 0x000055f593b1e4d7 in create_sort_index (thd=0x7f6b90000af0, join=0x7f6b90015990, tab=0x7f6b9014e4c8, fsort=0x7f6b9014fd88) at /data/src/10.4/sql/sql_select.cc:23479
#20 0x000055f593b187b0 in st_join_table::sort_table (this=0x7f6b9014e4c8) at /data/src/10.4/sql/sql_select.cc:21236
#21 0x000055f593b1838c in join_init_read_record (tab=0x7f6b9014e4c8) at /data/src/10.4/sql/sql_select.cc:21175
#22 0x000055f593b1614d in sub_select (join=0x7f6b90015990, join_tab=0x7f6b9014e4c8, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:20252
#23 0x000055f593b1563e in do_select (join=0x7f6b90015990, procedure=0x0) at /data/src/10.4/sql/sql_select.cc:19793
#24 0x000055f593aea821 in JOIN::exec_inner (this=0x7f6b90015990) at /data/src/10.4/sql/sql_select.cc:4452
#25 0x000055f593ae995e in JOIN::exec (this=0x7f6b90015990) at /data/src/10.4/sql/sql_select.cc:4234
#26 0x000055f593aeb073 in mysql_select (thd=0x7f6b90000af0, tables=0x7f6b90013958, wild_num=1, fields=..., conds=0x7f6b900147d8, og_num=1, order=0x7f6b90015810, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f6b90015968, unit=0x7f6b90004a18, select_lex=0x7f6b90013368) at /data/src/10.4/sql/sql_select.cc:4666
#27 0x000055f593adac24 in handle_select (thd=0x7f6b90000af0, lex=0x7f6b90004958, result=0x7f6b90015968, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:420
#28 0x000055f593aa134b in execute_sqlcom_select (thd=0x7f6b90000af0, all_tables=0x7f6b90013958) at /data/src/10.4/sql/sql_parse.cc:6360
#29 0x000055f593a969f9 in mysql_execute_command (thd=0x7f6b90000af0) at /data/src/10.4/sql/sql_parse.cc:3899
#30 0x000055f593aa5457 in mysql_parse (thd=0x7f6b90000af0, rawbuf=0x7f6b90013198 "SELECT * FROM event_whois_domain_minified WHERE 1 = 1 AND domain = 'www.mailhost.i-dev.fr' AND timestamp >= DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -1 MONTH) ORDER BY timestamp DESC", length=178, parser_state=0x7f6be40a5160, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7901
#31 0x000055f593a905fc in dispatch_command (command=COM_QUERY, thd=0x7f6b90000af0, packet=0x7f6b90137511 "", packet_length=178, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842
#32 0x000055f593a8ec89 in do_command (thd=0x7f6b90000af0) at /data/src/10.4/sql/sql_parse.cc:1360
#33 0x000055f593c17c51 in do_handle_one_connection (connect=0x55f597252880) at /data/src/10.4/sql/sql_connect.cc:1412
#34 0x000055f593c179a0 in handle_one_connection (arg=0x55f597252880) at /data/src/10.4/sql/sql_connect.cc:1316
#35 0x000055f59461db0d in pfs_spawn_thread (arg=0x55f5971bef50) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#36 0x00007f6beb65b4a4 in start_thread (arg=0x7f6be40a6700) at pthread_create.c:456
#37 0x00007f6be978fd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Elena Stepanova added a comment - 2020-01-15 19:04 Here is the test case reduced even further. It can be run via MTR with default MTR settings, or MySQL client on a server with default server options. --source include/have_innodb.inc CREATE TABLE event_whois_domain_minified ( id int (11) unsigned NOT NULL AUTO_INCREMENT, domain varchar (255) NOT NULL , registrant_name varchar (255) DEFAULT NULL , registrant_organization varchar (255) DEFAULT NULL , registrant_street1 varchar (255) DEFAULT NULL , registrant_street2 varchar (255) DEFAULT NULL , registrant_street3 varchar (255) DEFAULT NULL , registrant_street4 varchar (255) DEFAULT NULL , registrant_street5 varchar (255) DEFAULT NULL , registrant_city varchar (255) DEFAULT NULL , registrant_postal_code varchar (255) DEFAULT NULL , registrant_country varchar (255) DEFAULT NULL , registrant_email varchar (255) DEFAULT NULL , registrant_telephone varchar (255) DEFAULT NULL , administrative_name varchar (255) DEFAULT NULL , administrative_organization varchar (255) DEFAULT NULL , administrative_street1 varchar (255) DEFAULT NULL , administrative_street2 varchar (255) DEFAULT NULL , administrative_street3 varchar (255) DEFAULT NULL , administrative_street4 varchar (255) DEFAULT NULL , administrative_street5 varchar (255) DEFAULT NULL , administrative_city varchar (255) DEFAULT NULL , administrative_postal_code varchar (255) DEFAULT NULL , administrative_country varchar (255) DEFAULT NULL , administrative_email varchar (255) DEFAULT NULL , administrative_telephone varchar (255) DEFAULT NULL , technical_name varchar (255) DEFAULT NULL , technical_organization varchar (255) DEFAULT NULL , technical_street1 varchar (255) DEFAULT NULL , technical_street2 varchar (255) DEFAULT NULL , technical_street3 varchar (255) DEFAULT NULL , technical_street4 varchar (255) DEFAULT NULL , technical_street5 varchar (255) DEFAULT NULL , technical_city varchar (255) DEFAULT NULL , technical_postal_code varchar (255) DEFAULT NULL , technical_country varchar (255) DEFAULT NULL , technical_email varchar (255) DEFAULT NULL , technical_telephone varchar (255) DEFAULT NULL , json longblob NOT NULL , timestamp timestamp NOT NULL DEFAULT current_timestamp (), PRIMARY KEY (id), KEY ixEventWhoisDomainDomain (domain), KEY ixEventWhoisDomainTimestamp ( timestamp ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO event_whois_domain_minified (id, domain, registrant_name, registrant_organization, registrant_street1, registrant_street2, registrant_street3, registrant_street4, registrant_street5, registrant_city, registrant_postal_code, registrant_country, registrant_email, registrant_telephone, administrative_name, administrative_organization, administrative_street1, administrative_street2, administrative_street3, administrative_street4, administrative_street5, administrative_city, administrative_postal_code, administrative_country, administrative_email, administrative_telephone, technical_name, technical_organization, technical_street1, technical_street2, technical_street3, technical_street4, technical_street5, technical_city, technical_postal_code, technical_country, technical_email, technical_telephone, json, timestamp ) VALUES (60380, 'www.mailhost.i-dev.fr' , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , '' , '2016-12-22 09:18:28' ), (60383, 'www.bestwestern.fr' , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , '' , '2016-12-22 09:27:06' ), (80392, 'www.dfinitions.fr' , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , '' , '2017-01-30 08:02:01' ), (80407, 'www.firma.o2.pl' , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , 'AZ.pl Sp. z o.o.' , 'Al. Papieża Jana Pawła II 19/2' , null , null , null , null , '70-453 Szczecin' , null , 'POLAND' , null , '48914243780' , '' , '2017-01-30 08:24:51' ), (80551, 'www.mailhost.i-dev.fr' , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , null , '' , '2017-01-30 10:00:56' ), (80560, 'www.blackmer-mouvex.com' , 'MARIE-PIERRE PRODEAU' , 'MOUVEX' , '2 RUE DES CAILLOTES' , null , null , null , null , 'AUXERRE' , '89000' , 'FRANCE' , 'PRODEAU@MOUVEX.COM' , null , 'MARIE-PIERRE PRODEAU' , 'MOUVEX' , '2 RUE DES CAILLOTES' , null , null , null , null , 'AUXERRE' , '89000' , 'FRANCE' , 'PRODEAU@MOUVEX.COM' , '33 386498630' , 'LAURENT SOUCHELEAU' , 'MOUVEX' , '2 RUE DES CAILLOTES' , null , null , null , null , 'AUXERRE' , '89000' , 'FRANCE' , 'SOUCHELEAU@MOUVEX.COM' , '33 386498643' , '' , '2017-01-30 10:04:38' ), (80566, 'www.inup.com' , 'MAXIMILIAN V. KETELHODT' , null , 'SUELZBURGSTRASSE 158A' , null , null , null , null , 'KOELN' , '50937' , 'GERMANY' , 'ICANN@EXPIRES-2009.WEBCARE24.COM' , '492214307580' , 'MAXIMILIAN V. KETELHODT' , null , 'SUELZBURGSTRASSE 158A' , null , null , null , null , 'KOELN' , '50937' , 'GERMANY' , 'ICANN@EXPIRES-2009.WEBCARE24.COM' , '492214307580' , 'MAXIMILIAN V. KETELHODT' , null , 'SUELZBURGSTRASSE 158A' , null , null , null , null , 'KOELN' , '50937' , 'GERMANY' , 'ICANN@EXPIRES-2009.WEBCARE24.COM' , '492214307580' , '' , '2017-01-30 10:08:29' ); SET optimizer_switch= 'mrr=on,mrr_sort_keys=on' ; SELECT * FROM event_whois_domain_minified WHERE 1 = 1 AND domain = 'www.mailhost.i-dev.fr' AND timestamp >= DATE_ADD( CURRENT_TIMESTAMP , INTERVAL -1 MONTH ) ORDER BY timestamp DESC ; 10.4 2d4b6571 non-debug build MariaDB [test]> SELECT * FROM event_whois_domain_minified WHERE 1 = 1 AND domain = 'www.mailhost.i-dev.fr' AND timestamp >= DATE_ADD( CURRENT_TIMESTAMP , INTERVAL -1 MONTH ) ORDER BY timestamp DESC ; ERROR 1032 (HY000): Can 't find record in ' event_whois_domain_minified' Execution plan MariaDB [test]> EXPLAIN EXTENDED SELECT * FROM event_whois_domain_minified WHERE 1 = 1 AND domain = 'www.mailhost.i-dev.fr' AND timestamp >= DATE_ADD( CURRENT_TIMESTAMP , INTERVAL -1 MONTH ) ORDER BY timestamp DESC ; + ------+-------------+-----------------------------+------------+------------------------------------------------------+------------------------------------------------------+---------+-------+---------+----------+------------------------------------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra | + ------+-------------+-----------------------------+------------+------------------------------------------------------+------------------------------------------------------+---------+-------+---------+----------+------------------------------------------------------------------------+ | 1 | SIMPLE | event_whois_domain_minified | ref|filter | ixEventWhoisDomainDomain,ixEventWhoisDomainTimestamp | ixEventWhoisDomainDomain|ixEventWhoisDomainTimestamp | 767|4 | const | 2 (14%) | 14.29 | Using index condition; Using where ; Using filesort; Using rowid filter | + ------+-------------+-----------------------------+------------+------------------------------------------------------+------------------------------------------------------+---------+-------+---------+----------+------------------------------------------------------------------------+ 1 row in set , 1 warning (0.001 sec) MariaDB [test]> show warnings; + -------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | + -------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Note | 1003 | select `test`.`event_whois_domain_minified`.`id` AS `id`,`test`.`event_whois_domain_minified`.`domain` AS `domain`,`test`.`event_whois_domain_minified`.`registrant_name` AS `registrant_name`,`test`.`event_whois_domain_minified`.`registrant_organization` AS `registrant_organization`,`test`.`event_whois_domain_minified`.`registrant_street1` AS `registrant_street1`,`test`.`event_whois_domain_minified`.`registrant_street2` AS `registrant_street2`,`test`.`event_whois_domain_minified`.`registrant_street3` AS `registrant_street3`,`test`.`event_whois_domain_minified`.`registrant_street4` AS `registrant_street4`,`test`.`event_whois_domain_minified`.`registrant_street5` AS `registrant_street5`,`test`.`event_whois_domain_minified`.`registrant_city` AS `registrant_city`,`test`.`event_whois_domain_minified`.`registrant_postal_code` AS `registrant_postal_code`,`test`.`event_whois_domain_minified`.`registrant_country` AS `registrant_country`,`test`.`event_whois_domain_minified`.`registrant_email` AS `registrant_email`,`test`.`event_whois_domain_minified`.`registrant_telephone` AS `registrant_telephone`,`test`.`event_whois_domain_minified`.`administrative_name` AS `administrative_name`,`test`.`event_whois_domain_minified`.`administrative_organization` AS `administrative_organization`,`test`.`event_whois_domain_minified`.`administrative_street1` AS `administrative_street1`,`test`.`event_whois_domain_minified`.`administrative_street2` AS `administrative_street2`,`test`.`event_whois_domain_minified`.`administrative_street3` AS `administrative_street3`,`test`.`event_whois_domain_minified`.`administrative_street4` AS `administrative_street4`,`test`.`event_whois_domain_minified`.`administrative_street5` AS `administrative_street5`,`test`.`event_whois_domain_minified`.`administrative_city` AS `administrative_city`,`test`.`event_whois_domain_minified`.`administrative_postal_code` AS `administrative_postal_code`,`test`.`event_whois_domain_minified`.`administrative_country` AS `administrative_country`,`test`.`event_whois_domain_minified`.`administrative_email` AS `administrative_email`,`test`.`event_whois_domain_minified`.`administrative_telephone` AS `administrative_telephone`,`test`.`event_whois_domain_minified`.`technical_name` AS `technical_name`,`test`.`event_whois_domain_minified`.`technical_organization` AS `technical_organization`,`test`.`event_whois_domain_minified`.`technical_street1` AS `technical_street1`,`test`.`event_whois_domain_minified`.`technical_street2` AS `technical_street2`,`test`.`event_whois_domain_minified`.`technical_street3` AS `technical_street3`,`test`.`event_whois_domain_minified`.`technical_street4` AS `technical_street4`,`test`.`event_whois_domain_minified`.`technical_street5` AS `technical_street5`,`test`.`event_whois_domain_minified`.`technical_city` AS `technical_city`,`test`.`event_whois_domain_minified`.`technical_postal_code` AS `technical_postal_code`,`test`.`event_whois_domain_minified`.`technical_country` AS `technical_country`,`test`.`event_whois_domain_minified`.`technical_email` AS `technical_email`,`test`.`event_whois_domain_minified`.`technical_telephone` AS `technical_telephone`,`test`.`event_whois_domain_minified`.`json` AS `json`,`test`.`event_whois_domain_minified`.` timestamp ` AS ` timestamp ` from `test`.`event_whois_domain_minified` where `test`.`event_whois_domain_minified`.`domain` = 'www.mailhost.i-dev.fr' and `test`.`event_whois_domain_minified`.` timestamp ` >= <cache>( current_timestamp () + interval -1 month ) order by `test`.`event_whois_domain_minified`.` timestamp ` desc | + -------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) On a debug build, it produces the assertion failure: 10.4 debug 2d4b6571 mysqld: /data/src/10.4/storage/innobase/row/row0sel.cc:3942: ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const offset_t*): Assertion `!prebuilt->index->is_primary()' failed. 200115 21:02:58 [ERROR] mysqld got signal 6 ; #7 0x00007f6be96d2f12 in __GI___assert_fail (assertion=0x55f594a3a868 "!prebuilt->index->is_primary()", file=0x55f594a397a0 "/data/src/10.4/storage/innobase/row/row0sel.cc", line=3942, function=0x55f594a3d8e0 <row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned short const*)::__PRETTY_FUNCTION__> "ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const offset_t*)") at assert.c:101 #8 0x000055f5942320d2 in row_search_idx_cond_check (mysql_rec=0x7f6b90058d58 "\377\377\377\377\377\334\353", prebuilt=0x7f6b901516d8, rec=0x7f6bdf12c084 "", offsets=0x7f6be40a26d0) at /data/src/10.4/storage/innobase/row/row0sel.cc:3942 #9 0x000055f5942360a2 in row_search_mvcc (buf=0x7f6b90058d58 "\377\377\377\377\377\334\353", mode=PAGE_CUR_GE, prebuilt=0x7f6b901516d8, match_mode=1, direction=0) at /data/src/10.4/storage/innobase/row/row0sel.cc:5257 #10 0x000055f59404652e in ha_innobase::index_read (this=0x7f6b90056b78, buf=0x7f6b90058d58 "\377\377\377\377\377\334\353", key_ptr=0x7f6b90225e1c "\334\353", key_len=4, find_flag=HA_READ_KEY_EXACT) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9296 #11 0x000055f594047851 in ha_innobase::rnd_pos (this=0x7f6b90056b78, buf=0x7f6b90058d58 "\377\377\377\377\377\334\353", pos=0x7f6b90225e1c "\334\353") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9797 #12 0x000055f593dfb665 in handler::ha_rnd_pos (this=0x7f6b90056b78, buf=0x7f6b90058d58 "\377\377\377\377\377\334\353", pos=0x7f6b90225e1c "\334\353") at /data/src/10.4/sql/handler.cc:2859 #13 0x000055f593c71105 in Mrr_ordered_rndpos_reader::get_next (this=0x7f6b90057030, range_info=0x7f6be40a3688) at /data/src/10.4/sql/multi_range_read.cc:885 #14 0x000055f593c72b56 in DsMrr_impl::dsmrr_next (this=0x7f6b90057008, range_info=0x7f6be40a3688) at /data/src/10.4/sql/multi_range_read.cc:1520 #15 0x000055f59405a02a in ha_innobase::multi_range_read_next (this=0x7f6b90056b78, range_info=0x7f6be40a3688) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:20377 #16 0x000055f593f8caa8 in QUICK_RANGE_SELECT::get_next (this=0x7f6b901a1690) at /data/src/10.4/sql/opt_range.cc:12160 #17 0x000055f593debbdb in find_all_keys (thd=0x7f6b90000af0, param=0x7f6be40a3930, select=0x7f6b9014fa30, fs_info=0x7f6b901a17e0, buffpek_pointers=0x7f6be40a3b30, tempfile=0x7f6be40a39c0, pq=0x0, found_rows=0x7f6b901a19c0) at /data/src/10.4/sql/filesort.cc:764 #18 0x000055f593dea13d in filesort (thd=0x7f6b90000af0, table=0x7f6b9018cc20, filesort=0x7f6b9014fd88, tracker=0x7f6b901d2a90, join=0x7f6b90015990, first_table_bit=1) at /data/src/10.4/sql/filesort.cc:267 #19 0x000055f593b1e4d7 in create_sort_index (thd=0x7f6b90000af0, join=0x7f6b90015990, tab=0x7f6b9014e4c8, fsort=0x7f6b9014fd88) at /data/src/10.4/sql/sql_select.cc:23479 #20 0x000055f593b187b0 in st_join_table::sort_table (this=0x7f6b9014e4c8) at /data/src/10.4/sql/sql_select.cc:21236 #21 0x000055f593b1838c in join_init_read_record (tab=0x7f6b9014e4c8) at /data/src/10.4/sql/sql_select.cc:21175 #22 0x000055f593b1614d in sub_select (join=0x7f6b90015990, join_tab=0x7f6b9014e4c8, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:20252 #23 0x000055f593b1563e in do_select (join=0x7f6b90015990, procedure=0x0) at /data/src/10.4/sql/sql_select.cc:19793 #24 0x000055f593aea821 in JOIN::exec_inner (this=0x7f6b90015990) at /data/src/10.4/sql/sql_select.cc:4452 #25 0x000055f593ae995e in JOIN::exec (this=0x7f6b90015990) at /data/src/10.4/sql/sql_select.cc:4234 #26 0x000055f593aeb073 in mysql_select (thd=0x7f6b90000af0, tables=0x7f6b90013958, wild_num=1, fields=..., conds=0x7f6b900147d8, og_num=1, order=0x7f6b90015810, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f6b90015968, unit=0x7f6b90004a18, select_lex=0x7f6b90013368) at /data/src/10.4/sql/sql_select.cc:4666 #27 0x000055f593adac24 in handle_select (thd=0x7f6b90000af0, lex=0x7f6b90004958, result=0x7f6b90015968, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:420 #28 0x000055f593aa134b in execute_sqlcom_select (thd=0x7f6b90000af0, all_tables=0x7f6b90013958) at /data/src/10.4/sql/sql_parse.cc:6360 #29 0x000055f593a969f9 in mysql_execute_command (thd=0x7f6b90000af0) at /data/src/10.4/sql/sql_parse.cc:3899 #30 0x000055f593aa5457 in mysql_parse (thd=0x7f6b90000af0, rawbuf=0x7f6b90013198 "SELECT * FROM event_whois_domain_minified WHERE 1 = 1 AND domain = 'www.mailhost.i-dev.fr' AND timestamp >= DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -1 MONTH) ORDER BY timestamp DESC", length=178, parser_state=0x7f6be40a5160, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7901 #31 0x000055f593a905fc in dispatch_command (command=COM_QUERY, thd=0x7f6b90000af0, packet=0x7f6b90137511 "", packet_length=178, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842 #32 0x000055f593a8ec89 in do_command (thd=0x7f6b90000af0) at /data/src/10.4/sql/sql_parse.cc:1360 #33 0x000055f593c17c51 in do_handle_one_connection (connect=0x55f597252880) at /data/src/10.4/sql/sql_connect.cc:1412 #34 0x000055f593c179a0 in handle_one_connection (arg=0x55f597252880) at /data/src/10.4/sql/sql_connect.cc:1316 #35 0x000055f59461db0d in pfs_spawn_thread (arg=0x55f5971bef50) at /data/src/10.4/storage/perfschema/pfs.cc:1862 #36 0x00007f6beb65b4a4 in start_thread (arg=0x7f6be40a6700) at pthread_create.c:456 #37 0x00007f6be978fd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Christophe Migliorini added a comment - 2020-01-17 10:33 - edited

wow, that's a reduction! How did you find out? That could help us on another one (we still have the issue on a more complex, GDPR-related, table, and we would be happy to work on a test case for you.

Christophe Migliorini added a comment - 2020-01-17 10:33 - edited wow, that's a reduction! How did you find out? That could help us on another one (we still have the issue on a more complex, GDPR-related, table, and we would be happy to work on a test case for you.

Elena Stepanova added a comment - 2020-01-17 12:44

c_migliorini,

I have some handmade tools, but in your case they aren't necessary and way too complicated for the purpose. Test cases like yours, once you have something that fails deterministically, are very easy to simplify. You need a few-line script which preserves CREATE and SELECT and "bisects" INSERT statements, removing a bunch of them at a time, runs the resulting set of queries, checks the output (or exit code). If the failure still happens, then the removed bunch of INSERT isn't needed, otherwise it's kept. Drop the table, repeat. Leave it run overnight, it will do the trick.
One thing I recommend is enclosing the INSERT part into one big transaction by BEGIN/COMMIT or their analogues. It doesn't make a difference for the result, but will run hundreds times faster.

Elena Stepanova added a comment - 2020-01-17 12:44 c_migliorini , I have some handmade tools, but in your case they aren't necessary and way too complicated for the purpose. Test cases like yours, once you have something that fails deterministically, are very easy to simplify. You need a few-line script which preserves CREATE and SELECT and "bisects" INSERT statements, removing a bunch of them at a time, runs the resulting set of queries, checks the output (or exit code). If the failure still happens, then the removed bunch of INSERT isn't needed, otherwise it's kept. Drop the table, repeat. Leave it run overnight, it will do the trick. One thing I recommend is enclosing the INSERT part into one big transaction by BEGIN / COMMIT or their analogues. It doesn't make a difference for the result, but will run hundreds times faster.

Igor Babaev (Inactive) added a comment - 2020-02-11 07:16

A fix for this bug was pushed into 10.4

Igor Babaev (Inactive) added a comment - 2020-02-11 07:16 A fix for this bug was pushed into 10.4

MariaDB Server

ERROR 1032 Can't find record when running simple, single-table query

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration