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

Assertion `btr_page_get_index_id(btr_pcur_get_page(pcur)) == index->id' failed in row_search_mvcc

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.3(EOL), 10.4(EOL)
    • 10.5
    • Partitioning
    • None

    Description

      --source include/have_innodb.inc
      --source include/have_partition.inc
       
      CREATE TABLE t1 (pk int NOT NULL PRIMARY KEY, d1 decimal(10,0), KEY (d1)) ENGINE=InnoDB PARTITION BY KEY (pk) PARTITIONS 2;
      INSERT INTO t1 VALUES (1,0),(3,0);
       
      HANDLER t1 OPEN AS a1;
      HANDLER a1 READ d1 <= ( 76 );
      HANDLER a1 READ `PRIMARY` = ( 6 );
      HANDLER a1 READ `PRIMARY` PREV ;
      

      10.3 8a0944080c950349aaf7c81bc

      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x00007f71ce99e535 in __GI_abort () at abort.c:79
      #6  0x00007f71ce99e40f in __assert_fail_base (fmt=0x7f71ceb00ee0 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55bca30fdf70 "btr_page_get_index_id(btr_pcur_get_page(pcur)) == index->id", file=0x55bca30fc8b8 "/10.3/storage/innobase/row/row0sel.cc", line=4837, function=<optimized out>) at assert.c:92
      #7  0x00007f71ce9ac102 in __GI___assert_fail (assertion=0x55bca30fdf70 "btr_page_get_index_id(btr_pcur_get_page(pcur)) == index->id", file=0x55bca30fc8b8 "/10.3/storage/innobase/row/row0sel.cc", line=4837, function=0x55bca3100f20 <row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)::__PRETTY_FUNCTION__> "dberr_t row_search_mvcc(byte*, page_cur_mode_t, row_prebuilt_t*, ulint, ulint)") at assert.c:101
      #8  0x000055bca29131da in row_search_mvcc (buf=0xa5a5a5a5a5a5a5a7 <error: Cannot access memory at address 0xa5a5a5a5a5a5a5a7>, mode=PAGE_CUR_LE, prebuilt=0x7f71780b31c0, match_mode=0, direction=2) at /10.3/storage/innobase/row/row0sel.cc:4837
      #9  0x000055bca273a422 in ha_innobase::general_fetch (this=0x7f71781682f8, buf=0xa5a5a5a5a5a5a5a7 <error: Cannot access memory at address 0xa5a5a5a5a5a5a5a7>, direction=2, match_mode=0) at /10.3/storage/innobase/handler/ha_innodb.cc:9549
      #10 0x000055bca273a702 in ha_innobase::index_prev (this=0x7f71781682f8, buf=0xa5a5a5a5a5a5a5a7 <error: Cannot access memory at address 0xa5a5a5a5a5a5a5a7>) at /10.3/storage/innobase/handler/ha_innodb.cc:9643
      #11 0x000055bca250eeb6 in handler::ha_index_prev (this=0x7f71781682f8, buf=0xa5a5a5a5a5a5a5a7 <error: Cannot access memory at address 0xa5a5a5a5a5a5a5a7>) at /10.3/sql/handler.cc:2975
      #12 0x000055bca2d2a496 in ha_partition::handle_ordered_prev (this=0x7f7178167a98, buf=0x7f717803b158 "\245\006") at /10.3/sql/ha_partition.cc:8033
      #13 0x000055bca2d235de in ha_partition::index_prev (this=0x7f7178167a98, buf=0x7f717803b158 "\245\006") at /10.3/sql/ha_partition.cc:5938
      #14 0x000055bca250ee64 in handler::ha_index_prev (this=0x7f7178167a98, buf=0x7f717803b158 "\245\006") at /10.3/sql/handler.cc:2975
      #15 0x000055bca21a9d47 in mysql_ha_read (thd=0x7f7178000d50, tables=0x7f7178012bf0, mode=RPREV, keyname=0x7f7178013250 "PRIMARY", key_expr=0x7f7178013270, ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at /10.3/sql/sql_handler.cc:922
      #16 0x000055bca21f5ed0 in mysql_execute_command (thd=0x7f7178000d50) at /10.3/sql/sql_parse.cc:5492
      #17 0x000055bca21fd5ca in mysql_parse (thd=0x7f7178000d50, rawbuf=0x7f7178012a78 "HANDLER a1 READ `PRIMARY` PREV", length=30, parser_state=0x7f71c83b85c0, is_com_multi=false, is_next_command=false) at /10.3/sql/sql_parse.cc:7810
      #18 0x000055bca21e9f0c in dispatch_command (command=COM_QUERY, thd=0x7f7178000d50, packet=0x7f7178008ed1 "", packet_length=31, is_com_multi=false, is_next_command=false) at /10.3/sql/sql_parse.cc:1847
      #19 0x000055bca21e882f in do_command (thd=0x7f7178000d50) at /10.3/sql/sql_parse.cc:1393
      #20 0x000055bca236046a in do_handle_one_connection (connect=0x55bca6118100) at /10.3/sql/sql_connect.cc:1403
      #21 0x000055bca23601cc in handle_one_connection (arg=0x55bca6118100) at /10.3/sql/sql_connect.cc:1308
      #22 0x000055bca2cfb2d1 in pfs_spawn_thread (arg=0x55bca6396bf0) at /10.3/storage/perfschema/pfs.cc:1869
      #23 0x00007f71cf0f1fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486
      #24 0x00007f71cea754cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Issue Links

          Activity

            People

              holyfoot Alexey Botchkov
              alice Alice Sherepa
              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.