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

Assertion `offsets' failed in ulint btr_check_node_ptr(dict_index_t*, buf_block_t*, que_thr_t*, mtr_t*)

Details

    Description

      --source include/have_sequence.inc
      --source include/have_innodb.inc
       
      CREATE TABLE t (c CHAR(128),KEY(c DESC)) ENGINE=INNODB;
      INSERT INTO t SELECT SEQ FROM seq_1_to_100000;
       
      #cleanup
      DROP TABLE t;
      

      CS 11.8.0 349b8a10274c88887b7b2af24b4200724617611f (Debug)

      mariadbd: /test/mtest/11.8/storage/innobase/btr/btr0btr.cc:4403: ulint btr_check_node_ptr(dict_index_t*, buf_block_t*, que_thr_t*, mtr_t*): Assertion `offsets' failed.
      

      CS 11.8.0 349b8a10274c88887b7b2af24b4200724617611f (Debug)

      Core was generated by `/test/mtest/MD230125-mariadb-11.8.0-linux-x86_64-dbg/bin/mariadbd --no-defaults'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x14da9f94b700 (LWP 1716262))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055bcfe9189c2 in my_write_core (sig=sig@entry=6) at /test/mtest/11.8/mysys/stacktrace.c:424
      #2  0x000055bcfe1cf72e in handle_fatal_signal (sig=6) at /test/mtest/11.8/sql/signal_handler.cc:366
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x000014dad85ec859 in __GI_abort () at abort.c:79
      #6  0x000014dad85ec729 in __assert_fail_base (fmt=0x14dad8782588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55bcfedd3121 "offsets", file=0x55bcfede4298 "/test/mtest/11.8/storage/innobase/btr/btr0btr.cc", line=4403, function=<optimized out>) at assert.c:92
      #7  0x000014dad85fdfd6 in __GI___assert_fail (assertion=assertion@entry=0x55bcfedd3121 "offsets", file=file@entry=0x55bcfede4298 "/test/mtest/11.8/storage/innobase/btr/btr0btr.cc", line=line@entry=4403, function=function@entry=0x55bcfede6e58 "ulint btr_check_node_ptr(dict_index_t*, buf_block_t*, que_thr_t*, mtr_t*)") at assert.c:101
      #8  0x000055bcfe7564b1 in btr_check_node_ptr (index=index@entry=0x14da8c026d78, block=<optimized out>, thr=0x0, mtr=mtr@entry=0x14da9f948e30) at /test/mtest/11.8/storage/innobase/btr/btr0btr.cc:4403
      #9  0x000055bcfe758f20 in btr_compress (cursor=cursor@entry=0x14da9f948c20, adjust=adjust@entry=false, mtr=mtr@entry=0x14da9f948e30) at /test/mtest/11.8/storage/innobase/btr/btr0btr.cc:3929
      #10 0x000055bcfe77257b in btr_cur_compress_if_useful (cursor=cursor@entry=0x14da9f948c20, adjust=adjust@entry=false, mtr=mtr@entry=0x14da9f948e30) at /test/mtest/11.8/storage/innobase/include/buf0types.h:135
      #11 0x000055bcfe7810b5 in btr_cur_pessimistic_delete (err=err@entry=0x14da9f948c14, has_reserved_extents=has_reserved_extents@entry=0, cursor=cursor@entry=0x14da9f948c20, flags=flags@entry=0, rollback=rollback@entry=false, mtr=mtr@entry=0x14da9f948e30) at /test/mtest/11.8/storage/innobase/btr/btr0cur.cc:4741
      #12 0x000055bcfe8ab4ec in row_undo_ins_remove_sec_low (mode=<optimized out>, mode@entry=BTR_PURGE_TREE, index=index@entry=0x14da8c026d78, entry=entry@entry=0x14da8c07d9a8, thr=thr@entry=0x14da8c07d0e8) at /test/mtest/11.8/storage/innobase/row/row0uins.cc:307
      #13 0x000055bcfe8abbda in row_undo_ins_remove_sec (thr=0x14da8c07d0e8, entry=0x14da8c07d9a8, index=0x14da8c026d78) at /test/mtest/11.8/storage/innobase/row/row0uins.cc:345
      #14 row_undo_ins_remove_sec_rec (thr=0x14da8c07d0e8, node=0x14da8c07d2b8) at /test/mtest/11.8/storage/innobase/row/row0uins.cc:530
      #15 row_undo_ins (node=node@entry=0x14da8c07d2b8, thr=thr@entry=0x14da8c07d0e8) at /test/mtest/11.8/storage/innobase/row/row0uins.cc:582
      #16 0x000055bcfe6d7fc5 in row_undo (thr=0x14da8c07d0e8, node=0x14da8c07d2b8) at /test/mtest/11.8/storage/innobase/include/trx0undo.inl:82
      #17 row_undo_step (thr=thr@entry=0x14da8c07d0e8) at /test/mtest/11.8/storage/innobase/row/row0undo.cc:442
      #18 0x000055bcfe61b8a4 in que_thr_step (thr=0x14da8c07d0e8) at /test/mtest/11.8/storage/innobase/que/que0que.cc:552
      #19 que_run_threads_low (thr=0x14da8c07d0e8) at /test/mtest/11.8/storage/innobase/que/que0que.cc:610
      #20 que_run_threads (thr=0x14da8c07d0e8) at /test/mtest/11.8/storage/innobase/que/que0que.cc:630
      #21 0x000055bcfe71f1a6 in trx_t::rollback_low (this=this@entry=0x14dad5c46b80, savept=savept@entry=0x0) at /test/mtest/11.8/storage/innobase/trx/trx0roll.cc:129
      #22 0x000055bcfe71bec6 in trx_rollback_for_mysql_low (trx=0x14dad5c46b80) at /test/mtest/11.8/storage/innobase/trx/trx0roll.cc:203
      #23 trx_rollback_for_mysql (trx=trx@entry=0x14dad5c46b80) at /test/mtest/11.8/storage/innobase/trx/trx0roll.cc:238
      #24 0x000055bcfe4f6f5a in innobase_rollback (thd=0x14da8c000d48, rollback_trx=<optimized out>) at /test/mtest/11.8/storage/innobase/handler/ha_innodb.cc:4642
      #25 0x000055bcfe1d531c in ha_rollback_trans (thd=thd@entry=0x14da8c000d48, all=all@entry=false) at /test/mtest/11.8/sql/handler.cc:2344
      #26 0x000055bcfe035efc in trans_rollback_stmt (thd=thd@entry=0x14da8c000d48) at /test/mtest/11.8/sql/transaction.cc:561
      #27 0x000055bcfde9872e in mysql_execute_command (thd=thd@entry=0x14da8c000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/mtest/11.8/sql/sql_parse.cc:5950
      #28 0x000055bcfde8349f in mysql_parse (thd=thd@entry=0x14da8c000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14da9f94a2b0) at /test/mtest/11.8/sql/sql_parse.cc:7901
      #29 0x000055bcfde9a630 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14da8c000d48, packet=packet@entry=0x14da8c00b0c9 "INSERT INTO t SELECT SEQ,SEQ FROM seq_1_to_100000", packet_length=packet_length@entry=49, blocking=blocking@entry=true) at /test/mtest/11.8/sql/sql_class.h:1645
      #30 0x000055bcfde9ce9b in do_command (thd=thd@entry=0x14da8c000d48, blocking=blocking@entry=true) at /test/mtest/11.8/sql/sql_parse.cc:1416
      #31 0x000055bcfe01eabd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55bd0232a668, put_in_cache=put_in_cache@entry=true) at /test/mtest/11.8/sql/sql_connect.cc:1415
      #32 0x000055bcfe01ef97 in handle_one_connection (arg=0x55bd0232a668) at /test/mtest/11.8/sql/sql_connect.cc:1327
      #33 0x000014dad8b18609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #34 0x000014dad86e9133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Activity

          ramesh Ramesh Sivaraman created issue -

          The commit hash appears to be the head of the development preview branch preview-11.8-preview that was last updated on December 17, 2024, but not to any main branch, which further releases of the 11.8 series would be based on. Can you reproduce this bug on the current main branch? I can’t.

          marko Marko Mäkelä added a comment - The commit hash appears to be the head of the development preview branch preview-11.8-preview that was last updated on December 17, 2024, but not to any main branch, which further releases of the 11.8 series would be based on. Can you reproduce this bug on the current main branch ? I can’t.
          marko Marko Mäkelä made changes -
          Field Original Value New Value
          Assignee Marko Mäkelä [ marko ] Ramesh Sivaraman [ JIRAUSER48189 ]
          Status Open [ 1 ] Needs Feedback [ 10501 ]
          ramesh Ramesh Sivaraman added a comment - - edited

          marko The issue is reproduced only on preview-11.8-preview branch, could not reproduce it on 11.8 main branch

          ramesh Ramesh Sivaraman added a comment - - edited marko The issue is reproduced only on preview-11.8-preview branch, could not reproduce it on 11.8 main branch
          ramesh Ramesh Sivaraman made changes -
          Status Needs Feedback [ 10501 ] Open [ 1 ]

          could not reproduce the issue on 11.8 main branch

          ramesh Ramesh Sivaraman added a comment - could not reproduce the issue on 11.8 main branch
          ramesh Ramesh Sivaraman made changes -
          Fix Version/s N/A [ 14700 ]
          Fix Version/s 11.8 [ 29921 ]
          Resolution Cannot Reproduce [ 5 ]
          Status Open [ 1 ] Closed [ 6 ]

          People

            ramesh Ramesh Sivaraman
            ramesh Ramesh Sivaraman
            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.