Error during VlanManager._disassociate_stale_fixed_ips: (InterfaceError) Error binding parameter 0

[Joe Gordon]

Stack trace when running an instance in nova version Version: 2012.1~rc1~20120308.13246-0ubuntu0ppa1~oneiric1

root@oneiric:/var/log/nova# cat /etc/nova/nova.conf
--dhcpbridge_flagfile=/etc/nova/nova.conf
--dhcpbridge=/usr/bin/nova-dhcpbridge
--logdir=/var/log/nova
--state_path=/var/lib/nova
--lock_path=/var/lock/nova
--force_dhcp_release
--iscsi_helper=tgtadm
--libvirt_use_virtio_for_bridges
--connection_type=libvirt
--root_helper=sudo nova-rootwrap
--verbose
--scheduler_driver=nova.scheduler.chance.ChanceScheduler

2012-03-09 00:43:13 ERROR nova.manager [-] Error during VlanManager._disassociate_stale_fixed_ips: (InterfaceError) Error binding parameter 0 - probably unsupported type. u'SELECT fixed_ips.id AS fixed_ips_id \nFROM fixed_ips \nWHERE fixed_ips.id IN (?, ?, ?, ?)' ((4,), (4,), (4,), (4,))
(nova.manager): TRACE: Traceback (most recent call last):
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/nova/manager.py", line 155, in periodic_tasks
(nova.manager): TRACE: task(self, context)
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/nova/network/manager.py", line 775, in _disassociate_stale_fixed_ips
(nova.manager): TRACE: time)
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 458, in fixed_ip_disassociate_all_by_timeout
(nova.manager): TRACE: return IMPL.fixed_ip_disassociate_all_by_timeout(context, host, time)
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 101, in wrapper
(nova.manager): TRACE: return f(*args, **kwargs)
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 1089, in fixed_ip_disassociate_all_by_timeout
(nova.manager): TRACE: synchronize_session='fetch')
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2309, in update
(nova.manager): TRACE: params=self._params).fetchall()
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 724, in execute
(nova.manager): TRACE: clause, params or {})
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1191, in execute
(nova.manager): TRACE: params)
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1271, in _execute_clauseelement
(nova.manager): TRACE: return self.__execute_context(context)
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1302, in __execute_context
(nova.manager): TRACE: context.parameters[0], context=context)
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1401, in _cursor_execute
(nova.manager): TRACE: context)
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1394, in _cursor_execute
(nova.manager): TRACE: context)
(nova.manager): TRACE: File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 299, in do_execute
(nova.manager): TRACE: cursor.execute(statement, parameters)
(nova.manager): TRACE: InterfaceError: (InterfaceError) Error binding parameter 0 - probably unsupported type. u'SELECT fixed_ips.id AS fixed_ips_id \nFROM fixed_ips \nWHERE fixed_ips.id IN (?, ?, ?, ?)' ((4,), (4,), (4,), (4,))
(nova.manager): TRACE:

[Vish Ishaya (vishvananda)]

I can't seem to reproduce this. Any more information on how we got into this state? --force_dhcp_release should be releasing ips immediately.

[Joe Gordon (jogo)]

I am working on creating steps to reproduce the error right now.

[Joe Gordon (jogo)]

I am having trouble reproducing this bug myself. I must have gotten my environment in a very unusual state.