Channels
#kolide
Title
# kolide
a
Austin Dunn
10/30/2020, 10:00 PMHi i'm hoping someone can help with this error. I'm trying to migrate mysql from 5.7 to 8. doing DB migrations i'm getting this error
Copy code
FAIL 20171116163618_CreateTableOsqueryOptions.go (migrate options: retrieving decorators: missing destination name created_at in *[]*tables.decorator), quitting migration.z
zwass
10/30/2020, 10:02 PM
What version of Fleet are you running
fleet version --fulla
Austin Dunn
10/30/2020, 10:03 PM Copy code
fleet - version 3.2.0
branch: master
revision: 07534c766beb7bf9a022d29572d88493ecef8f7c
build date: 2020-10-08T19:24:59Z
build user: zwass
go version: go1.15z
zwass
10/30/2020, 10:25 PM
Is this a fresh install or an upgrade of an existing install?
a
Austin Dunn
10/30/2020, 10:35 PMupgrading from an existing install
z
zwass
10/30/2020, 11:22 PM
Fleet version and MySQL version are changing at the same time?
a
Austin Dunn
10/30/2020, 11:22 PMcorrect
i'd wipe it with a fresh install but i'm trying to not lose my data
z
zwass
10/30/2020, 11:25 PM
Yeah, that makes sense
Never seen someone end up in this state before. I think you may resolve it with
alter table decorators drop column created_atWhat version are you upgrading from? I wonder if I can reproduce this issue by starting at that version.
a
Austin Dunn
10/30/2020, 11:56 PMfleet version 1.0.7-1 to latest
Percona-Server-server-57.x86_64 5.7.20-19.1.el7 to percona-server-server.x86_64 8.0.21-12.2.el7
It’s percona MySQL server package. I’m going from the above ^
(yeah really old trying to salvage this stack lol)
z
zwass
10/31/2020, 12:05 AM
Ha yeah quite dated! Let me know how the alter table goes.
a
Austin Dunn
10/31/2020, 4:00 AMI also dropped the column
updated_at3 Views