Uploaded image for project: 'Traffic Control'
  1. Traffic Control
  2. TC-415

traffic_ops unit test fails: api/1.1/deliveryservice/ssl_keys.t

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.1.0
    • 2.1.0
    • Traffic Ops

    Description

      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:

      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 ............

      Attachments

        Activity

          People

            Unassigned Unassigned
            dangogh Dan Kirkwood
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: