Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1561

pt-show-grants broken on Debian Jessie

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 3.0.11
    • Fix Version/s: 3.0.13
    • Component/s: pt-show-grants
    • Labels:

      Description

      pt-show-grants is completely broken on Debian Jessie:

      # pt-show-grants --version
      pt-show-grants 3.0.10
      
      # pt-show-grants
      -- Grants dumped by pt-show-grants
      -- Dumped from server Localhost via UNIX socket, MySQL 5.5.60-0+deb8u1-log at 2018-05-23 23:03:01
      DBD::mysql::db selectall_arrayref failed: Unknown column 'account_locked' in 'where clause' [for Statement "SELECT DISTINCT User, Host FROM mysql.user WHERE NOT (`account_locked`="Y"
      AND `password_expired`="Y"
      AND `authentication_string`=""
      ) ORDER BY User, Host"] at /usr/bin/pt-show-grants line 1915.

      MySQL server versionĀ 5.5.60-0+deb8u1. Looks like it's trying to query for something that's a MySQL 5.7 feature.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  PhilB Brendon Colby
                • Votes:
                  9 Vote for this issue
                  Watchers:
                  13 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: