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

mysqld crash with signal 11 when renaming table+max_statement_time

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.4.5, 10.4.10, 10.4
    • Fix Version/s: 10.4.13
    • Component/s: Parser
    • Labels:
      None

      Description

      When we try to rename table with 'SET STATEMENT max_statement_time=180' it crashes mysqld with signal 11. We could reproduce it easily even if the table doesn't exist.
      A simple rename table works fine without using 'SET STATEMEMT..'

      MariaDB [test]> SET STATEMENT max_statement_time=180 FOR RENAME TABLE bleh TO blah;
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      MariaDB [test]>
       
      Stack trace:
       
      Thread pointer: 0x7fa1480009a8
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7fa30c8d9e90 thread_stack 0x49000
      /glide/mariadb/10.4.12.test/bin/mysqld(my_print_stacktrace+0x2b)[0x5654a880aa6b]
      mysys/stacktrace.c:270(my_print_stacktrace)[0x5654a825bf87]
      sigaction.c:0(__restore_rt)[0x7fa3303b05d0]
      sql/sql_parse.cc:8165(st_select_lex::add_table_to_list(THD*, Table_ident*, st_mysql_const_lex_string*, unsigned long, thr_lock_type, enum_mdl_type, List<Index_hint>*, List<String>*, st_mysql_lex_string*))[0x5654a806a108]
      sql/sql_yacc.yy:9033(MYSQLparse(THD*))[0x5654a82017e3]
      sql/sql_parse.cc:10207(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x5654a806d08d]
      sql/sql_parse.cc:7856(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5654a80748b6]
      sql/sql_lex.h:4678(Parser_state::reset(char*, unsigned int))[0x5654a80760eb]
      sql/sql_parse.cc:1360(do_command(THD*))[0x5654a80778d1]
      sql/sql_connect.cc:1412(do_handle_one_connection(CONNECT*))[0x5654a8147902]
      sql/sql_connect.cc:1318(handle_one_connection)[0x5654a81479e4]
      perfschema/pfs.cc:1872(pfs_spawn_thread)[0x5654a83ef96d]
      pthread_create.c:0(start_thread)[0x7fa3303a8dd5]
      /lib64/libc.so.6(clone+0x6d)[0x7fa32f283ead]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7fa148013fe0): SET STATEMENT max_statement_time=180 FOR RENAME TABLE blah_datea TO blah
      Connection ID (thread ID): 12
      Status: NOT_KILLED
      

        Attachments

          Activity

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            muhammad.irfan Muhammad Irfan
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: