<div dir="ltr"><div class="gmail_default" style="font-family:monospace,monospace">Can you tell us what repository you are using, the version of your neutron packages (rpm -qa |grep neutron) and how you are installing neutron ?</div><div class="gmail_default" style="font-family:monospace,monospace"><br></div><div class="gmail_default" style="font-family:monospace,monospace">Thanks.</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><br>David Moreau Simard<br>Senior Software Engineer | Openstack RDO<br><br>dmsimard = [irc, github, twitter]</div></div>
<br><div class="gmail_quote">On Tue, Dec 1, 2015 at 5:54 PM, Hui Kang <span dir="ltr"><<a href="mailto:hkang.sunysb@gmail.com" target="_blank">hkang.sunysb@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi, I installed openstack neutron package from rdo. My OS is centos<br>
7.1. The neutron database migration fails these days. The error output<br>
is<br>
<br>
NFO  [alembic.runtime.migration] Running upgrade 5498d17be016 -><br>
2a16083502f3, Metaplugin removal<br>
INFO  [alembic.runtime.migration] Running upgrade 2a16083502f3 -><br>
2e5352a0ad4d, Add missing foreign keys<br>
INFO  [alembic.runtime.migration] Running upgrade 2e5352a0ad4d -><br>
11926bcfe72d, add geneve ml2 type driver<br>
INFO  [alembic.runtime.migration] Running upgrade 11926bcfe72d -><br>
4af11ca47297, Drop cisco monolithic tables<br>
INFO  [alembic.runtime.migration] Running upgrade 4af11ca47297 -><br>
1b294093239c, Drop embrane plugin table<br>
INFO  [alembic.runtime.migration] Running upgrade 1b294093239c,<br>
32e5974ada25 -> 8a6d8bdae39, standardattributes migration<br>
Traceback (most recent call last):<br>
  File "/var/lib/kolla/venv/bin/neutron-db-manage", line 10, in <module><br>
    sys.exit(main())<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/cli.py",<br>
line 692, in main<br>
    CONF.command.func(config, <a href="http://CONF.command.name" rel="noreferrer" target="_blank">CONF.command.name</a>)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/cli.py",<br>
line 217, in do_upgrade<br>
    desc=branch, sql=CONF.command.sql)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/cli.py",<br>
line 124, in do_alembic_command<br>
    getattr(alembic_command, cmd)(config, *args, **kwargs)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/command.py",<br>
line 174, in upgrade<br>
    script.run_env()<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/script/base.py",<br>
line 397, in run_env<br>
    util.load_python_file(self.dir, 'env.py')<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/util/pyfiles.py",<br>
line 81, in load_python_file<br>
    module = load_module_py(module_id, path)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/util/compat.py",<br>
line 79, in load_module_py<br>
    mod = imp.load_source(module_id, path, fp)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py",<br>
line 135, in <module><br>
    run_migrations_online()<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py",<br>
line 125, in run_migrations_online<br>
    context.run_migrations()<br>
  File "<string>", line 8, in run_migrations<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/runtime/environment.py",<br>
line 797, in run_migrations<br>
    self.get_context().run_migrations(**kw)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/runtime/migration.py",<br>
line 312, in run_migrations<br>
    step.migration_fn(**kw)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/versions/mitaka/contract/8a6d8bdae39_migrate_neutron_resources_table.py",<br>
line 60, in upgrade<br>
    existing_server_default=False)<br>
  File "<string>", line 8, in alter_column<br>
  File "<string>", line 3, in alter_column<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/operations/ops.py",<br>
line 1414, in alter_column<br>
    return operations.invoke(alt)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/operations/base.py",<br>
line 318, in invoke<br>
    return fn(self, operation)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/operations/toimpl.py",<br>
line 53, in alter_column<br>
    **<a href="http://operation.kw" rel="noreferrer" target="_blank">operation.kw</a><br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/ddl/mysql.py",<br>
line 66, in alter_column<br>
    else existing_autoincrement<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/ddl/impl.py",<br>
line 118, in _exec<br>
    return conn.execute(construct, *multiparams, **params)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py",<br>
line 914, in execute<br>
    return meth(self, multiparams, params)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py",<br>
line 68, in _execute_on_connection<br>
    return connection._execute_ddl(self, multiparams, params)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py",<br>
line 968, in _execute_ddl<br>
    compiled<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py",<br>
line 1146, in _execute_context<br>
    context)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py",<br>
line 1337, in _handle_dbapi_exception<br>
    util.raise_from_cause(newraise, exc_info)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py",<br>
line 199, in raise_from_cause<br>
    reraise(type(exception), exception, tb=exc_tb)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py",<br>
line 1139, in _execute_context<br>
    context)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py",<br>
line 450, in do_execute<br>
    cursor.execute(statement, parameters)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/MySQLdb/cursors.py",<br>
line 205, in execute<br>
    self.errorhandler(self, exc, value)<br>
  File "/var/lib/kolla/venv/lib/python2.7/site-packages/MySQLdb/connections.py",<br>
line 36, in defaulterrorhandler<br>
    raise errorclass, errorvalue<br>
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError)<br>
(1832, "Cannot change column 'standard_attr_id': used in a foreign key<br>
constraint 'ports_ibfk_2'") [SQL: u'ALTER TABLE ports MODIFY<br>
standard_attr_id BIGINT NOT NULL']<br>
<br>
Is there anything wrong with the neutron rpm in RDO? Thanks. - Hui<br>
<br>
_______________________________________________<br>
Rdo-list mailing list<br>
<a href="mailto:Rdo-list@redhat.com">Rdo-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/rdo-list" rel="noreferrer" target="_blank">https://www.redhat.com/mailman/listinfo/rdo-list</a><br>
<br>
To unsubscribe: <a href="mailto:rdo-list-unsubscribe@redhat.com">rdo-list-unsubscribe@redhat.com</a><br>
</blockquote></div><br></div>