Skip to content

Fix database cross-join in Project & Group transfer

Max Orefice requested to merge mo-update_pending_builds-when-transferring-group-or-project-causes into master

Ref: #346229 (closed)

What does this MR do and why?

This MR fixes a cross database query between our 2 new databases identified as a ~"sharding-blocker" when a project or group is transferred.

Why are we doing this?

As explained on our multi databases documentation it will not be possible to make a transaction accessing our 2 databases.

This is why we are moving out our logic to update Ci::PendingBuild to 2 new dedicated workers so the update will happen asynchronously outside of our current transaction.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Max Orefice

Merge request reports