| 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: | |
| 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
[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
