I'm receiving this error in my logs fairly often. It's bringing the site to a halt.

PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: SELECT revision.order_number AS order_number, revision.revision_id AS revision_id, revision.revision_uid AS revision_uid, revision.mail AS mail, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.revision_hostname AS revision_hostname, revision.data AS data, base.order_id AS order_id, base.type AS type, base.uid AS uid, base.created AS created, base.changed AS changed, base.hostname AS hostname FROM {commerce_order} base INNER JOIN {commerce_order_revision} revision ON revision.revision_id = base.revision_id WHERE (base.order_id IN (:db_condition_placeholder_0)) FOR UPDATE; Array ( [:db_condition_placeholder_0] => 964 ) in DrupalDefaultEntityController->load() (line 196 of /home/circe/public_html/includes/entity.inc).

I've read through all of these and can't figure if there is a patch to apply or not. I'm running Commerce Kickstart 7.x-2.9
https://drupal.org/node/1608294
https://drupal.org/node/1514618
https://drupal.org/node/1363826

Is there something I can do?

Comments

jessejabberjaw’s picture

Issue summary: View changes

I get the same issue. I'm just using the commerce module in Drupal 7.28.

smokris’s picture

This appears to be the same issue that #2240427: Improve commerce entities locking is trying to solve.

Don't apply the patches on that case yet, since they aren't ready for primetime. In the meantime, when the deadlock happens, you can restart your SQL server to temporarily get things working again. You can also try disabling locking for commerce_order entities (similar to the patch on #1252278: Commerce Order pessimistic locking causes deadlocks in migrations).

rszrama’s picture

Status: Active » Closed (duplicate)

Thanks for linking that issue, smokris. That will undoubtedly address this support request, so I'm going to close this as a duplicate.