[openstack-dev] [Neutron][CI] DB migration error
Jakub Libosvar
libosvar at redhat.com
Thu Jul 17 12:52:56 UTC 2014
On 07/17/2014 12:18 PM, trinath.somanchi at freescale.com wrote:
> Hi Kevin-
>
>
>
> The fix given in the bug report is not working for my CI. I think I need
> to wait for the real fix in the main stream.
What version of alembic library did you have at the time of error?
Are you sure you re-run
pip install -r requirements.txt after you changed the version?
Kuba
>
>
>
> --
>
> Trinath Somanchi - B39208
>
> trinath.somanchi at freescale.com| extn: 4048
>
>
>
> *From:*Kevin Benton [mailto:blak111 at gmail.com]
> *Sent:* Wednesday, July 16, 2014 10:01 PM
> *To:* OpenStack Development Mailing List (not for usage questions)
> *Subject:* Re: [openstack-dev] [Neutron][CI] DB migration error
>
>
>
> This bug is also affecting Ryu and the Big Switch CI.
> There is a patch to bump the version requirement for alembic linked in
> the bug report that should fix it. It we can't get that merged we may
> have to revert the healing patch.
>
> https://bugs.launchpad.net/bugs/1342507
>
> On Jul 16, 2014 9:27 AM, "trinath.somanchi at freescale.com
> <mailto:trinath.somanchi at freescale.com>" <trinath.somanchi at freescale.com
> <mailto:trinath.somanchi at freescale.com>> wrote:
>
> Hi-
>
>
>
> With the neutron Update to my CI, I get the following error while
> configuring Neutron in devstack.
>
>
>
> 2014-07-16 16:12:06.349 | INFO [alembic.autogenerate.compare]
> Detected server default on column 'poolmonitorassociations.status'
>
> 2014-07-16 16:12:06.411 | INFO
> [neutron.db.migration.alembic_migrations.heal_script] Detected added
> foreign key for column 'id' on table u'ml2_brocadeports'
>
> 2014-07-16 16:12:14.853 | Traceback (most recent call last):
>
> 2014-07-16 16:12:14.853 | File "/usr/local/bin/neutron-db-manage",
> line 10, in <module>
>
> 2014-07-16 16:12:14.853 | sys.exit(main())
>
> 2014-07-16 16:12:14.854 | File
> "/opt/stack/new/neutron/neutron/db/migration/cli.py", line 171, in main
>
> 2014-07-16 16:12:14.854 | CONF.command.func(config,
> CONF.command.name <http://CONF.command.name>)
>
> 2014-07-16 16:12:14.854 | File
> "/opt/stack/new/neutron/neutron/db/migration/cli.py", line 85, in
> do_upgrade_downgrade
>
> 2014-07-16 16:12:14.854 | do_alembic_command(config, cmd,
> revision, sql=CONF.command.sql)
>
> 2014-07-16 16:12:14.854 | File
> "/opt/stack/new/neutron/neutron/db/migration/cli.py", line 63, in
> do_alembic_command
>
> 2014-07-16 16:12:14.854 | getattr(alembic_command, cmd)(config,
> *args, **kwargs)
>
> 2014-07-16 16:12:14.854 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line
> 124, in upgrade
>
> 2014-07-16 16:12:14.854 | script.run_env()
>
> 2014-07-16 16:12:14.854 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line
> 199, in run_env
>
> 2014-07-16 16:12:14.854 | util.load_python_file(self.dir, 'env.py')
>
> 2014-07-16 16:12:14.854 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 205,
> in load_python_file
>
> 2014-07-16 16:12:14.854 | module = load_module_py(module_id, path)
>
> 2014-07-16 16:12:14.854 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58,
> in load_module_py
>
> 2014-07-16 16:12:14.854 | mod = imp.load_source(module_id, path, fp)
>
> 2014-07-16 16:12:14.854 | File
> "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/env.py",
> line 106, in <module>
>
> 2014-07-16 16:12:14.854 | run_migrations_online()
>
> 2014-07-16 16:12:14.855 | File
> "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/env.py",
> line 90, in run_migrations_online
>
> 2014-07-16 16:12:14.855 | options=build_options())
>
> 2014-07-16 16:12:14.855 | File "<string>", line 7, in run_migrations
>
> 2014-07-16 16:12:14.855 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/environment.py",
> line 681, in run_migrations
>
> 2014-07-16 16:12:14.855 | self.get_context().run_migrations(**kw)
>
> 2014-07-16 16:12:14.855 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line
> 225, in run_migrations
>
> 2014-07-16 16:12:14.855 | change(**kw)
>
> 2014-07-16 16:12:14.856 | File
> "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/versions/1d6ee1ae5da5_db_healing.py",
> line 32, in upgrade
>
> 2014-07-16 16:12:14.856 | heal_script.heal()
>
> 2014-07-16 16:12:14.856 | File
> "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/heal_script.py",
> line 78, in heal
>
> 2014-07-16 16:12:14.856 | execute_alembic_command(el)
>
> 2014-07-16 16:12:14.856 | File
> "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/heal_script.py",
> line 93, in execute_alembic_command
>
> 2014-07-16 16:12:14.856 | parse_modify_command(command)
>
> 2014-07-16 16:12:14.856 | File
> "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/heal_script.py",
> line 126, in parse_modify_command
>
> 2014-07-16 16:12:14.856 | op.alter_column(table, column, **kwargs)
>
> 2014-07-16 16:12:14.856 | File "<string>", line 7, in alter_column
>
> 2014-07-16 16:12:14.856 | File "<string>", line 1, in <lambda>
>
> 2014-07-16 16:12:14.856 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 322,
> in go
>
> 2014-07-16 16:12:14.857 | return fn(*arg, **kw)
>
> 2014-07-16 16:12:14.857 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line
> 300, in alter_column
>
> 2014-07-16 16:12:14.857 |
> existing_autoincrement=existing_autoincrement
>
> 2014-07-16 16:12:14.857 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line
> 42, in alter_column
>
> 2014-07-16 16:12:14.857 | else existing_autoincrement
>
> 2014-07-16 16:12:14.857 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line
> 76, in _exec
>
> 2014-07-16 16:12:14.857 | conn.execute(construct, *multiparams,
> **params)
>
> 2014-07-16 16:12:14.857 | File
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
> line 727, in execute
>
> 2014-07-16 16:12:14.857 | return meth(self, multiparams, params)
>
> 2014-07-16 16:12:14.858 | File
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line
> 67, in _execute_on_connection
>
> 2014-07-16 16:12:14.858 | return connection._execute_ddl(self,
> multiparams, params)
>
> 2014-07-16 16:12:14.858 | File
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
> line 775, in _execute_ddl
>
> 2014-07-16 16:12:14.858 | compiled = ddl.compile(dialect=dialect)
>
> 2014-07-16 16:12:14.858 | File "<string>", line 1, in <lambda>
>
> 2014-07-16 16:12:14.858 | File
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py",
> line 493, in compile
>
> 2014-07-16 16:12:14.859 | return self._compiler(dialect,
> bind=bind, **kw)
>
> 2014-07-16 16:12:14.859 | File
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line
> 25, in _compiler
>
> 2014-07-16 16:12:14.859 | return dialect.ddl_compiler(dialect,
> self, **kw)
>
> 2014-07-16 16:12:14.859 | File
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py",
> line 196, in __init__
>
> 2014-07-16 16:12:14.859 | self.string =
> self.process(self.statement, **compile_kwargs)
>
> 2014-07-16 16:12:14.859 | File
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py",
> line 219, in process
>
> 2014-07-16 16:12:14.859 | return obj._compiler_dispatch(self,
> **kwargs)
>
> 2014-07-16 16:12:14.859 | File
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/compiler.py",
> line 410, in <lambda>
>
> 2014-07-16 16:12:14.859 | lambda *arg, **kw: existing(*arg, **kw))
>
> 2014-07-16 16:12:14.859 | File
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/compiler.py",
> line 448, in __call__
>
> 2014-07-16 16:12:14.859 | return fn(element, compiler, **kw)
>
> 2014-07-16 16:12:14.859 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line
> 98, in _mysql_alter_column
>
> 2014-07-16 16:12:14.860 | autoincrement=element.autoincrement
>
> 2014-07-16 16:12:14.860 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line
> 118, in _mysql_colspec
>
> 2014-07-16 16:12:14.860 | spec += " DEFAULT %s" %
> _render_value(compiler, server_default)
>
> 2014-07-16 16:12:14.860 | File
> "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line
> 106, in _render_value
>
> 2014-07-16 16:12:14.860 | return compiler.sql_compiler.process(expr)
>
> 2014-07-16 16:12:14.860 | File
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py",
> line 219, in process
>
> 2014-07-16 16:12:14.860 | return obj._compiler_dispatch(self,
> **kwargs)
>
> 2014-07-16 16:12:14.860 | AttributeError: 'DefaultClause' object has
> no attribute '_compiler_dispatch'
>
>
>
> Kindly help how to resolve this issue.
>
>
>
> Thanks in advance.
>
>
>
>
>
> --
>
> Trinath Somanchi - B39208
>
> trinath.somanchi at freescale.com
> <mailto:trinath.somanchi at freescale.com> | extn: 4048
>
>
>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> <mailto:OpenStack-dev at lists.openstack.org>
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
More information about the OpenStack-dev
mailing list