pt-table-checksum changes binlog_format even if already set to statement
Bug #919352 reported by
Rob Smith
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Medium
|
Brian Fraser |
Bug Description
pt-table-checksum currently changes the session binlog_format to statement no matter what it currently is set to. This requires the super privilege on mysql 5.1.29+.
From http://
You must have the SUPER privilege to set the global binlog_format value. Starting with MySQL 5.1.29, you must have the SUPER privilege to set either the global or session binlog_format value. (Bug #39106)
pt-table-checksum should check to see the current value of binlog_format before attempting to change it.
Related branches
Changed in percona-toolkit: | |
milestone: | none → 2.0.3 |
importance: | Undecided → Medium |
status: | New → Confirmed |
assignee: | nobody → Brian Fraser (fraserbn) |
tags: | added: privs |
Changed in percona-toolkit: | |
status: | Confirmed → Fix Committed |
summary: |
- pt-table-checksum should not change binlog_format if already set to - statement + pt-table-checksum changes binlog_format even if already set to statement |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
This is a security issue - there shouldn't be a need for a SUPER user for this functionality. Especially since many folks will store the password for the checksum user in a script somewhere.