You can't specify target table 'fixed_ips' for update
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
High
|
Dan Prince |
Bug Description
Using the latest nova Essex code with the FlatDHCPNetwork manager w/ MySQL. I'm seeing the following exceptions in nova-network.log after booting an instance:
2011-12-22 19:58:33,227 ERROR nova.manager [f8b2fd9e-
(nova.manager): TRACE: Traceback (most recent call last):
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: task(self, context)
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: time)
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: return IMPL.fixed_
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: return f(*args, **kwargs)
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: synchronize_
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: result = session.
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: clause, params or {})
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: params)
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: return self.__
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: context.
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: context)
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: context)
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: cursor.
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: self.errorhandl
(nova.manager): TRACE: File "/usr/lib/
(nova.manager): TRACE: raise errorclass, errorvalue
(nova.manager): TRACE: OperationalError: (OperationalError) (1093, "You can't specify target table 'fixed_ips' for update in FROM clause") 'UPDATE fixed_ips SET updated_at=%s, instance_id=%s, leased=%s WHERE fixed_ips.id IN (SELECT fixed_ips.id \nFROM fixed_ips INNER JOIN instances ON fixed_ips.
Changed in nova: | |
importance: | Undecided → High |
assignee: | nobody → Dan Prince (dan-prince) |
status: | New → In Progress |
Changed in nova: | |
milestone: | none → essex-3 |
status: | Fix Committed → Fix Released |
Changed in nova: | |
milestone: | essex-3 → 2012.1 |
Fix proposed to branch: master /review. openstack. org/2576
Review: https:/