Error install tacker in devstack

Bug #1596025 reported by Adriano
256
This bug affects 1 person
Affects Status Importance Assigned to Milestone
tacker
New
Undecided
Unassigned

Bug Description

2016-06-24 16:15:04.556 | INFO [alembic.runtime.migration] Context impl MySQLImpl.
2016-06-24 16:15:04.556 | INFO [alembic.runtime.migration] Will assume non-transactional DDL.
2016-06-24 16:15:04.700 | INFO [alembic.runtime.migration] Running upgrade -> 1c6b0d82afcd, add tables for tacker framework
2016-06-24 16:15:04.863 | INFO [alembic.runtime.migration] Running upgrade 1c6b0d82afcd -> 81ffa86020d, rpc_proxy
2016-06-24 16:15:04.949 | INFO [alembic.runtime.migration] Running upgrade 81ffa86020d -> 4c31092895b8, empty message
2016-06-24 16:15:04.998 | INFO [alembic.runtime.migration] Running upgrade 4c31092895b8 -> 13c0e0661015, add descrition to vnf
2016-06-24 16:15:05.163 | INFO [alembic.runtime.migration] Running upgrade 13c0e0661015 -> 5958429bcb3c, modify datatype of value
2016-06-24 16:15:05.286 | INFO [alembic.runtime.migration] Running upgrade 5958429bcb3c -> 12a57080b277, Add Service related dbs
2016-06-24 16:15:05.492 | INFO [alembic.runtime.migration] Running upgrade 12a57080b277 -> 12a57080b278, Alter devices
2016-06-24 16:15:05.609 | INFO [alembic.runtime.migration] Running upgrade 12a57080b278 -> 2774a42c7163, remove service related
2016-06-24 16:15:05.689 | INFO [alembic.runtime.migration] Running upgrade 2774a42c7163 -> 24bec5f211c7, Alter value in deviceattributes
2016-06-24 16:15:05.769 | INFO [alembic.runtime.migration] Running upgrade 24bec5f211c7 -> 5246a6bd410f, multisite_vim
2016-06-24 16:15:06.046 | INFO [alembic.runtime.migration] Running upgrade 5246a6bd410f -> acf941e54075, Add error_reason to device
2016-06-24 16:15:06.116 | INFO [alembic.runtime.migration] Running upgrade acf941e54075 -> f958f58e5daa, uuid consistency
2016-06-24 16:15:06.122 | Traceback (most recent call last):
2016-06-24 16:15:06.122 | File "/usr/local/bin/tacker-db-manage", line 10, in <module>
2016-06-24 16:15:06.122 | sys.exit(main())
2016-06-24 16:15:06.122 | File "/opt/stack/tacker/tacker/db/migration/cli.py", line 153, in main
2016-06-24 16:15:06.122 | CONF.command.func(config, CONF.command.name)
2016-06-24 16:15:06.122 | File "/opt/stack/tacker/tacker/db/migration/cli.py", line 67, in do_upgrade_downgrade
2016-06-24 16:15:06.122 | do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
2016-06-24 16:15:06.122 | File "/opt/stack/tacker/tacker/db/migration/cli.py", line 45, in do_alembic_command
2016-06-24 16:15:06.122 | getattr(alembic_command, cmd)(config, *args, **kwargs)
2016-06-24 16:15:06.122 | File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 174, in upgrade
2016-06-24 16:15:06.122 | script.run_env()
2016-06-24 16:15:06.122 | File "/usr/local/lib/python2.7/dist-packages/alembic/script/base.py", line 397, in run_env
2016-06-24 16:15:06.122 | util.load_python_file(self.dir, 'env.py')
2016-06-24 16:15:06.122 | File "/usr/local/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 93, in load_python_file
2016-06-24 16:15:06.123 | module = load_module_py(module_id, path)
2016-06-24 16:15:06.123 | File "/usr/local/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py
2016-06-24 16:15:06.123 | mod = imp.load_source(module_id, path, fp)
2016-06-24 16:15:06.123 | File "/opt/stack/tacker/tacker/db/migration/alembic_migrations/env.py", line 84, in <module>
2016-06-24 16:15:06.123 | run_migrations_online()
2016-06-24 16:15:06.123 | File "/opt/stack/tacker/tacker/db/migration/alembic_migrations/env.py", line 76, in run_migrations_online
2016-06-24 16:15:06.123 | context.run_migrations()
2016-06-24 16:15:06.123 | File "<string>", line 8, in run_migrations
2016-06-24 16:15:06.123 | File "/usr/local/lib/python2.7/dist-packages/alembic/runtime/environment.py", line 797, in run_migrations
2016-06-24 16:15:06.124 | self.get_context().run_migrations(**kw)
2016-06-24 16:15:06.124 | File "/usr/local/lib/python2.7/dist-packages/alembic/runtime/migration.py", line 312, in run_migrations
2016-06-24 16:15:06.124 | step.migration_fn(**kw)
2016-06-24 16:15:06.124 | File "/opt/stack/tacker/tacker/db/migration/alembic_migrations/versions/f958f58e5daa_uuid_consistency.py", line 40, in upgrade
2016-06-24 16:15:06.124 | type_=types.Uuid)
2016-06-24 16:15:06.124 | File "<string>", line 8, in alter_column
2016-06-24 16:15:06.124 | File "<string>", line 3, in alter_column
2016-06-24 16:15:06.124 | File "/usr/local/lib/python2.7/dist-packages/alembic/operations/ops.py", line 1414, in alter_column
2016-06-24 16:15:06.126 | return operations.invoke(alt)
2016-06-24 16:15:06.126 | File "/usr/local/lib/python2.7/dist-packages/alembic/operations/base.py", line 318, in invoke
2016-06-24 16:15:06.126 | return fn(self, operation)
2016-06-24 16:15:06.126 | File "/usr/local/lib/python2.7/dist-packages/alembic/operations/toimpl.py", line 53, in alter_column
2016-06-24 16:15:06.126 | **operation.kw
2016-06-24 16:15:06.126 | File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 67, in alter_column
2016-06-24 16:15:06.127 | else existing_autoincrement
2016-06-24 16:15:06.127 | File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 118, in _exec
2016-06-24 16:15:06.127 | return conn.execute(construct, *multiparams, **params)
2016-06-24 16:15:06.127 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-06-24 16:15:06.128 | return meth(self, multiparams, params)
2016-06-24 16:15:06.128 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2016-06-24 16:15:06.128 | return connection._execute_ddl(self, multiparams, params)
2016-06-24 16:15:06.128 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2016-06-24 16:15:06.128 | compiled
2016-06-24 16:15:06.128 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-06-24 16:15:06.129 | context)
2016-06-24 16:15:06.129 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
2016-06-24 16:15:06.129 | exc_info
2016-06-24 16:15:06.129 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-06-24 16:15:06.129 | reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-06-24 16:15:06.129 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-06-24 16:15:06.129 | context)
2016-06-24 16:15:06.129 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-06-24 16:15:06.130 | cursor.execute(statement, parameters)
2016-06-24 16:15:06.130 | File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 161, in execute
2016-06-24 16:15:06.146 | result = self._query(query)
2016-06-24 16:15:06.146 | File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 317, in _query
2016-06-24 16:15:06.146 | conn.query(q)
2016-06-24 16:15:06.146 | File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2016-06-24 16:15:06.209 | self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-06-24 16:15:06.209 | File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2016-06-24 16:15:06.209 | result.read()
2016-06-24 16:15:06.209 | File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2016-06-24 16:15:06.209 | first_packet = self.connection._read_packet()
2016-06-24 16:15:06.209 | File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-06-24 16:15:06.209 | packet.check_error()
2016-06-24 16:15:06.209 | File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-06-24 16:15:06.209 | err.raise_mysql_exception(self._data)
2016-06-24 16:15:06.209 | File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-06-24 16:15:06.209 | _check_mysql_exception(errinfo)
2016-06-24 16:15:06.210 | File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
2016-06-24 16:15:06.210 | raise InternalError(errno, errorvalue)
2016-06-24 16:15:06.210 | sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1833, u"Cannot change column 'id': used in a foreign key constraint 'devices_ibfk_2' of table 'tacker.devices'") [SQL: u'ALTER TABLE vims MODIFY id VARCHAR(36) NULL']
2016-06-24 16:15:06.251 | Error on exit

Revision history for this message
Vitalii Gridnev (vgridnev) wrote :

Why it affects sahara?

affects: sahara → tacker
Revision history for this message
Janki Chhatbar (jankihchhatbar) wrote :
Revision history for this message
Sripriya (sseetha) wrote :

Marking this bug as a duplicate of a similar bug that was raised earlier in https://bugs.launchpad.net/tacker/+bug/1594807. Please refer to that bug for details.

Adriano (dritec)
information type: Public → Public Security
To post a comment you must log in.
This report contains Public Security information  
Everyone can see this security related information.

Other bug subscribers

Remote bug watches

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