Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

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?

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?

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.

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?