You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafficcontrol.apache.org by "Matt Mills (JIRA)" <ji...@apache.org> on 2017/03/10 15:36:04 UTC
[jira] [Created] (TC-182) Traffic Ops seeds.sql missing data from
the status table
Matt Mills created TC-182:
-----------------------------
Summary: 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)