Upgraded from fleetdm 4.17.1 > 4.19.0 and had to play open heart sql surgery to get it to work ended up with

INFO: 12:50:42 Increasing width of software.vendor...
2022/08/29 12:50:43 FAIL 20220818101352_ChangeSoftwareVendorWidth.go (adding new uniquess constraint: Error 1062: Duplicate entry 'openpgm-5.2.122-rpm_packages-2.el7--x86_64' for key 'unq_name'), quitting migration.

Which led to

2022/08/29 12:56:43 FAIL 20220818101352_ChangeSoftwareVendorWidth.go (creating temp column for vendor: Error 1060: Duplicate column name 'vendor_wide'), quitting migration.

After deleting the column and row i was able to upgrade.

This sounds like a question for #fleet?

ah yea ty