Hey there trying upgrade and running into this iss...
# fleetp
pickmansec
10/03/2023, 7:10 PMHey there trying upgrade and running into this issue while doing the prepare db command
Copy code
2023/10/03 19:08:11 FAIL 20220915165116_HostDisplayName.go (upHostDisplayName: delete index: Error 1091 (42000): Can't DROP 'hosts_search'; check that column/key exists), quitting migration.g
Grant Bilstad
10/03/2023, 7:41 PMHey there Pickmansec!
Want to take existing servers offline before running the `fleet prepare db`; This could probably be better stated in docs somehow. Servers need to be offline as tables being constantly adjusted and if being currently inserted, will fail the prepare.
https://fleetdm.com/docs/deploy/upgrading-fleet
p
pickmansec
10/03/2023, 7:49 PM@Grant Bilstad when service is down we get this error
pickmansec
10/03/2023, 7:52 PM Copy code
ERROR 1062 (23000): Duplicate entry '' for key 'hosts.hosts_search'g
Grant Bilstad
10/03/2023, 8:00 PMinteresting, is your db something other than SQLite? Believe ran into this before and there was a work-around from another... trying to dig up
p
pickmansec
10/03/2023, 8:03 PMmysql
g
Grant Bilstad
10/03/2023, 8:04 PMHere is thread for someone with similar issue, but they were running K8 https://osquery.slack.com/archives/C01DXJL16D8/p1694629245611819
k
Kathy Satterlee
10/03/2023, 8:53 PMHey @pickmansec! Can you give me your full database version?
p
pickmansec
10/03/2023, 8:55 PMActually we followed that threads advice and everything worked out
k
Kathy Satterlee
10/03/2023, 9:49 PMThat's great! I'd still love the database information so we can work on recreating the issue.
p
pickmansec
10/06/2023, 4:27 PMHow do I get you that information?
2 Views