yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1207309] Re: Migration 147 does not downgrade on MySQL

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Thu, 05 Sep 2013 15:44:05 -0000
Reply-to: Bug 1207309 <1207309@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

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

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

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

Title:
  Migration 147 does not downgrade on MySQL

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  OperationalError: (OperationalError) (1242, 'Subquery returns more
  than 1 row') 'UPDATE services SET availability_zone=(SELECT
  aggregate_metadata.value \nFROM aggregate_metadata, aggregate_hosts
  \nWHERE aggregate_hosts.aggregate_id = aggregate_metadata.aggregate_id
  AND aggregate_metadata.`key` = %s AND aggregate_hosts.host =
  services.host AND services.`binary` = %s)' ('availability_zone',
  'nova-compute')

  We should probably re-write this to select all of the services and
  insert them rather than as a sub-query.

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