[ 
https://issues.apache.org/jira/browse/TC-415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16119387#comment-16119387
 ] 

Dan Kirkwood commented on TC-415:
---------------------------------

fixed by https://github.com/apache/incubator-trafficcontrol/pull/737

> 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
>              Labels: test
>             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)

Reply via email to