Dan Kirkwood created TC-415: ------------------------------- Summary: traffic_ops unit test fails: api/1.1/deliveryservice/ssl_keys.t Key: TC-415 URL: https://issues.apache.org/jira/browse/TC-415 Project: Traffic Control Issue Type: Bug Components: Traffic Ops Affects Versions: 2.1.0 Reporter: Dan Kirkwood Fix For: 2.1.0
This test script is showing 2 failures: api/1.1/deliveryservice/ssl_keys.t It's unknown when this started, since unit tests haven't been watched for a while. Console log from Apache Jenkins (current build log is https://builds.apache.org/view/S-Z/view/TrafficControl/job/incubator-trafficcontrol-traffic_ops-test/3/consoleFull) shows the error: {quote} unit_1 | writing RSA key unit_1 | Signature ok unit_1 | subject=/C=US/ST=Colorado/L=Denver/O=KableTown/OU=CDN_Eng/CN=foober.com unit_1 | Getting Private key unit_1 | DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /opt/traffic_ops/app/lib/API/DeliveryService/SslKeys.pm line 159 unit_1 | Use of uninitialized value $host_regex in concatenation (.) or string at /opt/traffic_ops/app/lib/API/DeliveryService/SslKeys.pm line 151. unit_1 | Use of uninitialized value $cdn_id in string at /opt/traffic_ops/app/lib/API/DeliveryService/SslKeys.pm line 159. db_1 | ERROR: invalid input syntax for integer: "" db_1 | STATEMENT: SELECT me.id, me.xml_id, me.active, me.dscp, me.signed, me.qstring_ignore, me.geo_limit, me.http_bypass_fqdn, me.dns_bypass_ip, me.dns_bypass_ip6, me.dns_bypass_ttl, me.org_server_fqdn, me.type, me.profile, me.cdn_id, me.ccr_dns_ttl, me.global_max_mbps, me.global_max_tps, me.long_desc, me.long_desc_1, me.long_desc_2, me.max_dns_answers, me.info_url, me.miss_lat, me.miss_long, me.check_path, me.last_updated, me.protocol, me.ssl_key_version, me.ipv6_routing_enabled, me.range_request_handling, me.edge_header_rewrite, me.origin_shield, me.mid_header_rewrite, me.regex_remap, me.cacheurl, me.remap_text, me.multi_site_origin, me.display_name, me.tr_response_headers, me.initial_dispersion, me.dns_bypass_cname, me.tr_request_headers, me.regional_geo_blocking, me.geo_provider, me.geo_limit_countries, me.logs_enabled, me.multi_site_origin_algorithm, me.geolimit_redirect_url, me.tenant_id FROM deliveryservice me LEFT JOIN deliveryservice_regex deliveryservice_regexes ON deliveryservice_regexes.deliveryservice = me.id LEFT JOIN regex regex ON regex.id = deliveryservice_regexes.regex WHERE ( ( cdn_id = $1 AND regex.pattern = $2 ) ) unit_1 | Warning: Log message argument #1 undefined at /opt/traffic_ops/app/local/lib/perl5/Mojolicious.pm line 199. unit_1 | Use of uninitialized value in join or string at /opt/traffic_ops/app/local/lib/perl5/Log/Log4perl/Appender.pm line 182. unit_1 | unit_1 | # Failed test '400 Bad Request' unit_1 | # at /opt/traffic_ops/app/t/api/1.1/deliveryservice/ssl_keys.t line 208. unit_1 | # got: '500' unit_1 | # expected: '400' unit_1 | Use of uninitialized value $cdn_id in string at /opt/traffic_ops/app/lib/API/DeliveryService/SslKeys.pm line 159. db_1 | ERROR: invalid input syntax for integer: "" db_1 | STATEMENT: SELECT me.id, me.xml_id, me.active, me.dscp, me.signed, me.qstring_ignore, me.geo_limit, me.http_bypass_fqdn, me.dns_bypass_ip, me.dns_bypass_ip6, me.dns_bypass_ttl, me.org_server_fqdn, me.type, me.profile, me.cdn_id, me.ccr_dns_ttl, me.global_max_mbps, me.global_max_tps, me.long_desc, me.long_desc_1, me.long_desc_2, me.max_dns_answers, me.info_url, me.miss_lat, me.miss_long, me.check_path, me.last_updated, me.protocol, me.ssl_key_version, me.ipv6_routing_enabled, me.range_request_handling, me.edge_header_rewrite, me.origin_shield, me.mid_header_rewrite, me.regex_remap, me.cacheurl, me.remap_text, me.multi_site_origin, me.display_name, me.tr_response_headers, me.initial_dispersion, me.dns_bypass_cname, me.tr_request_headers, me.regional_geo_blocking, me.geo_provider, me.geo_limit_countries, me.logs_enabled, me.multi_site_origin_algorithm, me.geolimit_redirect_url, me.tenant_id FROM deliveryservice me LEFT JOIN deliveryservice_regex deliveryservice_regexes ON deliveryservice_regexes.deliveryservice = me.id LEFT JOIN regex regex ON regex.id = deliveryservice_regexes.regex WHERE ( ( cdn_id = $1 AND regex.pattern = $2 ) ) unit_1 | Warning: Log message argument #1 undefined at /opt/traffic_ops/app/local/lib/perl5/Mojolicious.pm line 199. unit_1 | Use of uninitialized value in join or string at /opt/traffic_ops/app/local/lib/perl5/Log/Log4perl/Appender.pm line 182. unit_1 | unit_1 | # Failed test '400 Bad Request' unit_1 | # at /opt/traffic_ops/app/t/api/1.1/deliveryservice/ssl_keys.t line 212. unit_1 | # got: '500' unit_1 | # expected: '400' unit_1 | Generating a 2048 bit RSA private key unit_1 | .........................................................................................................+++ unit_1 | ......................................................................................................+++ unit_1 | writing new private key to '/var/tmp/foober.com.key' unit_1 | ----- unit_1 | writing RSA key unit_1 | Signature ok unit_1 | subject=/C=US/ST=Colorado/L=Denver/O=KableTown/OU=CDN_Eng/CN=foober.com unit_1 | Getting Private key unit_1 | # Looks like you failed 2 tests of 121. unit_1 | /opt/traffic_ops/app/t/api/1.1/deliveryservice/ssl_keys.t ............ {quote} -- This message was sent by Atlassian JIRA (v6.4.14#64029)