pt-config-diff does not handle multi-valued attributes

Bug #1175310 reported by Sheeri K. Cabral
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Confirmed
Undecided
Unassigned

Bug Description

# pt-config-diff localhost /etc/my.cnf
2 config differences
Variable addons3.versioncheck.db.phx1.mozilla.com /etc/my.cnf
========================= ========================= =========================
replicate_do_table percona.schema_checksu... percona.schema_checksu...
replicate_wild_do_table mysql.*,percona.* percona.*

MariaDB [(none)]> show variables like '%wild%';
+-----------------------------+-------------------+
| Variable_name | Value |
+-----------------------------+-------------------+
| replicate_wild_do_table | mysql.*,percona.* |
| replicate_wild_ignore_table | |
+-----------------------------+-------------------+
2 rows in set (0.00 sec)

MariaDB [(none)]>

# grep wild /etc/my.cnf
replicate_wild_do_table=mysql.*
replicate_wild_do_table=percona.*

So pt-config-diff is not handling the multi-valued attribute replicate_wild_do_table (and also is having trouble with replicate_do_table for the same reason.

This has manifested itself only recently because in Percona 5.1, these values are not system variables:

mysql> show variables like '%wild%';
Empty set (0.01 sec)

But in MariaDB 5.5, they are (see above).

tags: added: mariadb
Changed in percona-toolkit:
status: New → Confirmed
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1105

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.