[BSERV-4701] Performance empty pull request rescope activities is very poor on MySQL

Type: Bug
Resolution: Fixed
Priority: High
Fix Version/s: 3.0.8, 3.1.5, 3.2.5, 3.3.1
Affects Version/s: 3.0.1
Component/s: Database - MySQL, Enterprise, Pull Requests
Labels:

Bug Fix Policy:
View Atlassian Server bug fix policy

~~STASH-4517~~ introduced a recurring background job that deletes empty rescope activities. Unfortunately, this delete query performs very poorly on MySQL when there are lots of records in the sta_activity_* tables. This can result in both an increase in deadlocks and extremely long delays on other SQL operations.

Another action which can trigger these slow operations is deleting a repository, since that requires deleting all of the repository's pull requests (and their activities).

is caused by

BSERV-4517 Empty activity deletion deadlocks on MySQL

Closed

mentioned in: Page Failed to load; Page Failed to load; Page Failed to load; Page Failed to load; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...

(6 mentioned in)

No work has yet been logged on this issue.

Assignee:: Dariusz Kordonski (Inactive)

Reporter:: Michael Heemskerk (Inactive)

Affected customers:: 0 This affects my team

Watchers:: 8 Start watching this issue

Created:: 13/May/2014 1:08 PM

Updated:: 20/Apr/2022 8:12 AM

Resolved:: 15/Sep/2014 6:43 AM

Bitbucket Data Center

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates

Backbone Issue Sync