[Expired for neutron because there has been no activity for 60 days.]
** Changed in: neutron
Status: Incomplete => Expired
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1619367
Title:
neutron db upgrade raise error
Status in neutron:
Expired
Bug description:
here is the logs:
2016-09-01 14:46:26.838319 | Traceback (most recent call last):
2016-09-01 14:46:26.838344 | File
"/var/lib/kolla/venv/bin/neutron-db-manage", line 10, in <module>
2016-09-01 14:46:26.838356 | sys.exit(main())
2016-09-01 14:46:26.838389 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/cli.py",
line 686, in main
2016-09-01 14:46:26.838413 | return_val |= bool(CONF.command.func(config,
CONF.command.name))
2016-09-01 14:46:26.838448 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/cli.py",
line 207, in do_upgrade
2016-09-01 14:46:26.838464 | desc=branch, sql=CONF.command.sql)
2016-09-01 14:46:26.838500 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/cli.py",
line 108, in do_alembic_command
2016-09-01 14:46:26.838522 | getattr(alembic_command, cmd)(config, *args,
**kwargs)
2016-09-01 14:46:26.838563 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/command.py", line 174,
in upgrade
2016-09-01 14:46:26.838578 | script.run_env()
2016-09-01 14:46:26.838610 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/script/base.py", line
407, in run_env
2016-09-01 14:46:26.838629 | util.load_python_file(self.dir, 'env.py')
2016-09-01 14:46:26.838663 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/util/pyfiles.py", line
93, in load_python_file
2016-09-01 14:46:26.838682 | module = load_module_py(module_id, path)
2016-09-01 14:46:26.838715 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/util/compat.py", line
79, in load_module_py
2016-09-01 14:46:26.838734 | mod = imp.load_source(module_id, path, fp)
2016-09-01 14:46:26.838772 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py",
line 120, in <module>
2016-09-01 14:46:26.838787 | run_migrations_online()
2016-09-01 14:46:26.838828 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py",
line 114, in run_migrations_online
2016-09-01 14:46:26.838848 | context.run_migrations()
2016-09-01 14:46:26.838867 | File "<string>", line 8, in run_migrations
2016-09-01 14:46:26.838908 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/runtime/environment.py",
line 797, in run_migrations
2016-09-01 14:46:26.838927 | self.get_context().run_migrations(**kw)
2016-09-01 14:46:26.838962 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/runtime/migration.py",
line 312, in run_migrations
2016-09-01 14:46:26.838976 | step.migration_fn(**kw)
2016-09-01 14:46:26.839039 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/versions/newton/contract/b12a3ef66e62_add_standardattr_to_qos_policies.py",
line 60, in upgrade
2016-09-01 14:46:26.839059 | existing_server_default=False)
2016-09-01 14:46:26.839077 | File "<string>", line 8, in alter_column
2016-09-01 14:46:26.839095 | File "<string>", line 3, in alter_column
2016-09-01 14:46:26.839129 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/operations/ops.py",
line 1414, in alter_column
2016-09-01 14:46:26.839146 | return operations.invoke(alt)
2016-09-01 14:46:26.839178 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/operations/base.py",
line 318, in invoke
2016-09-01 14:46:26.839194 | return fn(self, operation)
2016-09-01 14:46:26.839228 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/operations/toimpl.py",
line 53, in alter_column
2016-09-01 14:46:26.839240 | **operation.kw
2016-09-01 14:46:26.839273 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/ddl/mysql.py", line
67, in alter_column
2016-09-01 14:46:26.839289 | else existing_autoincrement
2016-09-01 14:46:26.839319 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/ddl/impl.py", line
118, in _exec
2016-09-01 14:46:26.839341 | return conn.execute(construct, *multiparams,
**params)
2016-09-01 14:46:26.839374 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 914, in execute
2016-09-01 14:46:26.839392 | return meth(self, multiparams, params)
2016-09-01 14:46:26.839427 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line
68, in _execute_on_connection
2016-09-01 14:46:26.839450 | return connection._execute_ddl(self,
multiparams, params)
2016-09-01 14:46:26.839483 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 968, in _execute_ddl
2016-09-01 14:46:26.839495 | compiled
2016-09-01 14:46:26.839530 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1146, in _execute_context
2016-09-01 14:46:26.839541 | context)
2016-09-01 14:46:26.839578 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1337, in _handle_dbapi_exception
2016-09-01 14:46:26.839596 | util.raise_from_cause(newraise, exc_info)
2016-09-01 14:46:26.839631 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py",
line 202, in raise_from_cause
2016-09-01 14:46:26.839654 | reraise(type(exception), exception,
tb=exc_tb, cause=cause)
2016-09-01 14:46:26.839689 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1139, in _execute_context
2016-09-01 14:46:26.839700 | context)
2016-09-01 14:46:26.839734 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 450, in do_execute
2016-09-01 14:46:26.839752 | cursor.execute(statement, parameters)
2016-09-01 14:46:26.839783 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/cursors.py", line 167,
in execute
2016-09-01 14:46:26.839799 | result = self._query(query)
2016-09-01 14:46:26.839830 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/cursors.py", line 323,
in _query
2016-09-01 14:46:26.839842 | conn.query(q)
2016-09-01 14:46:26.839877 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/connections.py", line
836, in query
2016-09-01 14:46:26.839903 | self._affected_rows =
self._read_query_result(unbuffered=unbuffered)
2016-09-01 14:46:26.839938 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/connections.py", line
1020, in _read_query_result
2016-09-01 14:46:26.839950 | result.read()
2016-09-01 14:46:26.839982 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/connections.py", line
1303, in read
2016-09-01 14:46:26.840002 | first_packet = self.connection._read_packet()
2016-09-01 14:46:26.840043 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/connections.py", line
982, in _read_packet
2016-09-01 14:46:26.840060 | packet.check_error()
2016-09-01 14:46:26.840093 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/connections.py", line
394, in check_error
2016-09-01 14:46:26.840111 | err.raise_mysql_exception(self._data)
2016-09-01 14:46:26.840145 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/err.py", line 120, in
raise_mysql_exception
2016-09-01 14:46:26.840161 | _check_mysql_exception(errinfo)
2016-09-01 14:46:26.840195 | File
"/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/err.py", line 115, in
_check_mysql_exception
2016-09-01 14:46:26.840213 | raise InternalError(errno, errorvalue)
2016-09-01 14:46:26.840279 | oslo_db.exception.DBError:
(pymysql.err.InternalError) (1832, u"Cannot change column 'standard_attr_id':
used in a foreign key constraint 'qos_policies_ibfk_1'") [SQL: u'ALTER TABLE
qos_policies MODIFY standard_attr_id BIGINT NOT NULL']
2016-09-01 14:46:26.840290 | + copy_logs
more info please check[0]. Maybe this PS can fix this[1]
[0] http://logs.openstack.org/10/364310/2/check/gate-kolla-dsvm-
deploy-centos-source-
centos-7-nv/3fa8604/console.html#_2016-09-01_14_46_26_840279
[1] https://review.openstack.org/#/c/364336/
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1619367/+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
