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

dberr_t ibuf_insert_to_index_page(const dtuple_t*, buf_block_t*, dict_index_t*, mtr_t*): Assertion `rec_get_deleted_flag(rec, page_is_comp(page))' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      Assertion found on debug build
      Leads to :-

      GIT_SHOW: HEAD -> 10.11, origin/bb-10.11-MDEV-26115, origin/10.11 852e4510fa662c571a42f550278d4abd09e3c5cf 2025-07-23T09:34:47+07:00

       2025-07-23T11:29:41 [1403269] | mariadbd: /data/Server/10.11_new/storage/innobase/ibuf/ibuf0ibuf.cc:3643: dberr_t ibuf_insert_to_index_page(const dtuple_t*, buf_block_t*, dict_index_t*, mtr_t*): Assertion `rec_get_deleted_flag(rec, page_is_comp(page))' failed
      

      Stacktrace

      # 2025-07-23T11:31:03 [1403269] Thread 1 (Thread 0x7f6e8c4d9640 (LWP 1406844)):
      # 2025-07-23T11:31:03 [1403269] #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=140112777025088) at ./nptl/pthread_kill.c:44
      # 2025-07-23T11:31:03 [1403269] #1  __pthread_kill_internal (signo=6, threadid=140112777025088) at ./nptl/pthread_kill.c:78
      # 2025-07-23T11:31:03 [1403269] #2  __GI___pthread_kill (threadid=140112777025088, signo=6) at ./nptl/pthread_kill.c:89
      # 2025-07-23T11:31:03 [1403269] #3  0x000055f0ddc01958 in my_write_core (sig=6) at /data/Server/10.11_new/mysys/stacktrace.c:424
      # 2025-07-23T11:31:03 [1403269] #4  0x000055f0dd3bdb9e in handle_fatal_signal (sig=6) at /data/Server/10.11_new/sql/signal_handler.cc:298
      # 2025-07-23T11:31:03 [1403269] #5  <signal handler called>
      # 2025-07-23T11:31:03 [1403269] #6  __pthread_kill_implementation (no_tid=0, signo=6, threadid=140112777025088) at ./nptl/pthread_kill.c:44
      # 2025-07-23T11:31:03 [1403269] #7  __pthread_kill_internal (signo=6, threadid=140112777025088) at ./nptl/pthread_kill.c:78
      # 2025-07-23T11:31:03 [1403269] #8  __GI___pthread_kill (threadid=140112777025088, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      # 2025-07-23T11:31:03 [1403269] #9  0x00007f6eb2618476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      # 2025-07-23T11:31:03 [1403269] #10 0x00007f6eb25fe7f3 in __GI_abort () at ./stdlib/abort.c:79
      # 2025-07-23T11:31:03 [1403269] #11 0x00007f6eb25fe71b in __assert_fail_base (fmt=0x7f6eb27b3130 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55f0de063990 "rec_get_deleted_flag(rec, page_is_comp(page))", file=0x55f0de061320 "/data/Server/10.11_new/storage/innobase/ibuf/ibuf0ibuf.cc", line=3643, function=<optimized out>) at ./assert/assert.c:92
      # 2025-07-23T11:31:03 [1403269] #12 0x00007f6eb260fe96 in __GI___assert_fail (assertion=0x55f0de063990 "rec_get_deleted_flag(rec, page_is_comp(page))", file=0x55f0de061320 "/data/Server/10.11_new/storage/innobase/ibuf/ibuf0ibuf.cc", line=3643, function=0x55f0de063938 "dberr_t ibuf_insert_to_index_page(const dtuple_t*, buf_block_t*, dict_index_t*, mtr_t*)") at ./assert/assert.c:101
      # 2025-07-23T11:31:03 [1403269] #13 0x000055f0dd7b6a79 in ibuf_insert_to_index_page (entry=entry@entry=0x7f6dd00406d8, block=block@entry=0x7f6ea3000b60, index=0x7f6e300774a0, mtr=mtr@entry=0x7f6e8c4d5e80) at /data/Server/10.11_new/storage/innobase/ibuf/ibuf0ibuf.cc:3643
      # 2025-07-23T11:31:03 [1403269] #14 0x000055f0dd7bb5f6 in ibuf_merge_or_delete_for_page (block=block@entry=0x7f6ea3000b60, page_id=..., zip_size=<optimized out>) at /data/Server/10.11_new/storage/innobase/ibuf/ibuf0ibuf.cc:4252
      # 2025-07-23T11:31:03 [1403269] #15 0x000055f0dda54204 in buf_page_ibuf_merge_try (block=block@entry=0x7f6ea3000b60, rw_latch=rw_latch@entry=1, err=err@entry=0x7f6e8c4d63dc) at /data/Server/10.11_new/storage/innobase/include/buf0buf.h:643
      # 2025-07-23T11:31:03 [1403269] #16 0x000055f0dda547dd in buf_pool_t::page_fix (this=0x55f0de872c80 <buf_pool>, id=id@entry=..., err=err@entry=0x7f6e8c4d63dc, c=c@entry=buf_pool_t::FIX_WAIT_READ) at /data/Server/10.11_new/storage/innobase/buf/buf0buf.cc:2782
      # 2025-07-23T11:31:03 [1403269] #17 0x000055f0dda24177 in btr_latch_prev (rw_latch=rw_latch@entry=RW_X_LATCH, page_id=..., page_id@entry=..., err=err@entry=0x7f6e8c4d63dc, mtr=mtr@entry=0x7f6e8c4d7090) at /data/Server/10.11_new/storage/innobase/btr/btr0cur.cc:1019
      # 2025-07-23T11:31:03 [1403269] #18 0x000055f0dda24ba2 in btr_cur_t::pessimistic_search_leaf (this=this@entry=0x7f6e8c4d6c90, tuple=tuple@entry=0x7f6dd007f670, mode=mode@entry=PAGE_CUR_LE, mtr=mtr@entry=0x7f6e8c4d7090) at /data/Server/10.11_new/storage/innobase/btr/btr0cur.cc:1843
      # 2025-07-23T11:31:03 [1403269] #19 0x000055f0dda272e8 in btr_cur_t::search_leaf (this=this@entry=0x7f6e8c4d6c90, tuple=tuple@entry=0x7f6dd007f670, mode=mode@entry=PAGE_CUR_LE, latch_mode=<optimized out>, latch_mode@entry=1098, mtr=mtr@entry=0x7f6e8c4d7090) at /data/Server/10.11_new/storage/innobase/btr/btr0cur.cc:1574
      # 2025-07-23T11:31:03 [1403269] #20 0x000055f0dd8e304b in row_ins_sec_index_entry_low (flags=flags@entry=0, mode=mode@entry=BTR_INSERT_TREE, index=index@entry=0x7f6e18065300, offsets_heap=<optimized out>, offsets_heap@entry=0x7f6dd004edd0, heap=heap@entry=0x7f6dd005f9e0, entry=entry@entry=0x7f6dd007f670, trx_id=0, thr=0x7f6dd004d538) at /data/Server/10.11_new/storage/innobase/row/row0ins.cc:3111
      # 2025-07-23T11:31:03 [1403269] #21 0x000055f0dd8e3e12 in row_ins_sec_index_entry (index=index@entry=0x7f6e18065300, entry=entry@entry=0x7f6dd007f670, thr=thr@entry=0x7f6dd004d538, check_foreign=check_foreign@entry=true) at /data/Server/10.11_new/storage/innobase/row/row0ins.cc:3434
      # 2025-07-23T11:31:03 [1403269] #22 0x000055f0dd8e61bf in row_ins_index_entry (index=0x7f6e18065300, entry=0x7f6dd007f670, thr=thr@entry=0x7f6dd004d538) at /data/Server/10.11_new/storage/innobase/row/row0ins.cc:3487
      # 2025-07-23T11:31:03 [1403269] #23 0x000055f0dd8e638f in row_ins_index_entry_step (node=node@entry=0x7f6dd004cff0, thr=thr@entry=0x7f6dd004d538) at /data/Server/10.11_new/storage/innobase/row/row0ins.cc:3651
      # 2025-07-23T11:31:03 [1403269] #24 0x000055f0dd8e6de0 in row_ins (node=node@entry=0x7f6dd004cff0, thr=thr@entry=0x7f6dd004d538) at /data/Server/10.11_new/storage/innobase/row/row0ins.cc:3776
      # 2025-07-23T11:31:03 [1403269] #25 0x000055f0dd8e74fc in row_ins_step (thr=thr@entry=0x7f6dd004d538) at /data/Server/10.11_new/storage/innobase/row/row0ins.cc:3905
      # 2025-07-23T11:31:03 [1403269] #26 0x000055f0dd91080c in row_insert_for_mysql (mysql_rec=mysql_rec@entry=0x7f6dd0058b38 "\310\"", prebuilt=0x7f6dd004c9c0, ins_mode=<optimized out>) at /data/Server/10.11_new/storage/innobase/row/row0mysql.cc:1301
      # 2025-07-23T11:31:03 [1403269] #27 0x000055f0dd72ab14 in ha_innobase::write_row (this=0x7f6dd0058338, record=0x7f6dd0058b38 "\310\"") at /data/Server/10.11_new/storage/innobase/handler/ha_innodb.cc:7831
      # 2025-07-23T11:31:03 [1403269] #28 0x000055f0dd3d15f5 in handler::ha_write_row (this=0x7f6dd0058338, buf=0x7f6dd0058b38 "\310\"") at /data/Server/10.11_new/sql/handler.cc:7805
      # 2025-07-23T11:31:03 [1403269] #29 0x000055f0dd0595d6 in write_record (thd=thd@entry=0x7f6dd0000d58, table=table@entry=0x7f6dd0022668, info=info@entry=0x7f6e8c4d7c00, sink=sink@entry=0x0) at /data/Server/10.11_new/sql/sql_insert.cc:2372
      # 2025-07-23T11:31:03 [1403269] #30 0x000055f0dd061d47 in mysql_insert (thd=thd@entry=0x7f6dd0000d58, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/Server/10.11_new/sql/sql_insert.cc:1197
      # 2025-07-23T11:31:03 [1403269] #31 0x000055f0dd0a56a4 in mysql_execute_command (thd=thd@entry=0x7f6dd0000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/10.11_new/sql/sql_parse.cc:4628
      # 2025-07-23T11:31:03 [1403269] #32 0x000055f0dd0ab41b in mysql_parse (thd=thd@entry=0x7f6dd0000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f6e8c4d8380) at /data/Server/10.11_new/sql/sql_parse.cc:8178
      # 2025-07-23T11:31:03 [1403269] #33 0x000055f0dd0ad9b6 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f6dd0000d58, packet=packet@entry=0x7f6dd000b049 " INSERT INTO t1 (col1,col2, col_int, col_string, col_text) VALUES ( 34, 34, 34, REPEAT(SUBSTR(CAST( 34 AS CHAR),1,1), 10), REPEAT(SUBSTR(CAST( 34 AS CHAR),1,1), @fill_amount) ) /* E_R Thread33 QNO 211 CON_ID 51 */ ", packet_length=packet_length@entry=214, blocking=blocking@entry=true) at /data/Server/10.11_new/sql/sql_parse.cc:1906
      # 2025-07-23T11:31:03 [1403269] #34 0x000055f0dd0af860 in do_command (thd=thd@entry=0x7f6dd0000d58, blocking=blocking@entry=true) at /data/Server/10.11_new/sql/sql_parse.cc:1419
      # 2025-07-23T11:31:03 [1403269] #35 0x000055f0dd21f9d6 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55f0df819198, put_in_cache=put_in_cache@entry=true) at /data/Server/10.11_new/sql/sql_connect.cc:1386
      # 2025-07-23T11:31:03 [1403269] #36 0x000055f0dd21fc0b in handle_one_connection (arg=0x55f0df819198) at /data/Server/10.11_new/sql/sql_connect.cc:1298
      # 2025-07-23T11:31:03 [1403269] #37 0x00007f6eb266aac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      # 2025-07-23T11:31:03 [1403269] #38 0x00007f6eb26fc850 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Core dump is found on pluto:
      /data/results/1753268478/TBR-1530

      Attachments

        Issue Links

          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.