Title
#kolide
b

beatus

09/11/2020, 5:30 PM
👋 When I'm trying to do a DB migration I'm getting
20200405120000_UpdateLabelStorage.go (create label_membership table: Error 1050: Table 'label_membership' already exists), quitting migration.
5:30 PM
Am I looking at some DB surgery to migrate?
5:31 PM
fleet version
fleet version 3.1.0
zwass

zwass

09/11/2020, 5:31 PM
Yes, I think so. Probably you need
drop table label_membership
.
5:31 PM
Unfortunately MySQL does not handle table creation within transactions so we can end up in weird states when migrations fail.
b

beatus

09/11/2020, 5:32 PM
6:21 PM
worked, ty