Bug #76439 InnoDB: Failing assertion: flags & BUF_PAGE_PRINT_NO_CRASH
Submitted: 23 Mar 2015 0:48 Modified: 8 Apr 2015 19:26
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S6 (Debug Builds)
Version:5.7.5-m16, 5.7.6, 5.7.8, 8.0.0 OS:Any
Assigned to: CPU Architecture:Any

[23 Mar 2015 0:48] Roel Van de Paar 
Description:
Version: '5.7.6-m16-debug'  socket: '/sda/MS-mysql-5.7.6-m16-linux-x86_64-debug/socket.sock'  port: 10430  MySQL Community Server (GPL)
2015-03-23T00:44:56.669151Z 2 [ERROR] InnoDB: Records in wrong order on space 21 page 37 index `<auto_key>`
InnoDB: previous record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
[...]
2015-03-23T00:44:56.731466Z 2 [Note] InnoDB: Uncompressed page, stored checksum in field1 0, calculated checksums for field1: crc32 1054684808, innodb 3402273212, none 3735928559, stored checksum in field2 0, calculated checksums for field2: crc32 1054684808, innodb 895125843, none 3735928559,  page LSN 0 0, low 4 bytes of LSN at page end 0, page number (if stored to page already) 37, space id (if created with >= MySQL-4.1.1 and stored already) 21
InnoDB: Page may be an update undo log page
InnoDB: Page may be an index page where index id is 1
2015-03-23T00:44:56.731498Z 2 [Note] InnoDB: Index 1 is `CLUST_IND` in table `SYS_TABLES`
2015-03-23 11:44:56 0x7f0cc13ff700  InnoDB: Assertion failure in thread 139692758529792 in file buf0buf.cc line 1106
InnoDB: Failing assertion: flags & BUF_PAGE_PRINT_NO_CRASH

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
SET big_tables=on;
set global innodb_limit_optimistic_insert_debug=2;
select 1 as a union all select 1 union all select 2 union select 1 union all select 2;

+bt
#0  0x00007f0cc0e06771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000013a521c in my_write_core (sig=6) at /bzr/mysql-5.7.6-m16_dbg/mysys/stacktrace.c:247
#2  0x0000000000bb713c in handle_fatal_signal (sig=6) at /bzr/mysql-5.7.6-m16_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f0cbfa0a5c9 in raise () from /lib64/libc.so.6
#5  0x00007f0cbfa0bcd8 in abort () from /lib64/libc.so.6
#6  0x00000000016c790b in ut_dbg_assertion_failed (expr=0x1c761e0 "flags & BUF_PAGE_PRINT_NO_CRASH", file=0x1c75b80 "/bzr/mysql-5.7.6-m16_dbg/storage/innobase/buf/buf0buf.cc", line=1106) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x000000000172023d in buf_page_print (read_buf=0x7f0c4f898000 "", page_size=..., flags=0) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/buf/buf0buf.cc:1106
#8  0x000000000159c98f in page_validate (page=0x7f0c4f898000 "", index=0x7f0c1cc98a18) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/page/page0page.cc:2658
#9  0x00000000016e2539 in btr_page_split_and_insert (flags=3, cursor=0x7f0cc13fb6f0, offsets=0x7f0cc13fc010, heap=0x7f0cc13fc018, tuple=0x7f0c1cc1e6d8, n_ext=0, mtr=0x7f0cc13fbb00) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/btr/btr0btr.cc:2927
#10 0x00000000016df8aa in btr_root_raise_and_insert (flags=3, cursor=0x7f0cc13fb6f0, offsets=0x7f0cc13fc010, heap=0x7f0cc13fc018, tuple=0x7f0c1cc1e6d8, n_ext=0, mtr=0x7f0cc13fbb00) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/btr/btr0btr.cc:1793
#11 0x00000000016f9245 in btr_cur_pessimistic_insert (flags=3, cursor=0x7f0cc13fb6f0, offsets=0x7f0cc13fc010, heap=0x7f0cc13fc018, entry=0x7f0c1cc1e6d8, rec=0x7f0cc13fc008, big_rec=0x7f0cc13fc020, n_ext=0, thr=0x7f0c1cca37a0, mtr=0x7f0cc13fbb00) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/btr/btr0cur.cc:3417
#12 0x00000000015e6d5f in row_ins_clust_index_entry_low (flags=3, mode=33, index=0x7f0c1cc98a18, n_uniq=1, entry=0x7f0c1cc1e6d8, n_ext=0, thr=0x7f0c1cca37a0, dup_chk_only=false) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/row/row0ins.cc:2475
#13 0x00000000015e8e07 in row_ins_clust_index_entry (index=0x7f0c1cc98a18, entry=0x7f0c1cc1e6d8, thr=0x7f0c1cca37a0, n_ext=0, dup_chk_only=false) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/row/row0ins.cc:3193
#14 0x00000000016066c3 in row_insert_for_mysql_using_cursor (mysql_rec=0x7f0c1ccaec20 "\377\002", prebuilt=0x7f0c1cca3098) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/row/row0mysql.cc:1534
#15 0x0000000001607283 in row_insert_for_mysql (mysql_rec=0x7f0c1ccaec20 "\377\002", prebuilt=0x7f0c1cca3098) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/row/row0mysql.cc:1784
#16 0x00000000014d6933 in ha_innobase::intrinsic_table_write_row (this=0x7f0c1ccae8e0, record=0x7f0c1ccaec20 "\377\002") at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/handler/ha_innodb.cc:6546
#17 0x00000000014d69f8 in ha_innobase::write_row (this=0x7f0c1ccae8e0, record=0x7f0c1ccaec20 "\377\002") at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/handler/ha_innodb.cc:6570
#18 0x0000000000c24d3b in handler::ha_write_row (this=0x7f0c1ccae8e0, buf=0x7f0c1ccaec20 "\377\002") at /bzr/mysql-5.7.6-m16_dbg/sql/handler.cc:7441
#19 0x000000000114e297 in select_union::send_data (this=0x7f0c1cc965d0, values=...) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_union.cc:60
#20 0x000000000105d3d6 in JOIN::exec (this=0x7f0c1cc97b00) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:156
#21 0x00000000011503dd in st_select_lex_unit::execute (this=0x7f0c1cc2c3a8, thd=0x7f0c1cc1a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_union.cc:822
#22 0x00000000010f31c9 in handle_query (thd=0x7f0c1cc1a000, lex=0x7f0c1cc1c068, result=0x7f0c1cc2dff0, added_options=0, removed_options=0) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_select.cc:187
#23 0x00000000010a9eff in execute_sqlcom_select (thd=0x7f0c1cc1a000, all_tables=0x0) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:4712
#24 0x00000000010a3aa0 in mysql_execute_command (thd=0x7f0c1cc1a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:2450
#25 0x00000000010aae7a in mysql_parse (thd=0x7f0c1cc1a000, parser_state=0x7f0cc13fde00) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:5129
#26 0x00000000010a0bd4 in dispatch_command (command=COM_QUERY, thd=0x7f0c1cc1a000, packet=0x7f0c1cc46011 "select 1 as a union all select 1 union all select 2 union select 1 union all select 2", packet_length=85) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:1249
#27 0x000000000109f925 in do_command (thd=0x7f0c1cc1a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:835
#28 0x00000000011c2fd9 in handle_connection (arg=0x7f0cb7bf78c0) at /bzr/mysql-5.7.6-m16_dbg/sql/conn_handler/connection_handler_per_thread.cc:298
#29 0x00000000013d2299 in pfs_spawn_thread (arg=0x7f0cb8bb2d50) at /bzr/mysql-5.7.6-m16_dbg/storage/perfschema/pfs.cc:2147
#30 0x00007f0cc0e01df3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007f0cbfacb1ad in clone () from /lib64/libc.so.6
[23 Mar 2015 5:37] MySQL Verification Team 
Hello Roel,

Thank you for the report and test case.
Confirmed that 5.7.6, 5.7.8 debug builds are affected.

Thanks,
Umesh
[23 Mar 2015 5:38] MySQL Verification Team 
// 5.7.6 - only debug build is affected

bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76439 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76439 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/mysql-5.7.6/76439/log.err 2>&1 &

- build

commit: e1298eb6a8e2247361533811930a07fde7aff618
date: 2015-02-26 15:29:31 +0100
build-date: 2015-02-26 15:35:58 +0100
short: e1298eb
branch: mysql-5.7.6-m16-release

MySQL source 5.7.6

(gdb) bt
#0  0x00007f5f19f65771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000013ee069 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/mysys/stacktrace.c:247
#2  0x0000000000bdeba0 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f5f18b6b5c9 in raise () from /lib64/libc.so.6
#5  0x00007f5f18b6ccd8 in abort () from /lib64/libc.so.6
#6  0x000000000160d6bb in ut_dbg_assertion_failed (expr=0x1ca6b50 "flags & BUF_PAGE_PRINT_NO_CRASH",
    file=0x1ca64c8 "/export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/buf/buf0buf.cc", line=1106)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001666c5b in buf_page_print (read_buf=0x7f5f03d8c000 "", page_size=..., flags=0)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/buf/buf0buf.cc:1106
#8  0x00000000014e1e18 in page_validate (page=0x7f5f03d8c000 "", index=0x7f5ea4022cf8)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/page/page0page.cc:2658
#9  0x00000000016285c6 in btr_page_split_and_insert (flags=3, cursor=0x7f5f020fdff0, offsets=0x7f5f020fe110, heap=0x7f5f020fe118, tuple=0x7f5ea40102f8, n_ext=0, mtr=0x7f5f020fd7c0)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2927
#10 0x000000000162591d in btr_root_raise_and_insert (flags=3, cursor=0x7f5f020fdff0, offsets=0x7f5f020fe110, heap=0x7f5f020fe118, tuple=0x7f5ea40102f8, n_ext=0, mtr=0x7f5f020fd7c0)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/btr/btr0btr.cc:1793
#11 0x000000000163fa2e in btr_cur_pessimistic_insert (flags=3, cursor=0x7f5f020fdff0, offsets=0x7f5f020fe110, heap=0x7f5f020fe118, entry=0x7f5ea40102f8, rec=0x7f5f020fe108,
    big_rec=0x7f5f020fe120, n_ext=0, thr=0x7f5ea4024c20, mtr=0x7f5f020fd7c0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/btr/btr0cur.cc:3417
#12 0x000000000152c231 in row_ins_clust_index_entry_low (flags=3, mode=33, index=0x7f5ea4022cf8, n_uniq=1, entry=0x7f5ea40102f8, n_ext=0, thr=0x7f5ea4024c20, dup_chk_only=false)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/row/row0ins.cc:2475
#13 0x000000000152e340 in row_ins_clust_index_entry (index=0x7f5ea4022cf8, entry=0x7f5ea40102f8, thr=0x7f5ea4024c20, n_ext=0, dup_chk_only=false)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/row/row0ins.cc:3193
#14 0x000000000154bc03 in row_insert_for_mysql_using_cursor (mysql_rec=0x7f5ea400e980 "\377\002", prebuilt=0x7f5ea4024518)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/row/row0mysql.cc:1534
#15 0x000000000154c83f in row_insert_for_mysql (mysql_rec=0x7f5ea400e980 "\377\002", prebuilt=0x7f5ea4024518)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/row/row0mysql.cc:1784
#16 0x000000000141ada9 in ha_innobase::intrinsic_table_write_row (this=0x7f5ea401bf90, record=0x7f5ea400e980 "\377\002")
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:6546
#17 0x000000000141ae70 in ha_innobase::write_row (this=0x7f5ea401bf90, record=0x7f5ea400e980 "\377\002")
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:6570
#18 0x0000000000c4d0bd in handler::ha_write_row (this=0x7f5ea401bf90, buf=0x7f5ea400e980 "\377\002") at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/handler.cc:7441
#19 0x000000000118edbf in select_union::send_data (this=0x7f5ea401a480, values=...) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_union.cc:60
#20 0x000000000109a12e in JOIN::exec (this=0x7f5ea401b9b0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:154
#21 0x0000000001190f94 in st_select_lex_unit::execute (this=0x7f5ea40055a8, thd=0x7f5ea4000bb0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_union.cc:822
#22 0x00000000011320d1 in handle_query (thd=0x7f5ea4000bb0, lex=0x7f5ea4002a90, result=0x7f5ea40071f0, added_options=0, removed_options=0)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_select.cc:187
#23 0x00000000010e8bd7 in execute_sqlcom_select (thd=0x7f5ea4000bb0, all_tables=0x0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:4712
#24 0x00000000010e1c54 in mysql_execute_command (thd=0x7f5ea4000bb0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:2450
#25 0x00000000010e9a6f in mysql_parse (thd=0x7f5ea4000bb0, parser_state=0x7f5f021005d0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:5129
#26 0x00000000010debc8 in dispatch_command (command=COM_QUERY, thd=0x7f5ea4000bb0,
    packet=0x7f5ea4009ce1 "select 1 as a union all select 1 union all select 2 union select 1 union all select 2", packet_length=85)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:1249
#27 0x00000000010dd693 in do_command (thd=0x7f5ea4000bb0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:835
#28 0x000000000120444f in handle_connection (arg=0x3e44790) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#29 0x00000000017770f1 in pfs_spawn_thread (arg=0x3e6f660) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/perfschema/pfs.cc:2147
#30 0x00007f5f19f60df3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007f5f18c2c47d in clone () from /lib64/libc.so.6
[23 Mar 2015 5:38] MySQL Verification Team 
// 5.7.8 - only debug build is affected

bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76439 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76439 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/mysql-5.7.8/76439/log.err 2>&1 &

- build

commit: 91153f3385c4917a215aa4c7818b3f6265608286
date: 2015-03-20 14:48:27 +0100
build-date: 2015-03-20 18:03:24 +0100
short: 91153f3
branch: mysql-5.7

MySQL source 5.7.8

(gdb) bt
#0  0x00007fbe6490c771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000018c6688 in my_write_core (sig=6) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/mysys/stacktrace.c:247
#2  0x0000000000f4b39e in handle_fatal_signal (sig=6) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007fbe635125c9 in raise () from /lib64/libc.so.6
#5  0x00007fbe63513cd8 in abort () from /lib64/libc.so.6
#6  0x0000000001ae4b43 in ut_dbg_assertion_failed (expr=0x22a7d18 "flags & BUF_PAGE_PRINT_NO_CRASH",
    file=0x22a7688 "/export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/buf/buf0buf.cc", line=1106)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001b3d759 in buf_page_print (read_buf=0x7fbe4c4a8000 "", page_size=..., flags=0)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/buf/buf0buf.cc:1106
#8  0x00000000019b93f3 in page_validate (page=0x7fbe4c4a8000 "", index=0x7fbdd4011188)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/page/page0page.cc:2658
#9  0x0000000001aff791 in btr_page_split_and_insert (flags=3, cursor=0x7fbe59132720, offsets=0x7fbe59133040, heap=0x7fbe59133048, tuple=0x7fbdd400f8e8, n_ext=0, mtr=0x7fbe59132b30)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/btr/btr0btr.cc:2927
#10 0x0000000001afcb02 in btr_root_raise_and_insert (flags=3, cursor=0x7fbe59132720, offsets=0x7fbe59133040, heap=0x7fbe59133048, tuple=0x7fbdd400f8e8, n_ext=0, mtr=0x7fbe59132b30)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/btr/btr0btr.cc:1793
#11 0x0000000001b1649d in btr_cur_pessimistic_insert (flags=3, cursor=0x7fbe59132720, offsets=0x7fbe59133040, heap=0x7fbe59133048, entry=0x7fbdd400f8e8, rec=0x7fbe59133038,
    big_rec=0x7fbe59133050, n_ext=0, thr=0x7fbdd4010470, mtr=0x7fbe59132b30) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/btr/btr0cur.cc:3417
#12 0x0000000001a037df in row_ins_clust_index_entry_low (flags=3, mode=33, index=0x7fbdd4011188, n_uniq=1, entry=0x7fbdd400f8e8, n_ext=0, thr=0x7fbdd4010470, dup_chk_only=false)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/row/row0ins.cc:2475
#13 0x0000000001a05887 in row_ins_clust_index_entry (index=0x7fbdd4011188, entry=0x7fbdd400f8e8, thr=0x7fbdd4010470, n_ext=0, dup_chk_only=false)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/row/row0ins.cc:3193
#14 0x0000000001a23395 in row_insert_for_mysql_using_cursor (mysql_rec=0x7fbdd4025240 "\377\002", prebuilt=0x7fbdd400fd68)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/row/row0mysql.cc:1549
#15 0x0000000001a23f55 in row_insert_for_mysql (mysql_rec=0x7fbdd4025240 "\377\002", prebuilt=0x7fbdd400fd68)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/row/row0mysql.cc:1799
#16 0x00000000018f25ff in ha_innobase::intrinsic_table_write_row (this=0x7fbdd4024f00, record=0x7fbdd4025240 "\377\002")
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/handler/ha_innodb.cc:6642
#17 0x00000000018f26c4 in ha_innobase::write_row (this=0x7fbdd4024f00, record=0x7fbdd4025240 "\377\002")
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/handler/ha_innodb.cc:6666
#18 0x0000000000fbe01d in handler::ha_write_row (this=0x7fbdd4024f00, buf=0x7fbdd4025240 "\377\002")
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/handler.cc:7519
#19 0x000000000166abbd in Query_result_union::send_data (this=0x7fbdd4020e88, values=...) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_union.cc:60
#20 0x0000000001578e40 in JOIN::exec (this=0x7fbdd40223a8) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:155
#21 0x000000000166cceb in st_select_lex_unit::execute (this=0x7fbdd4005680, thd=0x7fbdd4000bb0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_union.cc:826
#22 0x000000000160fa05 in handle_query (thd=0x7fbdd4000bb0, lex=0x7fbdd4002b60, result=0x7fbdd4007270, added_options=0, removed_options=0)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_select.cc:190
#23 0x00000000015c68e4 in execute_sqlcom_select (thd=0x7fbdd4000bb0, all_tables=0x0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:4782
#24 0x00000000015c02ab in mysql_execute_command (thd=0x7fbdd4000bb0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:2468
#25 0x00000000015c78b1 in mysql_parse (thd=0x7fbdd4000bb0, parser_state=0x7fbe59134e50) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:5201
#26 0x00000000015bd46c in dispatch_command (thd=0x7fbdd4000bb0, com_data=0x7fbe59135e00, command=COM_QUERY)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:1280
#27 0x00000000015bc0bf in do_command (thd=0x7fbdd4000bb0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:851
#28 0x00000000016e052e in handle_connection (arg=0x591a500) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/conn_handler/connection_handler_per_thread.cc:299
#29 0x0000000001ce1375 in pfs_spawn_thread (arg=0x5821c30) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/perfschema/pfs.cc:2147
#30 0x00007fbe64907df3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007fbe635d347d in clone () from /lib64/libc.so.6
(gdb)
[23 Mar 2015 5:40] MySQL Verification Team 
// 5.8.0 - only debug build affected

bin/mysql_install_db --basedir=/export/umesh/mysql-5.8.0 --datadir=/export/umesh/mysql-5.8.0/76439 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.8.0 --datadir=/export/umesh/mysql-5.8.0/76439 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/mysql-5.8.0/76439/log.err 2>&1 &
more ~umshastr/.mysql_secret 

- build

commit: b48798db34fbcaf5dbb5c8ae7ef738afeb60eccc
date: 2015-03-20 14:52:33 +0100
build-date: 2015-03-20 17:03:10 +0100
short: b48798d
branch: mysql-trunk

MySQL source 5.8.0

(gdb) bt
#0  0x00007fa8c0956771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000018b3108 in my_write_core (sig=6) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/mysys/stacktrace.c:247
#2  0x0000000000f3d9fb in handle_fatal_signal (sig=6) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/signal_handler.cc:221
#3  <signal handler called>
#4  0x00007fa8bf55c5c9 in raise () from /lib64/libc.so.6
#5  0x00007fa8bf55dcd8 in abort () from /lib64/libc.so.6
#6  0x0000000001af2303 in ut_dbg_assertion_failed (expr=0x2295488 "flags & BUF_PAGE_PRINT_NO_CRASH",
    file=0x2294df8 "/export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/buf/buf0buf.cc", line=1106)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001b4af75 in buf_page_print (read_buf=0x7fa8a84a8000 "", page_size=..., flags=0)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/buf/buf0buf.cc:1106
#8  0x00000000019c77f7 in page_validate (page=0x7fa8a84a8000 "", index=0x7fa834010f28)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/page/page0page.cc:2658
#9  0x0000000001b0cfad in btr_page_split_and_insert (flags=3, cursor=0x7fa8b517c720, offsets=0x7fa8b517d040, heap=0x7fa8b517d048, tuple=0x7fa834011cf8, n_ext=0, mtr=0x7fa8b517cb30)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/btr/btr0btr.cc:2927
#10 0x0000000001b0a31e in btr_root_raise_and_insert (flags=3, cursor=0x7fa8b517c720, offsets=0x7fa8b517d040, heap=0x7fa8b517d048, tuple=0x7fa834011cf8, n_ext=0, mtr=0x7fa8b517cb30)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/btr/btr0btr.cc:1793
#11 0x0000000001b23cb9 in btr_cur_pessimistic_insert (flags=3, cursor=0x7fa8b517c720, offsets=0x7fa8b517d040, heap=0x7fa8b517d048, entry=0x7fa834011cf8, rec=0x7fa8b517d038,
    big_rec=0x7fa8b517d050, n_ext=0, thr=0x7fa83400fdf0, mtr=0x7fa8b517cb30) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/btr/btr0cur.cc:3417
#12 0x0000000001a11be3 in row_ins_clust_index_entry_low (flags=3, mode=33, index=0x7fa834010f28, n_uniq=1, entry=0x7fa834011cf8, n_ext=0, thr=0x7fa83400fdf0, dup_chk_only=false)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc:2475
#13 0x0000000001a13c8b in row_ins_clust_index_entry (index=0x7fa834010f28, entry=0x7fa834011cf8, thr=0x7fa83400fdf0, n_ext=0, dup_chk_only=false)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc:3193
#14 0x0000000001a3174a in row_insert_for_mysql_using_cursor (mysql_rec=0x7fa834025140 "\377\002", prebuilt=0x7fa83400f6e8)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0mysql.cc:1549
#15 0x0000000001a3230a in row_insert_for_mysql (mysql_rec=0x7fa834025140 "\377\002", prebuilt=0x7fa83400f6e8)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0mysql.cc:1799
#16 0x00000000019018db in ha_innobase::intrinsic_table_write_row (this=0x7fa834024e00, record=0x7fa834025140 "\377\002")
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:6509
#17 0x00000000019019a0 in ha_innobase::write_row (this=0x7fa834024e00, record=0x7fa834025140 "\377\002")
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:6533
#18 0x0000000000fb309f in handler::ha_write_row (this=0x7fa834024e00, buf=0x7fa834025140 "\377\002")
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/handler.cc:7521
#19 0x0000000001654b89 in Query_result_union::send_data (this=0x7fa834020e88, values=...) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_union.cc:62
#20 0x000000000156297c in JOIN::exec (this=0x7fa8340223a8) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:160
#21 0x0000000001656cc7 in st_select_lex_unit::execute (this=0x7fa834005680, thd=0x7fa834000bb0)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_union.cc:828
#22 0x00000000015f89f1 in handle_query (thd=0x7fa834000bb0, lex=0x7fa834002b60, result=0x7fa834007270, added_options=0, removed_options=0)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_select.cc:194
#23 0x00000000015afa50 in execute_sqlcom_select (thd=0x7fa834000bb0, all_tables=0x0) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:4736
#24 0x00000000015a94e4 in mysql_execute_command (thd=0x7fa834000bb0) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:2437
#25 0x00000000015b0a1d in mysql_parse (thd=0x7fa834000bb0, parser_state=0x7fa8b517ee50) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:5158
#26 0x00000000015a66e6 in dispatch_command (thd=0x7fa834000bb0, com_data=0x7fa8b517fe00, command=COM_QUERY)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:1245
#27 0x00000000015a5335 in do_command (thd=0x7fa834000bb0) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:814
#28 0x00000000016ca436 in handle_connection (arg=0x471a080) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/conn_handler/connection_handler_per_thread.cc:300
#29 0x0000000001c59c8d in pfs_spawn_thread (arg=0x46248d0) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/perfschema/pfs.cc:2147
#30 0x00007fa8c0951df3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007fa8bf61d47d in clone () from /lib64/libc.so.6
(gdb)
[23 Mar 2015 5:42] MySQL Verification Team 
// 5.6.25 latest builds not affected
[8 Apr 2015 19:26] Daniel Price 
Posted by developer:
 
Fixed as of the upcoming 5.7.8, 5.8.0 releases, and here's the changelog entry:

Queries that use both "UNION" and "UNION ALL" and disable the index would
cause an assertion due to duplicate B-tree values. 

Thank you for the bug report.
[18 Jun 2016 21:25] Omer Barnir 
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0