Hello,

I am adding and updating nodes pragmatically on my website. Everything was working fine. Suddenly I am getting a deadlock error on taxonomy_entity_index table. Can anyone suggest what to do or which thing is causing the problem.

PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO {taxonomy_entity_index} (entity_type, bundle, entity_id, revision_id, field_name, delta, tid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6), (:db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13), (:db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => offer [:db_insert_placeholder_2] => 1315657 [:db_insert_placeholder_3] => 1315657 [:db_insert_placeholder_4] => field_offer_category [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 3 [:db_insert_placeholder_7] => node [:db_insert_placeholder_8] => offer [:db_insert_placeholder_9] => 1315657 [:db_insert_placeholder_10] => 1315657 [:db_insert_placeholder_11] => field_offer_category [:db_insert_placeholder_12] => 1 [:db_insert_placeholder_13] => 31 [:db_insert_placeholder_14] => node [:db_insert_placeholder_15] => offer [:db_insert_placeholder_16] => 1315657 [:db_insert_placeholder_17] => 1315657 [:db_insert_placeholder_18] => field_offer_category [:db_insert_placeholder_19] => 2 [:db_insert_placeholder_20] => 61 ) i taxonomy_entity_index_field_attach_update() (rad 164 av /mnt/www/smartster/web/sites/all/modules/taxonomy_entity_index/taxonomy_entity_index.module).
Best Regards,
Rafiq Ahmed

Comments

rafiqasad’s picture

Issue summary: View changes
cilefen’s picture

Priority: Critical » Major
Status: Active » Closed (duplicate)
cilefen’s picture