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

InnoDB: Failing assertion: old_rec in storage/innobase/btr/btr0pcur.cc line 366

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      SET unique_checks=0;
      SET foreign_key_checks=0;
      SET @@pseudo_slave_mode=1;
      CREATE TABLE t (a INT,b CHAR,KEY(a)) engine=InnoDB;
      XA START '1';
      INSERT INTO t VALUES();
      XA END '1';
      XA PREPARE '1';
      HANDLER t OPEN AS t;
      HANDLER t READ NEXT;
      HANDLER t READ NEXT;
      

      Leads to:

      10.6.16 6f091434f313996436b4f01d7e7d62a9f3786958 (Debug)

      InnoDB: Failing assertion: old_rec
      

      10.6.16 6f091434f313996436b4f01d7e7d62a9f3786958 (Debug)

      Core was generated by `/test/MD311023-mariadb-10.6.16-linux-x86_64-dbg/bin/mariadbd --no-defaults --co'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x145b2cafe700 (LWP 1228624))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x0000145b35f6f859 in __GI_abort () at abort.c:79
      #2  0x000055f9584713df in ut_dbg_assertion_failed (expr=expr@entry=0x55f958aafad4 "old_rec", file=file@entry=0x55f958acceb8 "/test/10.6_dbg/storage/innobase/btr/btr0pcur.cc", line=line@entry=366) at /test/10.6_dbg/storage/innobase/ut/ut0dbg.cc:60
      #3  0x000055f9584c3708 in btr_pcur_t::restore_position (this=this@entry=0x145aec02aea8, restore_latch_mode=restore_latch_mode@entry=BTR_SEARCH_LEAF, mtr=mtr@entry=0x145b2cafc740) at /test/10.6_dbg/storage/innobase/btr/btr0pcur.cc:366
      #4  0x000055f9583e55f3 in sel_restore_position_for_mysql (same_user_rec=same_user_rec@entry=0x145b2cafc0ab, latch_mode=latch_mode@entry=BTR_SEARCH_LEAF, pcur=pcur@entry=0x145aec02aea8, moves_up=moves_up@entry=true, mtr=mtr@entry=0x145b2cafc740) at /test/10.6_dbg/storage/innobase/row/row0sel.cc:3643
      #5  0x000055f9583f1320 in row_search_mvcc (buf=buf@entry=0x145aec01fed8 "\377", mode=PAGE_CUR_G, mode@entry=PAGE_CUR_UNSUPP, prebuilt=0x145aec02acd8, match_mode=match_mode@entry=0, direction=direction@entry=1) at /test/10.6_dbg/storage/innobase/row/row0sel.cc:4734
      #6  0x000055f958238a95 in ha_innobase::general_fetch (this=0x145aec02a440, buf=0x145aec01fed8 "\377", direction=direction@entry=1, match_mode=match_mode@entry=0) at /test/10.6_dbg/storage/innobase/handler/ha_innodb.cc:9387
      #7  0x000055f958238e1a in ha_innobase::rnd_next (this=0x145aec02a440, buf=<optimized out>) at /test/10.6_dbg/storage/innobase/handler/ha_innodb.cc:9590
      #8  0x000055f957e7a1c7 in handler::ha_rnd_next (this=0x145aec02a440, buf=0x145aec01fed8 "\377") at /test/10.6_dbg/sql/handler.cc:3460
      #9  0x000055f957b5447e in mysql_ha_read (thd=thd@entry=0x145aec000d48, tables=tables@entry=0x145aec013488, mode=RNEXT, keyname=0x0, key_expr=<optimized out>, ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at /test/10.6_dbg/sql/sql_handler.cc:910
      #10 0x000055f957ba7653 in mysql_execute_command (thd=thd@entry=0x145aec000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.6_dbg/sql/sql_limit.h:96
      #11 0x000055f957b904fe in mysql_parse (thd=thd@entry=0x145aec000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x145b2cafd2c0) at /test/10.6_dbg/sql/sql_parse.cc:8050
      #12 0x000055f957b9e492 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x145aec000d48, packet=packet@entry=0x145aec00af99 "", packet_length=packet_length@entry=19, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_class.h:1403
      #13 0x000055f957ba0bba in do_command (thd=0x145aec000d48, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1409
      #14 0x000055f957cf6e37 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55f95a5d0728, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1416
      #15 0x000055f957cf73ec in handle_one_connection (arg=arg@entry=0x55f95a5d0728) at /test/10.6_dbg/sql/sql_connect.cc:1318
      #16 0x000055f95816bace in pfs_spawn_thread (arg=0x55f95a5be6d8) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
      #17 0x0000145b36480609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #18 0x0000145b3606c133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.6.16 (dbg), 10.6.16 (opt), 10.9.8 (dbg), 10.9.8 (opt), 10.10.7 (dbg), 10.10.7 (opt), 10.11.6 (dbg),10.11.6 (opt), 11.0.4 (dbg), 11.0.4 (opt), 11.1.3 (dbg), 11.1.3 (opt), 11.2.2 (dbg), 11.2.2 (opt), 11.3.0 (dbg), 11.3.0 (opt)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.4.32 (dbg), 10.4.32 (opt), 10.5.23 (dbg), 10.5.23 (opt)

      Attachments

        Issue Links

          Activity

            People

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