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

-- 
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/1168490

Title:
  nova-cells crash with: operator does not exist: boolean = integer

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  I'm using PostgreSQL as database engine and nova-cells version
  2013.1-0ubuntu1

  
  2013-04-12 13:15:51.582 CRITICAL nova [req-4306ce80-d32a-4b2d-a57c-69e0f82a58d1 None None] (ProgrammingError) operator does not exist: boolean = integer
  LINE 3: WHERE cells.deleted = 0
                              ^
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
   'SELECT cells.created_at AS cells_created_at, cells.updated_at AS cells_updated_at, cells.deleted_at AS cells_deleted_at, cells.deleted AS cells_deleted, cells.id AS cells_id, cells.name AS cells_name, cells.api_url AS cells_api_url, cells.username AS cells_username, cells.password AS cells_password, cells.weight_offset AS cells_weight_offset, cells.weight_scale AS cells_weight_scale, cells.is_parent AS cells_is_parent, cells.rpc_host AS cells_rpc_host, cells.rpc_port AS cells_rpc_port, cells.rpc_virtual_host AS cells_rpc_virtual_host \nFROM cells \nWHERE cells.deleted = %(deleted_1)s' {'deleted_1': 0}

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