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

Assertion `! is_set()' failed in Diagnostics_area::set_eof_status on executing ANALYZE SELECT via PS

    XMLWordPrintable

    Details

      Description

      The problem appeared on 10.1 tree with this revision

      commit d44dd54bc838e6679f451a8faf07a7f44efe2fa4
      Author: Sergei Petrunia <psergey@askmonty.org>
      Date:   Fri Oct 17 14:18:10 2014 +0400
       
          MDEV-6400: "ANALYZE SELECT ... INTO @var" doesn't set @var
          
          Make ANALYZE work for
          - ANALYZE SELECT ... INTO @var
          - ANALYZE INSERT SELECT ...;
          - ANALYZE SELECT .. INTO OUTFILE

      Test case

      prepare stmt from "analyze select * from mysql.user";
      execute stmt;

      Error log

      10.1/sql/sql_error.cc:406: void Diagnostics_area::set_eof_status(THD*): Assertion `! is_set()' failed.
      141105 14:27:33 [ERROR] mysqld got signal 6 ;

      #6  0x00007f459bd6a6f1 in *__GI___assert_fail (assertion=0x7f459ef8b687 "! is_set()", file=<optimized out>, line=406, function=0x7f459ef8c480 "void Diagnostics_area::set_eof_status(THD*)") at assert.c:81
      #7  0x00007f459e657f28 in Diagnostics_area::set_eof_status (this=0x7f45993fd100, thd=0x7f45993f8070) at 10.1/sql/sql_error.cc:406
      #8  0x00007f459e5d2da1 in my_eof (thd=0x7f45993f8070) at 10.1/sql/sql_class.h:3849
      #9  0x00007f459e641be1 in select_send::send_eof (this=0x7f4592900d60) at 10.1/sql/sql_class.cc:2697
      #10 0x00007f459e7df671 in Explain_query::send_explain (this=0x7f4592900860, thd=0x7f45993f8070) at 10.1/sql/sql_explain.cc:146
      #11 0x00007f459e688616 in execute_sqlcom_select (thd=0x7f45993f8070, all_tables=0x7f4592b2d698) at 10.1/sql/sql_parse.cc:5692
      #12 0x00007f459e67eac3 in mysql_execute_command (thd=0x7f45993f8070) at 10.1/sql/sql_parse.cc:2802
      #13 0x00007f459e6a51b0 in Prepared_statement::execute (this=0x7f4592a39470, expanded_query=0x7f459e14d550, open_cursor=false) at 10.1/sql/sql_prepare.cc:4038
      #14 0x00007f459e6a3ff9 in Prepared_statement::execute_loop (this=0x7f4592a39470, expanded_query=0x7f459e14d550, open_cursor=false, packet=0x0, packet_end=0x0) at 10.1/sql/sql_prepare.cc:3665
      #15 0x00007f459e6a2095 in mysql_sql_stmt_execute (thd=0x7f45993f8070) at 10.1/sql/sql_prepare.cc:2801
      #16 0x00007f459e67eaf4 in mysql_execute_command (thd=0x7f45993f8070) at 10.1/sql/sql_parse.cc:2813
      #17 0x00007f459e68b681 in mysql_parse (thd=0x7f45993f8070, rawbuf=0x7f45928ff088 "execute stmt", length=12, parser_state=0x7f459e14e1c0) at 10.1/sql/sql_parse.cc:6953
      #18 0x00007f459e67b741 in dispatch_command (command=COM_QUERY, thd=0x7f45993f8070, packet=0x7f4597bfa071 "", packet_length=12) at 10.1/sql/sql_parse.cc:1466
      #19 0x00007f459e67a55f in do_command (thd=0x7f45993f8070) at 10.1/sql/sql_parse.cc:1095
      #20 0x00007f459e7a7f27 in do_handle_one_connection (thd_arg=0x7f45993f8070) at 10.1/sql/sql_connect.cc:1351
      #21 0x00007f459e7a7c6c in handle_one_connection (arg=0x7f45993f8070) at 10.1/sql/sql_connect.cc:1262
      #22 0x00007f459ed39f2e in pfs_spawn_thread (arg=0x7f459b4249f0) at 10.1/storage/perfschema/pfs.cc:1860
      #23 0x00007f459dd84b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #24 0x00007f459be1b20d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      Stack trace from

      commit 43f185e171eecdce41e71c548ce0bc2bd6969c0f
      Author: Alexander Barkov <bar@mariadb.org>
      Date:   Mon Nov 3 21:45:06 2014 +0400

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: