Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-12379

Delete user tags (and ratings?) via hourly cron on user deletion

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • None
    • Back-end
    • None

      Currently we remove all tags and ratings for a user when they (or an admin) delete their account. For users with a significant amount of tags (multiple thousands) this is very slow, to the point that it can time out and block the user deletion.

      The new triggers for tags added in MBS-12224 do not seem to make this a lot worse than it already was but also do not help at all with the issue. As such, it probably makes sense to just queue the tag (and rating?) removal so that it happens via an hourly cron job instead of immediately - it's not a big deal to wait a while and the editor row isn't deleted anyway, so there's no FK problems.

            Unassigned Unassigned
            reosarevok Nicolás Tamargo
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:

                Version Package