** 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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
