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
• Status: Duplicate
• Category: MySQL Server: DDL
• Severity: S6 (Debug Builds)
• Version: 5.6.20, 5.6.22, 5.7.6
• OS: Any
• CPU Architecture: Any
• Tags: debug

[27 Oct 2014 5:07] Roel Van de Paar

Description:
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:
DROP DATABASE test;CREATE DATABASE test;USE test;
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.

Thanks,
Umesh

[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