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

Assertion `!page_rec_is_supremum(rec)' failed in btr_pcur_store_position or non-debug assertion failure in rem/rem0rec.cc upon HANDLER READ

    XMLWordPrintable

Details

    Description

      10.4 test, does not fail on 10.3

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (pk INT PRIMARY KEY, c INT) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1,2);
      ALTER TABLE t1 ADD COLUMN f VARCHAR(255);
      ALTER TABLE t1 DROP COLUMN f;
      DELETE FROM t1;
      HANDLER t1 OPEN;
      HANDLER t1 READ `PRIMARY` <= (3);
       
      # Cleanup
      DROP TABLE t1;
      

      Much uglier test, fails on both 10.3 and 10.4

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (
        pk INT AUTO_INCREMENT,
        f1 CHAR(32),
        f2 CHAR(32),
        f3 CHAR(32),
        f4 INT,
        f5 CHAR(32),
        f6 INT,
        f7 INT,
        f8 INT,
        PRIMARY KEY (pk),
        UNIQUE (f6)
      ) ENGINE=InnoDB;
       
      INSERT INTO t1 (f1,f2,f3,f4,f5,f6,f7,f8) VALUES 
        ('reality', 'llt', 'within', -1996816384, 'j', 160, 7, -1822687232),
        ('h', 'j', 'j', 251, 'civilian', NULL, 211, NULL),
        ('ltq', 'b', 'mud', 111, 'v', 90, 0, NULL),
        ('toxic', 'breakfast', 'series', 2, 'x', NULL, 118, 2),
        ('h', 'n', 'vision', 84, 'n', NULL, 197, 103),
        ('h', 'tq', 'q', 6, 'bet', -1927151616, -446038016, 3),
        ('pocket', 'qjt', 'jtl', 0, 'blink', NULL, 12, 0),
        ('k', 'uv', 'exist', 37, 'g', 149, -1610219520, NULL),
        ('parent', 'motion', 'u', 70, 'promote', NULL, 178, NULL),
        ('get', 'convict', 'liquid', -780337152, 'd', NULL, 4, NULL),
        ('vp', 'px', 'xi', -631111680, 'support', NULL, 8, NULL),
        ('ck', 'z', 'minority', 8, 'k', NULL, 864878592, NULL),
        ('kxx', 'g', 'container', 1, 'cholesterol', NULL, 4, 1404436480),
        ('xxv', 'rail', 'j', 219, 'serious', NULL, -816119808, 62),
        ('x', 'v', 'vr', 146, 'm', 16, 170, -1765867520),
        ('age', 'm', 'q', -1251278848, 'rte', 6, 224, NULL),
        ('discrimination', 't', 'q', 31, 'exl', 0, 2, 244),
        ('water', 'x', 'ldb', 98, 'r', 235, 4, 63),
        ('d', 'db', 'p', 248, 'so-called', 102, -255524864, 198),
        ('last', 'bz', 'us', 0, 'experienced', 137, 240, 134),
        ('q', 'z', 'attract', 67, 'code', 67, 75, 1758920704),
        ('yellow', 'c', 'u', 6, 'v', 1731985408, 528154624, 2),
        ('cognitive', 'he', 'protective', 590020608, 'sentence', NULL, 4, 102),
        ('eih', 'l', 'ih', 1266024448, 'traditionally', NULL, 190, NULL),
        ('pine', 'i', 'y', 6, 'glimpse', 214, 7, -1486880768),
        ('jo', 'everyone', 'ol', 0, 'lj', NULL, 1, 0),
        ('blood', 'f', 'scientist', 54, 'j', 1341128704, 168, NULL),
        ('z', 'brief', 'ambassador', 115, 'ygp', 82, 129, NULL),
        ('gp', 'severe', 'consist', 7, 'p', -1829961728, 602669056, 154),
        ('admit', 'poetry', 'x', 116, 'enemy', 174, -2128543744, -407764992),
        ('s', 'norm', 'decide', 2055667712, 'rtz', NULL, 99, -1233715200),
        ('tzg', 'f', 'beg', 2016280576, 'w', NULL, -643825664, 137),
        ('zgg', 'x', 'f', 148, 'y', -987496448, -708116480, 8),
        ('attorney', 'perfectly', 's', 49, 'z', -1865285632, 56, -1518534656),
        ('concentrate', 's', 'k', -1028849664, 'tir', 83, -1592459264, 1820065792),
        ('t', 'sacrifice', 'ir', -2143879168, 'recipe', 156, 217, NULL),
        ('wdf', 'd', 'f', 137, 'empty', NULL, 188, NULL),
        ('o', 'customer', 'qd', -2135293952, 'z', 1527840768, 227, -1174929408),
        ('d', 'qow', 'o', 1472266240, 'whe', NULL, 7, 197),
        ('deny', 'reputation', 'dutch', 59, 'v', 124, 2, 191),
        ('m', 'liver', 'fv', 0, 'policy', 781582336, 198574080, 177),
        ('vk', 'kx', 'immigrant', -1452736512, 'x', 163, 76, 6) ,
        ('j', 'ru', 'r', 67, 'joke', NULL, 3, NULL),
        ('o', 'u', 'a', -569442304, 'uz', NULL, 933298176, NULL),
        ('g', 'zb', 'c', -1694760960, 'fish', 18, -390463488, 1),
        ('bb', 'o', 'b', 6, 'z', 9, 12, NULL),
        ('compelling', 'xe', 'debut', 89, 'e', -734724096, 119, 175),
        ('md', 'r', 'object', 1046478848, 'frequently', 915537920, 0, 1506410496),
        ('dwn', 'wnz', 'x', 1767571456, 'nz', 241, -882180096, 9),
        ('zvf', 'vfo', 'g', -844824576, 'w', NULL, 1, 9),
        ('w', 'pose', 'r', 1029308416, 'a', -48627712, 1756168192, NULL),
        ('o', 'jwp', 'patient', 172, 'i', 297140224, 45809664, 3),
        ('w', 'p', 'american', 450297856, 'z', 20, 4, 186),
        ('ridiculous', 'helpful', 'vy', -2022899712, 'conspiracy', NULL, 162, -264634368),
        ('t', 'g', 'spite', 289931264, 'y', 4, 13, NULL),
        ('performer', 'i', 'tomato', -1519386624, 'mz', 8, 87, 106),
        ('m', 'z', 'hang', 3, 'crowded', -537919488, 1, 2),
        ('fu', 'uot', 'j', 1, 'o', 179, 220, -2084569088),
        ('ts', 'n', 'su', 1, 'o', 198, 9, 68),
        ('ball', 'halfway', 'uf', 40, 'l', 145948672, 9, 149),
        ('hunting', 'n', 'teenager', 0, 'neat', 209, 2044461056, 68),
        ('independent', 'along', 'fpn', 5, 'pn', 3, 1353252864, 217),
        ('p', 'presumably', 'n', -1977548800, 'balanced', 1909260288, 197, NULL),
        ('pink', 'h', 'tear', 8, 'n', 254, 8, 1006305280),
        ('tyy', 'n', 'yyr', 1107820544, 'yr', NULL, 0, 219),
        ('u', 'retirement', 'thread', -2083192832, 'rx', -678232064, 209, 1048969216),
        ('xk', 'kb', 'z', 9, 'ba', 218, 7, 8),
        ('a', 'plenty', 'forget', 36, 'c', 215, 2027094016, NULL),
        ('i', 'compromise', 'n', -1090256896, 'o', 10, 66, 1872887808),
        ('x', 'disappointment', 'cognitive', 753860608, 'ua', 77, 123, 10),
        ('e', 'added', 'aub', 2, 'u', NULL, 9, 92),
        ('bc', 'h', 'n', 146, 'master', NULL, 1003945984, NULL),
        ('execution', 'f', 'cgp', 574423040, 'gp', 2, -518782976, -1189085184),
        ('pv', 'bad', 'v', 132, 'r', 195, 6, 5),
        ('modify', 'participation', 'vol', 237, 'j', -842924032, 88, -747765760),
        ('substantially', 'i', 'congressional', 2, 'edit', NULL, 1003159552, NULL),
        ('tell', 'forty', 'v', -910098432, 'd', 43, 3, NULL),
        ('crawl', 'ad', 'respect', -1851195392, 'p', 72, -1709047808, 1343225856),
        ('w', 'reception', 'fiber', 56, 's', NULL, 2, -993787904),
        ('successful', 'instruct', 'dug', 2, 'u', 7, -411500544, NULL),
        ('appointment', 'pregnant', 'weird', 2, 'r', NULL, -897384448, 76),
        ('g', 'j', 'thin', 663617536, 'oan', 1, 7, NULL),
        ('secretary', 'a', 'o', 103, 'nj', 1977745408, -1291124736, -1314521088),
        ('g', 'jq', 'q', 1875116032, 'blame', NULL, 1, 4),
        ('oj', 'j', 'breast', 150, 'c', NULL, 3, NULL),
        ('rd', 'm', 'comprehensive', 1723334656, 't', NULL, 155, -312344576) ,
        ('a', 'd', 'criminal', -1155137536, 'airplane', 242, -662896640, 1),
        ('fast', 'i', 'k', -386662400, 'zxe', NULL, 7, 119),
        ('xe', 'mouse', 'c', -205717504, 'ew', NULL, -729612288, 86),
        ('hang', 'j', 'o', 3, 'hungry', NULL, 200, 49),
        ('expense', 'z', 'sum', 2, 'gob', -472055808, -538181632, NULL),
        ('nest', 'o', 'k', 116, 'weak', NULL, 223, NULL);
      --error ER_DUP_ENTRY
      INSERT INTO t1 (f1,f2,f3,f4,f5,f6,f7,f8) VALUES ('impact', 'b', 'h', 185, 'fj', 7, 7, 3);
       
      ALTER TABLE t1 ADD COLUMN filler VARCHAR(255) DEFAULT '';
      SELECT * FROM t1 INTO OUTFILE 'load.data';
      UPDATE IGNORE t1 SET pk = 0;
      LOAD DATA INFILE 'load.data' REPLACE INTO TABLE t1;
      HANDLER t1 OPEN AS h;
      HANDLER h READ `PRIMARY` PREV WHERE 0;
       
      # Cleanup
      HANDLER h CLOSE;
      DROP TABLE t1;
      --let $datadir= `select @@datadir`
      --remove_file $datadir/test/load.data
      

      10.3 debug ac31ff627

      mysqld: /data/src/10.3/storage/innobase/btr/btr0pcur.cc:162: void btr_pcur_store_position(btr_pcur_t*, mtr_t*): Assertion `!page_rec_is_supremum(rec)' failed.
      181213  1:37:05 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fc7db2c1ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055626ab1d063 in btr_pcur_store_position (cursor=0x7fc780071d60, mtr=0x7fc7d4605a00) at /data/src/10.3/storage/innobase/btr/btr0pcur.cc:162
      #9  0x000055626aa46998 in row_search_mvcc (buf=0x7fc7800a5240 "", mode=PAGE_CUR_L, prebuilt=0x7fc780071b98, match_mode=0, direction=2) at /data/src/10.3/storage/innobase/row/row0sel.cc:5595
      #10 0x000055626a8b2f59 in ha_innobase::general_fetch (this=0x7fc78006db98, buf=0x7fc7800a5240 "", direction=2, match_mode=0) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:9534
      #11 0x000055626a8b323c in ha_innobase::index_prev (this=0x7fc78006db98, buf=0x7fc7800a5240 "") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:9627
      #12 0x000055626a5918b7 in handler::ha_index_prev (this=0x7fc78006db98, buf=0x7fc7800a5240 "") at /data/src/10.3/sql/handler.cc:2894
      #13 0x000055626a25069d in mysql_ha_read (thd=0x7fc780000b00, tables=0x7fc780014e60, mode=RPREV, keyname=0x7fc7800154b0 "PRIMARY", key_expr=0x7fc780015dc8, ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x7fc7800154d0, select_limit_cnt=1, offset_limit_cnt=0) at /data/src/10.3/sql/sql_handler.cc:925
      #14 0x000055626a299f30 in mysql_execute_command (thd=0x7fc780000b00) at /data/src/10.3/sql/sql_parse.cc:5756
      #15 0x000055626a2a0d8f in mysql_parse (thd=0x7fc780000b00, rawbuf=0x7fc780014cd8 "HANDLER h READ `PRIMARY` PREV WHERE 0", length=37, parser_state=0x7fc7d46075f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8091
      #16 0x000055626a28df43 in dispatch_command (command=COM_QUERY, thd=0x7fc780000b00, packet=0x7fc78000b1e1 "", packet_length=37, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1850
      #17 0x000055626a28c967 in do_command (thd=0x7fc780000b00) at /data/src/10.3/sql/sql_parse.cc:1395
      #18 0x000055626a3f46a4 in do_handle_one_connection (connect=0x55626d0e6300) at /data/src/10.3/sql/sql_connect.cc:1402
      #19 0x000055626a3f4428 in handle_one_connection (arg=0x55626d0e6300) at /data/src/10.3/sql/sql_connect.cc:1308
      #20 0x000055626a88ea67 in pfs_spawn_thread (arg=0x55626d127ca0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #21 0x00007fc7dcd7d494 in start_thread (arg=0x7fc7d4608700) at pthread_create.c:333
      #22 0x00007fc7db37e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      10.3 non-debug ac31ff627

      2018-12-13 01:38:00 0x7f6270176700  InnoDB: Assertion failure in file /data/src/10.3/storage/innobase/rem/rem0rec.cc line 1872
      InnoDB: We intentionally generate a memory trap.
       
      #4  0x00007f62765da3fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
      #5  0x00005571215856fa in ut_dbg_assertion_failed (expr=expr@entry=0x0, file=file@entry=0x557121e95f20 "/data/src/10.3/storage/innobase/rem/rem0rec.cc", line=line@entry=1872) at /data/src/10.3/storage/innobase/ut/ut0dbg.cc:60
      #6  0x0000557121abf893 in rec_copy_prefix_to_buf (rec=0x7f626bcf0070 <error: Cannot access memory at address 0x7f626bcf0070>, index=0x7f62180701b0, n_fields=1, buf=0x7f6218071e20, buf_size=0x7f6218071e28) at /data/src/10.3/storage/innobase/rem/rem0rec.cc:1872
      #7  0x0000557121b8a7a5 in btr_pcur_store_position (cursor=cursor@entry=0x7f6218071d38, mtr=mtr@entry=0x7f621806e638) at /data/src/10.3/storage/innobase/btr/btr0pcur.cc:172
      #8  0x0000557121affa6e in row_search_mvcc (buf=buf@entry=0x7f621806e638 "", mode=PAGE_CUR_GE, mode@entry=PAGE_CUR_UNSUPP, prebuilt=<optimized out>, match_mode=match_mode@entry=0, direction=direction@entry=2) at /data/src/10.3/storage/innobase/row/row0sel.cc:5595
      #9  0x0000557121a34ffe in ha_innobase::general_fetch (this=0x7f62180667d0, buf=0x7f621806e638 "", direction=2, match_mode=0) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:9534
      #10 0x000055712182b113 in handler::ha_index_prev (this=0x7f62180667d0, buf=0x7f621806e638 "") at /data/src/10.3/sql/handler.cc:2894
      #11 0x0000557121625275 in mysql_ha_read (thd=0x7f62180009a8, tables=0x7f6218011808, mode=RFIRST, keyname=0xffffffffffffffff <error: Cannot access memory at address 0xffffffffffffffff>, key_expr=0x0, ha_rkey_mode=1880564608, cond=0x7f6218011e78, select_limit_cnt=1, offset_limit_cnt=0) at /data/src/10.3/sql/sql_handler.cc:925
      #12 0x0000557121656915 in mysql_execute_command (thd=0x7f62180009a8) at /data/src/10.3/sql/sql_parse.cc:5756
      #13 0x000055712165ac29 in mysql_parse (thd=0x7f62180009a8, rawbuf=<optimized out>, length=37, parser_state=0x7f6270175630, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_parse.cc:8091
      #14 0x000055712165df7e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f62180009a8, packet=packet@entry=0x7f6218009319 "", packet_length=packet_length@entry=37, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.3/sql/sql_parse.cc:1850
      #15 0x000055712165e620 in do_command (thd=0x7f62180009a8) at /data/src/10.3/sql/sql_parse.cc:1395
      #16 0x000055712172fe94 in do_handle_one_connection (connect=connect@entry=0x557123756078) at /data/src/10.3/sql/sql_connect.cc:1402
      #17 0x0000557121730034 in handle_one_connection (arg=arg@entry=0x557123756078) at /data/src/10.3/sql/sql_connect.cc:1308
      #18 0x0000557121a13714 in pfs_spawn_thread (arg=0x5571237c6df8) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #19 0x00007f627808d494 in start_thread (arg=0x7f6270176700) at pthread_create.c:333
      #20 0x00007f627668e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Neither fails on 10.2.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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