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.

| improve this answer | |

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

| improve this answer | |

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.