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.

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;