Dan Kirkwood created TC-226:
-------------------------------

             Summary: TO: seeds.sql produces errors on new setup
                 Key: TC-226
                 URL: https://issues.apache.org/jira/browse/TC-226
             Project: Traffic Control
          Issue Type: Bug
    Affects Versions: 2.1.0
            Reporter: Dan Kirkwood
            Assignee: Dan Kirkwood


I get the following errors when seeds.sql is loaded during `db/admin.pl setup`:

```
insert into cdn (name, dnssec_enabled) values ('ALL', false) ON CONFLICT (name) 
DO NOTHING;
ERROR:  null value in column "domain_name" violates not-null constraint
DETAIL:  Failing row contains (1, ALL, 2017-04-10 21:38:09.940452+00, f, null).
insert into job_agent (name, description, active) values ('dummy', 'Description 
of Purge Agent', true) ON CONFLICT (name) DO NOTHING;
ERROR:  column "active" is of type integer but expression is of type boolean
LINE 1: ...e) values ('dummy', 'Description of Purge Agent', true) ON C...
```



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to