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

Assertion `!rec_get_deleted_flag(((btr_cur)->page_cur.rec), (index->table)->not_redundant())' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      This crash was found while testing 10.11-MDEV-36159 branch

      --source include/have_innodb.inc
      CREATE TABLE t1 (a INT PRIMARY KEY,b INT UNIQUE) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (0,1),(1,0);
      REPLACE INTO t1 VALUES (1,1);
      SELECT * FROM t1;
      CHECK TABLE t1 EXTENDED;
      DROP TABLE t1;
      

      Leads to :-

      GIT_SHOW: HEAD -> 10.11-MDEV-36159, origin/10.11-MDEV-36159 c36d71ffcf363bac50396d41d648845248e897c5 2025-08-20T15:23:00+03:00

      # 2025-08-20T15:49:31 [3099865] | mariadbd: /data/Server/MDEV-36159/storage/innobase/row/row0upd.cc:2378: dberr_t row_upd_clust_rec(ulint, upd_node_t*, dict_index_t*, rec_offs*, mem_heap_t**, que_thr_t*, mtr_t*): Assertion `!rec_get_deleted_flag(((btr_cur)->page_cur.rec), (index->table)->not_redundant())' failed.
      

      StackTrace

      # 2025-08-20T15:56:23 [3099865] | #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=140076022347328) at ./nptl/pthread_kill.c:44
      # 2025-08-20T15:56:23 [3099865] | #1  __pthread_kill_internal (signo=6, threadid=140076022347328) at ./nptl/pthread_kill.c:78
      # 2025-08-20T15:56:23 [3099865] | #2  __GI___pthread_kill (threadid=140076022347328, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      # 2025-08-20T15:56:23 [3099865] | #3  0x00007f65fd561476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      # 2025-08-20T15:56:23 [3099865] | #4  0x00007f65fd5477f3 in __GI_abort () at ./stdlib/abort.c:79
      # 2025-08-20T15:56:23 [3099865] | #5  0x00007f65fd54771b in __assert_fail_base (fmt=0x7f65fd6fc130 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x563cc832ce10 "!rec_get_deleted_flag(((btr_cur)->page_cur.rec), (index->table)->not_redundant())", file=0x563cc832c110 "/data/Server/MDEV-36159/storage/innobase/row/row0upd.cc", line=2378, function=<optimized out>) at ./assert/assert.c:92
      # 2025-08-20T15:56:23 [3099865] | #6  0x00007f65fd558e96 in __GI___assert_fail (assertion=0x563cc832ce10 "!rec_get_deleted_flag(((btr_cur)->page_cur.rec), (index->table)->not_redundant())", file=0x563cc832c110 "/data/Server/MDEV-36159/storage/innobase/row/row0upd.cc", line=2378, function=0x563cc832cd80 "dberr_t row_upd_clust_rec(ulint, upd_node_t*, dict_index_t*, rec_offs*, mem_heap_t**, que_thr_t*, mtr_t*)") at ./assert/assert.c:101
      # 2025-08-20T15:56:23 [3099865] | #7  0x0000563cc7bea95c in row_upd_clust_rec (flags=flags@entry=0, node=node@entry=0x7d78640df688, index=index@entry=0x7a5824e1a400, offsets=<optimized out>, offsets@entry=0x7f65fd8d8db0, offsets_heap=offsets_heap@entry=0x7f65fd8d8da8, thr=thr@entry=0x7d78640dfc58, mtr=0x7f65fd8d9010) at /data/Server/MDEV-36159/storage/innobase/row/row0upd.cc:2378
      # 2025-08-20T15:56:23 [3099865] | #8  0x0000563cc7beed6c in row_upd_clust_step (node=node@entry=0x7d78640df688, thr=thr@entry=0x7d78640dfc58) at /data/Server/MDEV-36159/storage/innobase/row/row0upd.cc:2711
      # 2025-08-20T15:56:23 [3099865] | #9  0x0000563cc7bef018 in row_upd (node=node@entry=0x7d78640df688, thr=thr@entry=0x7d78640dfc58) at /data/Server/MDEV-36159/storage/innobase/row/row0upd.cc:2774
      # 2025-08-20T15:56:23 [3099865] | #10 0x0000563cc7bef432 in row_upd_step (thr=thr@entry=0x7d78640dfc58) at /data/Server/MDEV-36159/storage/innobase/row/row0upd.cc:2916
      # 2025-08-20T15:56:23 [3099865] | #11 0x0000563cc7b89957 in row_update_for_mysql (prebuilt=0x7d78640ded50) at /data/Server/MDEV-36159/storage/innobase/row/row0mysql.cc:1668
      # 2025-08-20T15:56:23 [3099865] | #12 0x0000563cc79a32b7 in ha_innobase::update_row (this=0x7d786410b308, old_row=0x7d786410bb48 "", new_row=0x7d786410bb08 "") at /data/Server/MDEV-36159/storage/innobase/handler/ha_innodb.cc:8621
      # 2025-08-20T15:56:23 [3099865] | #13 0x0000563cc764997e in handler::ha_update_row (this=0x7d786410b308, old_data=0x7d786410bb48 "", new_data=0x7d786410bb08 "") at /data/Server/MDEV-36159/sql/handler.cc:7832
      # 2025-08-20T15:56:23 [3099865] | #14 0x0000563cc72d0c29 in Write_record::replace_row (this=0x7f65fd8d9640, inserted=inserted@entry=0x7f65fd8d95a0, deleted=deleted@entry=0x7f65fd8d95a8) at /data/Server/MDEV-36159/sql/sql_insert.cc:2117
      # 2025-08-20T15:56:23 [3099865] | #15 0x0000563cc72d0e19 in Write_record::write_record (this=this@entry=0x7f65fd8d9640) at /data/Server/MDEV-36159/sql/sql_insert.cc:2364
      # 2025-08-20T15:56:23 [3099865] | #16 0x0000563cc7306fba in read_sep_field (thd=thd@entry=0x302224000d58, info=..., table_list=table_list@entry=0x3022240137b8, fields_vars=..., set_fields=..., set_values=..., read_info=..., enclosed=..., skip_lines=<optimized out>, ignore_check_option_errors=false) at /data/Server/MDEV-36159/sql/sql_load.cc:1220
      # 2025-08-20T15:56:23 [3099865] | #17 0x0000563cc730aadc in mysql_load (thd=thd@entry=0x302224000d58, ex=<optimized out>, table_list=table_list@entry=0x3022240137b8, fields_vars=..., set_fields=..., set_values=..., handle_duplicates=<optimized out>, ignore=<optimized out>, read_file_from_client=<optimized out>) at /data/Server/MDEV-36159/sql/sql_load.cc:706
      # 2025-08-20T15:56:23 [3099865] | #18 0x0000563cc731e85b in mysql_execute_command (thd=thd@entry=0x302224000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/MDEV-36159/sql/sql_parse.cc:5143
      # 2025-08-20T15:56:23 [3099865] | #19 0x0000563cc7322c78 in mysql_parse (thd=thd@entry=0x302224000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f65fd8da380) at /data/Server/MDEV-36159/sql/sql_parse.cc:8180
      # 2025-08-20T15:56:23 [3099865] | #20 0x0000563cc7325213 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x302224000d58, packet=packet@entry=0x30222400b049 " LOAD DATA INFILE 'load_view_DD' REPLACE INTO TABLE view_DD  /* E_R Thread1 QNO 490 CON_ID 16 */ ", packet_length=packet_length@entry=97, blocking=blocking@entry=true) at /data/Server/MDEV-36159/sql/sql_parse.cc:1906
      # 2025-08-20T15:56:23 [3099865] | #21 0x0000563cc73270bd in do_command (thd=thd@entry=0x302224000d58, blocking=blocking@entry=true) at /data/Server/MDEV-36159/sql/sql_parse.cc:1419
      # 2025-08-20T15:56:23 [3099865] | #22 0x0000563cc7497402 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x563ccabdb088, put_in_cache=put_in_cache@entry=true) at /data/Server/MDEV-36159/sql/sql_connect.cc:1386
      # 2025-08-20T15:56:23 [3099865] | #23 0x0000563cc7497637 in handle_one_connection (arg=0x563ccabdb088) at /data/Server/MDEV-36159/sql/sql_connect.cc:1298
      # 2025-08-20T15:56:23 [3099865] | #24 0x00007f65fd5b3ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      # 2025-08-20T15:56:23 [3099865] | #25 0x00007f65fd644a04 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      

      RR trace is present on pluto:-
      /data/results/1755695554/TBR-2314

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.