duplicate entry in guest_os when upgrading from 4.14 to 4.15 #5685

DB

4.14.1 => 4.15.2

restarting the management server after the packet upgrade fails with error "duplicate entry with id 305...". removing the entry and setting autoincrement back to 305 allows a successful migration

mysql> select * from guest_os_hypervisor where guest_os_id = 305;
+-------+-----------------+---------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
| id    | hypervisor_type | guest_os_name       | guest_os_id | hypervisor_version | uuid                                 | created             | removed | is_user_defined |
+-------+-----------------+---------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
| 12345 | VMware          | other3xLinux64Guest |         305 | 6.5                | xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx | 2020-08-22 19:44:35 | NULL    |               1 |
+-------+-----------------+---------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+

mysql> select * from guest_os where id = 305;
+-----+-------------+------+--------------------------------------+--------------------------+---------------------+---------+-----------------+
| id  | category_id | name | uuid                                 | display_name             | created             | removed | is_user_defined |
+-----+-------------+------+--------------------------------------+--------------------------+---------------------+---------+-----------------+
| 305 |           7 | NULL | xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx | Other 3.x Linux (64-bit) | 2020-08-22 21:43:15 | NULL    |               1 |
+-----+-------------+------+--------------------------------------+--------------------------+---------------------+---------+-----------------+

mysql> delete from guest_os_hypervisor where id = 12345;
mysql> delete from guest_os where id = 305;
mysql> ALTER TABLE guest_os AUTO_INCREMENT=305;

newly created entry should not have an id set, it should use autoincrement

script fails with sql error concerning duplicate entry with id 305