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

Assertion `state < buf_page_t::UNFIXED || page_id_t(page_get_space_id(block->page.frame), page_get_page_no(block->page.frame)) == block->page.id()' failed in mtr_t::page_lock

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
      --source include/have_sequence.inc
       
      CREATE TEMPORARY TABLE t (c POINT NOT NULL, SPATIAL(c)) ENGINE=InnoDB;
      INSERT INTO t SELECT PointFromText('POINT(0 0)') FROM seq_1_to_366;
      

      10.6 3e030488

      mariadbd: /data/src/10.6/storage/innobase/mtr/mtr0mtr.cc:1207: void mtr_t::page_lock(buf_block_t*, ulint): Assertion `state < buf_page_t::UNFIXED || page_id_t(page_get_space_id(block->page.frame), page_get_page_no(block->page.frame)) == block->page.id()' failed.
      220103 21:27:48 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007fa78a6ef40f in __assert_fail_base (fmt=0x7fa78a858128 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x565478d2abf8 "state < buf_page_t::UNFIXED || page_id_t(page_get_space_id(block->page.frame), page_get_page_no(block->page.frame)) == block->page.id()", file=0x565478d29c08 "/data/src/10.6/storage/innobase/mtr/mtr0mtr.cc", line=1207, function=<optimized out>) at assert.c:92
      #7  0x00007fa78a6fe662 in __GI___assert_fail (assertion=0x565478d2abf8 "state < buf_page_t::UNFIXED || page_id_t(page_get_space_id(block->page.frame), page_get_page_no(block->page.frame)) == block->page.id()", file=0x565478d29c08 "/data/src/10.6/storage/innobase/mtr/mtr0mtr.cc", line=1207, function=0x565478d2ab58 "void mtr_t::page_lock(buf_block_t*, ulint)") at assert.c:101
      #8  0x000056547853abc7 in mtr_t::page_lock (this=0x7fa7842932c0, block=0x7fa77f80f8a0, rw_latch=2) at /data/src/10.6/storage/innobase/mtr/mtr0mtr.cc:1207
      #9  0x000056547871d29b in buf_page_get_low (page_id=..., zip_size=0, rw_latch=2, guess=0x0, mode=16, mtr=0x7fa7842932c0, err=0x0, allow_ibuf_merge=false) at /data/src/10.6/storage/innobase/buf/buf0buf.cc:2926
      #10 0x000056547871d652 in buf_page_get_gen (page_id=..., zip_size=0, rw_latch=2, guess=0x0, mode=16, mtr=0x7fa7842932c0, err=0x0, allow_ibuf_merge=false) at /data/src/10.6/storage/innobase/buf/buf0buf.cc:2991
      #11 0x00005654784cbbaa in ibuf_bitmap_get_map_page (page_id=..., zip_size=0, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/ibuf/ibuf0ibuf.cc:669
      #12 0x00005654784cbcbc in ibuf_set_free_bits_low (block=0x7fa77f80f700, val=3, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/ibuf/ibuf0ibuf.cc:699
      #13 0x00005654784cc35f in ibuf_update_free_bits_for_two_pages_low (block1=0x7fa77f80f700, block2=0x7fa77f80f7d0, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/ibuf/ibuf0ibuf.cc:884
      #14 0x0000565478807123 in rtr_page_split_and_insert (flags=2, cursor=0x7fa784292fc0, offsets=0x7fa784292f68, heap=0x7fa784292f40, tuple=0x7fa72c043790, n_ext=0, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:1176
      #15 0x00005654786bfc85 in btr_root_raise_and_insert (flags=2, cursor=0x7fa784292fc0, offsets=0x7fa784292f68, heap=0x7fa784292f40, tuple=0x7fa72c043790, n_ext=0, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/btr/btr0btr.cc:1963
      #16 0x00005654786eca1d in btr_cur_pessimistic_insert (flags=2, cursor=0x7fa784292fc0, offsets=0x7fa784292f68, heap=0x7fa784292f40, entry=0x7fa72c043790, rec=0x7fa784292f70, big_rec=0x7fa784292f78, n_ext=0, thr=0x7fa72c21cba8, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/btr/btr0cur.cc:3759
      #17 0x00005654785d3a1b in row_ins_sec_index_entry_low (flags=2, mode=33, index=0x7fa72c1ad218, offsets_heap=0x7fa72c058738, heap=0x7fa72c058bd8, entry=0x7fa72c043790, trx_id=0, thr=0x7fa72c21cba8) at /data/src/10.6/storage/innobase/row/row0ins.cc:3131
      #18 0x00005654785d41b1 in row_ins_sec_index_entry (index=0x7fa72c1ad218, entry=0x7fa72c043790, thr=0x7fa72c21cba8, check_foreign=true) at /data/src/10.6/storage/innobase/row/row0ins.cc:3324
      #19 0x00005654785d433e in row_ins_index_entry (index=0x7fa72c1ad218, entry=0x7fa72c043790, thr=0x7fa72c21cba8) at /data/src/10.6/storage/innobase/row/row0ins.cc:3358
      #20 0x00005654785d4bef in row_ins_index_entry_step (node=0x7fa72c21c988, thr=0x7fa72c21cba8) at /data/src/10.6/storage/innobase/row/row0ins.cc:3524
      #21 0x00005654785d5108 in row_ins (node=0x7fa72c21c988, thr=0x7fa72c21cba8) at /data/src/10.6/storage/innobase/row/row0ins.cc:3670
      #22 0x00005654785d5a08 in row_ins_step (thr=0x7fa72c21cba8) at /data/src/10.6/storage/innobase/row/row0ins.cc:3816
      #23 0x00005654785f6e41 in row_insert_for_mysql (mysql_rec=0x7fa72c22e4e8 "\031", prebuilt=0x7fa72c21c498, ins_mode=ROW_INS_NORMAL) at /data/src/10.6/storage/innobase/row/row0mysql.cc:1318
      #24 0x0000565478437eab in ha_innobase::write_row (this=0x7fa72c22e950, record=0x7fa72c22e4e8 "\031") at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:7836
      #25 0x000056547802b1a3 in handler::ha_write_row (this=0x7fa72c22e950, buf=0x7fa72c22e4e8 "\031") at /data/src/10.6/sql/handler.cc:7519
      #26 0x0000565477c3a0ff in write_record (thd=0x7fa72c000db8, table=0x7fa72c22e058, info=0x7fa72c0185a8, sink=0x0) at /data/src/10.6/sql/sql_insert.cc:2146
      #27 0x0000565477c3fc09 in select_insert::send_data (this=0x7fa72c018558, values=...) at /data/src/10.6/sql/sql_insert.cc:4102
      #28 0x0000565477d2ab87 in select_result_sink::send_data_with_check (this=0x7fa72c018558, items=..., u=0x7fa72c005120, sent=365) at /data/src/10.6/sql/sql_class.h:5632
      #29 0x0000565477d10552 in end_send (join=0x7fa72c018618, join_tab=0x7fa72c019c10, end_of_records=false) at /data/src/10.6/sql/sql_select.cc:22311
      #30 0x0000565477d0da25 in evaluate_join_record (join=0x7fa72c018618, join_tab=0x7fa72c019860, error=0) at /data/src/10.6/sql/sql_select.cc:21304
      #31 0x0000565477d0d41e in sub_select (join=0x7fa72c018618, join_tab=0x7fa72c019860, end_of_records=false) at /data/src/10.6/sql/sql_select.cc:21113
      #32 0x0000565477d0c78c in do_select (join=0x7fa72c018618, procedure=0x0) at /data/src/10.6/sql/sql_select.cc:20621
      #33 0x0000565477cdfe5c in JOIN::exec_inner (this=0x7fa72c018618) at /data/src/10.6/sql/sql_select.cc:4737
      #34 0x0000565477cdeed1 in JOIN::exec (this=0x7fa72c018618) at /data/src/10.6/sql/sql_select.cc:4515
      #35 0x0000565477ce07e9 in mysql_select (thd=0x7fa72c000db8, tables=0x7fa72c0164a8, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202244745984, result=0x7fa72c018558, unit=0x7fa72c005120, select_lex=0x7fa72c015dd8) at /data/src/10.6/sql/sql_select.cc:4994
      #36 0x0000565477ccfb67 in handle_select (thd=0x7fa72c000db8, lex=0x7fa72c005058, result=0x7fa72c018558, setup_tables_done_option=1073741824) at /data/src/10.6/sql/sql_select.cc:545
      #37 0x0000565477c8b280 in mysql_execute_command (thd=0x7fa72c000db8, is_called_from_prepared_stmt=false) at /data/src/10.6/sql/sql_parse.cc:4710
      #38 0x0000565477c961f8 in mysql_parse (thd=0x7fa72c000db8, rawbuf=0x7fa72c0155c0 "INSERT INTO t SELECT PointFromText('POINT(0 0)') FROM seq_1_to_366", length=66, parser_state=0x7fa784295500) at /data/src/10.6/sql/sql_parse.cc:8029
      #39 0x0000565477c82833 in dispatch_command (command=COM_QUERY, thd=0x7fa72c000db8, packet=0x7fa72c00b879 "INSERT INTO t SELECT PointFromText('POINT(0 0)') FROM seq_1_to_366", packet_length=66, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1896
      #40 0x0000565477c811ed in do_command (thd=0x7fa72c000db8, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1404
      #41 0x0000565477e39fdc in do_handle_one_connection (connect=0x56547a80bc78, put_in_cache=true) at /data/src/10.6/sql/sql_connect.cc:1418
      #42 0x0000565477e39c7b in handle_one_connection (arg=0x56547a8cfe88) at /data/src/10.6/sql/sql_connect.cc:1312
      #43 0x00005654783508d8 in pfs_spawn_thread (arg=0x56547a809348) at /data/src/10.6/storage/perfschema/pfs.cc:2201
      #44 0x00007fa78abcaea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #45 0x00007fa78a7c7def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Reproducible on 10.6-10.8 debug builds.
      Also reproducible with innodb-change-buffering=none.
      No obvious immediate problem on 10.5 or on a non-debug build.
      Not reproducible with a non-temporary table.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.