https://github.com/osquery/osquery logo
#kolide
Title
# kolide
b

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.
Am I looking at some DB surgery to migrate?
Copy code
fleet version
fleet version 3.1.0
z

zwass

09/11/2020, 5:31 PM
Yes, I think so. Probably you need
drop table label_membership
.
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
fun
1
worked, ty
🍻 1