I dont know if this problem from 2.9 but its seems it happen after i update
Im checking mysql logs and i see much query for old rules where I delete them long time ago and also i see much logs in the system logs related to rules cache

then the whole sever stop with this error

Original

PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: DELETE FROM {semaphore} WHERE (name = :db_condition_placeholder_0) AND (value = :db_condition_placeholder_1) AND (expire <= :db_condition_placeholder_2) ; Array ( [:db_condition_placeholder_0] => rules_get_cacheevent_init [:db_condition_placeholder_1] => 115530849655110dad763d07.59300379 [:db_condition_placeholder_2] => 1427181086.21 ) in lock_may_be_available() (line 181 includes/lock.inc).

Additional

PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: DELETE FROM {semaphore} WHERE (name = :db_condition_placeholder_0) AND (value = :db_condition_placeholder_1) AND (expire <= :db_condition_placeholder_2) ; Array ( [:db_condition_placeholder_0] => rules_get_cacheevent_watchdog [:db_condition_placeholder_1] => 204835726855110d29a73153.53748269 [:db_condition_placeholder_2] => 1427180902.71 ) in lock_may_be_available() (line 181 of includes/lock.inc).

Comments

mdupont’s picture

mdupont
Primary language French
Location Switzerland
commented
Status: Active » Closed (duplicate)
Related issues: +#2406863: stampede protection should be flexible ("Cache rebuild lock hit" watchdog message)

Most likely a duplicate of #2406863: stampede protection should be flexible ("Cache rebuild lock hit" watchdog message)