mirror of
https://codeberg.org/forgejo/forgejo.git
synced 2026-07-25 10:57:37 +00:00
c07ea09050
In the case you hit some API error (Github ratelimit was often a problem) or the instance restarted in the middle of your migration, you would be left with data on the disk and/or database. Upon retrying the migration the migration code would (rightfully) fail because it's trying to migrate stuff that already exists.
This was hit so often on Codeberg it was better to force people to delete and start whole migration process again: 28ee60c91f
Delete the repository data before retrying to solve this.
Reviewed-on: https://codeberg.org/forgejo/forgejo/pulls/12370
Reviewed-by: Mathieu Fenniak <mfenniak@noreply.codeberg.org>
78 lines
2 KiB
Go
78 lines
2 KiB
Go
// Copyright 2023 The Gitea Authors. All rights reserved.
|
|
// SPDX-License-Identifier: MIT
|
|
|
|
package doctor
|
|
|
|
import (
|
|
"context"
|
|
|
|
"forgejo.org/models/db"
|
|
"forgejo.org/modules/log"
|
|
"forgejo.org/modules/storage"
|
|
repo_service "forgejo.org/services/repository"
|
|
|
|
"xorm.io/builder"
|
|
)
|
|
|
|
func handleDeleteOrphanedRepos(ctx context.Context, logger log.Logger, autofix bool) error {
|
|
test := &consistencyCheck{
|
|
Name: "Repos with no existing owner",
|
|
Counter: countOrphanedRepos,
|
|
Fixer: deleteOrphanedRepos,
|
|
FixedMessage: "Deleted all content related to orphaned repos",
|
|
}
|
|
return test.Run(ctx, logger, autofix)
|
|
}
|
|
|
|
// countOrphanedRepos count repository where user of owner_id do not exist
|
|
func countOrphanedRepos(ctx context.Context) (int64, error) {
|
|
return db.CountOrphanedObjects(ctx, "repository", "user", "repository.owner_id=`user`.id")
|
|
}
|
|
|
|
// deleteOrphanedRepos delete repository where user of owner_id do not exist
|
|
func deleteOrphanedRepos(ctx context.Context) (int64, error) {
|
|
if err := storage.Init(); err != nil {
|
|
return 0, err
|
|
}
|
|
|
|
batchSize := db.MaxBatchInsertSize("repository")
|
|
e := db.GetEngine(ctx)
|
|
var deleted int64
|
|
|
|
for {
|
|
select {
|
|
case <-ctx.Done():
|
|
return deleted, ctx.Err()
|
|
default:
|
|
var ids []int64
|
|
if err := e.Table("`repository`").
|
|
Join("LEFT", "`user`", "repository.owner_id=`user`.id").
|
|
Where(builder.IsNull{"`user`.id"}).
|
|
Select("`repository`.id").Limit(batchSize).Find(&ids); err != nil {
|
|
return deleted, err
|
|
}
|
|
|
|
// if we don't get ids we have deleted them all
|
|
if len(ids) == 0 {
|
|
return deleted, nil
|
|
}
|
|
|
|
for _, id := range ids {
|
|
if err := repo_service.DeleteRepositoryDirectly(ctx, id, repo_service.DeleteRepositoryOpts{IgnoreOrgTeams: true}); err != nil {
|
|
return deleted, err
|
|
}
|
|
deleted++
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
func init() {
|
|
Register(&Check{
|
|
Title: "Deleted all content related to orphaned repos",
|
|
Name: "delete-orphaned-repos",
|
|
IsDefault: false,
|
|
Run: handleDeleteOrphanedRepos,
|
|
Priority: 4,
|
|
})
|
|
}
|