Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7051

MySQL#74605 - InnoDB: Failing assertion: node_addr.page != FIL_NULL in file btr0btr.cc line 1101

    XMLWordPrintable

    Details

      Description

      Initially reported by Ramesh Sivaraman as http://bugs.mysql.com/bug.php?id=74605, refiling to make it searchable in Jira and to preserve the test case.

      DROP DATABASE test;CREATE DATABASE test;USE test;
      SET GLOBAL innodb_change_buffering_debug=1;
      CREATE TABLE t1(c1 INT)PARTITION BY HASH (c1) PARTITIONS 15;
      SET @start_global_value=@@global.innodb_spin_wait_delay;
      SET @@global.innodb_limit_optimistic_insert_debug=@start_global_value;
      create table tt(a int,b int,primary key(a,b));
      set global innodb_limit_optimistic_insert_debug=1;
      DROP TABLE IF EXISTS t1;

      innodb_change_buffering_debug flush 0 336
      innodb_change_buffering_debug evict 0 336
      2014-11-08 20:20:42 7f33ea975700  InnoDB: Assertion failure in thread 139860955846400 in file btr0btr.cc line 1101
      InnoDB: Failing assertion: node_addr.page != FIL_NULL
      InnoDB: We intentionally generate a memory trap.

      #5  0x00007f33e89fa7c0 in *__GI_abort () at abort.c:92
      #6  0x0000000000b9f2a4 in btr_page_alloc_for_ibuf (index=0x7f33e8022478, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:1101
      #7  0x0000000000b9f459 in btr_page_alloc (index=0x7f33e8022478, hint_page_no=355, file_direction=111 'o', level=1, mtr=0x7f33ea96f590, init_mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:1191
      #8  0x0000000000ba2e41 in btr_page_split_and_insert (flags=7, cursor=0x7f33ea96eef0, offsets=0x7f33ea96ef80, heap=0x7f33ea96ef78, tuple=0x7f33d542bb78, n_ext=0, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:2963
      #9  0x0000000000ba18f8 in btr_root_raise_and_insert (flags=7, cursor=0x7f33ea96eef0, offsets=0x7f33ea96ef80, heap=0x7f33ea96ef78, tuple=0x7f33d542bb78, n_ext=0, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:2311
      #10 0x0000000000bb34f4 in btr_cur_pessimistic_insert (flags=7, cursor=0x7f33ea96eef0, offsets=0x7f33ea96ef80, heap=0x7f33ea96ef78, entry=0x7f33d542bb78, rec=0x7f33ea96ef88, big_rec=0x7f33ea96ef90, n_ext=0, thr=0x0, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0cur.cc:1728
      #11 0x0000000000ba2241 in btr_insert_on_non_leaf_level_func (flags=3, index=0x7f33e8022478, level=1, tuple=0x7f33d542bb78, file=0x109fc70 "10.0/storage/xtradb/btr/btr0btr.cc", line=2767, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:2674
      #12 0x0000000000ba25d4 in btr_attach_half_pages (flags=3, index=0x7f33e8022478, block=0x7f33e2bb8a18, split_rec=0x7f33d54e3e84 "", new_block=0x7f33e2bb8750, direction=111, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:2767
      #13 0x0000000000ba30fc in btr_page_split_and_insert (flags=3, cursor=0x7f33ea96f4b0, offsets=0x7f33ea96ff68, heap=0x7f33ea96ff70, tuple=0x7f33d542b178, n_ext=0, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:3007
      #14 0x0000000000ba18f8 in btr_root_raise_and_insert (flags=3, cursor=0x7f33ea96f4b0, offsets=0x7f33ea96ff68, heap=0x7f33ea96ff70, tuple=0x7f33d542b178, n_ext=0, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0btr.cc:2311
      #15 0x0000000000bb34f4 in btr_cur_pessimistic_insert (flags=3, cursor=0x7f33ea96f4b0, offsets=0x7f33ea96ff68, heap=0x7f33ea96ff70, entry=0x7f33d542b178, rec=0x7f33ea96ff58, big_rec=0x7f33ea96ff78, n_ext=0, thr=0x7f33d573d190, mtr=0x7f33ea96f590) at 10.0/storage/xtradb/btr/btr0cur.cc:1728
      #16 0x0000000000a4e5e7 in ibuf_insert_low (mode=33, op=IBUF_OP_DELETE_MARK, no_counter=0, entry=0x7f33d542ac78, entry_size=28, index=0x7f33e8021cf8, space=0, zip_size=0, page_no=336, thr=0x7f33d573d190) at 10.0/storage/xtradb/ibuf/ibuf0ibuf.cc:3776
      #17 0x0000000000a4eb8f in ibuf_insert (op=IBUF_OP_DELETE_MARK, entry=0x7f33d542ac78, index=0x7f33e8021cf8, space=0, zip_size=0, page_no=336, thr=0x7f33d573d190) at 10.0/storage/xtradb/ibuf/ibuf0ibuf.cc:3963
      #18 0x0000000000bb1238 in btr_cur_search_to_nth_level (index=0x7f33e8021cf8, level=0, tuple=0x7f33d542ac78, mode=4, latch_mode=2, cursor=0x7f33ea970640, has_search_latch=0, file=0x1081c68 "10.0/storage/xtradb/row/row0row.cc", line=815, mtr=0x7f33ea970720) at 10.0/storage/xtradb/btr/btr0cur.cc:695
      #19 0x0000000000b1e9a5 in btr_pcur_open_low (index=0x7f33e8021cf8, level=0, tuple=0x7f33d542ac78, mode=4, latch_mode=4098, cursor=0x7f33ea970640, file=0x1081c68 "10.0/storage/xtradb/row/row0row.cc", line=815, mtr=0x7f33ea970720) at 10.0/storage/xtradb/include/btr0pcur.ic:440
      #20 0x0000000000b20531 in row_search_index_entry (index=0x7f33e8021cf8, entry=0x7f33d542ac78, mode=4098, pcur=0x7f33ea970640, mtr=0x7f33ea970720) at 10.0/storage/xtradb/row/row0row.cc:815
      #21 0x0000000000b39e23 in row_upd_sec_index_entry (node=0x7f33d573c9c0, thr=0x7f33d573d190) at 10.0/storage/xtradb/row/row0upd.cc:1751
      #22 0x0000000000b3a281 in row_upd_sec_step (node=0x7f33d573c9c0, thr=0x7f33d573d190) at 10.0/storage/xtradb/row/row0upd.cc:1866
      #23 0x0000000000b3bae8 in row_upd (node=0x7f33d573c9c0, thr=0x7f33d573d190) at 10.0/storage/xtradb/row/row0upd.cc:2569
      #24 0x0000000000b3bdcf in row_upd_step (thr=0x7f33d573d190) at 10.0/storage/xtradb/row/row0upd.cc:2686
      #25 0x0000000000abf69b in que_thr_step (thr=0x7f33d573d190) at 10.0/storage/xtradb/que/que0que.cc:1097
      #26 0x0000000000abf97e in que_run_threads_low (thr=0x7f33d573d190) at 10.0/storage/xtradb/que/que0que.cc:1177
      #27 0x0000000000abfb10 in que_run_threads (thr=0x7f33d573d190) at 10.0/storage/xtradb/que/que0que.cc:1218
      #28 0x0000000000abfd94 in que_eval_sql (info=0x7f33d5415278, sql=0x107b420 "PROCEDURE DROP_TABLE_PROC () IS\nsys_foreign_id CHAR;\ntable_id CHAR;\nindex_id CHAR;\nforeign_id CHAR;\nspace_id INT;\nfound INT;\nDECLARE CURSOR cur_fk IS\nSELECT ID FROM SYS_FOREIGN\nWHERE FOR_NAME = :table"..., reserve_dict_mutex=0, trx=0x7f33d5555278) at 10.0/storage/xtradb/que/que0que.cc:1301
      #29 0x0000000000b04c67 in row_drop_table_for_mysql (name=0x7f33ea971330 "test/t1#P#p1", trx=0x7f33d5555278, drop_db=false, nonatomic=true) at 10.0/storage/xtradb/row/row0mysql.cc:4187
      #30 0x0000000000a10630 in ha_innobase::delete_table (this=0x7f33d5629088, name=0x7f33ea9717d0 "./test/t1#P#p1") at 10.0/storage/xtradb/handler/ha_innodb.cc:11085
      #31 0x0000000000870f8e in handler::ha_delete_table (this=0x7f33d5629088, name=0x7f33ea9717d0 "./test/t1#P#p1") at 10.0/sql/handler.cc:4251
      #32 0x0000000000e0d5c3 in ha_partition::del_ren_table (this=0x7f33d561d908, from=0x7f33ea973830 "./test/t1", to=0x0) at 10.0/sql/ha_partition.cc:2324
      #33 0x0000000000e09736 in ha_partition::delete_table (this=0x7f33d561d908, name=0x7f33ea973830 "./test/t1") at 10.0/sql/ha_partition.cc:557
      #34 0x0000000000870f8e in handler::ha_delete_table (this=0x7f33d561d908, name=0x7f33ea973830 "./test/t1") at 10.0/sql/handler.cc:4251
      #35 0x000000000086c817 in ha_delete_table (thd=0x7f33e270b070, table_type=0x7f33dee48270, path=0x7f33ea973830 "./test/t1", db=0x7f33d561d738 "test", alias=0x7f33d561d128 "t1", generate_warning=true) at 10.0/sql/handler.cc:2323
      #36 0x000000000072145f in mysql_rm_table_no_locks (thd=0x7f33e270b070, tables=0x7f33d561d160, if_exists=true, drop_temporary=false, drop_view=false, dont_log_query=false, dont_free_locks=false) at 10.0/sql/sql_table.cc:2496
      #37 0x00000000007207c9 in mysql_rm_table (thd=0x7f33e270b070, tables=0x7f33d561d160, if_exists=1 '\001', drop_temporary=0 '\000') at 10.0/sql/sql_table.cc:2108
      #38 0x000000000067e282 in mysql_execute_command (thd=0x7f33e270b070) at 10.0/sql/sql_parse.cc:3665
      #39 0x000000000068586f in mysql_parse (thd=0x7f33e270b070, rawbuf=0x7f33d561d088 "DROP TABLE IF EXISTS t1", length=23, parser_state=0x7f33ea974630) at 10.0/sql/sql_parse.cc:6407
      #40 0x0000000000678652 in dispatch_command (command=COM_QUERY, thd=0x7f33e270b070, packet=0x7f33d77f2071 "DROP TABLE IF EXISTS t1", packet_length=23) at 10.0/sql/sql_parse.cc:1299
      #41 0x00000000006779f7 in do_command (thd=0x7f33e270b070) at 10.0/sql/sql_parse.cc:996
      #42 0x00000000007944aa in do_handle_one_connection (thd_arg=0x7f33e270b070) at 10.0/sql/sql_connect.cc:1379
      #43 0x00000000007941fd in handle_one_connection (arg=0x7f33e270b070) at 10.0/sql/sql_connect.cc:1293
      #44 0x0000000000ccb4a6 in pfs_spawn_thread (arg=0x7f33e27d9df0) at 10.0/storage/perfschema/pfs.cc:1860
      #45 0x00007f33ea5a9b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #46 0x00007f33e8aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      Stack trace from

      revision-id: sergii@pisem.net-20141103164737-457hfby1eg82zol9
      date: 2014-11-03 17:47:37 +0100
      build-date: 2014-11-08 20:24:28 +0400
      revno: 4471
      branch-nick: 10.0

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: