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

mysqld: storage/innobase/include/page0page.ic:662: const rec_t* page_rec_get_next_low(const rec_t*, ulint): Assertion `page_rec_is_infimum(rec) || !(rec_get_info_bits(page + offs, comp) & 0x10UL)' failed.

    Details

      Description

      10.3 commit 892378fb9def2cd38db8c1b0adcb66be2f72e86a 2019-10-09
      compiled with debug
       
      Version: '10.3.19-MariaDB-debug-log'  socket: '...
      mysqld: storage/innobase/include/page0page.ic:662: const rec_t* page_rec_get_next_low(const rec_t*, ulint): Assertion `page_rec_is_infimum(rec) || !(rec_get_info_bits(page + offs, comp) & 0x10UL)' failed.
      191009 18:20:13 [ERROR] mysqld got signal 6 ;
      ...
      Query (0x7f5934011a90): INSERT INTO t4 (col1,col_string, col_text) VALUES ( 9476, 'BBB', 'AAA' )
      Connection ID (thread ID): 9
      Status: NOT_KILLED
      ...
      Thread 1 (Thread 0x7f597b7a3700 (LWP 56396)):
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x0000556607b973ee in my_write_core (sig=6) at mysys/stacktrace.c:481
      #2  0x00005566072cd4a7 in handle_fatal_signal (sig=6) at sql/signal_handler.cc:343
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:58
      #5  0x00007f59864d237a in __GI_abort () at abort.c:89
      #6  0x00007f59864c8b47 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x556607e6a968 "page_rec_is_infimum(rec) || !(rec_get_info_bits(page + offs, comp) & 0x10UL)", file=file@entry=0x556607e6a630 "storage/innobase/include/page0page.ic", line=line@entry=662, function=function@entry=0x556607e6caa0 <_ZZL21page_rec_get_next_lowPKhmE19__PRETTY_FUNCTION__> "const rec_t* page_rec_get_next_low(const rec_t*, ulint)") at assert.c:92
      #7  0x00007f59864c8bf2 in __GI___assert_fail (assertion=0x556607e6a968 "page_rec_is_infimum(rec) || !(rec_get_info_bits(page + offs, comp) & 0x10UL)", file=0x556607e6a630 "storage/innobase/include/page0page.ic", line=662, function=0x556607e6caa0 <_ZZL21page_rec_get_next_lowPKhmE19__PRETTY_FUNCTION__> "const rec_t* page_rec_get_next_low(const rec_t*, ulint)") at assert.c:101
      #8  0x00005566075ff859 in page_rec_get_next_low (rec=0x7f597beb00ad "\200", comp=0) at storage/innobase/include/page0page.ic:662
      #9  0x00005566075ff8c3 in page_rec_get_next_const (rec=0x7f597beb00ad "\200") at storage/innobase/include/page0page.ic:690
      #10 0x00005566076070da in page_simple_validate_old (page=0x7f597beb0000 "") at storage/innobase/page/page0page.cc:2168
      #11 0x0000556607608515 in page_validate (page=0x7f597beb0000 "", index=0x7f593406de78) at storage/innobase/page/page0page.cc:2416
      #12 0x000055660779ab09 in btr_page_split_and_insert (flags=0, cursor=0x7f597b7a0ad0, offsets=0x7f597b7a0a70, heap=0x7f597b7a0a68, tuple=0x7f593415f918, n_ext=0, mtr=0x7f597b7a0ef0) at storage/innobase/btr/btr0btr.cc:3196
      #13 0x00005566077c51cb in btr_cur_pessimistic_insert (flags=0, cursor=0x7f597b7a0ad0, offsets=0x7f597b7a0a70, heap=0x7f597b7a0a68, entry=0x7f593415f918, rec=0x7f597b7a0a78, big_rec=0x7f597b7a0a60, n_ext=0, thr=0x7f593406d0d0, mtr=0x7f597b7a0ef0) at storage/innobase/btr/btr0cur.cc:3626
      #14 0x000055660766b387 in row_ins_clust_index_entry_low (flags=0, mode=33, index=0x7f593406de78, n_uniq=1, entry=0x7f593415f918, n_ext=0, thr=0x7f593406d0d0) at storage/innobase/row/row0ins.cc:2797
      #15 0x000055660766cbc5 in row_ins_clust_index_entry (index=0x7f593406de78, entry=0x7f593415f918, thr=0x7f593406d0d0, n_ext=0) at storage/innobase/row/row0ins.cc:3250
      #16 0x000055660766cfce in row_ins_index_entry (index=0x7f593406de78, entry=0x7f593415f918, thr=0x7f593406d0d0) at storage/innobase/row/row0ins.cc:3356
      #17 0x000055660766d6af in row_ins_index_entry_step (node=0x7f593406cdc8, thr=0x7f593406d0d0) at storage/innobase/row/row0ins.cc:3506
      #18 0x000055660766dad9 in row_ins (node=0x7f593406cdc8, thr=0x7f593406d0d0) at storage/innobase/row/row0ins.cc:3642
      #19 0x000055660766e281 in row_ins_step (thr=0x7f593406d0d0) at storage/innobase/row/row0ins.cc:3785
      #20 0x0000556607694963 in row_insert_for_mysql (mysql_rec=0x7f5934030468 "\361\004%", prebuilt=0x7f593406c7b8, ins_mode=ROW_INS_NORMAL) at storage/innobase/row/row0mysql.cc:1462
      #21 0x00005566074fecb9 in ha_innobase::write_row (this=0x7f5934167fc0, record=0x7f5934030468 "\361\004%") at storage/innobase/handler/ha_innodb.cc:8057
      #22 0x00005566072dff84 in handler::ha_write_row (this=0x7f5934167fc0, buf=0x7f5934030468 "\361\004%") at sql/handler.cc:6446
      #23 0x0000556606f79731 in write_record (thd=0x7f5934000a98, table=0x7f593406afc8, info=0x7f597b7a1bb0) at sql/sql_insert.cc:2031
      #24 0x0000556606f7684a in mysql_insert (thd=0x7f5934000a98, table_list=0x7f5934011bd0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at sql/sql_insert.cc:1072
      #25 0x0000556606fb9f66 in mysql_execute_command (thd=0x7f5934000a98) at sql/sql_parse.cc:4450
      #26 0x0000556606fc5843 in mysql_parse (thd=0x7f5934000a98, rawbuf=0x7f5934011a90 "INSERT INTO t4 (col1,col_string, col_text) VALUES ( 9476, 'BBB', 'AAA' )", length=72, parser_state=0x7f597b7a25e0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:7829
      #27 0x0000556606fb247d in dispatch_command (command=COM_QUERY, thd=0x7f5934000a98, packet=0x7f59340085e9 "INSERT INTO t4 (col1,col_string, col_text) VALUES ( 9476, 'BBB', 'AAA' ) ", packet_length=73, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1855
      #28 0x0000556606fb0dc5 in do_command (thd=0x7f5934000a98) at sql/sql_parse.cc:1400
      #29 0x0000556607127a8c in do_handle_one_connection (connect=0x55660aef9918) at sql/sql_connect.cc:1403
      #30 0x00005566071277ee in handle_one_connection (arg=0x55660aef9918) at sql/sql_connect.cc:1308
      #31 0x0000556607ad6cc4 in pfs_spawn_thread (arg=0x55660ae62f88) at storage/perfschema/pfs.cc:1862
      #32 0x00007f59871116da in start_thread (arg=0x7f597b7a3700) at pthread_create.c:456
      #33 0x00007f59865a3d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105
       
      --source include/have_innodb.inc
      SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' ;
      CREATE TABLE t4 (
         col1 INT PRIMARY KEY,
         col2 INT,
         col_string VARCHAR(20),
         col_text TEXT,
         col_text_g TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) PERSISTENT
      ) ENGINE = InnoDB ROW_FORMAT = Redundant ;
       
      INSERT INTO t4 (col1,col_string, col_text) VALUES ( 1821, 'BBB', 'AAA' ) ;
      ALTER TABLE t4 ADD COLUMN col_string_copy VARCHAR(20) AFTER col_text_g, LOCK = DEFAULT, ALGORITHM = NOCOPY ;
       
      let $run = 10000;
      while ($run)
      {
          eval INSERT INTO t4 (col1,col_string, col_text) VALUES ( $run, 'BBB', 'AAA' ) ;
          dec $run;
      }
      DROP TABLE t4;
      SHOW PROCESSLIST;
      
      

        Attachments

          Activity

            People

            • Assignee:
              marko Marko Mäkelä
              Reporter:
              mleich Matthias Leich
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: