Problem Definition

The cwd_tombstone table records removed users, groups, memberships and aliases during incremental synchronization for external user directories.

Over time, this table will continue to grow when left unchecked. The Crowd application has the capability to remove records older than 7 days. However, this is not implemented in Bitbucket.

Suggested Solution

Add a cleanup job so that cwd_tombstone records older than 7 days are removed.

Why This Is Important

The disk consumption of the cwd_tombstone table can significantly grow in size over time so it has to be cleaned up without user intervention.

This can also affect database migration where the tool might be backing up/restoring millions of records from this table, causing the migration to get stuck.

Workaround

Manually delete records from the cwd_tombstone table which are older than 7 days (based on the tombstone_timestamp column)

• Stop Bitbucket
• Take a backup of the database and the filesystem
• Delete cwd_tombstone records older than 7 days. Adjust the WHERE clause as necessary based on the database.

  DELETE FROM cwd_tombstone WHERE tombstone_timestamp < (EXTRACT(EPOCH FROM current_timestamp) - 7 * 24 * 60 * 60) * 1000;
  

• Start Bitbucket