In method 'instance_get_active_by_window' of the file 'nova/db/sqlalchemy/api.py', two syntax error are present :
*** /usr/lib/pymodules/python2.7/nova/db/sqlalchemy/api.py 2011-07-07 16:42:04.080054757 +0200
--- api.py 2011-07-07 16:41:55.430029053 +0200
***************
*** 1141,1149 ****
"""Return instances that were continuously active over the given window"""
session = get_session()
query = session.query(models.Instance).\
! options(joinedload_all('fixed_ip.floating_ips')).\
options(joinedload('security_groups')).\
! options(joinedload_all('fixed_ip.network')).\
options(joinedload('instance_type')).\
filter(models.Instance.launched_at < begin)
if end:
--- 1141,1149 ----
"""Return instances that were continuously active over the given window"""
session = get_session()
query = session.query(models.Instance).\
! options(joinedload_all('fixed_ips.floating_ips')).\
options(joinedload('security_groups')).\
! options(joinedload_all('fixed_ips.network')).\
options(joinedload('instance_type')).\
filter(models.Instance.launched_at < begin)
if end: