:wave: When I'm trying to do a DB migration I'm ge...
# kolideb
beatus
09/11/2020, 5:30 PM👋 When I'm trying to do a DB migration I'm getting
Copy code
20200405120000_UpdateLabelStorage.go (create label_membership table: Error 1050: Table 'label_membership' already exists), quitting migration.beatus
09/11/2020, 5:30 PMAm I looking at some DB surgery to migrate?
beatus
09/11/2020, 5:31 PM Copy code
fleet version
fleet version 3.1.0z
zwass
09/11/2020, 5:31 PM
Yes, I think so. Probably you need
drop table label_membershipzwass
09/11/2020, 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 PMfun
➕ 1
beatus
09/11/2020, 6:21 PMworked, ty
🍻 1