Channels
android_tests
apple-silicon
arm-architecture
auditing-warroom
aws
carving
code-review
community-feeds
core
darkbytes
doorman
ebpf
eclecticiq-polylogyx-extension
extensions
file-carving
fim
fleet
fleet-dev
fleetosquery
foundation
fuzzing
general
golang
goquery
infrastructure
jobs
kolide
linen-dev
linux
macos
officehours
osctrl
plugins
process-auditing
querycon
queryhub
random
selfgroup
sql
tls
uptycs
vendor-feeds
website
windows
zeek
zentral
zercurity
Title
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
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 PMWhat version of Fleet are you running
fleet version --fulla
Austin Dunn
10/30/2020, 10:03 PMfleet - 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 PMIs 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 PMFleet 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 PMYeah, 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 AMHa 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_at