I can't seem to install 4.7 fleet prepare db 2021/12/19 141739 FAIL 20211202092042_RemovePolicyHistory.go (create policy membership table: Error 1005: Can't create table

fleet

.

policy_membership

(errno: 121 "Duplicate key on write or update")), quitting migration. I see there's a bug report here (https://github.com/fleetdm/fleet/issues/3396) - someone said to remove indices - anyone know which ones to get an install to work?

Hi Catscrash, we are testing the workaround to remove the indices. We'll publish any updates on the issue.

https://osquery.slack.com/archives/C01DXJL16D8/p1640023187434200?thread_ts=1639646739.401700&cid=C01DXJL16D8 fwiw

Hi Tor, mhm

"Migrations completed."

should be displayed alone IIRC... So, after running such

ALTER

command and then running

prepare db

, you ran

serve

right? Does

serve

complain in any way? ("Missing migrations" message in the first lines of output)