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

ALL PRIVILEGES insufficient to kill query

    XMLWordPrintable

Details

    Description

      MariaDB [(none)]> show grants;
      +-----------------------------------------------------------------------------------------------------+
      | Grants for openquery@localhost                                                                      |
      +-----------------------------------------------------------------------------------------------------+
      | GRANT ALL PRIVILEGES ON *.* TO 'openquery'@'localhost' IDENTIFIED VIA unix_socket WITH GRANT OPTION |
      +-----------------------------------------------------------------------------------------------------+
       
       
      MariaDB [(none)]> pager grep RENAME
      PAGER set to 'grep RENAME'
      MariaDB [(none)]> show processlist;
      | 1132689 | web         | 10.0.1.226:49476 | web_core       | Query   |    5497 | exit mysqld_lock_tables()    | RENAME TABLE rec_db.abilities TO rec_db1447648955.abilities                  |    0.000 |
      | 1135244 | web         | 10.0.1.226:50465 | web_core       | Query   |    4783 | Waiting for table level lock | RENAME TABLE rec_db.abilityactions TO rec_db1447649669.abilityactions        |    0.000 |
      | 1137379 | web         | 10.0.1.226:52356 | web_core       | Query   |    3830 | Waiting for table level lock | RENAME TABLE rec_db.abilityreminders TO rec_db1447650622.abilityreminders    |    0.000 |
      100 rows in set (0.00 sec)
       
      MariaDB [(none)]> kill 1132689;
      ERROR 1095 (HY000): You are not owner of thread 1132689
      MariaDB [(none)]> kill 1135244;
      ERROR 1095 (HY000): You are not owner of thread 1135244
      MariaDB [(none)]> kill connection 1135244;
      ERROR 1095 (HY000): You are not owner of thread 1135244

      Attachments

        Activity

          People

            Unassigned Unassigned
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.