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

Assertion failure upon DROP TRIGGER between backup stages

    XMLWordPrintable

Details

    Description

      Note: I'm labeling it a regression assuming that the newly added assertion may be too strict. If it's in fact an old problem which the new assertion correctly reveals, feel free to remove the label.

      BACKUP STAGE START;
      BACKUP STAGE BLOCK_COMMIT;
      DROP TRIGGER IF EXISTS a;
      

      10.6 c62671543976eb397576f1b57fb6817029bc21ee

      mariadbd: /data/bld/10.6-asan-ubsan/sql/backup.cc:613: void backup_log_ddl(const backup_log_info*): Assertion `backup_stage <= BACKUP_WAIT_FOR_FLUSH || backup_stage >= BACKUP_END' failed.
      250506  0:32:39 [ERROR] /share8t/bld/10.6-asan-ubsan/sql/mariadbd got signal 6 ;
       
      #10 0x00007efeeac53eb2 in __GI___assert_fail (assertion=0x55d02c760ee0 "backup_stage <= BACKUP_WAIT_FOR_FLUSH || backup_stage >= BACKUP_END", file=0x55d02c760520 "/data/bld/10.6-asan-ubsan/sql/backup.cc", line=613, function=0x55d02c760f60 "void backup_log_ddl(const backup_log_info*)") at ./assert/assert.c:101
      #11 0x000055d029a6156b in backup_log_ddl (info=info@entry=0x7efee0170510) at /data/bld/10.6-asan-ubsan/sql/backup.cc:613
      #12 0x000055d02925cfe2 in mysql_create_or_drop_trigger (thd=thd@entry=0x62b00007e218, tables=<optimized out>, create=create@entry=false) at /data/bld/10.6-asan-ubsan/sql/sql_trigger.cc:710
      #13 0x000055d028d66fd7 in mysql_execute_command (thd=thd@entry=0x62b00007e218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:5999
      #14 0x000055d028d6ca56 in mysql_parse (thd=thd@entry=0x62b00007e218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7efee0171ac0) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:8200
      #15 0x000055d028d75d26 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62b00007e218, packet=packet@entry=0x62900024e219 "DROP TRIGGER IF EXISTS a", packet_length=packet_length@entry=24, blocking=blocking@entry=true) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:1908
      #16 0x000055d028d82978 in do_command (thd=thd@entry=0x62b00007e218, blocking=blocking@entry=true) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:1421
      #17 0x000055d0295049bc in do_handle_one_connection (connect=<optimized out>, connect@entry=0x608000002f38, put_in_cache=put_in_cache@entry=true) at /data/bld/10.6-asan-ubsan/sql/sql_connect.cc:1386
      #18 0x000055d029505b19 in handle_one_connection (arg=0x608000002f38) at /data/bld/10.6-asan-ubsan/sql/sql_connect.cc:1298
      #19 0x000055d02af30863 in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/10.6-asan-ubsan/storage/perfschema/pfs.cc:2201
      #20 0x00007efeeaca81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #21 0x00007efeead2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      No obvious immediate problem on a non-debug build.

      This commit added the assertion in 10.6:

      commit d9cd4e1f752a730b58ed9ccb2a05647163a8ae05 (origin/bb-10.6-monty)
      Commit:     Monty
      CommitDate: Mon Apr 28 12:38:01 2025 +0300
       
          MDEV-22250 InnoDB: Failing assertion: opt_no_lock during mariabackup --backup
      

      The affected versions have been assumed, as the commit above has not been merged up yet.

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.