LP #1519201: InnoDB: Failing assertion: !mutex_own(&buf_pool->zip_free_mutex) in file buf0buf.ic line 230

**Reported in Launchpad by Roel Van de Paar last update 30-03-2016 11:31:43

2015-11-24T04:52:16.268717Z 0 [Note] /sda/PS-mysql-5.7.9-90.0-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.9-90.0-debug' socket: '/sda/PS-mysql-5.7.9-90.0-linux-x86_64-debug/socket.sock' port: 19303 MySQL Community Server (GPL)
2015-11-24 15:52:21 0x7f717bf45700 InnoDB: Assertion failure in thread 140125387642624 in file buf0buf.ic line 230
InnoDB: Failing assertion: !mutex_own(&buf_pool->zip_free_mutex)

Program terminated with signal 6, Aborted.
#0 0x00007f717b94b771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
Missing separate debuginfos, use: debuginfo-install libaio-0.3.109-12.el7.x86_64 libgcc-4.8.3-9.el7.x86_64 libstdc++-4.8.3-9.el7.x86_64 nss-softokn-freebl-3.16.2.3-9.el7.x86_64
(gdb) bt
+bt
#0 0x00007f717b94b771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x00000000017b8e24 in my_write_core (sig=6) at /git/PS-5.7-Beta_dbg/mysys/stacktrace.c:247
#2 0x0000000000e2663f in handle_fatal_signal (sig=6) at /git/PS-5.7-Beta_dbg/sql/signal_handler.cc:223
#3 <signal handler called>
#4 0x00007f717a54f5d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007f717a550cc8 in __GI_abort () at abort.c:90
#6 0x0000000001b230ef in ut_dbg_assertion_failed (expr=0x21f11b8 "!mutex_own(&buf_pool->zip_free_mutex)", file=0x21f10a8 "/git/PS-5.7-Beta_dbg/storage/innobase/include/buf0buf.ic", line=230) at /git/PS-5.7-Beta_dbg/storage/innobase/ut/ut0dbg.cc:67
#7 0x0000000001ba5bb6 in buf_page_is_private (bpage=0x7f70d2da5940) at /git/PS-5.7-Beta_dbg/storage/innobase/include/buf0buf.ic:230
#8 0x0000000001ba5d96 in buf_page_set_state (bpage=0x7f70d2da5940, state=BUF_BLOCK_READY_FOR_USE) at /git/PS-5.7-Beta_dbg/storage/innobase/include/buf0buf.ic:264
#9 0x0000000001ba60f1 in buf_block_set_state (block=0x7f70d2da5940, state=BUF_BLOCK_READY_FOR_USE) at /git/PS-5.7-Beta_dbg/storage/innobase/include/buf0buf.ic:307
#10 0x0000000001ba90a4 in buf_LRU_get_free_only (buf_pool=0x7f71757f58c0) at /git/PS-5.7-Beta_dbg/storage/innobase/buf/buf0lru.cc:1236
#11 0x0000000001ba95ba in buf_LRU_get_free_block (buf_pool=0x7f71757f58c0) at /git/PS-5.7-Beta_dbg/storage/innobase/buf/buf0lru.cc:1380
#12 0x0000000001b88dc1 in buf_page_init_for_read (err=0x7f717bf41ac4, mode=132, page_id=..., page_size=..., unzip=0) at /git/PS-5.7-Beta_dbg/storage/innobase/buf/buf0buf.cc:5276
#13 0x0000000001bafcfc in buf_read_page_low (err=0x7f717bf41ac4, sync=false, type=192, mode=132, page_id=..., page_size=..., unzip=false, trx=0x0) at /git/PS-5.7-Beta_dbg/storage/innobase/buf/buf0rea.cc:152
#14 0x0000000001bb0a51 in buf_read_page_background (page_id=..., page_size=..., sync=false) at /git/PS-5.7-Beta_dbg/storage/innobase/buf/buf0rea.cc:502
#15 0x0000000001b541f5 in btr_cur_prefetch_siblings (block=0x7f70d2da42f0) at /git/PS-5.7-Beta_dbg/storage/innobase/btr/btr0cur.cc:3077
#16 0x0000000001b546d3 in btr_cur_optimistic_insert (flags=3, cursor=0x7f717bf41f90, offsets=0x7f717bf42368, heap=0x7f717bf42370, entry=0x7f70af8799a0, rec=0x7f717bf42360, big_rec=0x7f717bf42358, n_ext=0, thr=0x7f70af89d960, mtr=0x7f70af93fcb0) at /git/PS-5.7-Beta_dbg/storage/innobase/btr/btr0cur.cc:3238
#17 0x0000000001a250de in row_ins_sorted_clust_index_entry (mode=2, index=0x7f70af891a20, entry=0x7f70af8799a0, n_ext=0, thr=0x7f70af89d960) at /git/PS-5.7-Beta_dbg/storage/innobase/row/row0ins.cc:2593
#18 0x0000000001a26abd in row_ins_clust_index_entry (index=0x7f70af891a20, entry=0x7f70af8799a0, thr=0x7f70af89d960, n_ext=0, dup_chk_only=false) at /git/PS-5.7-Beta_dbg/storage/innobase/row/row0ins.cc:3161
#19 0x0000000001a462e9 in row_insert_for_mysql_using_cursor (mysql_rec=0x7f70af8a9c30 "\377", prebuilt=0x7f70af89d0a0) at /git/PS-5.7-Beta_dbg/storage/innobase/row/row0mysql.cc:1572
#20 0x0000000001a46e80 in row_insert_for_mysql (mysql_rec=0x7f70af8a9c30 "\377", prebuilt=0x7f70af89d0a0) at /git/PS-5.7-Beta_dbg/storage/innobase/row/row0mysql.cc:1830
#21 0x00000000018f144f in ha_innobase::intrinsic_table_write_row (this=0x7f70af8ebc30, record=0x7f70af8a9c30 "\377") at /git/PS-5.7-Beta_dbg/storage/innobase/handler/ha_innodb.cc:7415
#22 0x00000000018f1514 in ha_innobase::write_row (this=0x7f70af8ebc30, record=0x7f70af8a9c30 "\377") at /git/PS-5.7-Beta_dbg/storage/innobase/handler/ha_innodb.cc:7439
#23 0x0000000000eb84f4 in handler::ha_write_row (this=0x7f70af8ebc30, buf=0x7f70af8a9c30 "\377") at /git/PS-5.7-Beta_dbg/sql/handler.cc:8091
#24 0x000000000151afba in schema_table_store_record (thd=0x7f70af819000, table=0x7f70af886030) at /git/PS-5.7-Beta_dbg/sql/sql_show.cc:3404
#25 0x0000000001945a78 in i_s_cmpmem_fill_low (thd=0x7f70af819000, tables=0x7f70af82bd00, reset=1) at /git/PS-5.7-Beta_dbg/storage/innobase/handler/i_s.cc:2133
#26 0x0000000001945b48 in i_s_cmpmem_reset_fill (thd=0x7f70af819000, tables=0x7f70af82bd00, cond=0x0) at /git/PS-5.7-Beta_dbg/storage/innobase/handler/i_s.cc:2174
#27 0x000000000152d1a3 in do_fill_table (thd=0x7f70af819000, table_list=0x7f70af82bd00, qep_tab=0x7f70af89fc20) at /git/PS-5.7-Beta_dbg/sql/sql_show.cc:8553
#28 0x000000000152d588 in get_schema_tables_result (join=0x7f70af89f540, executed_place=PROCESSED_BY_JOIN_EXEC) at /git/PS-5.7-Beta_dbg/sql/sql_show.cc:8655
#29 0x0000000001503a05 in JOIN::prepare_result (this=0x7f70af89f540) at /git/PS-5.7-Beta_dbg/sql/sql_select.cc:909
#30 0x0000000001467344 in JOIN::exec (this=0x7f70af89f540) at /git/PS-5.7-Beta_dbg/sql/sql_executor.cc:124
#31 0x00000000015025da in handle_query (thd=0x7f70af819000, lex=0x7f70af81b5d8, result=0x7f70af82cb38, added_options=0, removed_options=0) at /git/PS-5.7-Beta_dbg/sql/sql_select.cc:184
#32 0x00000000014b72cd in execute_sqlcom_select (thd=0x7f70af819000, all_tables=0x7f70af82bd00) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:5226
#33 0x00000000014b048c in mysql_execute_command (thd=0x7f70af819000, first_level=true) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:2718
#34 0x00000000014b8284 in mysql_parse (thd=0x7f70af819000, parser_state=0x7f717bf44610) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:5665
#35 0x00000000014ad12c in dispatch_command (thd=0x7f70af819000, com_data=0x7f717bf44db0, command=COM_QUERY) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:1304
#36 0x00000000014ac048 in do_command (thd=0x7f70af819000) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:867
#37 0x00000000015e2a1b in handle_connection (arg=0x7f70c9bbe280) at /git/PS-5.7-Beta_dbg/sql/conn_handler/connection_handler_per_thread.cc:298
#38 0x00000000017e8208 in pfs_spawn_thread (arg=0x7f70c9aa9820) at /git/PS-5.7-Beta_dbg/storage/perfschema/pfs.cc:2192
#39 0x00007f717b946df5 in start_thread (arg=0x7f717bf45700) at pthread_create.c:308
#40 0x00007f717a6101ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

DROP DATABASE test;CREATE DATABASE test;USE test;
set big_tables=OFF,big_tables=ON,big_tables=0,big_tables=1,big_tables="OFF",big_tables="ON";
set global innodb_limit_optimistic_insert_debug=2;
SELECT * FROM INFORMATION_SCHEMA.INNODB_CMPMEM_RESET;

Note that exactly the same testcase results in a different assertion on upstream 5.7.9: http://bugs.mysql.com/bug.php?id=79391