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

LP #1221181: pt-online-schema-change can't run with --skip-grant-tables

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Elan Ruusamäe last update 19-11-2014 11:50:57

      $ pt-online-schema-change --alter "add column c int(11) not null default 0" D=db1,t=ce --nodrop-old-table --host HOSTNAME --port 3306 --user mysql --execute
      Error setting innodb_lock_wait_timeout: DBD::mysql::db do failed: Unknown system variable 'innodb_lock_wait_timeout' [for Statement "SET SESSION innodb_lock_wait_timeout=1"]. The current value for innodb_lock_wait_timeout is 50. If the variable is read only (not dynamic), specify --set-vars innodb_lock_wait_timeout=50 to avoid this warning, else manually set the variable and restart MySQL.

      Error setting innodb_lock_wait_timeout: DBD::mysql::db do failed: Unknown system variable 'innodb_lock_wait_timeout' [for Statement "SET SESSION innodb_lock_wait_timeout=1"]. The current value for innodb_lock_wait_timeout is 50. If the variable is read only (not dynamic), specify --set-vars innodb_lock_wait_timeout=50 to avoid this warning, else manually set the variable and restart MySQL.

      Failed to SHOW GRANTS FOR CURRENT_USER(): DBD::mysql::db selectcol_arrayref failed: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement [for Statement "SHOW GRANTS FOR CURRENT_USER()"] at /usr/bin/pt-online-schema-change line 4152.

      so, the innodb errors are ignored, but show grants failing is not ignored.
      is this setup something that is never going to be supported?

      i would like pt-osc to resume working if grants are not set (all privileges are granted)

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist