[jira] [Commented] (TC-182) Traffic Ops seeds.sql missing data from the status table

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TC-182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15905297#comment-15905297 ] 

ASF GitHub Bot commented on TC-182:
-----------------------------------

GitHub user MattMills opened a pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/345

    [TC-182] Add additional statuses into traffic ops seeds.sql

    This pr adds additional required statuses into the traffic ops status table fixing TC-182.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/MattMills/incubator-trafficcontrol TC-182_fix

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafficcontrol/pull/345.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 #345
    
----
commit 536bfe21971c1a757bf3d6a03f3d1fe75acbc4f4
Author: Matt Mills <mm...@2bn.net>
Date:   2017-03-10T15:51:47Z

    Add additional statuses into traffic ops seeds.sql (TC-182)

----


> Traffic Ops seeds.sql missing data from the status table
> --------------------------------------------------------
>
>                 Key: TC-182
>                 URL: https://issues.apache.org/jira/browse/TC-182
>             Project: Traffic Control
>          Issue Type: Bug
>          Components: Traffic Ops
>            Reporter: Matt Mills
>            Priority: Minor
>
> Currently seeds.sql contains the following for the status table:
> {code:sql}
> -- statuses
> insert into status (name, description) values ('PRE_PROD', 'Pre Production. Not active in any configuration.') ON CONFLICT DO NOTHING;
> {code}
> After startup, trying to add a server without the OFFLINE status in the table throws a SQL error. This can be resolved by adding the additional statuses:
> {code}
> OFFLINE    | Edge: Puts server in CCR config file in this state, but CCR will never route traffic to it. Mid: Server will not be included in parent.config files for its edge caches
> ONLINE     | Edge: Puts server in CCR config file in this state, and CCR will always route traffic to it. Mid: Server will be included in parent.config files for its edges
> REPORTED   | Edge: Puts server in CCR config file in this state, and CCR will adhere to the health protocol. Mid: N/A for now
> ADMIN_DOWN | Temporary down. Edge: XMPP client will send status OFFLINE to CCR, otherwise similar to REPORTED. Mid: Server will not be included in parent.config files for its edge caches
> CCR_IGNORE | Edge: 12M will not include caches in this state in CCR config files. Mid: N/A for now
> {code}



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