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

BACKUP UNLOCK + FTWRL assertion failure | SIGSEGV in I_P_List from MDL_context::release_lock on INSERT w/ BACKUP LOCK (on optimized builds) | Assertion `ticket->m_duration == MDL_EXPLICIT' failed.

Details

    Description

      CREATE TABLE t1(a INT);
      		 
      BACKUP LOCK t1;
      		 
      FLUSH TABLE t1 WITH READ LOCK; # FOR EXPORT crashes as well
      		 
      UNLOCK TABLES;
      		 
      BACKUP UNLOCK;
      		 
      DROP TABLE t1;


      #7  0x00007fd9817ffc82 in __GI___assert_fail (assertion=0x564412c268a8 "ticket->m_duration == MDL_EXPLICIT", file=0x564412c26110 "/home/svoj/devel/maria/mariadb/sql/mdl.cc", line=2835, function=0x564412c270e0 <MDL_context::release_lock(MDL_ticket*)::__PRETTY_FUNCTION__> "void MDL_context::release_lock(MDL_ticket*)") at assert.c:101
      		 
      #8  0x000056441206d270 in MDL_context::release_lock (this=0x7fd930000c20, ticket=0x7fd930011950) at /home/svoj/devel/maria/mariadb/sql/mdl.cc:2835
      		 
      #9  0x000056441216fb18 in backup_unlock (thd=0x7fd930000b00) at /home/svoj/devel/maria/mariadb/sql/backup.cc:388
      		 
      #10 0x0000564411edfef3 in mysql_execute_command (thd=0x7fd930000b00) at /home/svoj/devel/maria/mariadb/sql/sql_parse.cc:5046
      		 
      #11 0x0000564411eea477 in mysql_parse (thd=0x7fd930000b00, rawbuf=0x7fd930013148 "BACKUP UNLOCK", length=13, parser_state=0x7fd979b7eff0, is_com_multi=false, is_next_command=false) at /home/svoj/devel/maria/mariadb/sql/sql_parse.cc:7912
      		 
      #12 0x0000564411ed54f2 in dispatch_command (command=COM_QUERY, thd=0x7fd930000b00, packet=0x7fd93019e0f1 "BACKUP UNLOCK", packet_length=13, is_com_multi=false, is_next_command=false) at /home/svoj/devel/maria/mariadb/sql/sql_parse.cc:1841
      		 
      #13 0x0000564411ed3ac3 in do_command (thd=0x7fd930000b00) at /home/svoj/devel/maria/mariadb/sql/sql_parse.cc:1359
      		 
      #14 0x000056441205cc16 in do_handle_one_connection (connect=0x564415bb4070) at /home/svoj/devel/maria/mariadb/sql/sql_connect.cc:1412
      		 
      #15 0x000056441205c912 in handle_one_connection (arg=0x564415bb4070) at /home/svoj/devel/maria/mariadb/sql/sql_connect.cc:1316

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21994 Assertion `!thd || thd->locked_tables_mode || !thd->mdl_context.has_locks() || thd->handler_tables_hash.records || thd->ull_hash.records || thd->global_read_lock.is_acquired() || thd->current_backup_stage != BACKUP_FINISHED' failed in reload_acl_and_cache

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is caused by

          Task - A task that needs to be done. MDEV-5336 Implement BACKUP STAGE for safe external backups

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22448 SIGSEGV in I_P_List from MDL_context::release_lock on INSERT w/ BACKUP LOCK (on optimized builds)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22879 SIGSEGV (or hang) in free/my_free from _ma_end_block_record (on optimized builds)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24749 Various corruptions caused by Aria subsystem asking system call to overwrite memory that it does not own

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20946 Hard FTWRL deadlock under user level locks

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21460 ER_NOT_KEYFILE or Assertion `! is_set()' failed Diagnostics_area::set_ok_status upon LOAD into temporary Aria table

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25037 SIGSEGV in MDL_lock::hog_lock_types_bitmap on INSERT w/ RELEASE_ALL_LOCKS()

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 33 older comments
            monty Michael Widenius added a comment -

            Review of patch and minor edits to the patch

            Patch by Rinat Ibragimov <ri@tempesta-tech.com> pushed to 10.4 tree

            monty Michael Widenius added a comment - Review of patch and minor edits to the patch Patch by Rinat Ibragimov <ri@tempesta-tech.com> pushed to 10.4 tree
            Roel Roel Van de Paar added a comment -

            Note to self, also test (Inc 10.6 opt) with:

            BACKUP LOCK fake.t;
            		 
            CREATE TABLE t (c INT);
            		 
            LOCK TABLES t READ;
            		 
            UNLOCK TABLES;
            		 
            BACKUP LOCK fake.t;

            Roel Roel Van de Paar added a comment - Note to self, also test (Inc 10.6 opt) with: BACKUP LOCK fake.t; CREATE TABLE t (c INT); LOCK TABLES t READ; UNLOCK TABLES; BACKUP LOCK fake.t;
            Roel Roel Van de Paar added a comment -

            rinat.ibragimov the pull request still shows as open? https://github.com/MariaDB/server/pull/1541

            Roel Roel Van de Paar added a comment - rinat.ibragimov the pull request still shows as open? https://github.com/MariaDB/server/pull/1541
            rinat.ibragimov Rinat Ibragimov (Inactive) added a comment -

            Roel, the patch from the pull request was pushed into 10.4, as 709ba7dcae. There were apparently some differences made though, and that's why Github doesn't think that it's the same patch.

            Should I close the pull request?

            rinat.ibragimov Rinat Ibragimov (Inactive) added a comment - Roel , the patch from the pull request was pushed into 10.4, as 709ba7dcae. There were apparently some differences made though, and that's why Github doesn't think that it's the same patch. Should I close the pull request?
            Roel Roel Van de Paar added a comment -

            rinat.ibragimov I am not sure. monty ?

            Roel Roel Van de Paar added a comment - rinat.ibragimov I am not sure. monty ?

            People

              monty Michael Widenius
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.