tuskar

Tuskar migration error when running" tuskar-dbsync --config-file etc/tuskar/tuskar.conf "

Bug #1365848 reported by Andy Yan on 2014-09-05

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	tuskar	Fix Released	High	Dougal Matthews

Bug Description

The bug on line 95-96 in tuskar/db/sqlalchemy/migrate_repo/versions/001_init.py.
line 34 in tuskar/db/sqlalchemy/migrate_repo/versions/002_add_stored_file.py
I've followed this guide today: https://github.com/openstack/tuskar/blob/master/doc/source/INSTALL.rst
I managed to install all the packages need manually, but when I ran:
tuskar-dbsync --config-file etc/tuskar/tuskar.conf
It got error below:

(py27)stack@undercloud-undercloud-fvratskzqess:~/tuskar$ tuskar-dbsync --debug --config-file etc/tuskar/tuskar.conf
2014-09-05 05:53:49.972 10784 DEBUG migrate.versioning.repository [-] Loading repository /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migrate_repo... __init__ /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/repository.py:76
2014-09-05 05:53:49.973 10784 DEBUG migrate.versioning.script.base [-] Loading script /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migrate_repo/versions/001_init.py... __init__ /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/script/base.py:27
2014-09-05 05:53:49.973 10784 DEBUG migrate.versioning.script.base [-] Script /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migrate_repo/versions/001_init.py loaded successfully __init__ /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/script/base.py:30
2014-09-05 05:53:49.973 10784 DEBUG migrate.versioning.script.base [-] Loading script /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migrate_repo/versions/002_add_stored_file.py... __init__ /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/script/base.py:27
2014-09-05 05:53:49.974 10784 DEBUG migrate.versioning.script.base [-] Script /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migrate_repo/versions/002_add_stored_file.py loaded successfully __init__ /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/script/base.py:30
2014-09-05 05:53:49.974 10784 DEBUG migrate.versioning.repository [-] Repository /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migrate_repo loaded successfully __init__ /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/repository.py:82
2014-09-05 05:53:49.974 10784 DEBUG migrate.versioning.repository [-] Config: OrderedDict([('db_settings', OrderedDict([('__name__', 'db_settings'), ('repository_id', 'tuskar'), ('version_table', 'migrate_version'), ('required_dbs', '[]')]))]) __init__ /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/repository.py:83
2014-09-05 05:53:49.987 10784 DEBUG oslo.db.sqlalchemy.session [-] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION _mysql_check_effective_sql_mode /home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py:401
2014-09-05 05:53:50.147 10784 INFO migrate.versioning.api [-] 0 -> 1...
2014-09-05 05:53:50.151 10784 INFO 001_init [-] Table('overcloud_roles', MetaData(bind=Engine(mysql://tuskar:***@localhost/tuskar)), Column('id', Integer(), table=<overcloud_roles>, primary_key=True, nullable=False), Column('name', String(length=64), table=<overcloud_roles>), Column('description', String(length=256), table=<overcloud_roles>), Column('image_name', String(length=64), table=<overcloud_roles>), Column('flavor_id', String(length=36), table=<overcloud_roles>), Column('created_at', DateTime(), table=<overcloud_roles>), Column('updated_at', DateTime(), table=<overcloud_roles>), schema=None)
2014-09-05 05:53:50.348 10784 INFO 001_init [-] Table('overcloud_role_counts', MetaData(bind=Engine(mysql://tuskar:***@localhost/tuskar)), Column('id', Integer(), table=<overcloud_role_counts>, primary_key=True, nullable=False), Column('overcloud_role_id', Integer(), ForeignKey('overcloud_roles.id'), table=<overcloud_role_counts>, nullable=False), Column('overcloud_id', Integer(), ForeignKey('overclouds.id'), table=<overcloud_role_counts>, nullable=False), Column('num_nodes', Integer(), table=<overcloud_role_counts>, nullable=False), Column('created_at', DateTime(), table=<overcloud_role_counts>), Column('updated_at', DateTime(), table=<overcloud_role_counts>), schema=None)
2014-09-05 05:53:50.541 10784 INFO 001_init [-] Table('overcloud_role_counts', MetaData(bind=Engine(mysql://tuskar:***@localhost/tuskar)), Column('id', Integer(), table=<overcloud_role_counts>, primary_key=True, nullable=False), Column('overcloud_role_id', Integer(), ForeignKey('overcloud_roles.id'), table=<overcloud_role_counts>, nullable=False), Column('overcloud_id', Integer(), ForeignKey('overclouds.id'), table=<overcloud_role_counts>, nullable=False), Column('num_nodes', Integer(), table=<overcloud_role_counts>, nullable=False), Column('created_at', DateTime(), table=<overcloud_role_counts>), Column('updated_at', DateTime(), table=<overcloud_role_counts>), schema=None)
2014-09-05 05:53:50.542 10784 ERROR 001_init [-] Exception while creating table.
2014-09-05 05:53:50.542 10784 TRACE 001_init Traceback (most recent call last):
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migrate_repo/versions/001_init.py", line 101, in upgrade
2014-09-05 05:53:50.542 10784 TRACE 001_init table.create()
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 655, in create
2014-09-05 05:53:50.542 10784 TRACE 001_init checkfirst=checkfirst)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1617, in _run_visitor
2014-09-05 05:53:50.542 10784 TRACE 001_init conn._run_visitor(visitorcallable, element, **kwargs)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _run_visitor
2014-09-05 05:53:50.542 10784 TRACE 001_init **kwargs).traverse_single(element)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 120, in traverse_single
2014-09-05 05:53:50.542 10784 TRACE 001_init return meth(obj, **kw)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 732, in visit_table
2014-09-05 05:53:50.542 10784 TRACE 001_init self.connection.execute(CreateTable(table))
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute
2014-09-05 05:53:50.542 10784 TRACE 001_init return meth(self, multiparams, params)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 69, in _execute_on_connection
2014-09-05 05:53:50.542 10784 TRACE 001_init return connection._execute_ddl(self, multiparams, params)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 783, in _execute_ddl
2014-09-05 05:53:50.542 10784 TRACE 001_init compiled
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
2014-09-05 05:53:50.542 10784 TRACE 001_init context)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1156, in _handle_dbapi_exception
2014-09-05 05:53:50.542 10784 TRACE 001_init util.raise_from_cause(newraise, exc_info)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2014-09-05 05:53:50.542 10784 TRACE 001_init reraise(type(exception), exception, tb=exc_tb)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
2014-09-05 05:53:50.542 10784 TRACE 001_init context)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
2014-09-05 05:53:50.542 10784 TRACE 001_init cursor.execute(statement, parameters)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
2014-09-05 05:53:50.542 10784 TRACE 001_init self.errorhandler(self, exc, value)
2014-09-05 05:53:50.542 10784 TRACE 001_init File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2014-09-05 05:53:50.542 10784 TRACE 001_init raise errorclass, errorvalue
2014-09-05 05:53:50.542 10784 TRACE 001_init OperationalError: (OperationalError) (1005, "Can't create table 'tuskar.overcloud_role_counts' (errno: 150)") '\nCREATE TABLE overcloud_role_counts (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tovercloud_role_id INTEGER NOT NULL, \n\tovercloud_id INTEGER NOT NULL, \n\tnum_nodes INTEGER NOT NULL, \n\tcreated_at DATETIME, \n\tupdated_at DATETIME, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(overcloud_role_id) REFERENCES overcloud_roles (id), \n\tFOREIGN KEY(overcloud_id) REFERENCES overclouds (id)\n)ENGINE=InnoDB CHARSET=utf8\n\n' ()
2014-09-05 05:53:50.542 10784 TRACE 001_init
2014-09-05 05:53:50.545 10784 CRITICAL tuskar [-] OperationalError: (OperationalError) (1005, "Can't create table 'tuskar.overcloud_role_counts' (errno: 150)") '\nCREATE TABLE overcloud_role_counts (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tovercloud_role_id INTEGER NOT NULL, \n\tovercloud_id INTEGER NOT NULL, \n\tnum_nodes INTEGER NOT NULL, \n\tcreated_at DATETIME, \n\tupdated_at DATETIME, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(overcloud_role_id) REFERENCES overcloud_roles (id), \n\tFOREIGN KEY(overcloud_id) REFERENCES overclouds (id)\n)ENGINE=InnoDB CHARSET=utf8\n\n' ()
2014-09-05 05:53:50.545 10784 TRACE tuskar Traceback (most recent call last):
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/bin/tuskar-dbsync", line 10, in <module>
2014-09-05 05:53:50.545 10784 TRACE tuskar sys.exit(main())
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/cmd/dbsync.py", line 37, in main
2014-09-05 05:53:50.545 10784 TRACE tuskar migration.db_sync()
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/migration.py", line 31, in db_sync
2014-09-05 05:53:50.545 10784 TRACE tuskar return IMPL.db_sync(version=version)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migration.py", line 43, in db_sync
2014-09-05 05:53:50.545 10784 TRACE tuskar return versioning_api.upgrade(get_engine(), repository, version)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
2014-09-05 05:53:50.545 10784 TRACE tuskar return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "<string>", line 2, in _migrate
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
2014-09-05 05:53:50.545 10784 TRACE tuskar return f(*a, **kw)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
2014-09-05 05:53:50.545 10784 TRACE tuskar schema.runchange(ver, change, changeset.step)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
2014-09-05 05:53:50.545 10784 TRACE tuskar change.run(self.engine, step)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run
2014-09-05 05:53:50.545 10784 TRACE tuskar script_func(engine)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migrate_repo/versions/001_init.py", line 101, in upgrade
2014-09-05 05:53:50.545 10784 TRACE tuskar table.create()
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 655, in create
2014-09-05 05:53:50.545 10784 TRACE tuskar checkfirst=checkfirst)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1617, in _run_visitor
2014-09-05 05:53:50.545 10784 TRACE tuskar conn._run_visitor(visitorcallable, element, **kwargs)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _run_visitor
2014-09-05 05:53:50.545 10784 TRACE tuskar **kwargs).traverse_single(element)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 120, in traverse_single
2014-09-05 05:53:50.545 10784 TRACE tuskar return meth(obj, **kw)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 732, in visit_table
2014-09-05 05:53:50.545 10784 TRACE tuskar self.connection.execute(CreateTable(table))
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute
2014-09-05 05:53:50.545 10784 TRACE tuskar return meth(self, multiparams, params)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 69, in _execute_on_connection
2014-09-05 05:53:50.545 10784 TRACE tuskar return connection._execute_ddl(self, multiparams, params)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 783, in _execute_ddl
2014-09-05 05:53:50.545 10784 TRACE tuskar compiled
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
2014-09-05 05:53:50.545 10784 TRACE tuskar context)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1156, in _handle_dbapi_exception
2014-09-05 05:53:50.545 10784 TRACE tuskar util.raise_from_cause(newraise, exc_info)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2014-09-05 05:53:50.545 10784 TRACE tuskar reraise(type(exception), exception, tb=exc_tb)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
2014-09-05 05:53:50.545 10784 TRACE tuskar context)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
2014-09-05 05:53:50.545 10784 TRACE tuskar cursor.execute(statement, parameters)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
2014-09-05 05:53:50.545 10784 TRACE tuskar self.errorhandler(self, exc, value)
2014-09-05 05:53:50.545 10784 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2014-09-05 05:53:50.545 10784 TRACE tuskar raise errorclass, errorvalue
2014-09-05 05:53:50.545 10784 TRACE tuskar OperationalError: (OperationalError) (1005, "Can't create table 'tuskar.overcloud_role_counts' (errno: 150)") '\nCREATE TABLE overcloud_role_counts (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tovercloud_role_id INTEGER NOT NULL, \n\tovercloud_id INTEGER NOT NULL, \n\tnum_nodes INTEGER NOT NULL, \n\tcreated_at DATETIME, \n\tupdated_at DATETIME, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(overcloud_role_id) REFERENCES overcloud_roles (id), \n\tFOREIGN KEY(overcloud_id) REFERENCES overclouds (id)\n)ENGINE=InnoDB CHARSET=utf8\n\n' ()
2014-09-05 05:53:50.545 10784 TRACE tuskar

2014-09-05 06:06:46.247 12382 ERROR 002_add_stored_file [-] Exception while creating table.
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file Traceback (most recent call last):
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migrate_repo/versions/002_add_stored_file.py", line 46, in upgrade
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file stored_file.create()
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 655, in create
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file checkfirst=checkfirst)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1617, in _run_visitor
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file conn._run_visitor(visitorcallable, element, **kwargs)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _run_visitor
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file **kwargs).traverse_single(element)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 120, in traverse_single
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return meth(obj, **kw)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 732, in visit_table
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file self.connection.execute(CreateTable(table))
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return meth(self, multiparams, params)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 69, in _execute_on_connection
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return connection._execute_ddl(self, multiparams, params)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 777, in _execute_ddl
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file compiled = ddl.compile(dialect=dialect)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "<string>", line 1, in <lambda>
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 492, in compile
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return self._compiler(dialect, bind=bind, **kw)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 27, in _compiler
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return dialect.ddl_compiler(dialect, self, **kw)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 199, in __init__
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file self.string = self.process(self.statement, **compile_kwargs)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 222, in process
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return obj._compiler_dispatch(self, **kwargs)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 80, in _compiler_dispatch
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return meth(self, **kw)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2386, in visit_create_table
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file (table.description, column.name, ce.args[0])
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file reraise(type(exception), exception, tb=exc_tb)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2375, in visit_create_table
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file and not first_pk)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 222, in process
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return obj._compiler_dispatch(self, **kwargs)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 80, in _compiler_dispatch
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return meth(self, **kw)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2404, in visit_create_column
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file first_pk=first_pk
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 1704, in get_column_specification
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file self.dialect.type_compiler.process(column.type)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 269, in process
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return type_._compiler_dispatch(self)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 80, in _compiler_dispatch
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return meth(self, **kw)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2773, in visit_string
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file return self.visit_VARCHAR(type_)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2053, in visit_VARCHAR
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file self.dialect.name)
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file CompileError: (in table 'stored_file', column 'contents'): VARCHAR requires a length on dialect mysql
2014-09-05 06:06:46.247 12382 TRACE 002_add_stored_file
2014-09-05 06:06:46.251 12382 CRITICAL tuskar [-] CompileError: (in table 'stored_file', column 'contents'): VARCHAR requires a length on dialect mysql
2014-09-05 06:06:46.251 12382 TRACE tuskar Traceback (most recent call last):
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/bin/tuskar-dbsync", line 10, in <module>
2014-09-05 06:06:46.251 12382 TRACE tuskar sys.exit(main())
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/cmd/dbsync.py", line 37, in main
2014-09-05 06:06:46.251 12382 TRACE tuskar migration.db_sync()
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/migration.py", line 31, in db_sync
2014-09-05 06:06:46.251 12382 TRACE tuskar return IMPL.db_sync(version=version)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migration.py", line 43, in db_sync
2014-09-05 06:06:46.251 12382 TRACE tuskar return versioning_api.upgrade(get_engine(), repository, version)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
2014-09-05 06:06:46.251 12382 TRACE tuskar return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "<string>", line 2, in _migrate
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
2014-09-05 06:06:46.251 12382 TRACE tuskar return f(*a, **kw)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
2014-09-05 06:06:46.251 12382 TRACE tuskar schema.runchange(ver, change, changeset.step)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
2014-09-05 06:06:46.251 12382 TRACE tuskar change.run(self.engine, step)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run
2014-09-05 06:06:46.251 12382 TRACE tuskar script_func(engine)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/tuskar/db/sqlalchemy/migrate_repo/versions/002_add_stored_file.py", line 46, in upgrade
2014-09-05 06:06:46.251 12382 TRACE tuskar stored_file.create()
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 655, in create
2014-09-05 06:06:46.251 12382 TRACE tuskar checkfirst=checkfirst)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1617, in _run_visitor
2014-09-05 06:06:46.251 12382 TRACE tuskar conn._run_visitor(visitorcallable, element, **kwargs)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _run_visitor
2014-09-05 06:06:46.251 12382 TRACE tuskar **kwargs).traverse_single(element)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 120, in traverse_single
2014-09-05 06:06:46.251 12382 TRACE tuskar return meth(obj, **kw)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 732, in visit_table
2014-09-05 06:06:46.251 12382 TRACE tuskar self.connection.execute(CreateTable(table))
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute
2014-09-05 06:06:46.251 12382 TRACE tuskar return meth(self, multiparams, params)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 69, in _execute_on_connection
2014-09-05 06:06:46.251 12382 TRACE tuskar return connection._execute_ddl(self, multiparams, params)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 777, in _execute_ddl
2014-09-05 06:06:46.251 12382 TRACE tuskar compiled = ddl.compile(dialect=dialect)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "<string>", line 1, in <lambda>
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 492, in compile
2014-09-05 06:06:46.251 12382 TRACE tuskar return self._compiler(dialect, bind=bind, **kw)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 27, in _compiler
2014-09-05 06:06:46.251 12382 TRACE tuskar return dialect.ddl_compiler(dialect, self, **kw)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 199, in __init__
2014-09-05 06:06:46.251 12382 TRACE tuskar self.string = self.process(self.statement, **compile_kwargs)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 222, in process
2014-09-05 06:06:46.251 12382 TRACE tuskar return obj._compiler_dispatch(self, **kwargs)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 80, in _compiler_dispatch
2014-09-05 06:06:46.251 12382 TRACE tuskar return meth(self, **kw)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2386, in visit_create_table
2014-09-05 06:06:46.251 12382 TRACE tuskar (table.description, column.name, ce.args[0])
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2014-09-05 06:06:46.251 12382 TRACE tuskar reraise(type(exception), exception, tb=exc_tb)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2375, in visit_create_table
2014-09-05 06:06:46.251 12382 TRACE tuskar and not first_pk)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 222, in process
2014-09-05 06:06:46.251 12382 TRACE tuskar return obj._compiler_dispatch(self, **kwargs)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 80, in _compiler_dispatch
2014-09-05 06:06:46.251 12382 TRACE tuskar return meth(self, **kw)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2404, in visit_create_column
2014-09-05 06:06:46.251 12382 TRACE tuskar first_pk=first_pk
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 1704, in get_column_specification
2014-09-05 06:06:46.251 12382 TRACE tuskar self.dialect.type_compiler.process(column.type)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 269, in process
2014-09-05 06:06:46.251 12382 TRACE tuskar return type_._compiler_dispatch(self)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 80, in _compiler_dispatch
2014-09-05 06:06:46.251 12382 TRACE tuskar return meth(self, **kw)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 2773, in visit_string
2014-09-05 06:06:46.251 12382 TRACE tuskar return self.visit_VARCHAR(type_)
2014-09-05 06:06:46.251 12382 TRACE tuskar File "/home/stack/tuskar/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2053, in visit_VARCHAR
2014-09-05 06:06:46.251 12382 TRACE tuskar self.dialect.name)
2014-09-05 06:06:46.251 12382 TRACE tuskar CompileError: (in table 'stored_file', column 'contents'): VARCHAR requires a length on dialect mysql
2014-09-05 06:06:46.251 12382 TRACE tuskar

Dougal Matthews (d0ugal) on 2014-09-07

Changed in tuskar:
assignee:	nobody → Dougal Matthews (d0ugal)
status:	New → Confirmed
importance:	Undecided → High

OpenStack Infra (hudson-openstack) on 2014-09-09

Changed in tuskar:
status:	Confirmed → In Progress

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2014-09-10: Fix merged to tuskar (master)

Reviewed: https://review.openstack.org/120050
Committed: https://git.openstack.org/cgit/openstack/tuskar/commit/?id=a3575e31896b9dbdeaf17f8a34727a17a6bd0f8d
Submitter: Jenkins
Branch: master

commit a3575e31896b9dbdeaf17f8a34727a17a6bd0f8d
Author: Dougal Matthews <email address hidden>
Date: Tue Sep 9 10:47:05 2014 +0100

Changed the storage SQLAlchemy model to use Text

    The contents property on StoredFiles shouldn't have a length, under
    MySQL the String type requires a length but Text doesn't and is thus
    a better fit.

Closes-bug: #1365848
Change-Id: Ib91cabe72026d13587d48b4451013d2b3528e96c

Changed in tuskar:
status:	In Progress → Fix Committed

Jay Dobies (jdob) on 2014-09-15

Changed in tuskar:
status:	Fix Committed → Fix Released

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.