You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafficcontrol.apache.org by "Dan Kirkwood (JIRA)" <ji...@apache.org> on 2017/07/06 01:02:00 UTC
[jira] [Closed] (TC-226) TO: seeds.sql produces errors on new setup
[ https://issues.apache.org/jira/browse/TC-226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dan Kirkwood closed TC-226.
---------------------------
> 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.4.14#64029)