[ https://issues.apache.org/jira/browse/TC-226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15963529#comment-15963529 ]
ASF GitHub Bot commented on TC-226: ----------------------------------- GitHub user dangogh opened a pull request: https://github.com/apache/incubator-trafficcontrol/pull/450 [TC-226] fixes inserts to work on initial setup missed a couple of thing in seeds.sql -- this should fix them You can merge this pull request into a Git repository by running: $ git pull https://github.com/dangogh/incubator-trafficcontrol TC-226 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafficcontrol/pull/450.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #450 ---- commit 9fd5c535c8016c9e20414269f41fc542351cb2f7 Author: Dan Kirkwood <dang...@gmail.com> Date: 2017-04-10T21:46:53Z fixes inserts to work on initial setup ---- > 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)