New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Delete Orphaned Channels #4157

Closed
droyad opened this Issue Jan 12, 2018 · 3 comments

Comments

Projects
None yet
2 participants
@droyad

droyad commented Jan 12, 2018

For some customers the integrity check is reporting orphaned channels. We should write an upgrade script to delete those orphaned channels to determine whether the bug that created them in the first place is still present in the current version. (ie if they are deleted and the integrity check later finds them again).

@droyad droyad self-assigned this Jan 12, 2018

@droyad

This comment has been minimized.

Show comment
Hide comment
@droyad

droyad Jan 12, 2018

Until this is done, the following query removes them:

DELETE FROM Channel WHERE ProjectId not in (SELECT Id FROM Project)

droyad commented Jan 12, 2018

Until this is done, the following query removes them:

DELETE FROM Channel WHERE ProjectId not in (SELECT Id FROM Project)
@droyad

This comment has been minimized.

Show comment
Hide comment
@droyad

droyad Jan 15, 2018

Should also delete orphaned releases and add an integrity check for them

droyad commented Jan 15, 2018

Should also delete orphaned releases and add an integrity check for them

@droyad droyad closed this Jan 17, 2018

@octoreleasebot octoreleasebot added this to the 2018.1.0 milestone Jan 17, 2018

@octoreleasebot

This comment has been minimized.

Show comment
Hide comment
@octoreleasebot

octoreleasebot Jan 17, 2018

Release Note: Existing orphaned channels and releases are removed from the database

octoreleasebot commented Jan 17, 2018

Release Note: Existing orphaned channels and releases are removed from the database

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment