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

Dead lock at CREATE USER

    XMLWordPrintable

Details

    Description

      Hi,

      When I do: CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'b692RzMDSKjTg7AypUMEbhlx'

      I dead lock some time:

      SHOW FULL PROCESSLIST:
      |  12 | root | localhost | mysql | Query   | 43178 | Waiting for table level lock    | UPDATE user LEFT JOIN db USING (Host,User) SET Create_user_priv='Y'
        WHERE @hadCreateUserPriv = 0 AND
              (user.Grant_priv = 'Y' OR db.Grant_priv = 'Y') |    0.000 |
      |  19 | root | localhost | mysql | Query   | 43178 | Waiting for table metadata lock | ALTER TABLE user MODIFY Create_user_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_routine_priv                                  |    0.000 |
      |  23 | root | localhost | NULL  | Query   | 43178 | Waiting for table metadata lock | CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'XXXXXXXXXXXXXXXXXXXXXXX'
      

      Cheers,

      Attachments

        Activity

          People

            serg Sergei Golubchik
            alpha_one_x86 BRULE Herman Jacques Roger
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.