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

osquery

Trying to upgrade to v4.69 the migration job failed:
```2025/06/20 04:23:13 [2025-05-07] Host SCIM User Primary Key
2025/06/20 04:23:13 FAIL 20250507170845_HostSCIMUserPrimaryKey.go (failed to drop constraints: Error 1091 (42000): Can't DROP 'fk_host_scim_scim_user_id'; check that column/key exists), quitting migration.```

I had to marshall the migration along manually as a superuser

<@U06FS72M2EB> Was the migration job being run by multiple instances at the same time?

The first barrier was:
`20250507170845_HostSCIMUserPrimaryKey.go (failed to delete rows from host_scim_user: Error 1105 (HY000): Percona-XtraDB-Cluster prohibits use of DML command on a table (fleet.host_scim_user) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER), quitting migration.`

Hi <@U06FS72M2EB>! It looks like there may be some settings in your DB that aren’t compatible with the way Fleet is doing things. You’ll likely be able to move forward with the migration if you update the pxc_strict_mode setting. I’d really recommend using MySQL to ensure compatibility with Fleet. 

As I mentioned above; I already fixed this