CiviCRM Community Forums (archive)

We had a previous issue with the UpdateMembershipRecord script which seemed to be fixed, but the memberships aren't updating and we're getting a lot of fatal errors now.

There doesn't seem to be much in these forums about the "Deadlock" error we're getting:
Updating ...

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: unknown error

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [c ode] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_activity  WHERE (  civicrm_activity.source_record_id = 848595 )  AND (  civicrm_activity.activity_type_id = 7 ) [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_activity  WHERE (  civicrm_activity.source_record_id = 848595 )  AND (  civicrm_activity.activity_type_id = 7 ) [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_activity  WHERE (  civicrm_activity.source_record_id = 848595 )  AND (  civicrm_activity.activity_type_id = 7 ) [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]"]
)

And the error_log is giving this error periodically when we're trying to run the script:

PHP Notice:  Undefined index:  2 in /home/username/sitename.org/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php on line 330

In addition, the error_log is showing these errors for other users:

PHP Warning:  MySQL server has gone away\nquery: INSERT INTO watchdog\n    (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n    VALUES\n    (1123, 'php', '%message in %file on line %line.', 'a:4:{s:6:\\"%error\\";s:12:\\"user warning\\";s:8:\\"%message\\";s:367:\\"MySQL server has gone away\\nquery: UPDATE sessions SET uid = 113, cache = 0, hostname = '23.128.31.111', session = 'CiviCRM|a:3:{s:4:\\\\"ufID\\\\";s:4:\\\\"1123\\\\";s:6:\\\\"userID\\\\";s:4:\\\\"1327\\\\";s:8:\\\\"ufUniqID\\\\";s:0:\\\\"\\\\";}', timestamp = 1258043931 WHERE sid = 'c59iqqf15ng50m7h81q5dep8k4'\\";s:5:\\"%file\\";s:69:\\"/home/username/sitename.org/includes/session.inc\\";s:5:\\"%line\\";i:68;}', 3, '', 'http://www.sitename.org/system/files/Ad in /home/username/sitename.org/includes/database.mysql.inc on line 128, referer: http://www.sitename.org/node/path

This is Drupal 6.14 and CiviCRM 3.0.2.  Any guidance would be greatly appreciated as nothing membership related is updating correctly. (Users are trying to re-subscribe and they get a whitescreen, then try again and get an error message...meanwhile they are billed twice... nightmares).

Thanks, Lobo.

I realized that we moved this to a freshly installed server and the host didn't do much in the way of tweaking the default settings. They told me that "MySQL server has gone away" usually was related to faulty programming and they didn't offer to help any further. Luckily I stumbled upon this post in the Drupal forums, and then called back and had the host check their default MySQL settings, which were less than 10% of what this post recommended...

We've bumped it up and are now testing to see if that is what the issue was.

If we continue to have problems I may take you up on your generous offer.

Peace,
Laryn

hey Laryn:

Once you have a good config for mysql settings, can you please post on wiki so others can benefit

lobo