I am getting the following error:

PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO {domain_source} (nid, domain_id) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array([:db_insert_placeholder_0] => 101712 [:db_insert_placeholder_1] => 0)

This happens hook_node_update(). Do you have an idea on how to solve the issue?

  • 1
    Try finding a reason for the deadlock with SHOW ENGINE INNODB STATUS. – Letharion Aug 1 '12 at 11:04
  • Deadlocks hardly ever appear without explicit locking (or at least long and complicated transactions), so it's either a really old rdbms version (could you tell version? ) or careless module code. Is this question still valid? There were some issues in module's queue in that area. – Mołot Jun 17 '13 at 11:03

After applying this Patch, these errors are reduced however not fully rectified. This patch prevents empty delete queries being run and thus reducing the load on the domain_source table.

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.