You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafficcontrol.apache.org by "David Neuman (JIRA)" <ji...@apache.org> on 2016/10/31 21:33:58 UTC

[jira] [Created] (TC-15) Duplicate data in seeds.sql results in error

David Neuman created TC-15:
------------------------------

             Summary: Duplicate data in seeds.sql results in error
                 Key: TC-15
                 URL: https://issues.apache.org/jira/browse/TC-15
             Project: Traffic Control
          Issue Type: Bug
          Components: Traffic Ops
    Affects Versions: 1.8.0
            Reporter: David Neuman
            Assignee: David Neuman
             Fix For: 1.8.0


When you try to run a setup of the Traffic Ops database, it fails with the following error:  ERROR 1452 (23000) at line 172: Cannot add or update a child row: a foreign key constraint fails (`to_integration`.`profile_parameter`, CONSTRAINT `fk_atsprofile_atsparameters_atsparameters1` FOREIGN KEY (`parameter`) REFERENCES `parameter` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION)

This is because of a copy/paste error on lines 152 and 153 that cause duplicate data.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)