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

Server crashes in multi_delete::~multi_delete upon PS deleting from view

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (a INT);
       
      CREATE ALGORITHM = MERGE VIEW v1 AS SELECT * FROM t1;
      PREPARE stmt FROM 'DELETE A FROM v1 AS A WHERE 0';
      EXECUTE stmt;
       
      # Cleanup
      DROP VIEW v1;
      DROP TABLE t1;
      

      10.0 bcc677bb

      #3  <signal handler called>
      #4  0x00000000009987e6 in multi_delete::~multi_delete (this=0x7f103d4fa280, __in_chrg=<optimized out>) at /data/src/10.0/sql/sql_delete.cc:981
      #5  0x00000000009988b4 in multi_delete::~multi_delete (this=0x7f103d4fa280, __in_chrg=<optimized out>) at /data/src/10.0/sql/sql_delete.cc:989
      #6  0x0000000000650165 in mysql_execute_command (thd=0x7f103eea2070) at /data/src/10.0/sql/sql_parse.cc:3664
      #7  0x0000000000670242 in Prepared_statement::execute (this=0x7f103d516470, expanded_query=0x7f1046f52bd0, open_cursor=false) at /data/src/10.0/sql/sql_prepare.cc:3975
      #8  0x000000000066f310 in Prepared_statement::execute_loop (this=0x7f103d516470, expanded_query=0x7f1046f52bd0, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.0/sql/sql_prepare.cc:3629
      #9  0x000000000066d5fe in mysql_sql_stmt_execute (thd=0x7f103eea2070) at /data/src/10.0/sql/sql_prepare.cc:2779
      #10 0x000000000064d48b in mysql_execute_command (thd=0x7f103eea2070) at /data/src/10.0/sql/sql_parse.cc:2567
      #11 0x0000000000657d64 in mysql_parse (thd=0x7f103eea2070, rawbuf=0x7f103d4fa088 "EXECUTE stmt", length=12, parser_state=0x7f1046f53640) at /data/src/10.0/sql/sql_parse.cc:6637
      #12 0x000000000064a684 in dispatch_command (command=COM_QUERY, thd=0x7f103eea2070, packet=0x7f10403e5071 "EXECUTE stmt", packet_length=12) at /data/src/10.0/sql/sql_parse.cc:1300
      #13 0x0000000000649984 in do_command (thd=0x7f103eea2070) at /data/src/10.0/sql/sql_parse.cc:1003
      #14 0x000000000076acdc in do_handle_one_connection (thd_arg=0x7f103eea2070) at /data/src/10.0/sql/sql_connect.cc:1377
      #15 0x000000000076aa4e in handle_one_connection (arg=0x7f103eea2070) at /data/src/10.0/sql/sql_connect.cc:1292
      #16 0x0000000000accef0 in pfs_spawn_thread (arg=0x7f103eda2370) at /data/src/10.0/storage/perfschema/pfs.cc:1861
      #17 0x00007f1046b87494 in start_thread (arg=0x7f1046f54700) at pthread_create.c:333
      #18 0x00007f1044f4093f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Reproducible on all of 5.5-10.3, debug and non-debug builds, with at least MyISAM and InnoDB.

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              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.