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

LP:602278 - RQG: crash in String::free on EXPLAIN SELECT + subquery

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Not a Bug
    • None
    • None
    • None

    Description

      When executing the query below against the maria-5.3-subqueries tree, the server crashes as follows:

      #3 0x0821f8b4 in handle_segfault (sig=11) at mysqld.cc:2683
      #4 <signal handler called>
      #5 0x0815b8cb in String::free (this=0x1622d9d8) at sql_string.h:203
      #6 0x0815b8bf in String::~String (this=0x1622d9d8, __in_chrg=<value optimized out>) at sql_string.h:102
      #7 0x0817ea94 in Copy_field::~Copy_field (this=0x1622d9ac, __in_chrg=<value optimized out>) at field.h:2228
      #8 0x081805da in TMP_TABLE_PARAM::cleanup (this=0xb5c37eec) at sql_class.h:2806
      #9 0x082b02a0 in JOIN::cleanup (this=0xb5c33258, full=true) at sql_select.cc:7919
      #10 0x082a13eb in JOIN::destroy (this=0xb5c33258) at sql_select.cc:2237
      #11 0x082a13c4 in JOIN::destroy (this=0xb5c2d378) at sql_select.cc:2233
      #12 0x083cde13 in st_select_lex::cleanup (this=0xb5efad98) at sql_union.cc:831
      #13 0x083cda43 in st_select_lex_unit::cleanup (this=0xb5efaf30) at sql_union.cc:697
      #14 0x083cde68 in st_select_lex::cleanup (this=0x93a4fa8) at sql_union.cc:838
      #15 0x083cda43 in st_select_lex_unit::cleanup (this=0x93a4d20) at sql_union.cc:697
      #16 0x0823cbb5 in mysql_parse (thd=0x93a37c8,
      inBuf=0xb5e4bf00 "EXPLAIN\nSELECT table1 .`col_varchar_key`\nFROM (\nSELECT *\nFROM CC ) table1 STRAIGHT_JOIN ( B table2 JOIN CC table3 ON table2 .`col_int_nokey` ) ON table2 .`col_int_nokey`\nWHERE table1 .`col_varch"..., length=362, found_semicolon=0xb61d3228) at sql_parse.cc:6096
      #17 0x0822ee15 in dispatch_command (command=COM_QUERY, thd=0x93a37c8, packet=0x9469971 "", packet_length=365) at sql_parse.cc:1253
      #18 0x0822e053 in do_command (thd=0x93a37c8) at sql_parse.cc:891
      #19 0x0822c4a6 in handle_one_connection (arg=0x93a37c8) at sql_connect.cc:1599
      #20 0x00a08919 in start_thread () from /lib/libpthread.so.0
      #21 0x00951e5e in clone () from /lib/libc.so.6

      bzr version-info:

      revision-id: tsk@zen-20100601221000-puyh3el4utyselh9
      date: 2010-06-02 01:10:00 +0300
      build-date: 2010-07-06 07:12:46 -0700
      revno: 2794
      branch-nick: maria-5.3-subqueries

      maria-5.3 is not affected, but Timour reports that the 5.3-subqueries tree does contain extra patches.

      Attachments

        Activity

          People

            timour Timour Katchaounov (Inactive)
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.