Title
#kolide
a

Austin Dunn

10/30/2020, 10:00 PM
Hi 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
FAIL 20171116163618_CreateTableOsqueryOptions.go (migrate options: retrieving decorators: missing destination name created_at in *[]*tables.decorator), quitting migration.
zwass

zwass

10/30/2020, 10:02 PM
What version of Fleet are you running
fleet version --full
?
a

Austin Dunn

10/30/2020, 10:03 PM
fleet - version 3.2.0
  branch: 	master
  revision: 	07534c766beb7bf9a022d29572d88493ecef8f7c
  build date: 	2020-10-08T19:24:59Z
  build user: 	zwass
  go version: 	go1.15
zwass

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 PM
upgrading from an existing install
zwass

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 PM
correct
11:22 PM
i'd wipe it with a fresh install but i'm trying to not lose my data
zwass

zwass

10/30/2020, 11:25 PM
Yeah, that makes sense
11:28 PM
Never seen someone end up in this state before. I think you may resolve it with
alter table decorators drop column created_at
. That data is going to be dropped in the migration anyway.
11:37 PM
What 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 PM
fleet 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
11:56 PM
It’s percona MySQL server package. I’m going from the above ^
11:57 PM
(yeah really old trying to salvage this stack lol)
zwass

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 AM
I also dropped the column
updated_at
and migrations completed