You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafficcontrol.apache.org by GitBox <gi...@apache.org> on 2018/06/26 14:39:54 UTC
[GitHub] ocket8888 opened a new issue #2467: Error when attempting to view
Delivery services on a specific mid-tier cache
ocket8888 opened a new issue #2467: Error when attempting to view Delivery services on a specific mid-tier cache
URL: https://github.com/apache/trafficcontrol/issues/2467
I suspect this applies to all server types. I noticed it in the Traffic Portal UI via Configure -> Services -> {{ a server }} -> More -> View Delivery Services. API endpoint is `/api/1.3/servers/{{server id}}/deliveryservices`
Full Error output:
```
trafficops_1 | INFO: routing.go:225: 2018-06-26T14:03:04.501882959Z: GET /api/1.3/servers/1/deliveryservices handling (reqid 43)
trafficops_1 | DEBUG: shared_handlers.go:147: 2018-06-26T14:03:04.502699091Z: Query is SELECT
trafficops_1 | active,
trafficops_1 | ccr_dns_ttl,
trafficops_1 | cdn_id,
trafficops_1 | cacheurl,
trafficops_1 | check_path,
trafficops_1 | dns_bypass_cname,
trafficops_1 | dns_bypass_ip,
trafficops_1 | dns_bypass_ip6,
trafficops_1 | dns_bypass_ttl,
trafficops_1 | dscp,
trafficops_1 | display_name,
trafficops_1 | edge_header_rewrite,
db_1 | ERROR: column "org_server_fqdn" does not exist at character 583
trafficops_1 | geo_limit,
db_1 | STATEMENT: SELECT
trafficops_1 | geo_limit_countries,
db_1 | active,
trafficops_1 | geolimit_redirect_url,
db_1 | ccr_dns_ttl,
trafficops_1 | geo_provider,
db_1 | cdn_id,
trafficops_1 | global_max_mbps,
trafficops_1 | global_max_tps,
trafficops_1 | http_bypass_fqdn,
trafficops_1 | id,
trafficops_1 | ipv6_routing_enabled,
db_1 | cacheurl,
trafficops_1 | info_url,
db_1 | check_path,
trafficops_1 | initial_dispersion,
db_1 | dns_bypass_cname,
trafficops_1 | last_updated,
db_1 | dns_bypass_ip,
trafficops_1 | logs_enabled,
db_1 | dns_bypass_ip6,
trafficops_1 | long_desc,
db_1 | dns_bypass_ttl,
db_1 | dscp,
trafficops_1 | long_desc_1,
db_1 | display_name,
trafficops_1 | long_desc_2,
db_1 | edge_header_rewrite,
trafficops_1 | max_dns_answers,
db_1 | geo_limit,
trafficops_1 | mid_header_rewrite,
db_1 | geo_limit_countries,
trafficops_1 | miss_lat,
db_1 | geolimit_redirect_url,
trafficops_1 | miss_long,
db_1 | geo_provider,
trafficops_1 | multi_site_origin,
db_1 | global_max_mbps,
db_1 | global_max_tps,
trafficops_1 | multi_site_origin_algorithm,
db_1 | http_bypass_fqdn,
trafficops_1 | org_server_fqdn,
db_1 | id,
trafficops_1 | origin_shield,
db_1 | ipv6_routing_enabled,
trafficops_1 | profile,
db_1 | info_url,
trafficops_1 | protocol,
db_1 | initial_dispersion,
trafficops_1 | qstring_ignore,
db_1 | last_updated,
trafficops_1 | range_request_handling,
db_1 | logs_enabled,
trafficops_1 | regex_remap,
db_1 | long_desc,
trafficops_1 | regional_geo_blocking,
db_1 | long_desc_1,
trafficops_1 | remap_text,
db_1 | long_desc_2,
trafficops_1 | routing_name,
db_1 | max_dns_answers,
trafficops_1 | ssl_key_version,
db_1 | mid_header_rewrite,
trafficops_1 | signing_algorithm,
db_1 | miss_lat,
trafficops_1 | tr_request_headers,
db_1 | miss_long,
trafficops_1 | tr_response_headers,
db_1 | multi_site_origin,
trafficops_1 | tenant_id,
db_1 | multi_site_origin_algorithm,
trafficops_1 | type,
db_1 | org_server_fqdn,
trafficops_1 | xml_id
db_1 | origin_shield,
trafficops_1 | FROM deliveryservice d
trafficops_1 | WHERE id in (SELECT deliveryService FROM deliveryservice_server where server = $1)
db_1 | profile,
db_1 | protocol,
db_1 | qstring_ignore,
db_1 | range_request_handling,
trafficops_1 | ERROR: shared_handlers.go:147: 2018-06-26T14:03:04.503490886Z: Error querying DeliveryserviceServers: pq: column "org_server_fqdn" does not exist
db_1 | regex_remap,
db_1 | regional_geo_blocking,
trafficops_1 | ERROR: alerts.go:81: 2018-06-26T14:03:04.503543863Z: 172.13.239.7:56150 [database access error]
db_1 | remap_text,
db_1 | routing_name,
db_1 | ssl_key_version,
db_1 | signing_algorithm,
trafficops_1 | 172.13.239.7:56150 - admin [26/Jun/2018:14:03:04 +0000] "GET /api/1.3/servers/1/deliveryservices HTTP/1.1" 500 81 1 "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36"
db_1 | tr_request_headers,
trafficops_1 | INFO: routing.go:203: 2018-06-26T14:03:04.504086235Z: GET /api/1.3/servers/1/deliveryservices handled (reqid 43) in 2.155238ms
db_1 | tr_response_headers,
db_1 | tenant_id,
db_1 | type,
db_1 | xml_id
db_1 | FROM deliveryservice d
db_1 | WHERE id in (SELECT deliveryService FROM deliveryservice_server where server = $1)```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services