1

I am trying to clear the cache or view status reports in D7 i get the below error.

PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: DELETE FROM {cache_bootstrap} WHERE (cid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => system_list ) in cache_clear_all() (line 167 of /var/web/includes/cache.inc).

How do i fix the serialization error?

Thank you..

Improve this question
1
  • I restarted mysql server. I still see a different error. PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: DELETE FROM {cache} WHERE (cid LIKE :db_condition_placeholder_0 ESCAPE '\\') ; Array ( [:db_condition_placeholder_0] => node_types:% ) in cache_clear_all() (line 167 of /var/web/includes/cache.inc).
    – Suneel Kumar P
    May 11 '16 at 11:33
2

The Asynchronous Prefetch Database Query Cache module should handle it. If you want the longer version see How to get rid of Deadlocks and Lock time out type issues?

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.