yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: nova
       Status: Fix Committed => Fix Released

** Changed in: nova
    Milestone: None => havana-2

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1182754

Title:
  Tempest fails against wrong data types when using postgresql

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  Currently we have 6 Tempest tests  failing only when using postgresql:

  ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  tempest.api.compute.admin.test_fixed_ips.FixedIPsTestJson.test_set_reserve_with_invalid_ip
  tempest.api.compute.admin.test_fixed_ips.FixedIPsTestXml.test_set_reserve_with_invalid_ip
  tempest.api.compute.floating_ips.test_floating_ips_actions.FloatingIPsTestJSON.test_delete_nonexistant_floating_ip
  tempest.api.compute.floating_ips.test_floating_ips_actions.FloatingIPsTestXML.test_delete_nonexistant_floating_ip
  tempest.api.compute.floating_ips.test_list_floating_ips.FloatingIPDetailsTestJSON.test_get_nonexistant_floating_ip_details
  tempest.api.compute.floating_ips.test_list_floating_ips.FloatingIPDetailsTestXML.test_get_nonexistant_floating_ip_details
  ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  This happens cause the tests are request using a different data type
  again postgresql: in the fixed_ips tests it is not an ip and in the
  floating ips tests the ip id is bigger than postgresql's integer,
  causing sqlalchemy to raise DataError like:

  ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  2013-05-22 04:55:25.708 ERROR nova.api.openstack [req-5edb2331-ecfa-44c8-8935-039235e7f84f admin admin] Caught error: (DataError) invalid input syntax for type inet: "my.invalid.ip"
  LINE 3: ...ERE fixed_ips.deleted = 0 AND fixed_ips.address = 'my.invali...
                                                               ^
   'SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_uuid AS fixed_ips_instance_uuid, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host \nFROM fixed_ips \nWHERE fixed_ips.deleted = %(deleted_1)s AND fixed_ips.address = %(address_1)s \n LIMIT %(param_1)s' {'param_1': 1, 'address_1': u'my.invalid.ip', 'deleted_1': 0}
  ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Although all of them are valid test cases.

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1182754/+subscriptions