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 '18 at 6:26
  • this table is not exists in database, its temp storage table.
    – Camit1dk
    Jul 3 '18 at 6:27
  • Try to reset search indexing and try again.
    – P_U
    Jul 3 '18 at 6:33
  • ok let me try to reset and reindex
    – Camit1dk
    Jul 3 '18 at 6:44
  • @PareshaU its not working.
    – Camit1dk
    Jul 3 '18 at 6:48

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, privacy policy and cookie policy

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