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

podarok
🇺🇦 he/him/his
Primary language Ukrainian
Location Ukraine
commented
Version: 7.x-3.0-alpha1 » 7.x-3.0-alpha5
Status: Active » Postponed (maintainer needs more info)

#1764060: Register cache_location table with Drupal cache hook to enable cache cleanup fixed
You should check this in latest alpha release

podarok’s picture

podarok
🇺🇦 he/him/his
Primary language Ukrainian
Location Ukraine
commented
Issue summary: View changes

Updated issue summary.

jkingsnorth’s picture

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

This was fixed =]

firewaller’s picture

firewaller commented

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).