Comment 9 for bug 1782539

Revision history for this message
Jay Pipes (jaypipes) wrote : Re: Fail to filter the list of instances by the available zone

Denormalized, inconsistent data at its finest... :(

Please see the code comment next to the instances.availability_zone field:

https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/models.py#L295-L298

    # This always refers to the availability_zone kwarg passed in /servers and
    # provided as an API option, not at all related to the host AZ the instance
    # belongs to.
    availability_zone = Column(String(255))

Apparently, it's meant to be this way :(