[TC-552] Global parameters may be duplicated when seeds.sql is run

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.1.0
• Component/s: Traffic Ops
• Assignee: Unassigned
• Reporter: Jeremy Mitchell
• Created: 24/Aug/17 21:14
• Updated: 24/Aug/17 21:15

Description

If seeds.sql is run multiple times (i.e. on first install and subsequent upgrades), the following global parameters may end up duplicated:

https://github.com/apache/incubator-trafficcontrol/blob/master/traffic_ops/app/db/seeds.sql#L36-L43

For example, if you change the value of use_tenancy from 0 to 1 and then run db/admin.pl upgrade you will end up with 2 parameters for use_tenancy

Potential solution: check to see if those 3 global parameters are already in the db, and if not, insert, else do nothing.