Good morning,
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
suspect that a full reindex would help, but I'm unsure about how to do
it. Of course I know how to run bibindex using record ranges, but I
don't know how to delete the current indexes. bibindex -R does the job,
but I don't want it to start indexing the whole site from start to end.
According to bibndexadmin, the size of our fulltext index is:
Fwd.Idx Size: 1,084.438 MB
Rev.Idx Size: 870.052 MB
Fwd.Idx Words: 14,713,310
Rev.Idx Record: 100,598
And, before you ask, at this moment I prefer to continue with MySQL
indexes even knowing its limitations; I cannot open a new front with
Solr.
Thanks,
Ferran
