neutron

neutron db upgrade raise error

Bug #1619367 reported by Jeffrey Zhang on 2016-09-01

This bug affects 2 people

Affects		Status	Importance	Assigned to	Milestone
	neutron	Expired	Undecided	Unassigned

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/

Tags:

Jakub Libosvar (libosvar) on 2016-09-02

Changed in neutron:
status:	New → Confirmed

Revision history for this message

Henry Gessau (gessau) wrote on 2016-09-02:

Probably fixed by https://review.openstack.org/364336 - waiting for confirmation.

tags:

added: db

Revision history for this message

Jeffrey Zhang (jeffrey4l) wrote on 2016-09-04:

Download full text (7.8 KiB)

The almost issue exist, too. It is cased by 97c25b0d2353_add_name_desc.py file. see the logs[0]

The almost issue exist, too. It is cased by 97c25b0d2353_add_name_desc.py file. see the logs[0]

2016-09-02 07:23:23.661227 | Traceback (most recent call last):
2016-09-02 07:23:23.661267 |   File "/var/lib/kolla/venv/bin/neutron-db-manage", line 10, in <module>
2016-09-02 07:23:23.661291 |     sys.exit(main())
2016-09-02 07:23:23.661342 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 686, in main
2016-09-02 07:23:23.661382 |     return_val |= bool(CONF.command.func(config, CONF.command.name))
2016-09-02 07:23:23.661435 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 207, in do_upgrade
2016-09-02 07:23:23.661490 |     desc=branch, sql=CONF.command.sql)
2016-09-02 07:23:23.661551 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 108, in do_alembic_command
2016-09-02 07:23:23.661616 |     getattr(alembic_command, cmd)(config, *args, **kwargs)
2016-09-02 07:23:23.661664 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade
2016-09-02 07:23:23.661693 |     script.run_env()
2016-09-02 07:23:23.661744 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/script/base.py", line 407, in run_env
2016-09-02 07:23:23.661777 |     util.load_python_file(self.dir, 'env.py')
2016-09-02 07:23:23.661837 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
2016-09-02 07:23:23.661871 |     module = load_module_py(module_id, path)
2016-09-02 07:23:23.661922 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py
2016-09-02 07:23:23.661955 |     mod = imp.load_source(module_id, path, fp)
2016-09-02 07:23:23.662023 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 120, in <module>
2016-09-02 07:23:23.662054 |     run_migrations_online()
2016-09-02 07:23:23.662116 |   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-02 07:23:23.662143 |     context.run_migrations()
2016-09-02 07:23:23.662174 |   File "<string>", line 8, in run_migrations
2016-09-02 07:23:23.662227 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/runtime/environment.py", line 797, in run_migrations
2016-09-02 07:23:23.662259 |     self.get_context().run_migrations(**kw)
2016-09-02 07:23:23.662312 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/runtime/migration.py", line 312, in run_migrations
2016-09-02 07:23:23.662338 |     step.migration_fn(**kw)
2016-09-02 07:23:23.662410 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/versions/newton/contract/97c25b0d2353_add_name_desc.py", line 83, in upgrade
2016-09-02 07:23:23.662439 |     existing_server_default=False)
2016-09-02 07:23:23.662484 |   File "<string>", line 8, in alter_column
2016-09-02 07:23:23.662527 |   File "<string>", line 3, in alter_column
2016-09-02 07:23:23.662580 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/operations/ops.py", line 1414, in alter_column
2016-09-02 07:23:23.662608 |     return operations.invoke(alt)
2016-09-02 07:23:23.662659 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/operations/base.py", line 318, in invoke
2016-09-02 07:23:23.662686 |     return fn(self, operation)
2016-09-02 07:23:23.662739 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/operations/toimpl.py", line 53, in alter_column
2016-09-02 07:23:23.662761 |     **operation.kw
2016-09-02 07:23:23.662811 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/ddl/mysql.py", line 67, in alter_column
2016-09-02 07:23:23.662838 |     else existing_autoincrement
2016-09-02 07:23:23.662885 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/alembic/ddl/impl.py", line 118, in _exec
2016-09-02 07:23:23.662921 |     return conn.execute(construct, *multiparams, **params)
2016-09-02 07:23:23.662971 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-09-02 07:23:23.663001 |     return meth(self, multiparams, params)
2016-09-02 07:23:23.663054 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2016-09-02 07:23:23.663099 |     return connection._execute_ddl(self, multiparams, params)
2016-09-02 07:23:23.663151 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2016-09-02 07:23:23.663173 |     compiled
2016-09-02 07:23:23.663227 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-09-02 07:23:23.663248 |     context)
2016-09-02 07:23:23.663305 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2016-09-02 07:23:23.663337 |     util.raise_from_cause(newraise, exc_info)
2016-09-02 07:23:23.663391 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-09-02 07:23:23.663428 |     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-09-02 07:23:23.663504 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-09-02 07:23:23.663533 |     context)
2016-09-02 07:23:23.663586 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-09-02 07:23:23.663617 |     cursor.execute(statement, parameters)
2016-09-02 07:23:23.663664 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/cursors.py", line 167, in execute
2016-09-02 07:23:23.663692 |     result = self._query(query)
2016-09-02 07:23:23.663739 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/cursors.py", line 323, in _query
2016-09-02 07:23:23.663761 |     conn.query(q)
2016-09-02 07:23:23.663810 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/connections.py", line 836, in query
2016-09-02 07:23:23.663851 |     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-09-02 07:23:23.663903 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/connections.py", line 1020, in _read_query_result
2016-09-02 07:23:23.663927 |     result.read()
2016-09-02 07:23:23.663975 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/connections.py", line 1303, in read
2016-09-02 07:23:23.664008 |     first_packet = self.connection._read_packet()
2016-09-02 07:23:23.664059 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/connections.py", line 982, in _read_packet
2016-09-02 07:23:23.664084 |     packet.check_error()
2016-09-02 07:23:23.664134 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/connections.py", line 394, in check_error
2016-09-02 07:23:23.664171 |     err.raise_mysql_exception(self._data)
2016-09-02 07:23:23.664223 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-09-02 07:23:23.664251 |     _check_mysql_exception(errinfo)
2016-09-02 07:23:23.664302 |   File "/var/lib/kolla/venv/lib/python2.7/site-packages/pymysql/err.py", line 115, in _check_mysql_exception
2016-09-02 07:23:23.664333 |     raise InternalError(errno, errorvalue)
2016-09-02 07:23:23.664429 | oslo_db.exception.DBError: (pymysql.err.InternalError) (1832, u"Cannot change column 'standard_attr_id': used in a foreign key constraint 'networksegments_ibfk_2'") [SQL: u'ALTER TABLE networksegments MODIFY standard_attr_id BIGINT NOT NULL']

[0] http://logs.openstack.org/94/351294/19/check/gate-kolla-dsvm-deploy-centos-source-centos-7-nv/6963472/console.html#_2016-09-02_07_23_23_661227

Revision history for this message

Ann Taraday (akamyshnikova) wrote on 2016-12-01:

I think this issue was already fixed.

Changed in neutron:
status:	Confirmed → Incomplete

Revision history for this message

Launchpad Janitor (janitor) wrote on 2017-01-31:

[Expired for neutron because there has been no activity for 60 days.]

Changed in neutron:
status:	Incomplete → Expired

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.