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

Server crashes with indexed by prefix virtual column

    XMLWordPrintable

    Details

      Description

      --source include/have_partition.inc
       
      CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, b CHAR(20), c CHAR(20) AS (b) VIRTUAL, KEY (c(10),a)) PARTITION BY HASH(pk);
      INSERT INTO t1 (pk,a,b) VALUES (1,10,'foo'),(2,11,'baz');
      SELECT a FROM t1;
       
      # Cleanup
      DROP TABLE t1;
      

      10.2 debug 4aeb2b1c

      #3  <signal handler called>
      #4  0x0000564fa8eb47be in Field::register_field_in_read_map (this=0x7fbafc0a3200) at /data/src/10.2/sql/field.cc:11251
      #5  0x0000564fa95e39aa in ha_partition::index_init (this=0x7fbafc0a20e8, inx=1, sorted=true) at /data/src/10.2/sql/ha_partition.cc:5258
      #6  0x0000564fa8bc2a79 in handler::ha_index_init (this=0x7fbafc0a20e8, idx=1, sorted=true) at /data/src/10.2/sql/handler.h:2837
      #7  0x0000564fa8cb3391 in join_read_first (tab=0x7fbafc014150) at /data/src/10.2/sql/sql_select.cc:19881
      #8  0x0000564fa8cb0db0 in sub_select (join=0x7fbafc013008, join_tab=0x7fbafc014150, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18892
      #9  0x0000564fa8cb0374 in do_select (join=0x7fbafc013008, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18439
      #10 0x0000564fa8c89e85 in JOIN::exec_inner (this=0x7fbafc013008) at /data/src/10.2/sql/sql_select.cc:3651
      #11 0x0000564fa8c8932c in JOIN::exec (this=0x7fbafc013008) at /data/src/10.2/sql/sql_select.cc:3446
      #12 0x0000564fa8c8a506 in mysql_select (thd=0x7fbafc000d90, tables=0x7fbafc0128e8, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fbafc012fe8, unit=0x7fbafc004988, select_lex=0x7fbafc0050d8) at /data/src/10.2/sql/sql_select.cc:3849
      #13 0x0000564fa8c7e65a in handle_select (thd=0x7fbafc000d90, lex=0x7fbafc0048c8, result=0x7fbafc012fe8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:361
      #14 0x0000564fa8c48cc0 in execute_sqlcom_select (thd=0x7fbafc000d90, all_tables=0x7fbafc0128e8) at /data/src/10.2/sql/sql_parse.cc:6271
      #15 0x0000564fa8c3f834 in mysql_execute_command (thd=0x7fbafc000d90) at /data/src/10.2/sql/sql_parse.cc:3582
      #16 0x0000564fa8c4ca7c in mysql_parse (thd=0x7fbafc000d90, rawbuf=0x7fbafc012708 "SELECT a FROM t1", length=16, parser_state=0x7fbb0e30c560, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7793
      #17 0x0000564fa8c3acd7 in dispatch_command (command=COM_QUERY, thd=0x7fbafc000d90, packet=0x7fbafc008b61 "", packet_length=16, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827
      #18 0x0000564fa8c397d2 in do_command (thd=0x7fbafc000d90) at /data/src/10.2/sql/sql_parse.cc:1381
      #19 0x0000564fa8d95453 in do_handle_one_connection (connect=0x564fabc34110) at /data/src/10.2/sql/sql_connect.cc:1336
      #20 0x0000564fa8d951b8 in handle_one_connection (arg=0x564fabc34110) at /data/src/10.2/sql/sql_connect.cc:1241
      #21 0x0000564fa95c18f4 in pfs_spawn_thread (arg=0x564fabc17440) at /data/src/10.2/storage/perfschema/pfs.cc:1869
      #22 0x00007fbb14810609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #23 0x00007fbb143eb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      The failure started happening after this commit:

      commit 7d9ba57da4843c05a4d11e63159a961c4eb79a04
      Author: Nikita Malyavin
      Date:   Mon Jun 21 17:48:45 2021 +0300
       
          [1/2] MDEV-18166 ASSERT_COLUMN_MARKED_FOR_READ failed on tables with vcols
          
          This is a 10.2+ part of a jira task
      

      Reproducible with at least MyISAM and InnoDB, on debug and non-debug builds, currently on 10.2 and 10.3 (the commit hasn't been merged into higher versions yet).

        Attachments

          Activity

            People

            Assignee:
            nikitamalyavin Nikita Malyavin
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration