stack twitter rss linkedin cross

Wilco van Esch

Skip to main content

Search results

    SQLSTATE[40001]: Serialization failure: 1213 Deadlock found

    "SQLSTATE[40001]: Serialization failure: 1213 Deadlock found"

    This error can occur during reindexing.

    Example

    Category Products index is locked by another reindex process. 
    Skipping.
    Product Categories indexer process unknown error:
    SQLSTATE[40001]: Serialization failure: 1213 Deadlock found
    when trying to get lock; try restarting transaction,
    query was: DELETE FROM catalog_category_product
    WHERE (category_id = ('1050'))

    Cause

    Either another reindex is running, or someone cancelled a previous reindex (in which case indexing for that table will remain locked).

    Solution

    php bin/magento indexer:reset

    php bin/magento indexer:reindex