I'm running pt-table-checksum version 2.1.3 and I'm getting this issue...
08-10T10:44:12 Error checksumming table bugs.bug_group_map: Possible infinite loop detected! The lower boundary for chunk 4 is <26> and the lower boundary for chunk 5 is also <26>. This usually happens when using a non-unique single column index. The current chunk index for table bugs.bug_group_map is bug_group_map_group_id_idx which is not unique and covers 1 column.
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
08-10T10:44:12 1 0 0 4 4 0.015 bugs.bug_group_map
08-10T10:50:11 Error checksumming table bugs.user_group_map: Possible infinite loop detected! The lower boundary for chunk 2 is <69> and the lower boundary for chunk 3 is also <69>. This usually happens when using a non-unique single column index. The current chunk index for table bugs.user_group_map is fk_user_group_map_group_id_groups_id which is not unique and covers 1 column.
I'm running pt-table-checksum version 2.1.3 and I'm getting this issue...
08-10T10:44:12 Error checksumming table bugs.bug_group_map: Possible infinite loop detected! The lower boundary for chunk 4 is <26> and the lower boundary for chunk 5 is also <26>. This usually happens when using a non-unique single column index. The current chunk index for table bugs.bug_group_map is bug_group_ map_group_ id_idx which is not unique and covers 1 column.
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE group_map: Possible infinite loop detected! The lower boundary for chunk 2 is <69> and the lower boundary for chunk 3 is also <69>. This usually happens when using a non-unique single column index. The current chunk index for table bugs.user_group_map is fk_user_ group_map_ group_id_ groups_ id which is not unique and covers 1 column.
08-10T10:44:12 1 0 0 4 4 0.015 bugs.bug_group_map
08-10T10:50:11 Error checksumming table bugs.user_
08-10T10:50:11 1 0 0 2 2 0.092 bugs.user_group_map
08-10T10:50:12 0 1 0 1 0 0.010 mysql.proc
08-10T10:50:13 0 1 300 1 0 0.012 mysql.tables_priv
08-10T10:50:13 0 1 30 1 0 0.010 mysql.user
real 18m47.019s
user 0m3.645s
sys 0m0.467s
[reply] [-] Comment 7 Sheeri Cabral [:sheeri] 2012-08-28 16:27:19 EDT
Here's the bugs.bug_group_map table:
Table: bug_group_map map_bug_ id_idx` (`bug_id` ,`group_ id`), map_group_ id_idx` (`group_id`), group_map_ bug_id_ bugs_bug_ id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE, group_map_ group_id_ groups_ id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
Create Table: CREATE TABLE `bug_group_map` (
`bug_id` mediumint(9) NOT NULL,
`group_id` mediumint(9) NOT NULL,
UNIQUE KEY `bug_group_
KEY `bug_group_
CONSTRAINT `fk_bug_
CONSTRAINT `fk_bug_
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.03 sec)
and the bugs.user_group_map table: map_user_ id_idx` (`user_ id`,`group_ id`,`grant_ type`,` isbless` ), group_map_ group_id_ groups_ id` (`group_id`), group_map_ group_id_ groups_ id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, group_map_ user_id_ profiles_ userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
Table: user_group_map
Create Table: CREATE TABLE `user_group_map` (
`user_id` mediumint(9) NOT NULL,
`group_id` mediumint(9) NOT NULL,
`isbless` tinyint(4) NOT NULL DEFAULT '0',
`grant_type` tinyint(4) NOT NULL DEFAULT '0',
UNIQUE KEY `user_group_
KEY `fk_user_
CONSTRAINT `fk_user_
CONSTRAINT `fk_user_
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)