yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1109889] Re: SQL Error with fixed_ips.deleted in devstack/postgresql

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Thu, 21 Feb 2013 08:50:46 -0000
Reply-to: Bug 1109889 <1109889@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Changed in: nova
       Status: Fix Committed => Fix Released

** Changed in: nova
    Milestone: None => grizzly-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/1109889

Title:
  SQL Error with fixed_ips.deleted in devstack/postgresql

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  http://logs.openstack.org/20739/2/check/gate-tempest-devstack-vm-
  postgres/991/logs/screen-n-net.txt.gz

  Here's the log snippet:

  2013-01-30 00:22:09.440 ERROR nova.openstack.common.rpc.amqp [req-36540d57-ff59-4629-8483-7e38e7d58c84 demo demo] Exception during message handling
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp Traceback (most recent call last):
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/openstack/common/rpc/amqp.py", line 276, in _process_data
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     rval = self.proxy.dispatch(ctxt, version, method, **args)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/openstack/common/rpc/dispatcher.py", line 133, in dispatch
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     return getattr(proxyobj, method)(ctxt, **kwargs)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/openstack/common/rpc/common.py", line 397, in inner
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     return catch_client_exception(exceptions, func, *args, **kwargs)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/openstack/common/rpc/common.py", line 380, in catch_client_exception
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     return func(*args, **kwargs)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/network/manager.py", line 546, in associate_floating_ip
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     fixed_ip['instance_uuid'])
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/network/manager.py", line 587, in _associate_floating_ip
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     do_associate()
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/openstack/common/lockutils.py", line 234, in inner
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     retval = f(*args, **kwargs)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/network/manager.py", line 566, in do_associate
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     self.host)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/db/api.py", line 326, in floating_ip_fixed_ip_associate
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     host)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/db/sqlalchemy/api.py", line 134, in wrapper
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     return f(*args, **kwargs)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/opt/stack/new/nova/nova/db/sqlalchemy/api.py", line 798, in floating_ip_fixed_ip_associate
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     options(joinedload('network')).\
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2156, in first
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     ret = list(self[0:1])
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2023, in __getitem__
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     return list(res)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     return self._execute_and_instances(context)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     result = conn.execute(querycontext.statement, self._params)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     params)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     compiled_sql, distilled_params
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     context)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     context)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp     cursor.execute(statement, parameters)
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp ProgrammingError: (ProgrammingError) operator does not exist: integer = boolean
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp LINE 2: ...ps.network_id = networks_1.id AND fixed_ips.deleted = false 
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp                                                                ^
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp  '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_uuid AS fixed_ips_instance_uuid, 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, 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.rxtx_base AS networks_1_rxtx_base, 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 \nFROM fixed_ips LEFT OUTER JOIN networks AS networks_1 ON fixed_ips.network_id = networks_1.id AND fixed_ips.deleted = %(deleted_1)s \nWHERE fixed_ips.deleted = %(deleted_2)s AND fixed_ips.address = %(address_1)s \n LIMIT %(param_1)s' {'param_1': 1, 'address_1': u'10.1.0.3', 'deleted_1': False, 'deleted_2': 0}
  2013-01-30 00:22:09.440 10441 TRACE nova.openstack.common.rpc.amqp 
  2013-01-30 00:22:09.444 ERROR nova.openstack.common.rpc.common [req-36540d57-ff59-4629-8483-7e38e7d58c84 demo demo] Returning exception (ProgrammingError) operator does not exist: integer = boolean
  LINE 2: ...ps.network_id = networks_1.id AND fixed_ips.deleted = false 
                                                                 ^
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1109889/+subscriptions