Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I got this error when creating content, in this case nodes. I was importing 650 small images from 5x5px to 100x100px and it crashed at 311 images with the following error:
An AJAX HTTP error occurred. HTTP
Result Code: 500
Debugging information follows.
Path: /batch?render=overlay&id=114&op=do
StatusText: error ResponseText: PDOException:
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction:
INSERT INTO {settings_audit_log_user_db_connection} (uid, connection_id, log_timestamp)
VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2);
Array (
[:db_insert_placeholder_0] => 2 [:db_insert_placeholder_1] => 865190
[:db_insert_placeholder_2] => 1355405714 ) in settings_audit_log_set_connection_id()
line 28 of sites/all/modules/settings_audit_log/settings_audit_log.module
It uploaded the images just fine, it was the content creation that crashed it.
Comments
Comment #1
andrezstar CreditAttribution: andrezstar commentedHad the same prob.
Do you already know what to do ?
Comment #2
rudolfbykerIf you read the error, you will see that settings_audit_log is causing the trouble, not bulk_media_upload. You can read more about the 1213 deadlock error here: http://stackoverflow.com/questions/2332768/how-to-avoid-mysql-deadlock-f...
Try disabling the settings_audit_log module and see what happens. From there we need to determine in which module it has to be fixed.