nyanshak
07/24/2020, 12:24 AM2020/07/23 20:12:34 FAIL 20200405120000_UpdateLabelStorage.go (ensure all hosts are in all hosts label: Error 1213: Deadlock found when trying to get lock; try restarting transaction), quitting migration.
^ when upgrading from 2.6.0 to 3.0.0fleet prepare db
, it failed on:
2020/07/23 22:47:00 FAIL 20200405120000_UpdateLabelStorage.go (create label_membership table: Error 1050: Table 'label_membership' already exists), quitting migration.
drop table label_membership;
Then re-running fleet prepare db
zwass
nyanshak
07/24/2020, 12:48 AMDid you have active servers running against the database while the migration was running?Yes - though I'm guessing from that that I probably shouldn't. Trying to limit downtime so hosts can continue to get osquery configs, but sounds like I should plan for downtime here
zwass