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

Deadlock between mysql_change_user(), SHOW VARIABLES and INSTALL PLUGIN

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.34
    • 5.5.35
    • None
    • None

    Description

      3 threads required to reproduce this deadlock:
      thread1: mysql_change_user() (or connects/disconnects)
      thread2: INSTALL PLUGIN
      thread3: SHOW VARIABLES

      Easily repeatable with mtr test case:

      delimiter |;
      		 
      CREATE PROCEDURE p_install(x INT)
      		 
      BEGIN
      		 
        DECLARE CONTINUE HANDLER FOR 1126 BEGIN END;
      		 
        WHILE x DO
      		 
          SET x= x - 1;
      		 
          INSTALL PLUGIN no_such_plugin SONAME 'no_such_object';
      		 
        END WHILE;
      		 
      END|
      		 
       
      		 
      CREATE PROCEDURE p_show_vars(x INT)
      		 
      WHILE x DO
      		 
        SET x= x - 1;
      		 
        SHOW VARIABLES;
      		 
      END WHILE|
      		 
      delimiter ;|
      		 
       
      		 
      connect(con1, localhost, root,,);
      		 
      connect(con2, localhost, root,,);
      		 
       
      		 
      connection con1;
      		 
      --send CALL p_install(100);
      		 
       
      		 
      connection con2;
      		 
      --send CALL p_show_vars(100);
      		 
       
      		 
      connection default;
      		 
       
      		 
      disable_result_log;
      		 
      let $i= 100;
      		 
      while ($i)
      		 
      {
      		 
        change_user;
      		 
        dec $i;
      		 
      }
      		 
       
      		 
      connection con1;
      		 
      reap;
      		 
      connection con2;
      		 
      reap;
      		 
      connection default;
      		 
      enable_result_log;
      		 
       
      		 
      disconnect con1;
      		 
      disconnect con2;
      		 
      DROP PROCEDURE p_install;
      		 
      DROP PROCEDURE p_show_vars;

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-5089 possible deadlocks between rwlocks and mutexes

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Bug #71236 Deadlock between mysql_change_user(), SHOW VARIABLES and INSTALL PLUGIN

          Activity

            Ascending order - Click to sort in descending order
            svoj Sergey Vojtovich created issue -
            svoj Sergey Vojtovich made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Fix Version/s 5.5.35 [ 14000 ]
            Fix Version/s 5.5.34 [ 13700 ]
            laurynas Laurynas Biveinis added a comment -

            The MTR testcase fails the MySQL 5.6.15 too. Has this been reported to Oracle? If not, would you mind me reporting it with your testcase?

            laurynas Laurynas Biveinis added a comment - The MTR testcase fails the MySQL 5.6.15 too. Has this been reported to Oracle? If not, would you mind me reporting it with your testcase?
            svoj Sergey Vojtovich added a comment - - edited

            Laurynas, it hasn't been reported to Oracle yet. I'd appreciate if you could report it to Oracle.

            svoj Sergey Vojtovich added a comment - - edited Laurynas, it hasn't been reported to Oracle yet. I'd appreciate if you could report it to Oracle.
            svoj Sergey Vojtovich made changes -
            Assignee Sergey Vojtovich [ svoj ] Sergei Golubchik [ serg ]
            svoj Sergey Vojtovich added a comment -

            Sergei, please review fix for this bug.

            svoj Sergey Vojtovich added a comment - Sergei, please review fix for this bug.
            laurynas Laurynas Biveinis added a comment -

            http://bugs.mysql.com/bug.php?id=71236

            laurynas Laurynas Biveinis added a comment - http://bugs.mysql.com/bug.php?id=71236
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Sergey Vojtovich [ svoj ]
            svoj Sergey Vojtovich made changes -
            Assignee Sergey Vojtovich [ svoj ] Sergei Golubchik [ serg ]
            svoj Sergey Vojtovich added a comment -

            Sergei, please review updated patch.

            svoj Sergey Vojtovich added a comment - Sergei, please review updated patch.
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Sergey Vojtovich [ svoj ]
            svoj Sergey Vojtovich added a comment -

            Fixed in 5.5.35, revno: 4051, revision-id: svoj@mariadb.org-20140128071243-807nozcys0r84mxv

            svoj Sergey Vojtovich added a comment - Fixed in 5.5.35, revno: 4051, revision-id: svoj@mariadb.org-20140128071243-807nozcys0r84mxv
            svoj Sergey Vojtovich made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            dbart Daniel Bartholomew added a comment -

            http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/4051

            dbart Daniel Bartholomew added a comment - http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/4051
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 30305 ] MariaDB v2 [ 42852 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 42852 ] MariaDB v3 [ 62552 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 62552 ] MariaDB v4 [ 147265 ]

            People

              svoj Sergey Vojtovich
              svoj Sergey Vojtovich
              Votes:
              1 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.