Bug #84541
Updated by Sybille Peters over 6 years ago
Every once a while I get an Exception with HTTP status code 503 on loading a page with the Exception message: <pre> Oops, an error occurred! An exception occurred while executing 'INSERT INTO `index_words` (`wid`, `baseword`, `metaphone`) VALUES (?, ?, ?)' with params [55602717, "images\/botschaften", "66411504"]: Duplicate entry '55602717' for key 'PRIMARY' </pre> h2. System * TYPO3 version 8.7.12 * current master with indexed_search. h2. Reproduce # Activate This is not easily reproducable but can be acchieved with: * some crawling of the extension indexed_search # Add the following words to a new website with crawler or existing content element: graf gettogethers abfluss erworbener wget # Load the page * search in the frontend (you may have to do that twice) If you need to reproduce this several times, you can delete the index for the page by selecting the "Indexing" module, select the page with the content you inserted earlier, then select "Detailed statistics" and press the "Delete" garbage can. You can also check the sys_log for similar errors: sys_log, e.g.: <pre><code class="sql"> SELECT uid,FROM_UNIXTIME(tstamp),details FROM sys_log WHERE details LIKE '%index_word%' ORDER BY uid DESC LIMIT 10; </code></pre> h2. Cause of error possibly: https://github.com/TYPO3/TYPO3.CMS/blob/8124407655ae73656bf6c21f6bc8841b8e1d2023/typo3/sysext/indexed_search/Classes/Indexer.php#L2134 hash collision?