Missing software titles in software tab

Fleet version: v4.59.1 (probably previous versions too)

💥 Actual behavior

On the main Software tab:

Software versions are listed properly when Show versions is enabled. E.g. user can see names like Slack.app or Google Chrome.app. API: GET /api/latest/fleet/software/versions.
Some software titles are missing when Show versions is disabled. E.g. user searches and cannot find Slack.app or Google Chrome.app. API: GET /api/latest/fleet/software/titles.

This happens on All teams and when selecting a specific team.

🧑‍💻 Steps to reproduce

We still don't know why this is happening.

🕯️ More info (optional)

Guess: The vulnerabilities cron might be failing to aggregate software titles (if a title has hosts_count = 0 then it's not returned on the software titles API). Thus I requested vulnerabilities cron error logs.

We are still awaiting unfiltered logs from the user (seems details is missing here which could provide more information):

{
    "@timestamp": "2024-11-22T00:07:11.565Z",
    "instance": "...",
    "level": "error",
    "cron": "vulnerabilities",
    "err": "running job",
    "details": "upsert software titles: Error 1869 (HY000): Auto-increment value in UPDATE conflicts with internally generated values",
    "jobID": "cron_reconcile_software_titles"
},

fleetdm / fleet