Geo: Out of sync repositories not decreasing on GPRD
I did some analysis on the out of sync repositories on the GPRD site:
- We have 18,461 projects that may be deemed "dirty" (
Geo::ProjectRegistry.where(resync_repository: true).count) - 11,683 don't have a failure reason associated with them (
Geo::ProjectRegistry.where(resync_repository: true).where(last_repository_sync_failure: nil).count) - Only 1 project has a
repository_retry_attime in the future (Geo::ProjectRegistry.where(resync_repository: true).where(last_repository_sync_failure: nil).where("repository_retry_at > '#{Time.now}'").count) - 6,761 have some failure reason associated with them (
Geo::ProjectRegistry.where(resync_repository: true).where.not(last_repository_sync_failure: nil).count) - About 371 of these projects have been synced recently (
Geo::ProjectRegistry.where(resync_repository: true).where(last_repository_sync_failure: nil).where("last_repository_successful_sync_at > '#{Time.now.yesterday}'").count)
Edited by Stan Hu