https://github.com/osquery/osquery logo
Title
r

ryan

10/04/2021, 9:08 PM
Upgraded from 4.3.1 to 4.3.2 on Ubuntu 20 and the DB migration hangs. If I kill the process and rerun it I get an error
2021/10/04 20:26:53 FAIL 20210927143115_AddPolicyUpdatedAtColumn.go (adding policy_updated_at column: Error 1060: Duplicate column name 'policy_updated_at'), quitting migration.
so I check and it appears it’s an addition to the host table. I altered and drop the column and ran the DB migration again and it continues to hang. I killed it again and started fleet and it’s updating the column so 🤷
z

zwass

10/04/2021, 10:25 PM
Can you try
TRUNCATE TABLE policy_membership_history
followed by dropping that column and running the migration again?
r

ryan

10/05/2021, 12:17 AM
Ran successfully 👍
🚀 1