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

should_send_column_info(): Assertion `cmd == COM_STMT_EXECUTE || cmd == COM_STMT_PREPARE' failed

Details

    Description

      On merge to 10.6, the test case of MDEV-25197 triggers an assertion failure:

      10.6 a1e70388c45a0908c35443ba1df93ea8502b727a with the merge of 6c3e860cbf36831c118f6ea183acbbeb3c889bed

      main.ps                                  [ fail ]
              Test ended at 2021-04-14 12:13:47
       
      CURRENT_TEST: main.ps
      /dev/shm/10.6a/client/mysqltest: Error on delete of '/dev/shm/10.6a/mysql-test/var/tmp/f1.txt' (Errcode: 2 "No such file or directory")
      mysqltest: At line 5029: query 'EXECUTE stmt' failed: 2013: Lost connection to MySQL server during query
      ...
      2021-04-14 12:13:45 5 [Note] Deleted Master_info file '/dev/shm/10.6a/mysql-test/var/mysqld.1/data/relay-log.info'.
      mariadbd: /mariadb/10.6/sql/protocol.cc:1138: bool should_send_column_info(THD*, List<Item>*, uint): Assertion `cmd == COM_STMT_EXECUTE || cmd == COM_STMT_PREPARE' failed.
      ...
      #8  0x000055a0b8cce61a in should_send_column_info (thd=0x62b0002ca218, list=list@entry=0x62b00007ffe0, flags=flags@entry=3) at /mariadb/10.6/sql/protocol.cc:1138
      #9  0x000055a0b8cd5d9e in Protocol::send_result_set_metadata (this=0x62b0002ca800, list=<optimized out>, flags=<optimized out>) at /mariadb/10.6/sql/protocol.cc:1176
      #10 0x000055a0b8e590eb in select_send::send_result_set_metadata (this=0x62b000080c30, list=<optimized out>, flags=<optimized out>) at /mariadb/10.6/sql/sql_class.cc:2975
      #11 0x000055a0b9131bc6 in JOIN::exec_inner (this=this@entry=0x62b0002d1418) at /mariadb/10.6/sql/sql_select.cc:4336
      #12 0x000055a0b913309f in JOIN::exec (this=this@entry=0x62b0002d1418) at /mariadb/10.6/sql/sql_select.cc:4273
      #13 0x000055a0b912e08a in mysql_select (thd=thd@entry=0x62b0002ca218, tables=0x0, fields=@0x62b00007ffe0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x62b0000803e0, last = 0x62b0000803e0, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x62b000080c30, unit=0x62b00007e310, select_lex=0x62b00007fe90) at /mariadb/10.6/sql/sql_select.cc:4749
      #14 0x000055a0b912ee11 in handle_select (thd=thd@entry=0x62b0002ca218, lex=lex@entry=0x62b00007e248, result=result@entry=0x62b000080c30, setup_tables_done_option=setup_tables_done_option@entry=0) at /mariadb/10.6/sql/sql_select.cc:419
      #15 0x000055a0b8f9c9a3 in execute_sqlcom_select (thd=thd@entry=0x62b0002ca218, all_tables=<optimized out>) at /mariadb/10.6/sql/sql_parse.cc:6244
      #16 0x000055a0b8fc2ab9 in mysql_execute_command (thd=0x62b0002ca218) at /mariadb/10.6/sql/sql_parse.cc:3940
      #17 0x000055a0b9012e2f in Prepared_statement::execute (this=this@entry=0x619000155998, expanded_query=expanded_query@entry=0x7fd8e4496d30, open_cursor=open_cursor@entry=false) at /mariadb/10.6/sql/sql_prepare.cc:5049
      #18 0x000055a0b901398c in Prepared_statement::execute_loop (this=this@entry=0x619000155998, expanded_query=expanded_query@entry=0x7fd8e4496d30, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /mariadb/10.6/sql/sql_prepare.cc:4511
      #19 0x000055a0b90148fb in mysql_sql_stmt_execute (thd=thd@entry=0x62b0002ca218) at /mariadb/10.6/sql/sql_prepare.cc:3579
      #20 0x000055a0b8fc2b23 in mysql_execute_command (thd=thd@entry=0x62b0002ca218) at /mariadb/10.6/sql/sql_parse.cc:3956
      #21 0x000055a0b8fd2a32 in mysql_parse (thd=thd@entry=0x62b0002ca218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fd8e4497b30) at /mariadb/10.6/sql/sql_parse.cc:8017
      #22 0x000055a0b8fd9d3c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62b0002ca218, packet=packet@entry=0x629000285219 "EXECUTE stmt", packet_length=packet_length@entry=12, blocking=blocking@entry=true) at /mariadb/10.6/sql/sql_parse.cc:1897
      

      I will temporarily disable this part of the test in 10.6 so that the merge can proceed.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              shulga Dmitry Shulga
              marko Marko Mäkelä
              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.