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

Bug #1519201 reported by Roel Van de Paar on 2015-11-24
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
Invalid
Undecided
Unassigned
5.6
Invalid
Undecided
Unassigned
5.7
Fix Released
High
Unassigned

Bug Description

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

tags: added: upstream
tags: added: innodb

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3330

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Related blueprints

Remote bug watches

Bug watches keep track of this bug in other bug trackers.