Jason Roberts04/13/2023, 6:32 PM
John Speno04/13/2023, 6:34 PM
Jason Roberts04/13/2023, 6:36 PM
John Speno04/13/2023, 6:38 PM
- good luck.
Jason Roberts04/13/2023, 6:51 PM
Is the same called out in your gcp fleetdm terraform example https://github.com/fleetdm/fleet/blob/73827717d65e6f291161e2f53a1aa84f357dba9e/infrastructure/dogfood/terraform/gcp/mysql.tf#L40
Collation utf8mb4_unicode_ci Character set utf8mb4
If those work, you should hopefully be able to re-run the migration successfully. If not, you may need to follow the manual duplicate removal as described in https://github.com/fleetdm/fleet/issues/10911#issuecomment-1496293883.
ALTER TABLE software CONVERT TO CHARACTER SET utf8mb4; ALTER TABLE host_users CONVERT TO CHARACTER SET utf8mb4; ALTER TABLE operating_systems CONVERT TO CHARACTER SET utf8mb4;
Jason Roberts04/13/2023, 7:35 PM