Channels
doorman
infrastructure
random
zercurity
community-feeds
fleet-dev
code-review
queryhub
apple-silicon
carving
tls
fim
goquery
zentral
aws
querycon
golang
zeek
file-carving
fuzzing
auditing-warroom
linen-dev
fleetosquery
plugins
jobs
arm-architecture
darkbytes
process-auditing
uptycs
android_tests
selfgroup
vendor-feeds
fleet
eclecticiq-polylogyx-extension
ebpf
website
core
general
macos
kolide
osctrl
extensions
foundation
sql
officehours
linux
windows
Title
t
Tor Houghton
12/16/2021, 9:25 AMA question about upgrading to 4.7.0; I get the following when I did docker-compose run fleetdm fleet prepare db
Missing migrations: tables=[20211116184030 20211202092042 20211202181033 20211207161856], data=[].
2021/12/16 09:23:34 FAIL 20211202092042_RemovePolicyHistory.go (create policy membership table: Error 1005: Can't create table
fleetpolicy_membershipl
Lucas Rodriguez
12/16/2021, 11:27 AMHi Tor! I don't think it's related to file carving, let me take a look.
Q: Did you upgrade from v4.6.2?
When you ran
prepare dbMissing migrations: tables=...Press Enter to continue, or Control-c to exit.FAILAlso, what MySQL database are you using and which version?
t
Tor Houghton
12/16/2021, 5:01 PMHoi Lucas! Yes, upgrading from 4.6.2; and yep, I got a prompt (and didn't press ctrl c :)).
The version is mysqld 10.3.31-MariaDB-0+deb10u1
l
Lucas Rodriguez
12/16/2021, 5:05 PMOK, thanks for the info, I'll create an issue right away. It could be an incompatibility issue with MariaDB.
t
Tor Houghton
12/16/2021, 5:07 PMat this point i have no idea if i can attempt to start fleet or not (i left it on the floor in case there were things you wanted me to manually do in the db). is it ok to attempt a start? or should i just hold fast.
l
Lucas Rodriguez
12/16/2021, 5:08 PMNo, a start will cause issue due to the failed migrations.
👍 1
The team will try to reproduce and will respond on the issue as soon as we can.
t
Tor Houghton
12/16/2021, 5:12 PMCool beans. Thanks!
w
wkleinhenz
12/18/2021, 4:06 AMIm seeing this same issue, running with docker, im using Mariadb:10.6, the official container, upgrading from the last latest version to the most current one
👍 1
t
Tor Houghton
12/20/2021, 5:59 PMCan confirm that doing
MariaDB [fleet]> ALTER TABLE policy_membership_history DROP FOREIGN KEY fk_policy_membership_policy_id, DROP FOREIGN KEY fk_policy_membership_host_id;
then
$ docker-compose run fleetdm fleet prepare db
results in "Migrations completed." (but does report
# Missing migrations: tables=[20211202092042 20211202181033 20211207161856], data=[].
).
fleetdm appears to start normally after this.