postgres incompatibility in InstanceGroup.get_hosts()
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
High
|
Chris Friesen |
Bug Description
When running InstanceGroup.
RemoteError: Remote error: ProgrammingError (ProgrammingError) operator does not exist: timestamp without time zone ~ unknown
2014-03-14 09:58:57.193 8164 TRACE nova.compute.
2014-03-14 09:58:57.193 8164 TRACE nova.compute.
2014-03-14 09:58:57.193 8164 TRACE nova.compute.
I'm not a database expert, but after doing some digging, it seems that the problem is this line in get_hosts():
filters = {'uuid': filter_uuids, 'deleted_at': None}
It seems that current postgres doesn't allow implicit casts. If I change the line to:
filters = {'uuid': filter_uuids, 'deleted': 0}
Then it seems to work.
Changed in nova: | |
assignee: | nobody → Chris Friesen (cbf123) |
status: | New → In Progress |
Changed in nova: | |
importance: | Undecided → High |
milestone: | none → icehouse-rc1 |
tags: | added: db postgresql |
Changed in nova: | |
milestone: | none → icehouse-rc1 |
Changed in nova: | |
status: | Fix Committed → Fix Released |
Changed in nova: | |
milestone: | icehouse-rc1 → 2014.1 |
Fix proposed to branch: master /review. openstack. org/80808
Review: https:/