Cannot add same query to pack more than once (results in 5xx)

[noahtalerman]

• This is a duplicate of Cannot add same query to pack more than once (results in 5xx) kolide/fleet#2202.
• The issue was discussed during Roundup (12/2/2020).
• Noah has verified that the same error behavior regardless of the values chosen for the configuration fields.
• Error message displayed: inserting scheduled query: Error 1062: Duplicate entry 'query-1' for key 'unique_names_in_packs'

What version of fleet are you using (fleet version --full)?

2.4.0

What operating system are you using?

Docker image: kolide/fleet:2.4.0

What did you do?

1. create query 'my_awesome_query'
2. create pack 'my_pack'
3. (through the UI) add 'my_awesome_query' to pack, with snapshot false and interval 3600
4. (through the UI) add 'my_awesome_query' to pack again, with snapshot true, and interval 43200

What did you expect to see?

Query added to pack twice with different schedules / intervals.

Alternately: 400 error page explaining that adding a query to a pack more than once is not supported. I don't think a 5xx response is correct.

What did you see instead?

5xx error page

[zwass]

The related issue kolide/fleet#2227 was resolved by kolide/fleet#2327.

cc @guillaumoplatte

[zwass]

@nyanshak you reported this in kolide/fleet#2202 and it will be resolved with #96.