Title
#kolide
v

vaar

05/11/2020, 10:08 AM
is there a way to skip this DROP with prepare db? 2020/05/11 10:07:00 FAIL 20191010155147_UpdateTableHostsSearchIndex.go (drop old index: Error 1091: Can't DROP 'hosts_search'; check that column/key exists), quitting migration.
zwass

zwass

05/11/2020, 3:15 PM
No, but maybe you can add the index before running the migration?
v

vaar

05/11/2020, 3:41 PM
do you know how this index is done by kolide? just to not messup with the table 🙂
4:32 PM
I would try
CREATE FULLTEXT INDEX hosts_search ON hosts(host_name)
and then run the migration again.
4:32 PM
As always, very good idea to backup before running migrations.
v

vaar

05/11/2020, 4:52 PM
yes, already did it, thanks