I getting below error while open category page. i also tried to reindexing, cache clear, setup upgrade and di:compile but its not working.

Integrity constraint violation: 1062 Duplicate entry '62332' for key 'PRIMARY', query was: INSERT INTO search_tmp_5b3a22e6d14c03_14202655 (entity_id,score) VALUES

  • Take a backup of this table and try to check to remove this entry and do reindexing, cache clear, setup upgrade and di:compile again.
    – P_U
    Jul 3, 2018 at 6:26
  • this table is not exists in database, its temp storage table. Jul 3, 2018 at 6:27
  • Try to reset search indexing and try again.
    – P_U
    Jul 3, 2018 at 6:33
  • ok let me try to reset and reindex Jul 3, 2018 at 6:44
  • @PareshaU its not working. Jul 3, 2018 at 6:48

2 Answers 2


Try to add a \Magento\Framework\DB\Adapter\AdapterInterface::REPLACE directive in magento/framework/Search/Adapter/Mysql/TemporaryStorage.php in the insert statement.


It's magento bug you can follow here to get more info: https://support.magento.com/hc/en-us/articles/360025762211-503-error-on-store-front-catalog-pages-with-Integrity-constraint-violation-in-logs

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.