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

Server crashes in QPF_query::print_explain with log_slow_verbosity='query_plan,explain'

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • None
    • 10.0.5
    • None
    • None

    Description

      bzr version-info
      revision-id: psergey@askmonty.org-20130919043358-hkwt0vyh9zl9xhy5
      revno: 3691
      branch-nick: 10.0-base-explain-slowquerylog

      #3  <signal handler called>
      #4  0x000000000076f5f2 in QPF_query::print_explain (this=0x7f5620006af0, output=0x7f567036fc20, explain_flags=0 '\000') at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:119
      #5  0x000000000076f6d2 in QPF_query::print_explain_str (this=0x7f5620006af0, thd=0x3c8edb8, out_str=0x7f567036fdb0) at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:135
      #6  0x000000000076f646 in print_qpf_query (lex=0x3c92270, thd=0x3c8edb8, str=0x7f567036fdb0) at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:125
      #7  0x00000000008d3097 in MYSQL_QUERY_LOG::write (this=0x263e4d0, thd=0x3c8edb8, current_time=1379697846, user_host=0x7f5670370250 "root[root] @ localhost [127.0.0.1]", user_host_len=34, query_utime=122, lock_utime=0, is_command=false, sql_text=0x7f56200187a0 "set long_query_time=0.000001", sql_text_len=28) at 10.0-base-explain-slowquerylog/sql/log.cc:2833
      #8  0x00000000008ce232 in Log_to_file_event_handler::log_slow (this=0x263df80, thd=0x3c8edb8, current_time=..., user_host=0x7f5670370250 "root[root] @ localhost [127.0.0.1]", user_host_len=34, query_utime=122, lock_utime=0, is_command=false, sql_text=0x7f56200187a0 "set long_query_time=0.000001", sql_text_len=28) at 10.0-base-explain-slowquerylog/sql/log.cc:996
      #9  0x00000000008ced09 in LOGGER::slow_log_print (this=0x1593b80, thd=0x3c8edb8, query=0x7f56200187a0 "set long_query_time=0.000001", query_length=28, current_utime=2112774371346) at 10.0-base-explain-slowquerylog/sql/log.cc:1287
      #10 0x00000000008db047 in slow_log_print (thd=0x3c8edb8, query=0x7f56200187a0 "set long_query_time=0.000001", query_length=28, current_utime=2112774371346) at 10.0-base-explain-slowquerylog/sql/log.cc:5870
      #11 0x000000000061fcb1 in log_slow_statement (thd=0x3c8edb8) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:1566
      #12 0x000000000061f965 in dispatch_command (command=COM_QUERY, thd=0x3c8edb8, packet=0x3c93b29 "", packet_length=28) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:1495
      #13 0x000000000061d923 in do_command (thd=0x3c8edb8) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:812
      #14 0x000000000073da47 in do_handle_one_connection (thd_arg=0x3c8edb8) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1266
      #15 0x000000000073d7b5 in handle_one_connection (arg=0x3c8edb8) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1181
      #16 0x00007f5672a4ce9a in start_thread (arg=0x7f5670371700) at pthread_create.c:308
      #17 0x00007f5671d40cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      set global slow_query_log=1;
      set long_query_time=0.000001;
      set log_slow_verbosity='query_plan,explain';
      set autocommit = 1; 

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              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.