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

osquery

After upgrading to 4.54.0 we started seeing the following error in our ad hoc host where we run the `vulnerability processing` job
```Error: upsert software titles: Error 1869 (HY000): Auto-increment value in UPDATE conflicts with internally generated values```
Based on the error message I think it comes from the following <https://github.com/fleetdm/fleet/commit/e90b90d9051d4f2eb4246eadcbce6d6da13637db|commit>. I'm wondering if anyone else has seen this error before

<@U02A65PNY8K> -- I'm seeing this error with vuln processing jobs as well. Did you find a solution?

in our case we upgraded from 4.51 -&gt; 4.56, which would have gotten whatever 4.54 code you errored on

So the issue is in this <https://github.com/fleetdm/fleet/blob/fleet-v4.54.0/server/datastore/mysql/software.go#L1614-L1662|INSERT query>
I had to run the query by pieces to identify which records where triggering the error and then I had to update them manually.
I only had to do this once, after that we didn't face this issue anymore.

Interesting. I'll dig in. Do you recall the specific column(s) that were problematic?

no worries! I shall hack away at this. Appreciate the pointer! :ty: