As of e7d1792 I'm now getting SmokeStack failures when using Postgres:
2011-09-29 18:06:19,926 ERROR nova.api.ec2.metadata [-] Failed to get metadata for ip: 192.168.0.2
(nova.api.ec2.metadata): TRACE: Traceback (most recent call last):
(nova.api.ec2.metadata): TRACE: File "/usr/lib/python2.6/dist-packages/nova/api/ec2/metadatarequesthandler.py", line 79, in __call__
(nova.api.ec2.metadata): TRACE: meta_data = self.cc.get_metadata(remote_address)
(nova.api.ec2.metadata): TRACE: File "/usr/lib/python2.6/dist-packages/nova/api/ec2/cloud.py", line 380, in get_metadata
(nova.api.ec2.metadata): TRACE: return_all=False)
(nova.api.ec2.metadata): TRACE: File "/usr/lib/python2.6/dist-packages/nova/api/ec2/cloud.py", line 276, in _get_floaters_for_instance
(nova.api.ec2.metadata): TRACE: floaters = self._get_floaters_for_fixed_ip(context, ip)
(nova.api.ec2.metadata): TRACE: File "/usr/lib/python2.6/dist-packages/nova/api/ec2/cloud.py", line 244, in _get_floaters_for_fixed_ip
(nova.api.ec2.metadata): TRACE: fixed_ip)
(nova.api.ec2.metadata): TRACE: File "/usr/lib/python2.6/dist-packages/nova/network/api.py", line 53, in get_floating_ips_by_fixed_address
(nova.api.ec2.metadata): TRACE: 'args': {'fixed_address': fixed_address}})
(nova.api.ec2.metadata): TRACE: File "/usr/lib/python2.6/dist-packages/nova/rpc/__init__.py", line 45, in call
(nova.api.ec2.metadata): TRACE: return get_impl().call(context, topic, msg)
(nova.api.ec2.metadata): TRACE: File "/usr/lib/python2.6/dist-packages/nova/rpc/impl_kombu.py", line 738, in call
(nova.api.ec2.metadata): TRACE: rv = list(rv)
(nova.api.ec2.metadata): TRACE: File "/usr/lib/python2.6/dist-packages/nova/rpc/impl_kombu.py", line 703, in __iter__
(nova.api.ec2.metadata): TRACE: raise result
(nova.api.ec2.metadata): TRACE: RemoteError: ProgrammingError (ProgrammingError) operator does not exist: character varying = text[]
(nova.api.ec2.metadata): TRACE: LINE 4: WHERE fixed_ips.address = ARRAY[E'192.168.0.2'] AND fixed_ip...
(nova.api.ec2.metadata): TRACE: ^
(nova.api.ec2.metadata): TRACE: HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
---
Due to this issue I'm unable to boot instances using Postgres.
Looks like similar errors occur w/ MySQL as well:
(nova.api. ec2.metadata) : TRACE: RemoteError: 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, ...