I built and installed packages from 2012.1~e1~20110909.1546-0ubuntu1 and now I just get these errors about some bad SQL syntax:
2011-09-30 13:36:59,829 ERROR nova.rpc [-] Exception during message handling
(nova.rpc): TRACE: Traceback (most recent call last):
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/nova/rpc/impl_kombu.py", line 620, in _process_data
(nova.rpc): TRACE: rval = node_func(context=ctxt, **node_args)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/nova/network/manager.py", line 317, in get_floating_ips_by_fixed_address
(nova.rpc): TRACE: fixed_address)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 295, in floating_ip_get_by_fixed_address
(nova.rpc): TRACE: return IMPL.floating_ip_get_by_fixed_address(context, fixed_address)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 120, in wrapper
(nova.rpc): TRACE: return f(*args, **kwargs)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 668, in floating_ip_get_by_fixed_address
(nova.rpc): TRACE: fixed_ip = fixed_ip_get_by_address(context, fixed_address, session)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 120, in wrapper
(nova.rpc): TRACE: return f(*args, **kwargs)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 838, in fixed_ip_get_by_address
(nova.rpc): TRACE: options(joinedload('instance')).\
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1652, in first
(nova.rpc): TRACE: ret = list(self[0:1])
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1560, in __getitem__
(nova.rpc): TRACE: return list(res)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1721, in __iter__
(nova.rpc): TRACE: return self._execute_and_instances(context)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1726, in _execute_and_instances
(nova.rpc): TRACE: mapper=self._mapper_zero_or_none())
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 724, in execute
(nova.rpc): TRACE: clause, params or {})
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1191, in execute
(nova.rpc): TRACE: params)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1271, in _execute_clauseelement
(nova.rpc): TRACE: return self.__execute_context(context)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1302, in __execute_context
(nova.rpc): TRACE: context.parameters[0], context=context)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1401, in _cursor_execute
(nova.rpc): TRACE: context)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1394, in _cursor_execute
(nova.rpc): TRACE: context)
(nova.rpc): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 299, in do_execute
(nova.rpc): TRACE: cursor.execute(statement, parameters)
(nova.rpc): TRACE: File "/usr/lib/pymodules/python2.7/MySQLdb/cursors.py", line 174, in execute
(nova.rpc): TRACE: self.errorhandler(self, exc, value)
(nova.rpc): TRACE: File "/usr/lib/pymodules/python2.7/MySQLdb/connections.py", line 36, in defaulterrorhandler
(nova.rpc): TRACE: raise errorclass, errorvalue
(nova.rpc): TRACE: ProgrammingError: (ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND fixed_ips.deleted = 0 \n LIMIT 0, 1) AS anon_1 LEFT OUTER JOIN networks AS ' at line 4") 'SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon_1_fixed_ips_deleted_at, anon_1.fixed_ips_deleted AS anon_1_fixed_ips_deleted, anon_1.fixed_ips_id AS anon_1_fixed_ips_id, anon_1.fixed_ips_address AS anon_1_fixed_ips_address, anon_1.fixed_ips_network_id AS anon_1_fixed_ips_network_id, anon_1.fixed_ips_virtual_interface_id AS anon_1_fixed_ips_virtual_interface_id, anon_1.fixed_ips_instance_id AS anon_1_fixed_ips_instance_id, anon_1.fixed_ips_allocated AS anon_1_fixed_ips_allocated, anon_1.fixed_ips_leased AS anon_1_fixed_ips_leased, anon_1.fixed_ips_reserved AS anon_1_fixed_ips_reserved, anon_1.fixed_ips_host AS anon_1_fixed_ips_host, networks_1.created_at AS networks_1_created_at, networks_1.updated_at AS networks_1_updated_at, networks_1.deleted_at AS networks_1_deleted_at, networks_1.deleted AS networks_1_deleted, networks_1.id AS networks_1_id, networks_1.label AS networks_1_label, networks_1.injected AS networks_1_injected, networks_1.cidr AS networks_1_cidr, networks_1.cidr_v6 AS networks_1_cidr_v6, networks_1.multi_host AS networks_1_multi_host, networks_1.gateway_v6 AS networks_1_gateway_v6, networks_1.netmask_v6 AS networks_1_netmask_v6, networks_1.netmask AS networks_1_netmask, networks_1.bridge AS networks_1_bridge, networks_1.bridge_interface AS networks_1_bridge_interface, networks_1.gateway AS networks_1_gateway, networks_1.broadcast AS networks_1_broadcast, networks_1.dns1 AS networks_1_dns1, networks_1.dns2 AS networks_1_dns2, networks_1.vlan AS networks_1_vlan, networks_1.vpn_public_address AS networks_1_vpn_public_address, networks_1.vpn_public_port AS networks_1_vpn_public_port, networks_1.vpn_private_address AS networks_1_vpn_private_address, networks_1.dhcp_start AS networks_1_dhcp_start, networks_1.project_id AS networks_1_project_id, networks_1.priority AS networks_1_priority, networks_1.host AS networks_1_host, networks_1.uuid AS networks_1_uuid, instances_1.created_at AS instances_1_created_at, instances_1.updated_at AS instances_1_updated_at, instances_1.deleted_at AS instances_1_deleted_at, instances_1.deleted AS instances_1_deleted, instances_1.id AS instances_1_id, instances_1.user_id AS instances_1_user_id, instances_1.project_id AS instances_1_project_id, instances_1.image_ref AS instances_1_image_ref, instances_1.kernel_id AS instances_1_kernel_id, instances_1.ramdisk_id AS instances_1_ramdisk_id, instances_1.server_name AS instances_1_server_name, instances_1.launch_index AS instances_1_launch_index, instances_1.key_name AS instances_1_key_name, instances_1.key_data AS instances_1_key_data, instances_1.power_state AS instances_1_power_state, instances_1.vm_state AS instances_1_vm_state, instances_1.task_state AS instances_1_task_state, instances_1.memory_mb AS instances_1_memory_mb, instances_1.vcpus AS instances_1_vcpus, instances_1.local_gb AS instances_1_local_gb, instances_1.hostname AS instances_1_hostname, instances_1.host AS instances_1_host, instances_1.instance_type_id AS instances_1_instance_type_id, instances_1.user_data AS instances_1_user_data, instances_1.reservation_id AS instances_1_reservation_id, instances_1.scheduled_at AS instances_1_scheduled_at, instances_1.launched_at AS instances_1_launched_at, instances_1.terminated_at AS instances_1_terminated_at, instances_1.availability_zone AS instances_1_availability_zone, instances_1.display_name AS instances_1_display_name, instances_1.display_description AS instances_1_display_description, instances_1.launched_on AS instances_1_launched_on, instances_1.locked AS instances_1_locked, instances_1.os_type AS instances_1_os_type, instances_1.architecture AS instances_1_architecture, instances_1.vm_mode AS instances_1_vm_mode, instances_1.uuid AS instances_1_uuid, instances_1.root_device_name AS instances_1_root_device_name, instances_1.default_local_device AS instances_1_default_local_device, instances_1.default_swap_device AS instances_1_default_swap_device, instances_1.config_drive AS instances_1_config_drive, instances_1.access_ip_v4 AS instances_1_access_ip_v4, instances_1.access_ip_v6 AS instances_1_access_ip_v6, instances_1.managed_disk AS instances_1_managed_disk, instances_1.progress AS instances_1_progress, floating_ips_1.created_at AS floating_ips_1_created_at, floating_ips_1.updated_at AS floating_ips_1_updated_at, floating_ips_1.deleted_at AS floating_ips_1_deleted_at, floating_ips_1.deleted AS floating_ips_1_deleted, floating_ips_1.id AS floating_ips_1_id, floating_ips_1.address AS floating_ips_1_address, floating_ips_1.fixed_ip_id AS floating_ips_1_fixed_ip_id, floating_ips_1.project_id AS floating_ips_1_project_id, floating_ips_1.host AS floating_ips_1_host, floating_ips_1.auto_assigned AS floating_ips_1_auto_assigned \nFROM (SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host \nFROM fixed_ips \nWHERE fixed_ips.address = %s AND fixed_ips.deleted = %s \n LIMIT 0, 1) AS anon_1 LEFT OUTER JOIN networks AS networks_1 ON networks_1.id = anon_1.fixed_ips_network_id LEFT OUTER JOIN instances AS instances_1 ON anon_1.fixed_ips_instance_id = instances_1.id AND anon_1.fixed_ips_deleted = %s LEFT OUTER JOIN floating_ips AS floating_ips_1 ON floating_ips_1.fixed_ip_id = anon_1.fixed_ips_id AND floating_ips_1.deleted = %s' ([u'172.18.77.2'], 0, 0, 0)
I built and installed packages from 2012.1~ e1~20110909. 1546-0ubuntu1 and now I just get these errors about some bad SQL syntax:
2011-09-30 13:36:59,829 ERROR nova.rpc [-] Exception during message handling python2. 7/dist- packages/ nova/rpc/ impl_kombu. py", line 620, in _process_data context= ctxt, **node_args) python2. 7/dist- packages/ nova/network/ manager. py", line 317, in get_floating_ ips_by_ fixed_address python2. 7/dist- packages/ nova/db/ api.py" , line 295, in floating_ ip_get_ by_fixed_ address ip_get_ by_fixed_ address( context, fixed_address) python2. 7/dist- packages/ nova/db/ sqlalchemy/ api.py" , line 120, in wrapper python2. 7/dist- packages/ nova/db/ sqlalchemy/ api.py" , line 668, in floating_ ip_get_ by_fixed_ address get_by_ address( context, fixed_address, session) python2. 7/dist- packages/ nova/db/ sqlalchemy/ api.py" , line 120, in wrapper python2. 7/dist- packages/ nova/db/ sqlalchemy/ api.py" , line 838, in fixed_ip_ get_by_ address joinedload( 'instance' )).\ python2. 7/dist- packages/ sqlalchemy/ orm/query. py", line 1652, in first python2. 7/dist- packages/ sqlalchemy/ orm/query. py", line 1560, in __getitem__ python2. 7/dist- packages/ sqlalchemy/ orm/query. py", line 1721, in __iter__ and_instances( context) python2. 7/dist- packages/ sqlalchemy/ orm/query. py", line 1726, in _execute_ and_instances self._mapper_ zero_or_ none()) python2. 7/dist- packages/ sqlalchemy/ orm/session. py", line 724, in execute python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1191, in execute python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1271, in _execute_ clauseelement execute_ context( context) python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1302, in __execute_context parameters[ 0], context=context) python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1401, in _cursor_execute python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1394, in _cursor_execute python2. 7/dist- packages/ sqlalchemy/ engine/ default. py", line 299, in do_execute execute( statement, parameters) pymodules/ python2. 7/MySQLdb/ cursors. py", line 174, in execute er(self, exc, value) pymodules/ python2. 7/MySQLdb/ connections. py", line 36, in defaulterrorhandler fixed_ips_ created_ at AS anon_1_ fixed_ips_ created_ at, anon_1. fixed_ips_ updated_ at AS anon_1_ fixed_ips_ updated_ at, anon_1. fixed_ips_ deleted_ at AS anon_1_ fixed_ips_ deleted_ at, anon_1. fixed_ips_ deleted AS anon_1_ fixed_ips_ deleted, anon_1.fixed_ips_id AS anon_1_ fixed_ips_ id, anon_1. fixed_ips_ address AS anon_1_ fixed_ips_ address, anon_1. fixed_ips_ network_ id AS anon_1_ fixed_ips_ network_ id, anon_1. fixed_ips_ virtual_ interface_ id AS anon_1_ fixed_ips_ virtual_ interface_ id, anon_1. fixed_ips_ instance_ id AS anon_1_ fixed_ips_ instance_ id, anon_1. fixed_ips_ allocated AS anon_1_ fixed_ips_ allocated, anon_1. fixed_ips_ leased AS anon_1_ fixed_ips_ leased, anon_1. fixed_ips_ reserved AS anon_1_ fixed_ips_ reserved, anon_1. fixed_ips_ host AS anon_1_ fixed_ips_ host, networks_ 1.created_ at AS networks_ 1_created_ at, networks_ 1.updated_ at AS networks_ 1_updated_ at, networks_ 1.deleted_ at AS networks_ 1_deleted_ at, networks_1.deleted AS networks_1_deleted, networks_1.id AS networks_1_id, networks_1.label AS networks_1_label, networks_1.injected AS networks_ 1_injected, networks_1.cidr AS networks_1_cidr, networks_1.cidr_v6 AS networks_1_cidr_v6, networks_ 1.multi_ host AS networks_ 1_multi_ host, networks_ 1.gateway_ v6 AS networks_ 1_gateway_ v6, networks_ 1.netmask_ v6 AS networks_ 1_netmask_ v6, networks_1.netmask AS networks_1_netmask, networks_1.bridge AS networks_1_bridge, networks_ 1.bridge_ interface AS networks_ 1_bridge_ interface, networks_1.gateway AS networks_1_gateway, networks_ 1.broadcast AS networks_ 1_broadcast, networks_1.dns1 AS networks_1_dns1, networks_1.dns2 AS networks_1_dns2, networks_1.vlan AS networks_1_vlan, networks_ 1.vpn_public_ address AS networks_ 1_vpn_public_ address, networks_ 1.vpn_public_ port AS networks_ 1_vpn_public_ port, networks_ 1.vpn_private_ address AS networks_ 1_vpn_private_ address, networks_ 1.dhcp_ start AS networks_ 1_dhcp_ start, networks_ 1.project_ id AS networks_ 1_project_ id, networks_1.priority AS networks_ 1_priority, networks_1.host AS networks_1_host, networks_1.uuid AS networks_1_uuid, instances_ 1.created_ at AS instances_ 1_created_ at, instances_ 1.updated_ at AS instances_ 1_updated_ at, instances_ 1.deleted_ at AS instances_ 1_deleted_ at, instances_1.deleted AS instances_ 1_deleted, instances_1.id AS instances_1_id, instances_1.user_id AS instances_ 1_user_ id, instances_ 1.project_ id AS instances_ 1_project_ id, instances_ 1.image_ ref AS instances_ 1_image_ ref, instances_ 1.kernel_ id AS instances_ 1_kernel_ id, instances_ 1.ramdisk_ id AS instances_ 1_ramdisk_ id, instances_ 1.server_ name AS instances_ 1_server_ name, instances_ 1.launch_ index AS instances_ 1_launch_ index, instances_ 1.key_name AS instances_ 1_key_name, instances_ 1.key_data AS instances_ 1_key_data, instances_ 1.power_ state AS instances_ 1_power_ state, instances_ 1.vm_state AS instances_ 1_vm_state, instances_ 1.task_ state AS instances_ 1_task_ state, instances_ 1.memory_ mb AS instances_ 1_memory_ mb, instances_1.vcpus AS instances_1_vcpus, instances_ 1.local_ gb AS instances_ 1_local_ gb, instances_ 1.hostname AS instances_ 1_hostname, instances_1.host AS instances_1_host, instances_ 1.instance_ type_id AS instances_ 1_instance_ type_id, instances_ 1.user_ data AS instances_ 1_user_ data, instances_ 1.reservation_ id AS instances_ 1_reservation_ id, instances_ 1.scheduled_ at AS instances_ 1_scheduled_ at, instances_ 1.launched_ at AS instances_ 1_launched_ at, instances_ 1.terminated_ at AS instances_ 1_terminated_ at, instances_ 1.availability_ zone AS instances_ 1_availability_ zone, instances_ 1.display_ name AS instances_ 1_display_ name, instances_ 1.display_ description AS instances_ 1_display_ description, instances_ 1.launched_ on AS instances_ 1_launched_ on, instances_1.locked AS instances_1_locked, instances_1.os_type AS instances_ 1_os_type, instances_ 1.architecture AS instances_ 1_architecture, instances_1.vm_mode AS instances_ 1_vm_mode, instances_1.uuid AS instances_1_uuid, instances_ 1.root_ device_ name AS instances_ 1_root_ device_ name, instances_ 1.default_ local_device AS instances_ 1_default_ local_device, instances_ 1.default_ swap_device AS instances_ 1_default_ swap_device, instances_ 1.config_ drive AS instances_ 1_config_ drive, instances_ 1.access_ ip_v4 AS instances_ 1_access_ ip_v4, instances_ 1.access_ ip_v6 AS instances_ 1_access_ ip_v6, instances_ 1.managed_ disk AS instances_ 1_managed_ disk, instances_ 1.progress AS instances_ 1_progress, floating_ ips_1.created_ at AS floating_ ips_1_created_ at, floating_ ips_1.updated_ at AS floating_ ips_1_updated_ at, floating_ ips_1.deleted_ at AS floating_ ips_1_deleted_ at, floating_ ips_1.deleted AS floating_ ips_1_deleted, floating_ips_1.id AS floating_ips_1_id, floating_ ips_1.address AS floating_ ips_1_address, floating_ ips_1.fixed_ ip_id AS floating_ ips_1_fixed_ ip_id, floating_ ips_1.project_ id AS floating_ ips_1_project_ id, floating_ips_1.host AS floating_ ips_1_host, floating_ ips_1.auto_ assigned AS floating_ ips_1_auto_ assigned \nFROM (SELECT fixed_ips. created_ at AS fixed_ips_ created_ at, fixed_ips. updated_ at AS fixed_ips_ updated_ at, fixed_ips. deleted_ at AS fixed_ips_ deleted_ at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips. network_ id AS fixed_ips_ network_ id, fixed_ips. virtual_ interface_ id AS fixed_ips_ virtual_ interface_ id, fixed_ips. instance_ id AS fixed_ips_ instance_ id, fixed_ips.allocated AS fixed_ips_ allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host \nFROM fixed_ips \nWHERE fixed_ips.address = %s AND fixed_ips.deleted = %s \n LIMIT 0, 1) AS anon_1 LEFT OUTER JOIN networks AS networks_1 ON networks_1.id = anon_1. fixed_ips_ network_ id LEFT OUTER JOIN instances AS instances_1 ON anon_1. fixed_ips_ instance_ id = instances_1.id AND anon_1. fixed_ips_ deleted = %s LEFT OUTER JOIN floating_ips AS floating_ips_1 ON floating_ ips_1.fixed_ ip_id = anon_1.fixed_ips_id AND floating_ ips_1.deleted = %s' ([u'172.18.77.2'], 0, 0, 0)
(nova.rpc): TRACE: Traceback (most recent call last):
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: rval = node_func(
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: fixed_address)
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: return IMPL.floating_
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: return f(*args, **kwargs)
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: fixed_ip = fixed_ip_
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: return f(*args, **kwargs)
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: options(
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: ret = list(self[0:1])
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: return list(res)
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: return self._execute_
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: mapper=
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: clause, params or {})
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: params)
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: return self.__
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: context.
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: context)
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: context)
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: cursor.
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: self.errorhandl
(nova.rpc): TRACE: File "/usr/lib/
(nova.rpc): TRACE: raise errorclass, errorvalue
(nova.rpc): TRACE: ProgrammingError: (ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND fixed_ips.deleted = 0 \n LIMIT 0, 1) AS anon_1 LEFT OUTER JOIN networks AS ' at line 4") 'SELECT anon_1.