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

Galera crashes when converting table to partition

    XMLWordPrintable

    Details

      Description

      CREATE TABLE t3 (c INT) PARTITION BY RANGE (c) (PARTITION p1 VALUES LESS THAN (1000));
      CREATE TABLE tp2 (c INT);
      ALTER TABLE t3 CONVERT TABLE tp2 TO PARTITION p2 VALUES LESS THAN (2000);
      

      Leads to

      10.7.1 8bd21167d28748bea8717183534db1103a696755 (Optimized)

      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000056005b23ee2f in my_write_core (sig=sig@entry=11) at /test/10.7_opt/mysys/stacktrace.c:424
      #2  0x000056005ace6860 in handle_fatal_signal (sig=11) at /test/10.7_opt/sql/signal_handler.cc:345
      #3  <signal handler called>
      #4  0x000056005aa35611 in wait_while_table_is_used (thd=thd@entry=0x145ff0000c58, table=table@entry=0x0, function=function@entry=HA_EXTRA_PREPARE_FOR_RENAME) at /test/10.7_opt/sql/sql_base.cc:1313
      #5  0x000056005aabcdcd in fast_alter_partition_table (thd=thd@entry=0x145ff0000c58, table=table@entry=0x56005dd885c8, alter_info=alter_info@entry=0x1460680aa430, alter_ctx=alter_ctx@entry=0x1460680a9720, 
          create_info=create_info@entry=0x1460680aa520, table_list=0x145ff00109e8) at /test/10.7_opt/sql/sql_partition.cc:7530
      #6  0x000056005ab619b8 in mysql_alter_table (thd=thd@entry=0x145ff0000c58, new_db=new_db@entry=0x145ff0005738, new_name=new_name@entry=0x145ff0005b50, create_info=create_info@entry=0x1460680aa520, 
          table_list=<optimized out>, table_list@entry=0x145ff00109e8, alter_info=alter_info@entry=0x1460680aa430, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.7_opt/sql/sql_table.cc:9998
      #7  0x000056005abcd007 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x145ff0000c58) at /test/10.7_opt/sql/structs.h:568
      #8  0x000056005aaab276 in mysql_execute_command (thd=0x145ff0000c58, is_called_from_prepared_stmt=<optimized out>) at /test/10.7_opt/sql/sql_parse.cc:5989
      #9  0x000056005aa9af17 in mysql_parse (thd=0x145ff0000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/10.7_opt/sql/sql_parse.cc:8028
      #10 0x000056005aa9a6d1 in wsrep_mysql_parse (thd=0x145ff0000c58, rawbuf=0x145ff00108b0 "ALTER TABLE t3 CONVERT TABLE tp2 TO PARTITION p2 VALUES LESS THAN (2000)", length=72, parser_state=0x1460680ab440)
          at /test/10.7_opt/sql/sql_parse.cc:7841
      #11 0x000056005aaa883a in dispatch_command (command=COM_QUERY, thd=0x145ff0000c58, packet=0x145ff0008589 "ALTER TABLE t3 CONVERT TABLE tp2 TO PARTITION p2 VALUES LESS THAN (2000)", 
          packet_length=<optimized out>, blocking=<optimized out>) at /test/10.7_opt/sql/sql_class.h:1360
      #12 0x000056005aaa9358 in do_command (thd=0x145ff0000c58, blocking=blocking@entry=true) at /test/10.7_opt/sql/sql_parse.cc:1402
      #13 0x000056005abc8007 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /test/10.7_opt/sql/sql_connect.cc:1418
      #14 0x000056005abc835d in handle_one_connection (arg=arg@entry=0x56005dddfa08) at /test/10.7_opt/sql/sql_connect.cc:1312
      #15 0x000056005af3265d in pfs_spawn_thread (arg=0x56005dde5ce8) at /test/10.7_opt/storage/perfschema/pfs.cc:2201
      #16 0x000014606b80a609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #17 0x000014606b3f9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.7.1 (opt), 10.7.1 (dbg)

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.