Hello all, > since our migration to Invenio 1.1, I'm being flood with messages like > that: > > This exception has already been seen 449655 times > last time it was seen: 2013-06-26 16:23:51 > last time it was notified: 2013-06-26 15:04:23 > > 'Error when putting the term \'\'658.01:378(467.1)\'\' into db > (hitlist=intbitset([72999])): (1062, "Duplicate entry \'16777215\' for key > \'PRIMARY\'")\n' > > * 2013-06-26 16:23:51 -> IntegrityError: (1062, "Duplicate entry '16777215' > for key 'PRIMARY'") (connections.py:35:defaulterrorhandler) > > As a matter of fact, during our migration, I recreated all my indexes, > except fulltext, because I feared that it would take too much. I
After sending the message, now I think that the error could be rather due to the datatype of the MySQL index, like Alexander wrote in this message: http://www.mail-archive.com/[email protected]/msg00094.html My indexes are defined mediumint(9) unsigned: show create table idxWORD09F; | Table | Create Table | idxWORD09F | CREATE TABLE `idxWORD09F` ( `id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT, `term` varchar(50) DEFAULT NULL, `hitlist` longblob, PRIMARY KEY (`id`), UNIQUE KEY `term` (`term`) ) ENGINE=MyISAM AUTO_INCREMENT=16777216 DEFAULT CHARSET=utf8 | show create table idxWORD09R; | Table | Create Table | idxWORD09R | CREATE TABLE `idxWORD09R` ( `id_bibrec` mediumint(9) unsigned NOT NULL DEFAULT '0', `termlist` longblob, `type` enum('CURRENT','FUTURE','TEMPORARY') NOT NULL DEFAULT 'CURRENT', PRIMARY KEY (`id_bibrec`,`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 | So, the my question should rather be double: (a) how to change id_bibrec type and (b) how to recreate fulltext index. Thanks, Ferran
