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

dberr_t ibuf_merge_or_delete_for_page(buf_block_t*, page_id_t, ulint): Assertion `page_validate(block->page.frame, dummy_index)' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      Assertion found on debug build:-

      GIT_SHOW: HEAD -> 10.11, origin/10.11 21bb6a3e348f89c5cf23d4ee688c57f6078c7b02 2025-08-27T11:02:19+03:00

      # 2025-08-27T22:07:57 [1256399] | mariadbd: /data/Server/10.11_new/storage/innobase/ibuf/ibuf0ibuf.cc:4249: dberr_t ibuf_merge_or_delete_for_page(buf_block_t*, page_id_t, ulint): Assertion `page_validate(block->page.frame, dummy_index)' failed.
      

      Stacktrace

      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=93145368016448) at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=93145368016448) at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=93145368016448, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      #3  __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      #4  __GI_abort () at ./stdlib/abort.c:79
      #5  __assert_fail_base (fmt="%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion="page_validate(block->page.frame, dummy_index)", file="/data/Server/10.11_new/storage/innobase/ibuf/ibuf0ibuf.cc", line=4249, 
          function=<optimized out>) at ./assert/assert.c:92
      #6  __GI___assert_fail (assertion="page_validate(block->page.frame, dummy_index)", file="/data/Server/10.11_new/storage/innobase/ibuf/ibuf0ibuf.cc", line=4249, 
          function="dberr_t ibuf_merge_or_delete_for_page(buf_block_t*, page_id_t, ulint)") at ./assert/assert.c:101
      #7  ibuf_merge_or_delete_for_page (block=block@entry=, page_id=..., zip_size=<optimized out>) at /data/Server/10.11_new/storage/innobase/ibuf/ibuf0ibuf.cc:4249
      #8  buf_page_ibuf_merge_try (block=block@entry=, rw_latch=rw_latch@entry=2, err=err@entry=) at /data/Server/10.11_new/storage/innobase/include/buf0buf.h:643
      #9  buf_page_get_low (page_id=..., page_id@entry=..., zip_size=zip_size@entry=0, rw_latch=rw_latch@entry=RW_X_LATCH, guess=<optimized out>, guess@entry=, mode=mode@entry=10, mtr=mtr@entry=, err=<optimized out>, 
          allow_ibuf_merge=<optimized out>) at /data/Server/10.11_new/storage/innobase/buf/buf0buf.cc:3208
      #10 buf_page_get_gen (page_id=page_id@entry=..., zip_size=zip_size@entry=0, rw_latch=rw_latch@entry=RW_X_LATCH, guess=guess@entry=, mode=mode@entry=10, mtr=mtr@entry=, err=, allow_ibuf_merge=true)
          at /data/Server/10.11_new/storage/innobase/buf/buf0buf.cc:3248
      #11 btr_cur_t::search_leaf (this=this@entry=, tuple=tuple@entry=, mode=mode@entry=PAGE_CUR_LE, latch_mode=<optimized out>, latch_mode@entry=2114, mtr=mtr@entry=) at /data/Server/10.11_new/storage/innobase/btr/btr0cur.cc:1269
      #12 row_ins_sec_index_entry_low (flags=flags@entry=0, mode=mode@entry=BTR_MODIFY_LEAF, index=index@entry=, offsets_heap=<optimized out>, offsets_heap@entry=, heap=heap@entry=, entry=entry@entry=, trx_id=0, thr=)
          at /data/Server/10.11_new/storage/innobase/row/row0ins.cc:3121
      #13 row_ins_sec_index_entry (index=index@entry=, entry=, thr=thr@entry=, check_foreign=<optimized out>) at /data/Server/10.11_new/storage/innobase/row/row0ins.cc:3430
      #14 row_upd_sec_index_entry (node=node@entry=, thr=thr@entry=) at /data/Server/10.11_new/storage/innobase/row/row0upd.cc:2027
      #15 row_upd_sec_step (node=node@entry=, thr=thr@entry=) at /data/Server/10.11_new/storage/innobase/row/row0upd.cc:2054
      #16 row_upd (node=node@entry=, thr=thr@entry=) at /data/Server/10.11_new/storage/innobase/row/row0upd.cc:2801
      #17 row_upd_step (thr=thr@entry=) at /data/Server/10.11_new/storage/innobase/row/row0upd.cc:2916
      #18 que_thr_step (thr=thr@entry=) at /data/Server/10.11_new/storage/innobase/que/que0que.cc:535
      #19 que_run_threads_low (thr=thr@entry=) at /data/Server/10.11_new/storage/innobase/que/que0que.cc:609
      #20 que_run_threads (thr=) at /data/Server/10.11_new/storage/innobase/que/que0que.cc:629
      #21 que_eval_sql (info=info@entry=, sql=sql@entry="PROCEDURE RENAME_TABLE () IS\nBEGIN\nUPDATE SYS_TABLES SET NAME = :new_table_name\n WHERE NAME = :old_table_name;\nEND;\n", trx=trx@entry=)
          at /data/Server/10.11_new/storage/innobase/que/que0que.cc:668
      #22 row_rename_table_for_mysql (old_name=<optimized out>, old_name@entry="test/u#P#p3#SP#p3sp0", new_name=new_name@entry="test/#sql-backup-133b1f-1c#P#p3#SP#p3sp0", trx=trx@entry=, fk=fk@entry=RENAME_ALTER_COPY)
          at /data/Server/10.11_new/storage/innobase/row/row0mysql.cc:2656
      #23 innobase_rename_table (trx=trx@entry=, from=from@entry="./test/u#P#p3#SP#p3sp0", to=to@entry="./test/#sql-backup-133b1f-1c#P#p3#SP#p3sp0", fk=fk@entry=RENAME_ALTER_COPY)
          at /data/Server/10.11_new/storage/innobase/handler/ha_innodb.cc:13829
      #24 ha_innobase::rename_table (this=<optimized out>, from=<optimized out>, to=<optimized out>) at /data/Server/10.11_new/storage/innobase/handler/ha_innodb.cc:14266
      #25 handler::ha_rename_table (this=, from=from@entry="./test/u#P#p3#SP#p3sp0", to=to@entry="./test/#sql-backup-133b1f-1c#P#p3#SP#p3sp0") at /data/Server/10.11_new/sql/handler.cc:5541
      #26 ha_partition::del_ren_table (this=, from="./test/u", to="./test/#sql-backup-133b1f-1c") at /data/Server/10.11_new/sql/ha_partition.cc:2505
      #27 ha_partition::rename_table (this=<optimized out>, from=<optimized out>, to=<optimized out>) at /data/Server/10.11_new/sql/ha_partition.cc:663
      #28 handler::ha_rename_table (this=this@entry=, from=from@entry="./test/u", to=to@entry="./test/#sql-backup-133b1f-1c") at /data/Server/10.11_new/sql/handler.cc:5541
      #29 mysql_rename_table (base=base@entry=, old_db=old_db@entry=, old_name=old_name@entry=, new_db=new_db@entry=, new_name=new_name@entry=, id=id@entry=, flags=2) at /data/Server/10.11_new/sql/sql_table.cc:5507
      #30 mysql_alter_table (thd=thd@entry=, new_db=new_db@entry=, new_name=<optimized out>, create_info=create_info@entry=, table_list=<optimized out>, table_list@entry=, recreate_info=recreate_info@entry=, 
          alter_info=<optimized out>, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /data/Server/10.11_new/sql/sql_table.cc:11768
      #31 Sql_cmd_alter_table::execute (this=<optimized out>, thd=) at /data/Server/10.11_new/sql/sql_alter.cc:688
      #32 mysql_execute_command (thd=thd@entry=, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/10.11_new/sql/sql_parse.cc:6165
      #33 mysql_parse (thd=thd@entry=, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=) at /data/Server/10.11_new/sql/sql_parse.cc:8180
      #34 dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=, packet=packet@entry="ALTER TABLE u REMOVE PARTITIONING /* E_R Thread13 QNO 261 CON_ID 28 */ ", packet_length=packet_length@entry=71, 
          blocking=blocking@entry=true) at /data/Server/10.11_new/sql/sql_parse.cc:1906
      #35 do_command (thd=thd@entry=, blocking=blocking@entry=true) at /data/Server/10.11_new/sql/sql_parse.cc:1419
      #36 do_handle_one_connection (connect=<optimized out>, connect@entry=, put_in_cache=put_in_cache@entry=true) at /data/Server/10.11_new/sql/sql_connect.cc:1386
      #37 handle_one_connection (arg=) at /data/Server/10.11_new/sql/sql_connect.cc:1298
      #38 start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #39 clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      

      RR trace is presenton pluto:-
      /data/results/1756324862/TBR-1510

      Attachments

        Activity

          People

            marko Marko Mäkelä
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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