conductor breaks sqlite datetime fields
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
High
|
Russell Bryant |
Bug Description
When using nova trunk with sqlite, instance updates fail to update datetime columns. Sqlite doesn't like strings being put into datetime columns. In his case, launched_at.
2012-11-28 12:53:09 3483 DEBUG nova.openstack.
2012-11-28 12:53:09 3483 DEBUG nova.openstack.
2012-11-28 12:53:09 ERROR nova.exception [req-6184c2f3-
2012-11-28 12:53:09 3483 TRACE nova.exception Traceback (most recent call last):
2012-11-28 12:53:09 3483 TRACE nova.exception File "/opt/nova/
2012-11-28 12:53:09 3483 TRACE nova.exception return f(*args, **kwargs)
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception self._flush(
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception flush_context.
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception rec.execute(self)
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception uow
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception mapper, table, update)
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception execute(statement, params)
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception params)
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception compiled_sql, distilled_params
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception None, None)
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception context = constructor(
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception param.append(
2012-11-28 12:53:09 3483 TRACE nova.exception File "/usr/local/
2012-11-28 12:53:09 3483 TRACE nova.exception raise TypeError("SQLite DateTime type only accepts Python "
2012-11-28 12:53:09 3483 TRACE nova.exception StatementError: SQLite DateTime type only accepts Python datetime and date objects as input. (original cause: TypeError: SQLite DateTime type only accepts Python datetime and date objects as input.) 'UPDATE instances SET updated_at=?, power_state=?, vm_state=?, task_state=?, launched_at=? WHERE instances.id = ?' [{'vm_state': u'active', 'task_state': None, u'instances_id': 1, 'launched_at': u' 2012-11-
2012-11-28 12:53:09 3483 TRACE nova.exception
2012-11-28 12:53:09 3483 ERROR nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
2012-11-28 12:53:09 3483 TRACE nova.openstack.
Changed in nova: | |
milestone: | none → grizzly-2 |
status: | Fix Committed → Fix Released |
Changed in nova: | |
milestone: | grizzly-2 → 2013.1 |
Give this patch a try.