Esteban
07/01/2021, 11:33 AM2021/07/01 11:29:41 FAIL 20210601000001_CreateTeamsTables.go (alter hosts: Error 1005: Can't create table `fleet`.`hosts` (errno: 121 "Duplicate key on write or update")), quitting migration.
zwass
07/01/2021, 3:23 PMEsteban
07/01/2021, 4:07 PMzwass
07/01/2021, 6:27 PMThe CONSTRAINT symbol value, if defined, must be unique in the database. A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121).I am not sure why this migration works in our development and testing environments. Let us think about how to best address this and make a 4.0.1 release.
Esteban
07/01/2021, 6:50 PMzwass
07/01/2021, 6:53 PMEsteban
07/01/2021, 6:57 PMzwass
07/01/2021, 10:52 PMEsteban
07/02/2021, 12:01 AMzwass
07/02/2021, 12:17 AMEsteban
07/02/2021, 12:47 AM2021/07/02 11:26:08 FAIL 20210601000002_AddRolesToInvites.go (create invite_teams: Error 1005: Can't create table `fleet`.`invite_teams` (errno: 121 "Duplicate key on write or update")), quitting migration.
Ricardo Santos
07/02/2021, 2:27 PM{"component":"service","err":"list users: missing destination name global_role in *[]*kolide.User","level":"info","method":"ListUsers","took":"698.826µs","ts":"2021-07-02T14:26:11.197380836Z","user":"none"}
Error fetching setup requirement: list users: missing destination name global_role in *[]*kolide.User
Esteban
07/02/2021, 2:39 PMRicardo Santos
07/02/2021, 3:00 PMzwass
07/03/2021, 12:34 AMALTER TABLE user_teams DROP FOREIGN KEY fk_team_id, ADD FOREIGN KEY fk_user_teams_team_id (team_id) REFERENCES teams (id) ON DELETE CASCADE ON UPDATE CASCADE;
Ricardo Santos
07/05/2021, 9:47 AMEsteban
07/05/2021, 11:41 AM