** 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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
