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

Assertion failure in ddl_log_increment_phase_no_lock upon partition operations with spider plugin loaded

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      --let $restart_parameters= --plugin-load-add=ha_spider
      --source include/restart_mysqld.inc
       
      CREATE TABLE t (a INT) PARTITION BY HASH (a) PARTITIONS 2;
      ALTER TABLE t REBUILD PARTITION p0;
      

      10.10 d5e15424

      mariadbd: /data/src/10.10/sql/ddl_log.cc:879: bool ddl_log_increment_phase_no_lock(uint): Assertion `0' failed.
      231020 21:18:28 [ERROR] mysqld got signal 6 ;
       
      #9  0x00007f5efb253df2 in __GI___assert_fail (assertion=0x558eb0416c20 "0", file=0x558eb0416160 "/data/src/10.10/sql/ddl_log.cc", line=879, function=0x558eb0417160 "bool ddl_log_increment_phase_no_lock(uint)") at ./assert/assert.c:101
      #10 0x0000558eae6123fa in ddl_log_increment_phase_no_lock (entry_pos=1) at /data/src/10.10/sql/ddl_log.cc:879
      #11 0x0000558eae61d1ab in ddl_log_increment_phase (entry_pos=1) at /data/src/10.10/sql/ddl_log.cc:2594
      #12 0x0000558eaf2f5477 in ha_partition::rename_partitions (this=0x61d0004c36b8, path=0x7f5ee7b869d0 "./test/t") at /data/src/10.10/sql/ha_partition.cc:1183
      #13 0x0000558eaebb9c13 in handler::ha_rename_partitions (this=0x61d0004c36b8, path=0x7f5ee7b869d0 "./test/t") at /data/src/10.10/sql/handler.cc:5608
      #14 0x0000558eae311174 in mysql_rename_partitions (lpt=0x7f5ee7b86e60) at /data/src/10.10/sql/sql_partition.cc:6204
      #15 0x0000558eae31cf03 in fast_alter_partition_table (thd=0x62c000210218, table=0x619000232d98, alter_info=0x7f5ee7b89f70, alter_ctx=0x7f5ee7b890f0, create_info=0x7f5ee7b8a120, table_list=0x629000316358) at /data/src/10.10/sql/sql_partition.cc:7863
      #16 0x0000558eae5b7143 in mysql_alter_table (thd=0x62c000210218, new_db=0x62c000214f70, new_name=0x62c0002153c0, create_info=0x7f5ee7b8a120, table_list=0x629000316358, recreate_info=0x7f5ee7b89ed0, alter_info=0x7f5ee7b89f70, order_num=0, order=0x0, ignore=false, if_exists=false) at /data/src/10.10/sql/sql_table.cc:10596
      #17 0x0000558eae77f19d in Sql_cmd_alter_table::execute (this=0x629000316aa8, thd=0x62c000210218) at /data/src/10.10/sql/sql_alter.cc:685
      #18 0x0000558eae2ca4fd in mysql_execute_command (thd=0x62c000210218, is_called_from_prepared_stmt=false) at /data/src/10.10/sql/sql_parse.cc:6026
      #19 0x0000558eae2d7898 in mysql_parse (thd=0x62c000210218, rawbuf=0x629000316238 "ALTER TABLE t REBUILD PARTITION p0", length=34, parser_state=0x7f5ee7b8b9f0) at /data/src/10.10/sql/sql_parse.cc:8054
      #20 0x0000558eae2ad4f9 in dispatch_command (command=COM_QUERY, thd=0x62c000210218, packet=0x62900030c219 "ALTER TABLE t REBUILD PARTITION p0", packet_length=34, blocking=true) at /data/src/10.10/sql/sql_parse.cc:1894
      #21 0x0000558eae2aa24a in do_command (thd=0x62c000210218, blocking=true) at /data/src/10.10/sql/sql_parse.cc:1407
      #22 0x0000558eae7603ea in do_handle_one_connection (connect=0x608000007138, put_in_cache=true) at /data/src/10.10/sql/sql_connect.cc:1416
      #23 0x0000558eae75fdab in handle_one_connection (arg=0x608000007138) at /data/src/10.10/sql/sql_connect.cc:1318
      #24 0x0000558eaf358c14 in pfs_spawn_thread (arg=0x617000036818) at /data/src/10.10/storage/perfschema/pfs.cc:2201
      #25 0x00007f5efb2a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #26 0x00007f5efb3285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      The failure started happening after this commit in 10.10:

      commit a60cf9c7ae4ae012443a6a91db4ee265fa6e4403
      Author: Yuchen Pei
      Date:   Thu Oct 5 16:19:10 2023 +1100
       
          MDEV-22979 MDEV-27233 MDEV-28218 Fixing spider init bugs
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.