CiviCRM Community Forums (archive)

Hi everyone,

Here's the issue every time a person donate it throws this error:
Error Details
Database Error Code: Deadlock found when trying to get lock; try restarting transaction, 1213
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] =>   
UPDATE civicrm_group g
SET    cache_date = null
WHERE  TIMESTAMPDIFF(MINUTE, cache_date, 20120208042148) >= 0
 [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
    [type] => DB_Error
    [user_info] =>   
UPDATE civicrm_group g
SET    cache_date = null
WHERE  TIMESTAMPDIFF(MINUTE, cache_date, 20120208042148) >= 0
 [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="
UPDATE civicrm_group g
SET    cache_date = null
WHERE  TIMESTAMPDIFF(MINUTE, cache_date, 20120208042148) >= 0
 [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]"]
)

I've talked to our technical support and they said this could be resolved by modifying the time stamp values used in the column 'cache_date' and by the update query 'WHERE TIMESTAMPDIFF(MINUTE, cache_date, 20120208042148)' to use a more precise value such as SECONDS or MICROSECONDS, is this true ? it is possible to change it and won't effect any data if so where I can go change that and what I should put instead.

Thanks 

I change it to second and it didn't work please advise.

Database Error Code: Deadlock found when trying to get lock; try restarting transaction, 1213
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] =>
UPDATE civicrm_group g
SET    cache_date = null
WHERE  TIMESTAMPDIFF(SECOND, cache_date, 20120208161221) >= 0
 [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
    [type] => DB_Error
    [user_info] =>
UPDATE civicrm_group g
SET    cache_date = null
WHERE  TIMESTAMPDIFF(SECOND, cache_date, 20120208161221) >= 0
 [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="
UPDATE civicrm_group g
SET    cache_date = null
WHERE  TIMESTAMPDIFF(SECOND, cache_date, 20120208161221) >= 0
 [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]"]
)