Bug #78494 InnoDB: Failing assertion: !(&buf_pool->mutex)->is_owned() buf0buf.cc line 3388
Submitted: 21 Sep 2015 4:44 Modified: 24 Sep 2015 13:25
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Information schema Severity:S6 (Debug Builds)
Version:5.7.8 (RC2), 5.7.10, 8.0.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: debug

[21 Sep 2015 4:44] Roel Van de Paar
Description:
2015-09-21T04:31:04.336235Z 0 [Note] /sda/mysql-5.7.8-rc-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.8-rc-debug'  socket: '/sda/mysql-5.7.8-rc-linux-x86_64-debug/socket.sock'  port: 16775  MySQL Community Server (GPL)
2015-09-21 14:31:08 0x7f9467269700  InnoDB: Assertion failure in thread 140275362469632 in file buf0buf.cc line 3388
InnoDB: Failing assertion: !(&buf_pool->mutex)->is_owned()

Thread 1 (Thread 0x7fce43f11700 (LWP 30432)):
+bt
#0  0x00007fce43958771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000001721318 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.c:247
#2  0x0000000000dd6008 in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007fce4255c5d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007fce4255dcc8 in __GI_abort () at abort.c:90
#6  0x0000000001a6f71b in ut_dbg_assertion_failed (expr=0x204af90 "!(&buf_pool->mutex)->is_owned()", file=0x204b610 "/git/mysql-server_dbg/storage/innobase/buf/buf0buf.cc", line=3388) at /git/mysql-server_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001ad0383 in buf_page_make_young_if_needed (bpage=0x7fce175de8e0) at /git/mysql-server_dbg/storage/innobase/buf/buf0buf.cc:3388
#8  0x0000000001ad2f25 in buf_page_get_gen (page_id=..., page_size=..., rw_latch=8, guess=0x0, mode=10, file=0x20028c8 "/git/mysql-server_dbg/storage/innobase/row/row0ins.cc", line=2590, mtr=0x7fce06145cb0, dirty_with_no_latch=true) at /git/mysql-server_dbg/storage/innobase/buf/buf0buf.cc:4550
#9  0x0000000001a9dce9 in btr_cur_search_to_nth_level_with_no_latch (index=0x7fce0606fca0, level=0, tuple=0x7fce0606f9a0, mode=PAGE_CUR_LE, cursor=0x7fce43f0e0a0, file=0x20028c8 "/git/mysql-server_dbg/storage/innobase/row/row0ins.cc", line=2590, mtr=0x7fce06145cb0, mark_dirty=true) at /git/mysql-server_dbg/storage/innobase/btr/btr0cur.cc:2059
#10 0x0000000001978432 in row_ins_sorted_clust_index_entry (mode=2, index=0x7fce0606fca0, entry=0x7fce0606f9a0, n_ext=0, thr=0x7fce060ba960) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:2590
#11 0x0000000001979f35 in row_ins_clust_index_entry (index=0x7fce0606fca0, entry=0x7fce0606f9a0, thr=0x7fce060ba960, n_ext=0, dup_chk_only=false) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3181
#12 0x0000000001998440 in row_insert_for_mysql_using_cursor (mysql_rec=0x7fce0605a710 "\377", prebuilt=0x7fce060ba0a0) at /git/mysql-server_dbg/storage/innobase/row/row0mysql.cc:1571
#13 0x0000000001998fd7 in row_insert_for_mysql (mysql_rec=0x7fce0605a710 "\377", prebuilt=0x7fce060ba0a0) at /git/mysql-server_dbg/storage/innobase/row/row0mysql.cc:1829
#14 0x00000000018549eb in ha_innobase::intrinsic_table_write_row (this=0x7fce0605a430, record=0x7fce0605a710 "\377") at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:6907
#15 0x0000000001854ab0 in ha_innobase::write_row (this=0x7fce0605a430, record=0x7fce0605a710 "\377") at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:6931
#16 0x0000000000e4827b in handler::ha_write_row (this=0x7fce0605a430, buf=0x7fce0605a710 "\377") at /git/mysql-server_dbg/sql/handler.cc:7599
#17 0x0000000001484063 in schema_table_store_record (thd=0x7fce0601a000, table=0x7fce06068030) at /git/mysql-server_dbg/sql/sql_show.cc:3015
#18 0x00000000018a32d1 in i_s_cmpmem_fill_low (thd=0x7fce0601a000, tables=0x7fce0602cd00, reset=1) at /git/mysql-server_dbg/storage/innobase/handler/i_s.cc:2127
#19 0x00000000018a33cc in i_s_cmpmem_reset_fill (thd=0x7fce0601a000, tables=0x7fce0602cd00, cond=0x0) at /git/mysql-server_dbg/storage/innobase/handler/i_s.cc:2168
#20 0x00000000014954d9 in do_fill_table (thd=0x7fce0601a000, table_list=0x7fce0602cd00, qep_tab=0x7fce060bcc20) at /git/mysql-server_dbg/sql/sql_show.cc:7834
#21 0x00000000014958be in get_schema_tables_result (join=0x7fce060bc540, executed_place=PROCESSED_BY_JOIN_EXEC) at /git/mysql-server_dbg/sql/sql_show.cc:7936
#22 0x000000000146e923 in JOIN::prepare_result (this=0x7fce060bc540) at /git/mysql-server_dbg/sql/sql_select.cc:912
#23 0x00000000013d6704 in JOIN::exec (this=0x7fce060bc540) at /git/mysql-server_dbg/sql/sql_executor.cc:125
#24 0x000000000146d4e2 in handle_query (thd=0x7fce0601a000, lex=0x7fce0601c210, result=0x7fce0602db38, added_options=0, removed_options=0) at /git/mysql-server_dbg/sql/sql_select.cc:184
#25 0x0000000001424906 in execute_sqlcom_select (thd=0x7fce0601a000, all_tables=0x7fce0602cd00) at /git/mysql-server_dbg/sql/sql_parse.cc:4843
#26 0x000000000141e332 in mysql_execute_command (thd=0x7fce0601a000) at /git/mysql-server_dbg/sql/sql_parse.cc:2521
#27 0x000000000142584f in mysql_parse (thd=0x7fce0601a000, parser_state=0x7fce43f10680) at /git/mysql-server_dbg/sql/sql_parse.cc:5255
#28 0x000000000141b458 in dispatch_command (thd=0x7fce0601a000, com_data=0x7fce43f10dc0, command=COM_QUERY) at /git/mysql-server_dbg/sql/sql_parse.cc:1272
#29 0x000000000141a10e in do_command (thd=0x7fce0601a000) at /git/mysql-server_dbg/sql/sql_parse.cc:852
#30 0x0000000001541c80 in handle_connection (arg=0x7fce327ff260) at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:300
#31 0x000000000174e31f in pfs_spawn_thread (arg=0x7fce397e8e20) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2178
#32 0x00007fce43953df5 in start_thread (arg=0x7fce43f11700) at pthread_create.c:308
#33 0x00007fce4261d1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
mysql> source 1442805024.sql

Must be SOURCEd. Direct CLI execution does not reproduce. Also attached full bug bundle. See 1442805024_how_to_use.txt for how to use.
[21 Sep 2015 4:48] Roel Van de Paar
SQL input file - SOURCE it

Attachment: 1442805024.sql (application/octet-stream, text), 124 bytes.

[21 Sep 2015 4:49] Roel Van de Paar
Bug bundle, if needed at all. See howto file for instructions.

Attachment: 1442805024_bug_bundle.tar.gz (application/x-gzip, text), 998.96 KiB.

[21 Sep 2015 6:58] MySQL Verification Team
Hello Roel,

Thank you for the report and test case.
Observed that only 5.7(confirmed with 5.7.8 and 5.7.10) debug builds are affected.

Thanks,
Umesh
[21 Sep 2015 6:59] MySQL Verification Team
// 5.7.10 - only debug build is affected
-- Build used

[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.10: cat docs/INFO_SRC
commit: 4656cd8ee54eda79638017581aa419a2d898f2d0
date: 2015-09-21 09:11:03 +0530
build-date: 2015-09-21 06:03:26 +0200
short: 4656cd8
branch: mysql-5.7

MySQL source 5.7.10

[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.10: bin/mysqld --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.10 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.10/78494 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.7.10/78494/log.err 2>&1 &
[1] 10019
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.10: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.10-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> source /tmp/78494.sql;
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.00 sec)

+-----------+----------------------+------------+------------+----------------+-----------------+
| page_size | buffer_pool_instance | pages_used | pages_free | relocation_ops | relocation_time |
+-----------+----------------------+------------+------------+----------------+-----------------+
|      1024 |                    0 |          0 |          0 |              0 |               0 |
|      2048 |                    0 |          0 |          0 |              0 |               0 |
|      4096 |                    0 |          0 |          0 |              0 |               0 |
|      8192 |                    0 |          0 |          0 |              0 |               0 |
|     16384 |                    0 |          0 |          0 |              0 |               0 |
+-----------+----------------------+------------+------------+----------------+-----------------+
5 rows in set (0.00 sec)

mysql> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.10: bin/mysqladmin  -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.10 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.10/78494 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.7.10/78494/log.err 2>&1
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.10:
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.10: bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.10 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.10/78494 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.7.10/78494/log.err 2>&1 &
[1] 10054
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.10: bin/mysql -uroot -S /tmp/mysql_ushastry.sock                                                                                 Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.10-enterprise-commercial-advanced-debug MySQL Enterprise Server - Advanced Edition Debug (Commercial)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> source /tmp/78494.sql;
Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.00 sec)

ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
[21 Sep 2015 7:00] MySQL Verification Team
// 5.7.10

(gdb) bt
#0  0x00007f41fdcda771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x000000000177358d in my_write_core (sig=6) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/mysys/stacktrace.c:247
#2  0x0000000000d794e4 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f41fc8e05c9 in raise () from /lib64/libc.so.6
#5  0x00007f41fc8e1cd8 in abort () from /lib64/libc.so.6
#6  0x00000000019f1463 in ut_dbg_assertion_failed (expr=0x2256d78 "!(&buf_pool->mutex)->is_owned()",
    file=0x2257518 "/export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/buf/buf0buf.cc", line=3472)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001a54003 in buf_page_make_young_if_needed (bpage=0x7f41d1941790) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/buf/buf0buf.cc:3472
#8  0x0000000001a56d39 in buf_page_get_gen (page_id=..., page_size=..., rw_latch=8, guess=0x0, mode=10,
    file=0x2205ac0 "/export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/row/row0ins.cc", line=2561, mtr=0x7f418401bea0, dirty_with_no_latch=true)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/buf/buf0buf.cc:4634
#9  0x0000000001a20e03 in btr_cur_search_to_nth_level_with_no_latch (index=0x7f4184010a20, level=0, tuple=0x7f4184026130, mode=PAGE_CUR_LE, cursor=0x7f41d0662d00,
    file=0x2205ac0 "/export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/row/row0ins.cc", line=2561, mtr=0x7f418401bea0, mark_dirty=true)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/btr/btr0cur.cc:2059
#10 0x00000000018ee307 in row_ins_sorted_clust_index_entry (mode=2, index=0x7f4184010a20, entry=0x7f4184026130, n_ext=0, thr=0x7f418401ad30)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/row/row0ins.cc:2561
#11 0x00000000018efec2 in row_ins_clust_index_entry (index=0x7f4184010a20, entry=0x7f4184026130, thr=0x7f418401ad30, n_ext=0, dup_chk_only=false)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/row/row0ins.cc:3154
#12 0x000000000190f17f in row_insert_for_mysql_using_cursor (mysql_rec=0x7f418403edd0 "\377", prebuilt=0x7f418401a470)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/row/row0mysql.cc:1570
#13 0x000000000190fd66 in row_insert_for_mysql (mysql_rec=0x7f418403edd0 "\377", prebuilt=0x7f418401a470)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/row/row0mysql.cc:1828
#14 0x00000000017c3aff in ha_innobase::intrinsic_table_write_row (this=0x7f418403eae0, record=0x7f418403edd0 "\377")
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/handler/ha_innodb.cc:7047
#15 0x00000000017c3bc6 in ha_innobase::write_row (this=0x7f418403eae0, record=0x7f418403edd0 "\377")
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/handler/ha_innodb.cc:7071
#16 0x0000000000dff82b in handler::ha_write_row (this=0x7f418403eae0, buf=0x7f418403edd0 "\377") at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/handler.cc:7764
#17 0x00000000014a86e4 in schema_table_store_record (thd=0x7f4184000b70, table=0x7f418400ee10) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_show.cc:3092
#18 0x0000000001815adf in i_s_cmpmem_fill_low (thd=0x7f4184000b70, tables=0x7f4184006250, reset=1)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/handler/i_s.cc:2123
#19 0x0000000001815bfa in i_s_cmpmem_reset_fill (thd=0x7f4184000b70, tables=0x7f4184006250, cond=0x0)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/innobase/handler/i_s.cc:2164
#20 0x00000000014ba748 in do_fill_table (thd=0x7f4184000b70, table_list=0x7f4184006250, qep_tab=0x7f4184024850)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_show.cc:7970
#21 0x00000000014bab38 in get_schema_tables_result (join=0x7f4184024170, executed_place=PROCESSED_BY_JOIN_EXEC)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_show.cc:8072
#22 0x0000000001492081 in JOIN::prepare_result (this=0x7f4184024170) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_select.cc:908
#23 0x00000000013f2679 in JOIN::exec (this=0x7f4184024170) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_executor.cc:124
#24 0x0000000001490c3e in handle_query (thd=0x7f4184000b70, lex=0x7f4184002cd0, result=0x7f4184007088, added_options=0, removed_options=0)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_select.cc:184
#25 0x0000000001445c4a in execute_sqlcom_select (thd=0x7f4184000b70, all_tables=0x7f4184006250) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_parse.cc:4947
#26 0x000000000143e8e2 in mysql_execute_command (thd=0x7f4184000b70, first_level=true) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_parse.cc:2597
#27 0x0000000001446aa1 in mysql_parse (thd=0x7f4184000b70, parser_state=0x7f41d06656a0) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_parse.cc:5357
#28 0x000000000143b6a3 in dispatch_command (thd=0x7f4184000b70, com_data=0x7f41d0665e10, command=COM_QUERY)
    at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_parse.cc:1284
#29 0x000000000143a560 in do_command (thd=0x7f4184000b70) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/sql_parse.cc:852
#30 0x000000000156f6a9 in handle_connection (arg=0x56d5a80) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/sql/conn_handler/connection_handler_per_thread.cc:294
#31 0x0000000001b8146c in pfs_spawn_thread (arg=0x582b3d0) at /export/home/pb2/build/sb_0-16527764-1442809445.14/mysqlcom-pro-5.7.10/storage/perfschema/pfs.cc:2191
#32 0x00007f41fdcd5df3 in start_thread () from /lib64/libpthread.so.0
#33 0x00007f41fc9a147d in clone () from /lib64/libc.so.6
(gdb)
[21 Sep 2015 7:33] MySQL Verification Team
// 5.8.0 - only debug build affected

[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.8.0: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.8.0-m17-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> source /tmp/78494.sql;
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.00 sec)

+-----------+----------------------+------------+------------+----------------+-----------------+
| page_size | buffer_pool_instance | pages_used | pages_free | relocation_ops | relocation_time |
+-----------+----------------------+------------+------------+----------------+-----------------+
|      1024 |                    0 |          0 |          0 |              0 |               0 |
|      2048 |                    0 |          0 |          0 |              0 |               0 |
|      4096 |                    0 |          0 |          0 |              0 |               0 |
|      8192 |                    0 |          0 |          0 |              0 |               0 |
|     16384 |                    0 |          0 |          0 |              0 |               0 |
+-----------+----------------------+------------+------------+----------------+-----------------+
5 rows in set (0.00 sec)

mysql> source /tmp/78494.sql;
Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.00 sec)

+-----------+----------------------+------------+------------+----------------+-----------------+
| page_size | buffer_pool_instance | pages_used | pages_free | relocation_ops | relocation_time |
+-----------+----------------------+------------+------------+----------------+-----------------+
|      1024 |                    0 |          0 |          0 |              0 |               0 |
|      2048 |                    0 |          0 |          0 |              0 |               0 |
|      4096 |                    0 |          0 |          0 |              0 |               0 |
|      8192 |                    0 |          0 |          0 |              0 |               0 |
|     16384 |                    0 |          0 |          0 |              0 |               0 |
+-----------+----------------------+------------+------------+----------------+-----------------+
5 rows in set (0.00 sec)

mysql> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.8.0: bin/mysqladmin  -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.8.0 --datadir=/export/umesh/server/binaries/mysql-advanced-5.8.0/78494 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.8.0/78494/log.err 2>&1
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.8.0:
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.8.0: bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.8.0 --datadir=/export/umesh/server/binaries/mysql-advanced-5.8.0/78494 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.8.0/78494/log.err 2>&1 &
[1] 12677
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.8.0: bin/mysql -uroot -S /tmp/mysql_ushastry.sock                                                                                  Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.8.0-m17-enterprise-commercial-advanced-debug MySQL Enterprise Server - Advanced Edition Debug (Commercial)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> source /tmp/78494.sql;
Query OK, 0 rows affected (0.01 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.00 sec)

ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
[21 Sep 2015 7:34] MySQL Verification Team
//
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.8.0: cat docs/INFO_SRC
commit: 346ccb59d223cc2692591b3f7bcc2d4089793de7
date: 2015-09-21 09:12:08 +0530
build-date: 2015-09-21 05:58:21 +0200
short: 346ccb5
branch: mysql-trunk

MySQL source 5.8.0

(gdb) bt
#0  0x00007f4c01193771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x000000000182b565 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/mysys/stacktrace.c:251
#2  0x000000000103fd05 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/signal_handler.cc:221
#3  <signal handler called>
#4  0x00007f4bffd995c9 in raise () from /lib64/libc.so.6
#5  0x00007f4bffd9acd8 in abort () from /lib64/libc.so.6
#6  0x0000000001a8cb97 in ut_dbg_assertion_failed (expr=0x2227280 "!(&buf_pool->mutex)->is_owned()",
    file=0x2227d50 "/export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/buf/buf0buf.cc", line=2938)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001aeecee in buf_page_make_young_if_needed (bpage=0x7f4bd4df3e18) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/buf/buf0buf.cc:2938
#8  0x0000000001af19e3 in buf_page_get_gen (page_id=..., page_size=..., rw_latch=8, guess=0x0, mode=10,
    file=0x21d5158 "/export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc", line=2637, mtr=0x7f4b8401bcd0, dirty_with_no_latch=true)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/buf/buf0buf.cc:4077
#9  0x0000000001abbe0f in btr_cur_search_to_nth_level_with_no_latch (index=0x7f4b8401b350, level=0, tuple=0x7f4b8401cfa0, mode=PAGE_CUR_LE, cursor=0x7f4bd3b15d10,
    file=0x21d5158 "/export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc", line=2637, mtr=0x7f4b8401bcd0, mark_dirty=true)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/btr/btr0cur.cc:2059
#10 0x0000000001990941 in row_ins_sorted_clust_index_entry (mode=2, index=0x7f4b8401b350, entry=0x7f4b8401cfa0, n_ext=0, thr=0x7f4b8402c9f0)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc:2637
#11 0x0000000001992192 in row_ins_clust_index_entry (index=0x7f4b8401b350, entry=0x7f4b8401cfa0, thr=0x7f4b8402c9f0, n_ext=0, dup_chk_only=false)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc:3174
#12 0x00000000019b07ed in row_insert_for_mysql_using_cursor (mysql_rec=0x7f4b8404d588 "\377", prebuilt=0x7f4b8402c130)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0mysql.cc:1558
#13 0x00000000019b13c8 in row_insert_for_mysql (mysql_rec=0x7f4b8404d588 "\377", prebuilt=0x7f4b8402c130)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0mysql.cc:1816
#14 0x000000000186644d in ha_innobase::intrinsic_table_write_row (this=0x7f4b8404d2a0, record=0x7f4b8404d588 "\377")
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:7119
#15 0x0000000001866514 in ha_innobase::write_row (this=0x7f4b8404d2a0, record=0x7f4b8404d588 "\377")
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:7143
#16 0x00000000011227fb in handler::ha_write_row (this=0x7f4b8404d2a0, buf=0x7f4b8404d588 "\377") at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/handler.cc:7752
#17 0x0000000000f6b173 in schema_table_store_record (thd=0x7f4b84000b70, table=0x7f4b8404c0a0) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_show.cc:3202
#18 0x00000000018b72dc in i_s_cmpmem_fill_low (thd=0x7f4b84000b70, tables=0x7f4b840063f0, reset=1)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/i_s.cc:2104
#19 0x00000000018b73f7 in i_s_cmpmem_reset_fill (thd=0x7f4b84000b70, tables=0x7f4b840063f0, cond=0x0)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/i_s.cc:2145
#20 0x0000000000f7d1c4 in do_fill_table (thd=0x7f4b84000b70, table_list=0x7f4b840063f0, qep_tab=0x7f4b8402dde0)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_show.cc:8064
#21 0x0000000000f7d5b4 in get_schema_tables_result (join=0x7f4b8402d700, executed_place=PROCESSED_BY_JOIN_EXEC)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_show.cc:8166
#22 0x0000000000f5367f in JOIN::prepare_result (this=0x7f4b8402d700) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_select.cc:923
#23 0x0000000000ee1e9f in JOIN::exec (this=0x7f4b8402d700) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_executor.cc:139
#24 0x0000000000f52252 in handle_query (thd=0x7f4b84000b70, lex=0x7f4b84002e70, result=0x7f4b84007228, added_options=0, removed_options=0)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_select.cc:190
#25 0x0000000000f14086 in execute_sqlcom_select (thd=0x7f4b84000b70, all_tables=0x7f4b840063f0)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:4899
#26 0x0000000000f0cf20 in mysql_execute_command (thd=0x7f4b84000b70, first_level=true) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:2564
#27 0x0000000000f14eb2 in mysql_parse (thd=0x7f4b84000b70, parser_state=0x7f4bd3b186a0) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:5305
#28 0x0000000000f09d32 in dispatch_command (thd=0x7f4b84000b70, com_data=0x7f4bd3b18e10, command=COM_QUERY)
    at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:1251
#29 0x0000000000f08bf8 in do_command (thd=0x7f4b84000b70) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:819
#30 0x000000000102f987 in handle_connection (arg=0x4309040) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/sql/conn_handler/connection_handler_per_thread.cc:295
#31 0x0000000001c0d273 in pfs_spawn_thread (arg=0x4342550) at /export/home/pb2/build/sb_0-16527734-1442808832.67/mysqlcom-pro-5.8.0-m17/storage/perfschema/pfs.cc:2210
#32 0x00007f4c0118edf3 in start_thread () from /lib64/libpthread.so.0
#33 0x00007f4bffe5a47d in clone () from /lib64/libc.so.6
(gdb)
[24 Sep 2015 13:25] Daniel Price
Posted by developer:
 
Fixed as of the upcoming 5.7.10, 5.8.0 release, and here's the changelog entry:

Selecting from INNODB_CMPMEM with option big-tables=1 raised a buffer
pool mutex assertion. 

Thank you for the bug report.
[10 Dec 2015 7:24] Erlend Dahl
Bug#79391 InnoDB: Failing assertion: !is_owned() in file sync0policy.ic line 63

was marked as a duplicate.
[18 Jun 2016 21:27] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0