Error when installing development version of Murano

Asked by Vahid Hashemian

Hello,

I'm trying to follow the instructions at http://murano.readthedocs.org/en/latest/install/#installing-and-running-the-development-version to install Murano in my DevStack environment. Here's what I've done:

- followed devstack installation instructions and cloned devstack
- cloned murano (git clone git://git.openstack.org/openstack/murano)
- copied murano integration scripts into devstack folder
- updated local.conf to enable heat and murano

When I do ./stack.sh when it comes to configuring murano I get this error:

2015-06-11 18:51:21.830 | ++ mysql -uroot -ptime4fun -h127.0.0.1 -e 'DROP DATABASE IF EXISTS murano;'
2015-06-11 18:51:21.852 | ++ mysql -uroot -ptime4fun -h127.0.0.1 -e 'CREATE DATABASE murano CHARACTER SET utf8;'
2015-06-11 18:51:21.860 | ++ /usr/local/bin/murano-db-manage --config-file /etc/murano/murano.conf upgrade
2015-06-11 18:51:22.246 | 2015-06-11 18:51:22.246 23571 INFO alembic.migration [-] Context impl MySQLImpl.
2015-06-11 18:51:22.246 | 2015-06-11 18:51:22.246 23571 INFO alembic.migration [-] Will assume non-transactional DDL.
2015-06-11 18:51:22.253 | 2015-06-11 18:51:22.253 23571 INFO alembic.migration [-] Running upgrade -> 001, empty message
2015-06-11 18:51:22.379 | 2015-06-11 18:51:22.379 23571 DEBUG alembic.migration [-] new branch insert 001 update_to_step /usr/local/lib/python2.7/dist-packages/alembic/migration.py:473
2015-06-11 18:51:22.382 | 2015-06-11 18:51:22.382 23571 INFO alembic.migration [-] Running upgrade 001 -> 002, empty message
2015-06-11 18:51:22.397 | 2015-06-11 18:51:22.397 23571 DEBUG alembic.migration [-] update 001 to 002 update_to_step /usr/local/lib/python2.7/dist-packages/alembic/migration.py:496
2015-06-11 18:51:22.400 | 2015-06-11 18:51:22.399 23571 INFO alembic.migration [-] Running upgrade 002 -> 003, Add action column to deployment table.
2015-06-11 18:51:22.470 | 2015-06-11 18:51:22.470 23571 DEBUG alembic.migration [-] update 002 to 003 update_to_step /usr/local/lib/python2.7/dist-packages/alembic/migration.py:496
2015-06-11 18:51:22.473 | 2015-06-11 18:51:22.473 23571 INFO alembic.migration [-] Running upgrade 003 -> 004, Change type of description field in package table.
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 CRITICAL murano [-] IntegrityError: (IntegrityError) (1217, u'Cannot delete or update a parent row: a foreign key constraint fails') '\nDROP TABLE package' ()
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano Traceback (most recent call last):
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/bin/murano-db-manage", line 10, in <module>
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano sys.exit(main())
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/opt/stack/murano/murano/cmd/db_manage.py", line 82, in main
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano CONF.command.func(config)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/opt/stack/murano/murano/cmd/db_manage.py", line 26, in upgrade
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano migration.upgrade(CONF.command.revision, config=config)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/opt/stack/murano/murano/db/migration/migration.py", line 48, in upgrade
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano alembic.command.upgrade(config, revision or 'head')
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 165, in upgrade
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano script.run_env()
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 390, in run_env
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano util.load_python_file(self.dir, 'env.py')
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 243, in load_python_file
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano module = load_module_py(module_id, path)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 79, in load_module_py
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano mod = imp.load_source(module_id, path, fp)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/opt/stack/murano/murano/db/migration/alembic_migrations/env.py", line 50, in <module>
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano run_migrations_online()
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/opt/stack/murano/murano/db/migration/alembic_migrations/env.py", line 47, in run_migrations_online
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano context.run_migrations()
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "<string>", line 7, in run_migrations
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line 738, in run_migrations
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano self.get_context().run_migrations(**kw)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line 309, in run_migrations
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano step.migration_fn(**kw)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/opt/stack/murano/murano/db/migration/alembic_migrations/versions/004_change_package_desc_type.py", line 74, in upgrade
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano mysql_charset=MYSQL_CHARSET
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/opt/stack/murano/murano/db/migration/helpers.py", line 55, in transform_table
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano op.drop_table(name)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "<string>", line 7, in drop_table
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line 970, in drop_table
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano self._table(name, **kw)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 207, in drop_table
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano self._exec(schema.DropTable(table))
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 122, in _exec
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano return conn.execute(construct, *multiparams, **params)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 841, in execute
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano return meth(self, multiparams, params)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 69, in _execute_on_connection
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano return connection._execute_ddl(self, multiparams, params)
2015-06-11 18:51:22.516 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 895, in _execute_ddl
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano compiled
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1070, in _execute_context
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano context)
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1271, in _handle_dbapi_exception
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano exc_info
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano reraise(type(exception), exception, tb=exc_tb)
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1063, in _execute_context
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano context)
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 442, in do_execute
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano cursor.execute(statement, parameters)
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 134, in execute
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano result = self._query(query)
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 282, in _query
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano conn.query(q)
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 768, in query
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 929, in _read_query_result
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano result.read()
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1125, in read
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano first_packet = self.connection._read_packet()
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 893, in _read_packet
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano packet.check_error()
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 369, in check_error
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano err.raise_mysql_exception(self._data)
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano _check_mysql_exception(errinfo)
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano raise errorclass(errno, errorvalue)
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano IntegrityError: (IntegrityError) (1217, u'Cannot delete or update a parent row: a foreign key constraint fails') '\nDROP TABLE package' ()
2015-06-11 18:51:22.517 | 2015-06-11 18:51:22.513 23571 TRACE murano
2015-06-11 18:51:22.533 | + exit_trap

I have done this installation before successfully. So I am wondering if I'm missing a (new) step in the installation, or there is a bug somewhere in the latest code.

Thanks.
--Vahid

Question information

Language:
English Edit question
Status:
Solved
For:
Murano Edit question
Assignee:
Ekaterina Chernova Edit question
Solved by:
Ekaterina Chernova
Solved:
Last query:
Last reply:
Revision history for this message
Best Ekaterina Chernova (efedorova) said :
#1

Hi!

It's happened after devstack migrated to pymysql today.

We hope to fix this bug asap.

Revision history for this message
Vahid Hashemian (vahidhashemian) said :
#2

Hi Ekaterina. Thank you for the quick response, and looking forward to the fix.

Revision history for this message
Vahid Hashemian (vahidhashemian) said :
#3

Thanks Ekaterina Chernova, that solved my question.