It seems there was a temporary issue in the ci environment when running
db sync.
** Changed in: nova
Status: New => Invalid
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1103088
Title:
Build failed on database migration tests
Status in OpenStack Compute (Nova):
Invalid
Bug description:
Bogus build failure from Jenkins test run:
http://logs.openstack.org/19128/12/check/gate-nova-python26/14409/console.html
https://review.openstack.org/#/c/19128/
17:46:40 ERROR:
nova.tests.test_migrations.TestMigrations.test_migration_149_mysql
17:46:40 tags: worker-1
17:46:40
----------------------------------------------------------------------
17:46:40 Empty attachments:
17:46:40 pythonlogging:'nova'
17:46:40 stderr
17:46:40 stdout
17:46:40
17:46:40 Traceback (most recent call last):
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/nova/tests/test_migrations.py",
line 336, in test_migration_149_mysql
17:46:40 self._migrate_up(engine, 149)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/nova/tests/test_migrations.py",
line 399, in _migrate_up
17:46:40 version)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/versioning/api.py",
line 186, in upgrade
17:46:40 return _migrate(url, repository, version, upgrade=True, err=err,
**opts)
17:46:40 File "<string>", line 2, in _migrate
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/nova/db/sqlalchemy/migration.py",
line 43, in patched_with_engine
17:46:40 return f(*a, **kw)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/versioning/api.py",
line 366, in _migrate
17:46:40 schema.runchange(ver, change, changeset.step)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/versioning/schema.py",
line 91, in runchange
17:46:40 change.run(self.engine, step)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/versioning/script/py.py",
line 145, in run
17:46:40 script_func(engine)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/nova/db/sqlalchemy/migrate_repo/versions/149_inet_datatype_for_postgres.py",
line 61, in upgrade
17:46:40 getattr(t.c, column).alter(type=String(39))
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/changeset/schema.py",
line 491, in alter
17:46:40 return alter_column(self, *p, **k)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/changeset/schema.py",
line 136, in alter_column
17:46:40 engine._run_visitor(visitorcallable, delta)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 2302, in _run_visitor
17:46:40 conn._run_visitor(visitorcallable, element, **kwargs)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 1972, in _run_visitor
17:46:40 **kwargs).traverse_single(element)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/changeset/ansisql.py",
line 53, in traverse_single
17:46:40 ret = super(AlterTableVisitor, self).traverse_single(elem)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/sql/visitors.py",
line 106, in traverse_single
17:46:40 return meth(obj, **kw)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/changeset/databases/mysql.py",
line 43, in visit_column
17:46:40 self.execute()
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/changeset/ansisql.py",
line 42, in execute
17:46:40 return self.connection.execute(self.buffer.getvalue())
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 1449, in execute
17:46:40 params)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 1628, in _execute_text
17:46:40 statement, parameters
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 1698, in _execute_context
17:46:40 context)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 1691, in _execute_context
17:46:40 context)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/default.py",
line 331, in do_execute
17:46:40 cursor.execute(statement, parameters)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/MySQLdb/cursors.py",
line 201, in execute
17:46:40 self.errorhandler(self, exc, value)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/MySQLdb/connections.py",
line 36, in defaulterrorhandler
17:46:40 raise errorclass, errorvalue
17:46:40 ProgrammingError: (ProgrammingError) (1146, "Table
'openstack_citest.networks' doesn't exist") '\nALTER TABLE networks CHANGE
COLUMN vpn_private_address vpn_private_address VARCHAR(39)' ()
17:46:40
======================================================================
17:46:40 ERROR: nova.tests.test_migrations.TestMigrations.test_mysql_innodb
17:46:40 tags: worker-0
17:46:40
----------------------------------------------------------------------
17:46:40 Empty attachments:
17:46:40 pythonlogging:'nova'
17:46:40 stderr
17:46:40 stdout
17:46:40
17:46:40 Traceback (most recent call last):
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/nova/tests/test_migrations.py",
line 238, in test_mysql_innodb
17:46:40 self._walk_versions(engine, False, False)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/nova/tests/test_migrations.py",
line 361, in _walk_versions
17:46:40 TestMigrations.REPOSITORY))
17:46:40 File "<string>", line 2, in db_version
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/nova/db/sqlalchemy/migration.py",
line 43, in patched_with_engine
17:46:40 return f(*a, **kw)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/versioning/api.py",
line 148, in db_version
17:46:40 schema = ControlledSchema(engine, repository)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/versioning/schema.py",
line 32, in __init__
17:46:40 self.load()
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/migrate/versioning/schema.py",
line 44, in load
17:46:40 self.table = Table(tname, self.meta, autoload=True)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/schema.py",
line 318, in __new__
17:46:40 table._init(name, metadata, *args, **kw)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/schema.py",
line 381, in _init
17:46:40 self._autoload(metadata, autoload_with, include_columns)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/schema.py",
line 408, in _autoload
17:46:40 self, include_columns, exclude_columns
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 2425, in run_callable
17:46:40 return conn.run_callable(callable_, *args, **kwargs)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 1968, in run_callable
17:46:40 return callable_(self, *args, **kwargs)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/default.py",
line 260, in reflecttable
17:46:40 return insp.reflecttable(table, include_columns, exclude_columns)
17:46:40 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/reflection.py",
line 350, in reflecttable
17:46:40 tbl_opts = self.get_table_options(table_name, schema,
**table.kwargs)
17:47:45 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/reflection.py",
line 178, in get_table_options
17:47:45 **kw)
17:47:45 File "<string>", line 1, in <lambda>
17:47:45 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/reflection.py",
line 47, in cache
17:47:45 ret = fn(self, con, *args, **kw)
17:47:45 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/dialects/mysql/base.py",
line 2064, in get_table_options
17:47:45 parsed_state = self._parsed_state_or_create(connection,
table_name, schema, **kw)
17:47:45 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/dialects/mysql/base.py",
line 2163, in _parsed_state_or_create
17:47:45 info_cache=kw.get('info_cache', None)
17:47:45 File "<string>", line 1, in <lambda>
17:47:45 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/reflection.py",
line 47, in cache
17:47:45 ret = fn(self, con, *args, **kw)
17:47:45 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/dialects/mysql/base.py",
line 2188, in _setup_parser
17:47:45 full_name=full_name)
17:47:45 File
"/home/jenkins/workspace/gate-nova-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/dialects/mysql/base.py",
line 2275, in _show_create_table
17:47:45 raise exc.NoSuchTableError(full_name)
17:47:45 DatabaseNotControlledError: `migrate_version`
17:47:45 Ran 4552 tests in 823.903s
17:47:45 FAILED (id=0, failures=2, skips=8)
17:47:45 error: testr failed (1)
17:47:45 ERROR: InvocationError:
'/home/jenkins/workspace/gate-nova-python26/.tox/py26/bin/python setup.py testr
--slowest --testr-args='
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1103088/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
