Bug #92187 [InnoDB] InnoDB: Assertion failure: btr0btr.ic:133:level <= 50
Submitted: 25 Aug 2018 7:16 Modified: 9 May 2019 13:28
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DML Severity:S6 (Debug Builds)
Version:8.0.12 OS:Any
Assigned to: CPU Architecture:Any

[25 Aug 2018 7:16] Roel Van de Paar
Description:
2018-08-25T07:11:43.157614Z 9 [ERROR] [MY-000000] [InnoDB] InnoDB: Assertion failure: btr0btr.ic:133:level <= 50
InnoDB: thread 139661590652672

Core was generated by `/sda/2/bin/mysqld --no-defaults --core-file --basedir=/sda/2 --tmpdir=/sda/2/da'.
Program terminated with signal SIGABRT, Aborted.
#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
57	../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
[Current thread is 1 (Thread 0x7f057f7fe700 (LWP 21619))]
(gdb) bt
#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1  0x0000564cb587878d in my_write_core (sig=6) at /git/MS-8.0.12_dbg/mysys/stacktrace.cc:278
#2  0x0000564cb45ccd94 in handle_fatal_signal (sig=6) at /git/MS-8.0.12_dbg/sql/signal_handler.cc:249
#3  <signal handler called>
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5  0x00007f059487c801 in __GI_abort () at abort.c:79
#6  0x0000564cb5c62239 in ut_dbg_assertion_failed (expr=0x564cb6eebcbf "level <= 50", 
    file=0x564cb6eebc88 "/git/MS-8.0.12_dbg/storage/innobase/include/btr0btr.ic", line=133)
    at /git/MS-8.0.12_dbg/storage/innobase/ut/ut0dbg.cc:90
#7  0x0000564cb5c9494c in btr_page_set_level (page=0x7f057567c000 "", page_zip=0x0, level=51, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/include/btr0btr.ic:133
#8  0x0000564cb5c9942a in btr_page_empty (block=0x7f0574266dd8, page_zip=0x0, index=0x7f056acf3db8, level=51, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:1477
#9  0x0000564cb5c99b31 in btr_root_raise_and_insert (flags=7, cursor=0x7f057f7c6710, offsets=0x7f057f7c6708, heap=0x7f057f7c6700, 
    tuple=0x7f056ac976b8, n_ext=0, mtr=0x7f057f7f6aa0) at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:1620
#10 0x0000564cb5cb5fcc in btr_cur_pessimistic_insert (flags=7, cursor=0x7f057f7c6710, offsets=0x7f057f7c6708, heap=0x7f057f7c6700, 
    entry=0x7f056ac976b8, rec=0x7f057f7c66f8, big_rec=0x7f057f7c66f0, n_ext=0, thr=0x0, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0cur.cc:3038
#11 0x0000564cb5c9a84b in btr_insert_on_non_leaf_level_func (flags=7, index=0x7f056acf3db8, level=50, tuple=0x7f056ac976b8, 
    file=0x564cb6eebf28 "/git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc", line=2109, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:1998
#12 0x0000564cb5c9af09 in btr_attach_half_pages (flags=7, index=0x7f056acf3db8, block=0x7f057436c3e0, 
    split_rec=0x7f0576b3008b "\200", new_block=0x7f05743764d8, direction=112, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2109
#13 0x0000564cb5c9c4e2 in btr_page_split_and_insert (flags=7, cursor=0x7f057f7c7660, offsets=0x7f057f7c7658, heap=0x7f057f7c7650, 
    tuple=0x7f056ac96cb8, n_ext=0, mtr=0x7f057f7f6aa0) at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2469
#14 0x0000564cb5cb600c in btr_cur_pessimistic_insert (flags=7, cursor=0x7f057f7c7660, offsets=0x7f057f7c7658, heap=0x7f057f7c7650, 
    entry=0x7f056ac96cb8, rec=0x7f057f7c7648, big_rec=0x7f057f7c7640, n_ext=0, thr=0x0, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0cur.cc:3041
#15 0x0000564cb5c9a84b in btr_insert_on_non_leaf_level_func (flags=7, index=0x7f056acf3db8, level=49, tuple=0x7f056ac96cb8, 
    file=0x564cb6eebf28 "/git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc", line=2109, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:1998
#16 0x0000564cb5c9af09 in btr_attach_half_pages (flags=7, index=0x7f056acf3db8, block=0x7f057436c0b8, 
    split_rec=0x7f0576b2c08b "\200", new_block=0x7f05743761b0, direction=112, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2109
#17 0x0000564cb5c9c4e2 in btr_page_split_and_insert (flags=7, cursor=0x7f057f7c85b0, offsets=0x7f057f7c85a8, heap=0x7f057f7c85a0, 
    tuple=0x7f056ac962b8, n_ext=0, mtr=0x7f057f7f6aa0) at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2469
#18 0x0000564cb5cb600c in btr_cur_pessimistic_insert (flags=7, cursor=0x7f057f7c85b0, offsets=0x7f057f7c85a8, heap=0x7f057f7c85a0, 
    entry=0x7f056ac962b8, rec=0x7f057f7c8598, big_rec=0x7f057f7c8590, n_ext=0, thr=0x0, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0cur.cc:3041
#19 0x0000564cb5c9a84b in btr_insert_on_non_leaf_level_func (flags=7, index=0x7f056acf3db8, level=48, tuple=0x7f056ac962b8, 
    file=0x564cb6eebf28 "/git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc", line=2109, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:1998
#20 0x0000564cb5c9af09 in btr_attach_half_pages (flags=7, index=0x7f056acf3db8, block=0x7f057436bd90, 
    split_rec=0x7f0576b2808b "\200", new_block=0x7f0574375e88, direction=112, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2109
#21 0x0000564cb5c9c4e2 in btr_page_split_and_insert (flags=7, cursor=0x7f057f7c9500, offsets=0x7f057f7c94f8, heap=0x7f057f7c94f0, 
    tuple=0x7f056ac958b8, n_ext=0, mtr=0x7f057f7f6aa0) at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2469
#22 0x0000564cb5cb600c in btr_cur_pessimistic_insert (flags=7, cursor=0x7f057f7c9500, offsets=0x7f057f7c94f8, heap=0x7f057f7c94f0, 
    entry=0x7f056ac958b8, rec=0x7f057f7c94e8, big_rec=0x7f057f7c94e0, n_ext=0, thr=0x0, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0cur.cc:3041
#23 0x0000564cb5c9a84b in btr_insert_on_non_leaf_level_func (flags=7, index=0x7f056acf3db8, level=47, tuple=0x7f056ac958b8, 
    file=0x564cb6eebf28 "/git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc", line=2109, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:1998
#24 0x0000564cb5c9af09 in btr_attach_half_pages (flags=7, index=0x7f056acf3db8, block=0x7f057436ba68, 
    split_rec=0x7f0576b2408b "\200", new_block=0x7f0574375b60, direction=112, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2109
#25 0x0000564cb5c9c4e2 in btr_page_split_and_insert (flags=7, cursor=0x7f057f7ca450, offsets=0x7f057f7ca448, heap=0x7f057f7ca440, 
    tuple=0x7f056ac94eb8, n_ext=0, mtr=0x7f057f7f6aa0) at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2469

How to repeat:
CREATE DATABASE test;
USE test;
CREATE TEMPORARY TABLE t1(c1 DEC NOT NULL);
INSERT INTO t1  VALUES (0xED40),(0xED41),(0xED42),(0xED43),(0xED44),(0xED45),(0xED46),(0xED47), (0xED48),(0xED49),(0xED4A),(0xED4B),(0xED4C),(0xED4D),(0xED4E),(0xED4F), (0xED50),(0xED51),(0xED52),(0xED53),(0xED54),(0xED55),(0xED56),(0xED57), (0xED58),(0xED59),(0xED5A),(0xED5B),(0xED5C),(0xED5D),(0xED5E),(0xED5F), (0xED60),(0xED61),(0xED62),(0xED63),(0xED64),(0xED65),(0xED66),(0xED67), (0xED68),(0xED69),(0xED6A),(0xED6B),(0xED6C),(0xED6D),(0xED6E),(0xED6F), (0xED70),(0xED71),(0xED72),(0xED73),(0xED74),(0xED75),(0xED76),(0xED77), (0xED78),(0xED79),(0xED7A),(0xED7B),(0xED7C),(0xED7D),(0xED7E), (0xED80),(0xED81),(0xED82),(0xED83),(0xED84),(0xED85),(0xED86),(0xED87), (0xED88),(0xED89),(0xED8A),(0xED8B),(0xED8C),(0xED8D),(0xED8E),(0xED8F), (0xED90),(0xED91),(0xED92),(0xED93),(0xED94),(0xED95),(0xED96),(0xED97), (0xED98),(0xED99),(0xED9A),(0xED9B),(0xED9C),(0xED9D),(0xED9E),(0xED9F), (0xEDA0),(0xEDA1),(0xEDA2),(0xEDA3),(0xEDA4),(0xEDA5),(0xEDA6),(0xEDA7), (0xEDA8),(0xEDA9),(0xEDAA),(0xEDAB),(0xEDAC),(0xEDAD),(0xEDAE),(0xEDAF), (0xEDB0),(0xEDB1),(0xEDB2),(0xEDB3),(0xEDB4),(0xEDB5),(0xEDB6),(0xEDB7), (0xEDB8),(0xEDB9),(0xEDBA),(0xEDBB),(0xEDBC),(0xEDBD),(0xEDBE),(0xEDBF), (0xEDC0),(0xEDC1),(0xEDC2),(0xEDC3),(0xEDC4),(0xEDC5),(0xEDC6),(0xEDC7), (0xEDC8),(0xEDC9),(0xEDCA),(0xEDCB),(0xEDCC),(0xEDCD),(0xEDCE),(0xEDCF), (0xEDD0),(0xEDD1),(0xEDD2),(0xEDD3),(0xEDD4),(0xEDD5),(0xEDD6),(0xEDD7), (0xEDD8),(0xEDD9),(0xEDDA),(0xEDDB),(0xEDDC),(0xEDDD),(0xEDDE),(0xEDDF), (0xEDE0),(0xEDE1),(0xEDE2),(0xEDE3),(0xEDE4),(0xEDE5),(0xEDE6),(0xEDE7), (0xEDE8),(0xEDE9),(0xEDEA),(0xEDEB),(0xEDEC),(0xEDED),(0xEDEE),(0xEDEF), (0xEDF0),(0xEDF1),(0xEDF2),(0xEDF3),(0xEDF4),(0xEDF5),(0xEDF6),(0xEDF7), (0xEDF8),(0xEDF9),(0xEDFA),(0xEDFB),(0xEDFC), (0xEE40),(0xEE41),(0xEE42),(0xEE43),(0xEE44),(0xEE45),(0xEE46),(0xEE47), (0xEE48),(0xEE49),(0xEE4A),(0xEE4B),(0xEE4C),(0xEE4D),(0xEE4E),(0xEE4F), (0xEE50),(0xEE51),(0xEE52),(0xEE53),(0xEE54),(0xEE55),(0xEE56),(0xEE57), (0xEE58),(0xEE59),(0xEE5A),(0xEE5B),(0xEE5C),(0xEE5D),(0xEE5E),(0xEE5F), (0xEE60),(0xEE61),(0xEE62),(0xEE63),(0xEE64),(0xEE65),(0xEE66),(0xEE67), (0xEE68),(0xEE69),(0xEE6A),(0xEE6B),(0xEE6C),(0xEE6D),(0xEE6E),(0xEE6F), (0xEE70),(0xEE71),(0xEE72),(0xEE73),(0xEE74),(0xEE75),(0xEE76),(0xEE77), (0xEE78),(0xEE79),(0xEE7A),(0xEE7B),(0xEE7C),(0xEE7D),(0xEE7E), (0xEE80),(0xEE81),(0xEE82),(0xEE83),(0xEE84),(0xEE85),(0xEE86),(0xEE87), (0xEE88),(0xEE89),(0xEE8A),(0xEE8B),(0xEE8C),(0xEE8D),(0xEE8E),(0xEE8F), (0xEE90),(0xEE91),(0xEE92),(0xEE93),(0xEE94),(0xEE95),(0xEE96),(0xEE97), (0xEE98),(0xEE99),(0xEE9A),(0xEE9B),(0xEE9C),(0xEE9D),(0xEE9E),(0xEE9F), (0xEEA0),(0xEEA1),(0xEEA2),(0xEEA3),(0xEEA4),(0xEEA5),(0xEEA6),(0xEEA7), (0xEEA8),(0xEEA9),(0xEEAA),(0xEEAB),(0xEEAC),(0xEEAD),(0xEEAE),(0xEEAF), (0xEEB0),(0xEEB1),(0xEEB2),(0xEEB3),(0xEEB4),(0xEEB5),(0xEEB6),(0xEEB7), (0xEEB8),(0xEEB9),(0xEEBA),(0xEEBB),(0xEEBC),(0xEEBD),(0xEEBE),(0xEEBF), (0xEEC0),(0xEEC1),(0xEEC2),(0xEEC3),(0xEEC4),(0xEEC5),(0xEEC6),(0xEEC7), (0xEEC8),(0xEEC9),(0xEECA),(0xEECB),(0xEECC),(0xEECD),(0xEECE),(0xEECF), (0xEED0),(0xEED1),(0xEED2),(0xEED3),(0xEED4),(0xEED5),(0xEED6),(0xEED7), (0xEED8),(0xEED9),(0xEEDA),(0xEEDB),(0xEEDC),(0xEEDD),(0xEEDE),(0xEEDF), (0xEEE0),(0xEEE1),(0xEEE2),(0xEEE3),(0xEEE4),(0xEEE5),(0xEEE6),(0xEEE7), (0xEEE8),(0xEEE9),(0xEEEA),(0xEEEB),(0xEEEC),(0xEEEF), (0xEEF0),(0xEEF1),(0xEEF2),(0xEEF3),(0xEEF4),(0xEEF5),(0xEEF6),(0xEEF7), (0xEEF8),(0xEEF9),(0xEEFA),(0xEEFB),(0xEEFC);
set global innodb_limit_optimistic_insert_debug = 2;
CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 DESC); ;
[25 Aug 2018 7:18] Roel Van de Paar
Rest of stack

    entry=0x7f056ac94eb8, rec=0x7f057f7ca438, big_rec=0x7f057f7ca430, n_ext=0, thr=0x0, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0cur.cc:3041
#27 0x0000564cb5c9a84b in btr_insert_on_non_leaf_level_func (flags=7, index=0x7f056acf3db8, level=46, tuple=0x7f056ac94eb8, 
    file=0x564cb6eebf28 "/git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc", line=2109, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:1998
#28 0x0000564cb5c9af09 in btr_attach_half_pages (flags=7, index=0x7f056acf3db8, block=0x7f057436b740, 
    split_rec=0x7f0576b2008b "\200", new_block=0x7f0574375838, direction=112, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2109
#29 0x0000564cb5c9c4e2 in btr_page_split_and_insert (flags=7, cursor=0x7f057f7cb3a0, offsets=0x7f057f7cb398, heap=0x7f057f7cb390, 
    tuple=0x7f056ac944b8, n_ext=0, mtr=0x7f057f7f6aa0) at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2469
#30 0x0000564cb5cb600c in btr_cur_pessimistic_insert (flags=7, cursor=0x7f057f7cb3a0, offsets=0x7f057f7cb398, heap=0x7f057f7cb390, 
    entry=0x7f056ac944b8, rec=0x7f057f7cb388, big_rec=0x7f057f7cb380, n_ext=0, thr=0x0, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0cur.cc:3041

...

#200 0x0000564cb5c9af09 in btr_attach_half_pages (flags=7, index=0x7f056acf3db8, block=0x7f0574362f88, 
    split_rec=0x7f0576a7408b "\200", new_block=0x7f057436d080, direction=112, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2109
#201 0x0000564cb5c9c4e2 in btr_page_split_and_insert (flags=7, cursor=0x7f057f7f4610, offsets=0x7f057f7f4608, heap=0x7f057f7f4600, 
    tuple=0x7f056ac5b5b8, n_ext=0, mtr=0x7f057f7f6aa0) at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2469
#202 0x0000564cb5cb600c in btr_cur_pessimistic_insert (flags=7, cursor=0x7f057f7f4610, offsets=0x7f057f7f4608, heap=0x7f057f7f4600, 
    entry=0x7f056ac5b5b8, rec=0x7f057f7f45f8, big_rec=0x7f057f7f45f0, n_ext=0, thr=0x0, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0cur.cc:3041
#203 0x0000564cb5c9a84b in btr_insert_on_non_leaf_level_func (flags=7, index=0x7f056acf3db8, level=2, tuple=0x7f056ac5b5b8, 
    file=0x564cb6eebf28 "/git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc", line=2109, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:1998
#204 0x0000564cb5c9af09 in btr_attach_half_pages (flags=7, index=0x7f056acf3db8, block=0x7f0574362c60, 
    split_rec=0x7f0576a7008b "\200", new_block=0x7f057436cd58, direction=112, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2109
#205 0x0000564cb5c9c4e2 in btr_page_split_and_insert (flags=7, cursor=0x7f057f7f5560, offsets=0x7f057f7f5558, heap=0x7f057f7f5550, 
    tuple=0x7f056ac5a6b8, n_ext=0, mtr=0x7f057f7f6aa0) at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2469
#206 0x0000564cb5cb600c in btr_cur_pessimistic_insert (flags=7, cursor=0x7f057f7f5560, offsets=0x7f057f7f5558, heap=0x7f057f7f5550, 
    entry=0x7f056ac5a6b8, rec=0x7f057f7f5548, big_rec=0x7f057f7f5540, n_ext=0, thr=0x0, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0cur.cc:3041
#207 0x0000564cb5c9a84b in btr_insert_on_non_leaf_level_func (flags=3, index=0x7f056acf3db8, level=1, tuple=0x7f056ac5a6b8, 
    file=0x564cb6eebf28 "/git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc", line=2109, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:1998
#208 0x0000564cb5c9af09 in btr_attach_half_pages (flags=3, index=0x7f056acf3db8, block=0x7f0574362938, 
    split_rec=0x7f0576a6c094 "\200", new_block=0x7f057436ca30, direction=112, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2109
#209 0x0000564cb5c9c4e2 in btr_page_split_and_insert (flags=3, cursor=0x7f057f7f64f0, offsets=0x7f057f7f6498, heap=0x7f057f7f6490, 
    tuple=0x7f056acf3a38, n_ext=0, mtr=0x7f057f7f6aa0) at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0btr.cc:2469
#210 0x0000564cb5cb600c in btr_cur_pessimistic_insert (flags=3, cursor=0x7f057f7f64f0, offsets=0x7f057f7f6498, heap=0x7f057f7f6490, 
    entry=0x7f056acf3a38, rec=0x7f057f7f64a0, big_rec=0x7f057f7f6488, n_ext=0, thr=0x7f056ad569b8, mtr=0x7f057f7f6aa0)
    at /git/MS-8.0.12_dbg/storage/innobase/btr/btr0cur.cc:3041
#211 0x0000564cb5b54ed6 in row_ins_clust_index_entry_low (flags=3, mode=33, index=0x7f056acf3db8, n_uniq=1, entry=0x7f056acf3a38, 
    n_ext=0, thr=0x7f056ad569b8, dup_chk_only=false) at /git/MS-8.0.12_dbg/storage/innobase/row/row0ins.cc:2531
#212 0x0000564cb5b56f48 in row_ins_clust_index_entry (index=0x7f056acf3db8, entry=0x7f056acf3a38, thr=0x7f056ad569b8, n_ext=0, 
    dup_chk_only=false) at /git/MS-8.0.12_dbg/storage/innobase/row/row0ins.cc:3156
#213 0x0000564cb5b572d4 in row_ins_index_entry (index=0x7f056acf3db8, entry=0x7f056acf3a38, thr=0x7f056ad569b8)
    at /git/MS-8.0.12_dbg/storage/innobase/row/row0ins.cc:3261
#214 0x0000564cb5b578e1 in row_ins_index_entry_step (node=0x7f056ad566d8, thr=0x7f056ad569b8)
    at /git/MS-8.0.12_dbg/storage/innobase/row/row0ins.cc:3395
#215 0x0000564cb5b57c8f in row_ins (node=0x7f056ad566d8, thr=0x7f056ad569b8)
    at /git/MS-8.0.12_dbg/storage/innobase/row/row0ins.cc:3517
#216 0x0000564cb5b582cb in row_ins_step (thr=0x7f056ad569b8) at /git/MS-8.0.12_dbg/storage/innobase/row/row0ins.cc:3683
#217 0x0000564cb5b75eff in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7f056acb0028 "\377\200", prebuilt=0x7f056ad560b8)
    at /git/MS-8.0.12_dbg/storage/innobase/row/row0mysql.cc:1556
#218 0x0000564cb5b76566 in row_insert_for_mysql (mysql_rec=0x7f056acb0028 "\377\200", prebuilt=0x7f056ad560b8)
    at /git/MS-8.0.12_dbg/storage/innobase/row/row0mysql.cc:1685
#219 0x0000564cb59a2f4e in ha_innobase::write_row (this=0x7f056ad54028, record=0x7f056acb0028 "\377\200")
    at /git/MS-8.0.12_dbg/storage/innobase/handler/ha_innodb.cc:7629
#220 0x0000564cb475ea54 in handler::ha_write_row (this=0x7f056ad54028, buf=0x7f056acb0028 "\377\200")
    at /git/MS-8.0.12_dbg/sql/handler.cc:7478
#221 0x0000564cb44e1424 in copy_data_between_tables (thd=0x7f056ac23000, psi=0x7f0593d331b8, from=0x7f056acc1c20, 
    to=0x7f056acc2a20, create=..., copied=0x7f057f7f8400, deleted=0x7f057f7f8408, keys_onoff=Alter_info::LEAVE_AS_IS, 
    alter_ctx=0x7f057f7faec0) at /git/MS-8.0.12_dbg/sql/sql_table.cc:14797
#222 0x0000564cb44de4c5 in mysql_alter_table (thd=0x7f056ac23000, new_db=0x7f056ad031a0 "test", new_name=0x7f056ad02a20 "t1", 
    create_info=0x7f057f7fbe40, table_list=0x7f056ad02c18, alter_info=0x7f057f7fbf30) at /git/MS-8.0.12_dbg/sql/sql_table.cc:13970
#223 0x0000564cb49ae80e in Sql_cmd_create_or_drop_index_base::execute (this=0x7f056ad032d0, thd=0x7f056ac23000)
    at /git/MS-8.0.12_dbg/sql/sql_cmd_ddl_table.cc:378
#224 0x0000564cb4420536 in mysql_execute_command (thd=0x7f056ac23000, first_level=true) at /git/MS-8.0.12_dbg/sql/sql_parse.cc:3228
#225 0x0000564cb4425f94 in mysql_parse (thd=0x7f056ac23000, parser_state=0x7f057f7fd330) at /git/MS-8.0.12_dbg/sql/sql_parse.cc:4925
#226 0x0000564cb441baeb in dispatch_command (thd=0x7f056ac23000, com_data=0x7f057f7fdc90, command=COM_QUERY)
    at /git/MS-8.0.12_dbg/sql/sql_parse.cc:1607
#227 0x0000564cb441a3c6 in do_command (thd=0x7f056ac23000) at /git/MS-8.0.12_dbg/sql/sql_parse.cc:1232
#228 0x0000564cb45ba678 in handle_connection (arg=0x7f05823904c0)
    at /git/MS-8.0.12_dbg/sql/conn_handler/connection_handler_per_thread.cc:308
#229 0x0000564cb5f29422 in pfs_spawn_thread (arg=0x7f05883e7720) at /git/MS-8.0.12_dbg/storage/perfschema/pfs.cc:2836
#230 0x00007f05962686db in start_thread (arg=0x7f057f7fe700) at pthread_create.c:463
#231 0x00007f059495d88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
[25 Aug 2018 7:35] MySQL Verification Team
Hello Roel,

Thank you for the report and test case.
Observed that 8.0.12 debug build is affected.

regards,
Umesh
[9 May 2019 13:19] Daniel Price
Posted by developer:
 
commit 50e758ffddd70bc3363ee65a58e15a5b8bc1963d
Author: Darshan M N <darshan.m.n@oracle.com>
Date:   Thu May 9 15:46:23 2019 +0530

Bug#28552330 - [INNODB] INNODB: ASSERTION FAILURE: BTR0BTR.IC:133:LEVEL <= 50
    
Issue
=====
The case is that in case of a table with a primary key if we insert records in
a descending manner (say 100, 99, 98, 97, etc), with optimistic_insert_debug
set to 2, we see that for 104 records 52 levels are created which crosses the
current limit of 51 levels. This seems to be a natural behaviour of btree and
not really a production bug as it's reproducible only in the case when debug
variable optimistic_insert_debug is set to 2 (i.e, max 2 records in a page)
and to see such a scenario in production is unlikely.
    
Fix
===
Return an error in such a case instead of a debug assert.
[9 May 2019 13:28] Daniel Price
Posted by developer:
 
Fixed as of the upcoming 8.0.17 release, and here's the changelog entry:

Under specific circumstances, setting the
innodb_limit_optimistic_insert_debug variable to 2 raised a debug
assertion when it should have reported an error.