yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: neutron
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1250405

Title:
  Mistake in sqlalchemy DateTime type usage

Status in OpenStack Neutron (virtual network service):
  Fix Released

Bug description:
  In migration f9263d6df56_remove_dhcp_lease there is mistake in
  DateTime type usage for mysql, used sa.DATETIME() instead of
  sa.DateTime()

     File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/versions/f9263d6df56_remove_dhcp_lease.py", line 46, in downgrade
      nullable=True))
    File "<string>", line 7, in add_column
    File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/alembic/operations.py", line 363, in add_column
      schema=schema
    File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 127, in add_column
      self._exec(base.AddColumn(table_name, column, schema=schema))
    File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 76, in _exec
      conn.execute(construct, *multiparams, **params)
    File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
      params)
    File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1542, in _execute_ddl
      compiled
    File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
      context)
    File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
      context)
    File "/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
      cursor.execute(statement, parameters)
  ProgrammingError: (ProgrammingError) type "datetime" does not exist
  LINE 1: ALTER TABLE ipallocations ADD COLUMN expiration DATETIME
                                                          ^
   'ALTER TABLE ipallocations ADD COLUMN expiration DATETIME' {}

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