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 found last month several times this message in the logging:
"PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO {httpbl} (hostname, status, expire) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 178.118.125.253 [:db_insert_placeholder_1] => 0 [:db_insert_placeholder_2] => 1352230941 ) in _httpbl_cache_set() (line 610 of xxxxx/sites/all/modules/httpbl/httpbl.module).
Comments
Comment #1
bryrock CreditAttribution: bryrock commentedI have seen this happen periodically during periods of prolonged high traffic, though I freely admit I'm not knowledgable enough at this time to address it. My rudimentary understanding is that it happens when there are "simultaneous" attempts to insert records. This module doesn't force any record locking, as it is to expensive considering it is (depending on configuration) being invoked on every page request. See http://drupal.org/node/807696#comment-4605730.
Am also keeping an eye on this somewhat unrelated issue that runs into the same problem, #1369332: Avoid deadlock issues on the {node} table
Comment #2
PROMESNext time it happens I will search the logs to see if there is a high traffic for the same or different IP's at that time. I presumed allready this being the case.
My purpose was to share the exeption hoping for a solution.
Comment #3
bryrock CreditAttribution: bryrock commentedCan't make any promises, but the patch to address #1343432: Integrity constraint violation may address this problem as well. If not, I'm admittedly out of ideas and am open to suggestions.
Comment #4
PROMESI installed rc6 on 3 sites on nov, 12. I'll report back.
Comment #5
bryrock CreditAttribution: bryrock commentedChanging this to fixed, and released in 7.x-1.0. Will re-open if necessary.
Comment #6
PROMESHello bryrock,
I promised to report back. My problem didn't return. Thanks for your help.