Comment 13 for bug 978432

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.

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
Create Table: CREATE TABLE `bug_group_map` (
  `bug_id` mediumint(9) NOT NULL,
  `group_id` mediumint(9) NOT NULL,
  UNIQUE KEY `bug_group_map_bug_id_idx` (`bug_id`,`group_id`),
  KEY `bug_group_map_group_id_idx` (`group_id`),
  CONSTRAINT `fk_bug_group_map_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_bug_group_map_group_id_groups_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.03 sec)

and the bugs.user_group_map table:
       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_map_user_id_idx` (`user_id`,`group_id`,`grant_type`,`isbless`),
  KEY `fk_user_group_map_group_id_groups_id` (`group_id`),
  CONSTRAINT `fk_user_group_map_group_id_groups_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_user_group_map_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)