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

Server crashes in ha_myisammrg::add_children_list upon CREATE OR REPLACE with MERGE

    XMLWordPrintable

Details

    Description

      Note: Reproducible on bb-10.11-midenok which already has a fix for MDEV-29698.

      --source include/have_log_bin.inc
      --source include/have_binlog_format_row.inc
       
      CREATE TABLE t (a INT) ENGINE=MyISAM;
      CREATE TEMPORARY TABLE tm (a INT) ENGINE=MERGE UNION=(t);
      CREATE OR REPLACE TABLE tt LIKE tm;
       
      # Cleanup
      DROP TABLE tt, tm, t;
      

      bb-10.11-midenok 8e82c973ee

      #3  <signal handler called>
      #4  0x000055f081ca72a0 in ha_myisammrg::add_children_list (this=0x61b00003dbb8) at /data/src/bb-10.11-midenok/storage/myisammrg/ha_myisammrg.cc:466
      #5  0x000055f081cae845 in ha_myisammrg::extra (this=0x61b00003dbb8, operation=HA_EXTRA_ADD_CHILDREN_LIST) at /data/src/bb-10.11-midenok/storage/myisammrg/ha_myisammrg.cc:1335
      #6  0x000055f0801dcf1e in mysql_create_like_table (thd=0x62c0000c0218, table=0x6290000e83c8, src_table=0x6290000e6af0, create_info=0x7f35fdaae7f0) at /data/src/bb-10.11-midenok/sql/sql_table.cc:5942
      #7  0x000055f0802107a2 in Sql_cmd_create_table_like::execute (this=0x6290000e62f0, thd=0x62c0000c0218) at /data/src/bb-10.11-midenok/sql/sql_table.cc:12817
      #8  0x000055f07ff1c392 in mysql_execute_command (thd=0x62c0000c0218, is_called_from_prepared_stmt=false) at /data/src/bb-10.11-midenok/sql/sql_parse.cc:5997
      #9  0x000055f07ff29692 in mysql_parse (thd=0x62c0000c0218, rawbuf=0x6290000e6238 "CREATE OR REPLACE TABLE tt LIKE tm", length=34, parser_state=0x7f35fdaafa90) at /data/src/bb-10.11-midenok/sql/sql_parse.cc:8023
      #10 0x000055f07feffde4 in dispatch_command (command=COM_QUERY, thd=0x62c0000c0218, packet=0x629000253219 "CREATE OR REPLACE TABLE tt LIKE tm", packet_length=34, blocking=true) at /data/src/bb-10.11-midenok/sql/sql_parse.cc:1894
      #11 0x000055f07fefcbc8 in do_command (thd=0x62c0000c0218, blocking=true) at /data/src/bb-10.11-midenok/sql/sql_parse.cc:1407
      #12 0x000055f0803a53d8 in do_handle_one_connection (connect=0x608000002638, put_in_cache=true) at /data/src/bb-10.11-midenok/sql/sql_connect.cc:1416
      #13 0x000055f0803a4d6e in handle_one_connection (arg=0x6080000025b8) at /data/src/bb-10.11-midenok/sql/sql_connect.cc:1318
      #14 0x000055f080f7f6d8 in pfs_spawn_thread (arg=0x617000005498) at /data/src/bb-10.11-midenok/storage/perfschema/pfs.cc:2201
      #15 0x00007f36073a9ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #16 0x00007f3606f98aef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Before MDEV-25292 CREATE OR REPLACE succeeds.

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.