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

Assertion `!element_started' failed in Json_writer& Json_writer::add_member(const char*)

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (a INT) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1),(2);
       
      CREATE TABLE t2 (column_name_1 INT, column_name_2 VARCHAR(52)) ENGINE=InnoDB;
      INSERT INTO t2 VALUES (3,'United States');
       
      CREATE TABLE t3 (b INT, c VARCHAR(3), PRIMARY KEY (c,b)) ENGINE=InnoDB;
      INSERT INTO t3 VALUES (4,'USA'),(5,'CAN');
       
      EXPLAIN FORMAT=JSON SELECT * FROM t1 WHERE 0 < ALL ( 
        SELECT tbl_alias1.column_name_1 FROM t2 AS tbl_alias1, t3 AS tbl_alias2 
        WHERE tbl_alias2.b = tbl_alias1.column_name_1 AND tbl_alias2.c = tbl_alias1.column_name_2 
      );

      Stack trace from d1522af7

      sql/my_json_writer.cc:86: Json_writer& Json_writer::add_member(const char*): Assertion `!element_started' failed.
      141204 20:14:59 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007faec77f06f1 in *__GI___assert_fail (assertion=0x7faecaa918f4 "!element_started", file=<optimized out>, line=86, function=0x7faecaa919a0 "Json_writer& Json_writer::add_member(const char*)") at assert.c:81
      #7  0x00007faeca29ac7c in Json_writer::add_member (this=0x7faec9bc9020, name=0x7faec9bc902c "ref") at 10.1/sql/my_json_writer.cc:86
      #8  0x00007faeca29b3f3 in Single_line_formatting_helper::disable_and_flush (this=0x7faec9bc9028) at 10.1/sql/my_json_writer.cc:326
      #9  0x00007faeca29b221 in Single_line_formatting_helper::on_add_str (this=0x7faec9bc9028, str=0x7faec9bc9030 "test.tbl_alias1.column_name_2") at 10.1/sql/my_json_writer.cc:271
      #10 0x00007faeca29af31 in Json_writer::add_str (this=0x7faec9bc9020, str=0x7faec9bc9030 "test.tbl_alias1.column_name_2") at 10.1/sql/my_json_writer.cc:168
      #11 0x00007faeca29b422 in Single_line_formatting_helper::disable_and_flush (this=0x7faec9bc9028) at 10.1/sql/my_json_writer.cc:334
      #12 0x00007faeca29b221 in Single_line_formatting_helper::on_add_str (this=0x7faec9bc9028, str=0x7faec9bc9030 "test.tbl_alias1.column_name_2") at 10.1/sql/my_json_writer.cc:271
      #13 0x00007faeca29af31 in Json_writer::add_str (this=0x7faec9bc9020, str=0x7faec9bc9030 "test.tbl_alias1.column_name_2") at 10.1/sql/my_json_writer.cc:168
      #14 0x00007faeca29b422 in Single_line_formatting_helper::disable_and_flush (this=0x7faec9bc9028) at 10.1/sql/my_json_writer.cc:334
      #15 0x00007faeca29b1a7 in Single_line_formatting_helper::on_add_str (this=0x7faec9bc9028, str=0x7faeb32dd780 "test.tbl_alias1.column_name_1") at 10.1/sql/my_json_writer.cc:259
      #16 0x00007faeca29af31 in Json_writer::add_str (this=0x7faec9bc9020, str=0x7faeb32dd780 "test.tbl_alias1.column_name_1") at 10.1/sql/my_json_writer.cc:168
      #17 0x00007faeca273361 in Explain_table_access::print_explain_json (this=0x7faeb32dd448, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:1211
      #18 0x00007faeca271b2e in Explain_basic_join::print_explain_json (this=0x7faeb32dd118, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:739
      #19 0x00007faeca271a3a in Explain_select::print_explain_json (this=0x7faeb32dd118, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:720
      #20 0x00007faeca2713b1 in Explain_node::print_explain_json_for_children (this=0x7faeb32ddf40, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:590
      #21 0x00007faeca271b8b in Explain_basic_join::print_explain_json (this=0x7faeb32ddf40, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:744
      #22 0x00007faeca271a3a in Explain_select::print_explain_json (this=0x7faeb32ddf40, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:720
      #23 0x00007faeca26ffb0 in Explain_query::print_explain_json (this=0x7faeb32dd0a8, output=0x7faeb326cec0, is_analyze=false) at 10.1/sql/sql_explain.cc:205
      #24 0x00007faeca117d57 in execute_sqlcom_select (thd=0x7faec01c8070, all_tables=0x7faeb3182408) at 10.1/sql/sql_parse.cc:5706
      #25 0x00007faeca10e6c3 in mysql_execute_command (thd=0x7faec01c8070) at 10.1/sql/sql_parse.cc:2892
      #26 0x00007faeca11b1d7 in mysql_parse (thd=0x7faec01c8070, rawbuf=0x7faeb3182088 "EXPLAIN FORMAT=JSON SELECT * FROM t1 WHERE 0 < ALL ( \nSELECT tbl_alias1.column_name_1 FROM t2 AS tbl_alias1, t3 AS tbl_alias2 \nWHERE tbl_alias2.b = tbl_alias1.column_name_1 AND tbl_alias2.c = tbl_alia"..., length=219, parser_state=0x7faec9bca1c0) at 10.1/sql/sql_parse.cc:7028
      #27 0x00007faeca10aade in dispatch_command (command=COM_QUERY, thd=0x7faec01c8070, packet=0x7faec02a0071 "", packet_length=219) at 10.1/sql/sql_parse.cc:1460
      #28 0x00007faeca1098fc in do_command (thd=0x7faec01c8070) at 10.1/sql/sql_parse.cc:1089
      #29 0x00007faeca238538 in do_handle_one_connection (thd_arg=0x7faec01c8070) at 10.1/sql/sql_connect.cc:1347
      #30 0x00007faeca23827d in handle_one_connection (arg=0x7faec01c8070) at 10.1/sql/sql_connect.cc:1258
      #31 0x00007faeca7d4fee in pfs_spawn_thread (arg=0x7faec0240770) at 10.1/storage/perfschema/pfs.cc:1860
      #32 0x00007faec980ab50 in start_thread (arg=<optimized out>) at pthread_create.c:304

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              psergei Sergei Petrunia
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration