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

    XMLWordPrintable

    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

              People

              Assignee:
              shulga Dmitry Shulga
              Reporter:
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: