2013-01-25 13:34:52 |
Walter Heck |
bug |
|
|
added bug |
2013-01-25 13:35:43 |
Walter Heck |
description |
on MMM monitor:
<pre>[root@baz ~]# pt-table-checksum --replicate test.checksum --empty-replicate-table --create-replicate-table --user maatkit --ask-pass 192.168.1.113
Enter MySQL password:
foo.com has binlog_format STATEMENT but replica bar.com has binlog_format MIXED. This could cause pt-table-checksum to break replication. If you understand the risks, specify --no-check-binlog-format to disable this check.
[root@brownsboro ~]# pt-table-checksum --version
pt-table-checksum 2.1.8</pre>
on foo:
<pre>
MariaDB [(none)]> select @@binlog_format
-> ;
+-----------------+
| @@binlog_format |
+-----------------+
| MIXED |
+-----------------+
1 row in set (0.00 sec)
[root@barfield ~]# grep format /etc/my.cnf
binlog_format = mixed
[root@barfield ~]# mysqld -V
mysqld Ver 5.2.12-MariaDB-mariadb115-log for unknown-linux-gnu on x86_64 ((MariaDB - http://mariadb.com/))
</pre>
on bar:
<pre>
MariaDB [(none)]> select @@binlog_format;
+-----------------+
| @@binlog_format |
+-----------------+
| MIXED |
+-----------------+
1 row in set (0.00 sec)
[root@bar ~]# grep format /etc/my.cnf
binlog_format = mixed
[root@bar ~]# mysqld -V
mysqld Ver 5.2.12-MariaDB-mariadb115-log for unknown-linux-gnu on x86_64 ((MariaDB - http://mariadb.com/))
</pre>
Am I missing something? |
on MMM monitor:
<pre>[root@baz ~]# pt-table-checksum --replicate test.checksum --empty-replicate-table --create-replicate-table --user maatkit --ask-pass 192.168.1.113
Enter MySQL password:
foo.com has binlog_format STATEMENT but replica bar.com has binlog_format MIXED. This could cause pt-table-checksum to break replication. If you understand the risks, specify --no-check-binlog-format to disable this check.
[root@brownsboro ~]# pt-table-checksum --version
pt-table-checksum 2.1.8</pre>
on foo:
<pre>
MariaDB [(none)]> select @@binlog_format
-> ;
+-----------------+
| @@binlog_format |
+-----------------+
| MIXED |
+-----------------+
1 row in set (0.00 sec)
[root@foo ~]# grep format /etc/my.cnf
binlog_format = mixed
[root@foo ~]# mysqld -V
mysqld Ver 5.2.12-MariaDB-mariadb115-log for unknown-linux-gnu on x86_64 ((MariaDB - http://mariadb.com/))
</pre>
on bar:
<pre>
MariaDB [(none)]> select @@binlog_format;
+-----------------+
| @@binlog_format |
+-----------------+
| MIXED |
+-----------------+
1 row in set (0.00 sec)
[root@bar ~]# grep format /etc/my.cnf
binlog_format = mixed
[root@bar ~]# mysqld -V
mysqld Ver 5.2.12-MariaDB-mariadb115-log for unknown-linux-gnu on x86_64 ((MariaDB - http://mariadb.com/))
</pre>
Am I missing something? |
|
2013-01-27 00:17:35 |
Jaime Sicam |
tags |
|
i29097 |
|
2013-01-28 15:25:57 |
Brian Fraser |
percona-toolkit: status |
New |
Triaged |
|
2013-01-28 15:26:00 |
Brian Fraser |
percona-toolkit: importance |
Undecided |
Medium |
|
2013-01-28 15:26:02 |
Brian Fraser |
percona-toolkit: assignee |
|
Brian Fraser (fraserbn) |
|
2013-01-28 15:26:05 |
Brian Fraser |
percona-toolkit: milestone |
|
2.2.1 |
|
2013-01-28 15:26:16 |
Brian Fraser |
percona-toolkit: milestone |
2.2.1 |
2.1.9 |
|
2013-01-28 15:26:16 |
Brian Fraser |
percona-toolkit: assignee |
Brian Fraser (fraserbn) |
|
|
2013-01-28 15:26:31 |
Brian Fraser |
nominated for series |
|
percona-toolkit/2.1 |
|
2013-01-28 15:26:31 |
Brian Fraser |
bug task added |
|
percona-toolkit/2.1 |
|
2013-01-28 15:26:31 |
Brian Fraser |
nominated for series |
|
percona-toolkit/2.2 |
|
2013-01-28 15:26:31 |
Brian Fraser |
bug task added |
|
percona-toolkit/2.2 |
|
2013-01-28 15:26:42 |
Brian Fraser |
percona-toolkit/2.2: milestone |
2.1.9 |
2.2.1 |
|
2013-01-28 15:26:46 |
Brian Fraser |
percona-toolkit/2.1: status |
New |
Triaged |
|
2013-01-28 15:26:48 |
Brian Fraser |
percona-toolkit/2.1: importance |
Undecided |
Medium |
|
2013-01-28 15:26:50 |
Brian Fraser |
percona-toolkit/2.1: assignee |
|
Brian Fraser (fraserbn) |
|
2013-01-28 15:26:52 |
Brian Fraser |
percona-toolkit/2.2: assignee |
|
Brian Fraser (fraserbn) |
|
2013-01-28 15:26:54 |
Brian Fraser |
percona-toolkit/2.1: milestone |
|
2.1.9 |
|
2013-01-30 16:06:21 |
Daniel Nichter |
bug task deleted |
percona-toolkit/2.2 |
|
|
2013-01-30 16:06:31 |
Daniel Nichter |
bug task deleted |
percona-toolkit/2.1 |
|
|
2013-01-30 16:06:37 |
Daniel Nichter |
percona-toolkit: status |
Triaged |
In Progress |
|
2013-01-30 16:06:42 |
Daniel Nichter |
percona-toolkit: milestone |
2.2.1 |
2.1.9 |
|
2013-01-30 16:07:11 |
Daniel Nichter |
tags |
i29097 |
ambiguity error-message percona-29097 pt-table-checksum |
|
2013-01-30 16:07:21 |
Daniel Nichter |
percona-toolkit: importance |
Medium |
High |
|
2013-01-30 16:27:22 |
Brian Fraser |
summary |
pt-table-checksum mistakenly reports different binlog_format on master and slave |
pt-table-checksum: Confusing error message with binlog_format ROW or MIXED on slave |
|
2013-01-30 16:33:14 |
Brian Fraser |
branch linked |
|
lp:~percona-toolkit-dev/percona-toolkit/fix-1105077-ptc-binlog_format-error |
|
2013-01-30 16:33:31 |
Brian Fraser |
branch linked |
|
lp:~percona-toolkit-dev/percona-toolkit/fix-1105077-ptc-binlog_format-error-2.1.9 |
|
2013-01-30 23:33:10 |
Daniel Nichter |
branch unlinked |
lp:~percona-toolkit-dev/percona-toolkit/fix-1105077-ptc-binlog_format-error |
|
|
2013-01-31 22:12:38 |
Brian Fraser |
percona-toolkit: status |
In Progress |
Fix Committed |
|
2013-02-15 17:11:37 |
Daniel Nichter |
percona-toolkit: status |
Fix Committed |
Fix Released |
|