traffic_ops_ort.pl execution error

[Nuno Vargas <nu...@nos.pt>]

Hi,

We've installed the TrafficControl 2.3.0 ecosystem but are having a problem running the traffic_ops_ort.pl at ATS.

The script breaks when regex_revalidate.config is being processed:
ERROR https://10.150.136.74:443/api/1.2/cdns/nos/configfiles/ats/regex_revalidate.config returned HTTP 500! Internal Server Error
...
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR:  invalid input syntax for type interval: " day"
LINE 1: ...liveryservice WHERE ( start_time > now() - interval ' day' )
                                                               ^ [for Statement "SELECT me.id, me.agent, me.object_type, me.object_name, me.keyword, me.parameters, me.asset_url, me.asset_type, me.status, me.start_time, me.entered_time, me.job_user, me.last_updated, me.job_deliveryservice, job_deliveryservice.id, job_deliveryservice.xml_id, job_deliveryservice.active, job_deliveryservice.anonymous_blocking_enabled, job_deliveryservice.dscp, job_deliveryservice.signing_algorithm, job_deliveryservice.qstring_ignore, job_deliveryservice.geo_limit, job_deliveryservice.http_bypass_fqdn, job_deliveryservice.dns_bypass_ip, job_deliveryservice.dns_bypass_ip6, job_deliveryservice.dns_bypass_ttl, job_deliveryservice.type, job_deliveryservice.profile, job_deliveryservice.cdn_id, job_deliveryservice.ccr_dns_ttl, job_deliveryservice.global_max_mbps, job_deliveryservice.global_max_tps, job_deliveryservice.long_desc, job_deliveryservice.long_desc_1, job_deliveryservice.long_desc_2, job_deliveryservice.max_dns_answers, job_deliveryservice.info_url, job_deliveryservice.miss_lat, job_deliveryservice.miss_long, job_deliveryservice.check_path, job_deliveryservice.last_updated, job_deliveryservice.protocol, job_deliveryservice.ssl_key_version, job_deliveryservice.ipv6_routing_enabled, job_deliveryservice.range_request_handling, job_deliveryservice.edge_header_rewrite, job_deliveryservice.origin_shield, job_deliveryservice.mid_header_rewrite, job_deliveryservice.regex_remap, job_deliveryservice.cacheurl, job_deliveryservice.remap_text, job_deliveryservice.multi_site_origin, job_deliveryservice.display_name, job_deliveryservice.tr_response_headers, job_deliveryservice.initial_dispersion, job_deliveryservice.dns_bypass_cname, job_deliveryservice.tr_request_headers, job_deliveryservice.regional_geo_blocking, job_deliveryservice.geo_provider, job_deliveryservice.geo_limit_countries, job_deliveryservice.logs_enabled, job_deliveryservice.multi_site_origin_algorithm, job_deliveryservice.geolimit_redirect_url, job_deliveryservice.tenant_id, job_deliveryservice.routing_name, job_deliveryservice.deep_caching_type, job_deliveryservice.fq_pacing_rate FROM job me LEFT JOIN deliveryservice job_deliveryservice ON job_deliveryservice.id = me.job_deliveryservice WHERE ( start_time > now() - interval ' day' )"] at /opt/traffic_ops/app/lib/API/Configs/ApacheTrafficServer.pm line 1768
....

In the above database query  the where clause is invalid because "interval ' day'" is missing an integer.

There is the warn below but don't know if it is having any impact on this:
...
WARN regex_revalidate.config is being processed with an unknown service
....

Any clue how to solve or dig further on this issue?

Thanks in advance,

Regards,
Nuno Vargas
NOS