Jason Roberts
04/13/2023, 6:32 PMJohn Speno
04/13/2023, 6:34 PMJason Roberts
04/13/2023, 6:36 PMJohn Speno
04/13/2023, 6:38 PMutf8mb4_unicode_ci
- good luck.Jason Roberts
04/13/2023, 6:51 PMCollation utf8mb4_unicode_ci
Character set utf8mb4
Is the same called out in your gcp fleetdm terraform example https://github.com/fleetdm/fleet/blob/73827717d65e6f291161e2f53a1aa84f357dba9e/infrastructure/dogfood/terraform/gcp/mysql.tf#L40zwass
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;
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.Jason Roberts
04/13/2023, 7:35 PMzwass