yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1103088] Re: Build failed on database migration tests

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Vish Ishaya <vishvananda@xxxxxxxxx>
Date: Tue, 26 Feb 2013 22:57:37 -0000
Reply-to: Bug 1103088 <1103088@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
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