[
https://issues.apache.org/jira/browse/TC-182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15905945#comment-15905945
]
ASF GitHub Bot commented on TC-182:
-----------------------------------
Github user MattMills closed the pull request at:
https://github.com/apache/incubator-trafficcontrol/pull/345
> 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)
