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

Assertion `0' failed in Explain_table_access::tag_to_json

    XMLWordPrintable

Details

    • 10.1.8-3

    Description

      CREATE TABLE t1 (i INT) ENGINE=MyISAM;
      EXPLAIN FORMAT=JSON SELECT * FROM t1;

      Stack trace from 10.1 commit 7cbecadf9b59d06f4d9a9e776f99418b273c2ebc

      10.1/sql/sql_explain.cc:1433: void Explain_table_access::tag_to_json(Json_writer*, explain_extra_tag): Assertion `0' failed.
      150923  2:38:17 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007ff45408e311 in *__GI___assert_fail (assertion=0x7ff457395a60 "0", file=<optimized out>, line=1433, function=0x7ff457397180 "void Explain_table_access::tag_to_json(Json_writer*, explain_extra_tag)") at assert.c:81
      #7  0x00007ff456b4023d in Explain_table_access::tag_to_json (this=0x7ff44b265298, writer=0x7ff45646e000, tag=ET_CONST_ROW_NOT_FOUND) at 10.1/sql/sql_explain.cc:1433
      #8  0x00007ff456b40c06 in Explain_table_access::print_explain_json (this=0x7ff44b265298, query=0x7ff44b264fe0, writer=0x7ff45646e000, is_analyze=false, fs_tracker=0x0, first_table_sort_used=false) at 10.1/sql/sql_explain.cc:1621
      #9  0x00007ff456b3ece7 in Explain_basic_join::print_explain_json_interns (this=0x7ff44b265150, query=0x7ff44b264fe0, writer=0x7ff45646e000, is_analyze=false, first_table_sort=0x0, first_table_sort_used=false) at 10.1/sql/sql_explain.cc:1002
      #10 0x00007ff456b3eb4f in Explain_select::print_explain_json (this=0x7ff44b265150, query=0x7ff44b264fe0, writer=0x7ff45646e000, is_analyze=false) at 10.1/sql/sql_explain.cc:961
      #11 0x00007ff456b3c582 in Explain_query::print_explain_json (this=0x7ff44b264fe0, output=0x7ff44b263940, is_analyze=false) at 10.1/sql/sql_explain.cc:223
      #12 0x00007ff4569dd61d in execute_sqlcom_select (thd=0x7ff44d176070, all_tables=0x7ff44b263288) at 10.1/sql/sql_parse.cc:5800
      #13 0x00007ff4569d3aeb in mysql_execute_command (thd=0x7ff44d176070) at 10.1/sql/sql_parse.cc:2962
      #14 0x00007ff4569e0f22 in mysql_parse (thd=0x7ff44d176070, rawbuf=0x7ff44b263088 "EXPLAIN FORMAT=JSON SELECT * FROM t1", length=36, parser_state=0x7ff45646f1a0) at 10.1/sql/sql_parse.cc:7227
      #15 0x00007ff4569cfc8a in dispatch_command (command=COM_QUERY, thd=0x7ff44d176070, packet=0x7ff44ed35071 "", packet_length=36) at 10.1/sql/sql_parse.cc:1488
      #16 0x00007ff4569ce9b0 in do_command (thd=0x7ff44d176070) at 10.1/sql/sql_parse.cc:1110
      #17 0x00007ff456b03961 in do_handle_one_connection (thd_arg=0x7ff44d176070) at 10.1/sql/sql_connect.cc:1350
      #18 0x00007ff456b036b2 in handle_one_connection (arg=0x7ff44d176070) at 10.1/sql/sql_connect.cc:1262
      #19 0x00007ff4570cf2cf in pfs_spawn_thread (arg=0x7ff453823d70) at 10.1/storage/perfschema/pfs.cc:1860
      #20 0x00007ff4560a9b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #21 0x00007ff45413e95d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.