Problem Definition

If deleting a lot of rows from COMMIT_FILES during Build Deletion or Expiry, this can take a long time, potentially blocking other tasks from running.

Suggested Solution

Perform incremental deletes, or limited delete, so that Bamboo runs multiple smaller queries instead of one large query.

Why this is important

This query could, in some cases, affect enough Builds that it would be attempting to delete over two billion rows. This would result in significant load on the database, and thus the server.

Workaround

There is a possible workaround:

1. Stop Bamboo
2. Run delete queries to delete some number of rows at a time
3. Start Bamboo