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

            Transition Time In Source Status Execution Times
            Sergey Vojtovich made transition -
            Open Confirmed
            		2m 51s 1
            Rinat Ibragimov (Inactive) made transition -
            Confirmed In Progress
            		202d 2h 53m 1
            Rinat Ibragimov (Inactive) made transition -
            In Progress Stalled
            		11d 19h 11m 1
            Rinat Ibragimov (Inactive) made transition -
            Stalled In Review
            		1m 17s 1
            Michael Widenius made transition -
            In Review Stalled
            		117d 6h 32m 2
            Rinat Ibragimov (Inactive) made transition -
            Stalled In Progress
            		4d 4h 8m 2
            Rinat Ibragimov (Inactive) made transition -
            In Progress In Review
            		17d 17h 17m 2
            Michael Widenius made transition -
            In Review Closed
            		2d 3h 15m 1

            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.