Our site is growing in traffic and this error is happening more and more as users save their nodes. We are using the locations module to simply allow people to put in their zipcodes.

Thoughts on why this could be happening? There is another thread here related to the same error on the node table. #937284: DEADLOCK errors on MergeQuery INSERT due to InnoDB gap locking when condition in SELECT ... FOR UPDATE results in 0 rows

PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO {location_instance} (nid, vid, uid, genid, lid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => 31451 [:db_insert_placeholder_1] => 31451 [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => cck:field_location:31451 [:db_insert_placeholder_4] => 25092 ) in location_save_locations() (line 974 of /var/www/cityposted.com/httpdocs/sites/all/modules/location/location.module).

Setting to critical - same as other thread.

Comments

podarok’s picture

Version: 7.x-3.0-alpha1 » 7.x-3.0-alpha5
Status: Active » Postponed (maintainer needs more info)
podarok’s picture

Issue summary: View changes

Updated issue summary.

JKingsnorth’s picture

Issue summary: View changes
Status: Postponed (maintainer needs more info) » Closed (fixed)

This was fixed =]

firewaller’s picture

I'm getting the following on 7.x-3.7:

PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO {location_instance} (nid, vid, uid, genid, lid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => 0 [:db_insert_placeholder_2] => 22016 [:db_insert_placeholder_3] => cck:field_location:22016 [:db_insert_placeholder_4] => 17991 ) in location_save_locations() (line 1132 of sites/all/modules/location/location.module).