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

Server crashes in Field::register_field_in_read_map upon INSERT DELAYED with virtual columns

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5, 10.6, 10.7
    • Fix Version/s: 10.5, 10.6
    • Component/s: Virtual Columns
    • Labels:
      None

      Description

      CREATE TABLE t (
        id INT AUTO_INCREMENT,
        a varchar(16) NOT NULL DEFAULT '',
        b varchar(16) GENERATED ALWAYS AS (a) VIRTUAL,
        KEY `col_year` (b(8),id)
      ) ENGINE=MyISAM;
       
      INSERT DELAYED INTO t (a) VALUES ('foo'),('bar');
       
      # Cleanup
      DROP TABLE t;
      

      10.5 f1ba07a0

      #3  <signal handler called>
      #4  0x0000565526134adc in Field::register_field_in_read_map (this=0x7f9b50017498) at /data/src/10.5/sql/field.cc:11277
      #5  0x0000565525f34fb7 in do_mark_index_columns (table=0x7f9b50016c80, index=0, bitmap=0x7f9b50016db0, read=true) at /data/src/10.5/sql/table.cc:7204
      #6  0x0000565525f3f39a in TABLE::mark_index_columns_for_read (this=0x7f9b50016c80, index=0) at /data/src/10.5/sql/table.cc:7224
      #7  0x0000565525f35168 in TABLE::mark_auto_increment_column (this=0x7f9b50016c80) at /data/src/10.5/sql/table.cc:7245
      #8  0x0000565525f357c6 in TABLE::mark_columns_needed_for_insert (this=0x7f9b50016c80) at /data/src/10.5/sql/table.cc:7442
      #9  0x0000565525d8db39 in mysql_insert (thd=0x7f9b50000db8, table_list=0x7f9b50015408, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/src/10.5/sql/sql_insert.cc:945
      #10 0x0000565525de23af in mysql_execute_command (thd=0x7f9b50000db8) at /data/src/10.5/sql/sql_parse.cc:4624
      #11 0x0000565525dedeaa in mysql_parse (thd=0x7f9b50000db8, rawbuf=0x7f9b50015300 "INSERT DELAYED INTO t (a) VALUES ('foo'),('bar')", length=48, parser_state=0x7f9b6078d490, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8100
      #12 0x0000565525dd9e1d in dispatch_command (command=COM_QUERY, thd=0x7f9b50000db8, packet=0x7f9b5000b5b9 "INSERT DELAYED INTO t (a) VALUES ('foo'),('bar')", packet_length=48, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1891
      #13 0x0000565525dd860f in do_command (thd=0x7f9b50000db8) at /data/src/10.5/sql/sql_parse.cc:1370
      #14 0x0000565525f89b84 in do_handle_one_connection (connect=0x5655290f6168, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1418
      #15 0x0000565525f89837 in handle_one_connection (arg=0x565528ffcd78) at /data/src/10.5/sql/sql_connect.cc:1312
      #16 0x00005655264afb19 in pfs_spawn_thread (arg=0x5655290f5b38) at /data/src/10.5/storage/perfschema/pfs.cc:2201
      #17 0x00007f9b66437609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #18 0x00007f9b6600a293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Reproducible on 10.5+, but on some reason not on 10.2-10.4.

      The failure has some relation to MDEV-26220, but due to the complicated history of the bugfix I can't find out whether it fixed the problem in 10.2-10.4 but not in 10.5, or introduced the problem in 10.5, or something else happened.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:

                Git Integration