Bug #74577 InnoDB: Failing assertion: level <= 50 in file btr0btr.ic line 141
Submitted: 27 Oct 2014 5:07 Modified: 5 Feb 2015 3:49
Reporter: Roel Van de Paar Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: DDL Severity:S6 (Debug Builds)
Version:5.6.20, 5.6.22, 5.7.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: debug

[27 Oct 2014 5:07] Roel Van de Paar
2014-10-28 02:01:32 7f712896e700  InnoDB: Assertion failure in thread 140123989010176 in file btr0btr.ic line 141
InnoDB: Failing assertion: level <= 50

(gdb) bt
#0  0x00007f71beb71771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000a9035e in my_write_core (sig=6) at /bzr/mysql-5.6/mysys/stacktrace.c:422
#2  0x0000000000723688 in handle_fatal_signal (sig=6) at /bzr/mysql-5.6/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f71bd97d5c9 in raise () from /lib64/libc.so.6
#5  0x00007f71bd97ecd8 in abort () from /lib64/libc.so.6
#6  0x0000000000cfd74c in btr_page_set_level (page=0x7f71a8798000 "\376w\314\f", page_zip=0x0, level=51, mtr=0x7f7128968450) at /bzr/mysql-5.6/storage/innobase/include/btr0btr.ic:141
#7  0x0000000000d010f0 in btr_page_empty (block=0x7f71a7c2da40, page_zip=0x0, index=0x744c758, level=51, mtr=0x7f7128968450) at /bzr/mysql-5.6/storage/innobase/btr/btr0btr.cc:2092
#8  0x0000000000d0163a in btr_root_raise_and_insert (flags=7, cursor=0x7f71289589d0, offsets=0x7f7128958a60, heap=0x7f7128958a58, tuple=0x7f71080b95a8, n_ext=0, mtr=0x7f7128968450) at /bzr/mysql-5.6/storage/innobase/btr/btr0btr.cc:2230
#9  0x0000000000d13811 in btr_cur_pessimistic_insert (flags=7, cursor=0x7f71289589d0, offsets=0x7f7128958a60, heap=0x7f7128958a58, entry=0x7f71080b95a8, rec=0x7f7128958a68, big_rec=0x7f7128958a70, n_ext=0, thr=0x0, mtr=0x7f7128968450) at /bzr/mysql-5.6/storage/innobase/btr/btr0cur.cc:1601
[...backtrace goes on and on...]

Debug only

How to repeat:
set global innodb_limit_optimistic_insert_debug=1;
CREATE TABLE t1(c1 CHAR (1),c2 VARCHAR(1),c3 INT);
[27 Oct 2014 5:43] MySQL Verification Team
Hello Roel,

Thank you for the bug report and test case.
Confirmed that only debug build asserts.

[27 Oct 2014 5:44] MySQL Verification Team
test results, gdb stacktraces

Attachment: 74577.txt (text/plain), 91.62 KiB.

[27 Oct 2014 6:03] MySQL Verification Team
5.7.6 debug build too affected.
[27 Oct 2014 6:04] MySQL Verification Team
test results

Attachment: 74577_5.7.6.txt (text/plain), 87.13 KiB.

[2 Dec 2014 12:21] Erlend Dahl
Fixed as a duplicate of bug#74605
[5 Feb 2015 3:49] Roel Van de Paar
See bug 75784