MySQL deadlock on site save

Description

When creating or updating a site, under mysql, the site service has been failing due to deadlocks.

I found this (along with the deadlocks on authz groups, https://sakaiproject.atlassian.net/browse/SAK-8454#icft=SAK-8454) when stress testing creating new accounts (which creates a myworkspace for each new account).

Solution: remove the transaction around the site creation.

Activity

Filter Maintainer September 10, 2007 at 7:30 AM

[Bulk Edit] This issue is Resolved for 2.4.0, however, there were not sufficient resources available for it to be QA'ed. As no further reports have caused it to be reopened we are assuming it was completely addressed, and are Closing it. Please feel free to reopen this issue if you are indeed experiencing problems with this specific issue's fix, otherwise, please open a new issue.

Glenn R. Golden March 17, 2007 at 11:58 AM

Rather than removing the transactions, we will retry the transaction if deadlock occurs, a configurable number of times.

Megan May March 14, 2007 at 3:46 PM

Updating these issues to have a fix version of 2.4.0.004 tag as these will be in the .004 tag (to be cut on March 18)

Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Created March 12, 2007 at 3:54 PM
Updated February 11, 2009 at 6:53 PM
Resolved March 12, 2007 at 4:25 PM