Webboard: Indexer quits after indexing words
| Newsgroups | gmane.comp.web.mnogosearch.general |
|---|---|
| Message-ID | <[email protected]> |
Author: Alexander Barkov Email: [email protected] Message: > I have the 3.3.10 mnogosearch running on FreeBSD. The indexer previously worked correctly, but has stopped indexing. Each day I get the message: > > indexer[76040]: [76040]{01} Writing words (385906 words, 8428522 bytes). > indexer[76040]: [76040]{01} The words are written successfully. > indexer[76040]: [76040]{01} mysql_stmt_execute() failed: Duplicate entry 'was' for > key 2 > indexer[76040]: [76040]{01} Error: 'DB err: mysql_stmt_execute() failed: Duplicate > entry 'was' for key 2 - ' > > Note: I have crosswords set to yes and have a stop file. The word 'was' is in the stop file. > > Any ideas on how to clear out this error? Please try adding ps=0 parameter to DBAddr, for example like this: DBAddr mysql://root@locahost/test/?ps=0 then run again. It should print the query which failed to stderr. Please paste it here. If it does not help, try to enable MySQL query log and check the query which failed there. Reply: <http://www.mnogosearch.org/board/message.php?id=21174>