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

bryrock’s picture

Status: Active » Postponed (maintainer needs more info)

I 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

PROMES’s picture

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

bryrock’s picture

Version: 7.x-1.0-rc4 » 7.x-1.0-rc6
Status: Postponed (maintainer needs more info) » Needs review

Can'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.

PROMES’s picture

I installed rc6 on 3 sites on nov, 12. I'll report back.

bryrock’s picture

Version: 7.x-1.0-rc6 » 7.x-1.0
Status: Needs review » Fixed

Changing this to fixed, and released in 7.x-1.0. Will re-open if necessary.

PROMES’s picture

Hello bryrock,
I promised to report back. My problem didn't return. Thanks for your help.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.