https://github.com/osquery/osquery logo
#fleet
Title
# fleet
b

benbass

11/17/2020, 8:34 PM
I just updated from 3.0.0 to 3.3.0 and I am seeing a warning when I start the service that it is missing migrations. I have run the fleet prepare db a few times with no luck. Does anyone have any thoughts?
n

Noah Talerman

11/17/2020, 9:28 PM
Hi! That’s odd that you’re seeing both the warning and the “Migrations completed” messages. I’m guessing you’ve been following the updating fleet documentation (linked here: https://github.com/fleetdm/fleet/blob/master/docs/infrastructure/updating-fleet.md#running-database-migrations) Do you mind sending a screenshot of the commands you ran and their respective output?
b

benbass

11/17/2020, 9:29 PM
Sure - let me check again.
👍 1
Just sent you a DM.
Just an FYI, these are the same procedures and commands I have run for all of the updates to fleet I have done in the past. Not sure what is different this time.
This is on my dev instance so it doesn’t get much traffic, but we can definitely look at the mysql db. It is a db originally from a 1.x or older version of fleet.
z

zwass

11/17/2020, 10:18 PM
Hey Ben, can you please run
select * from migration_status_tables
on that MySQL database and paste the output (here or in a DM)? Which version are you upgrading from?