Comment 6 for bug 1793364

Revision history for this message
Matt Riedemann (mriedem) wrote :

I'm seeing something slightly different here:

http://logs.openstack.org/27/619527/16/check/openstack-tox-lower-constraints/e5a44b6/job-output.txt.gz#_2019-02-08_17_51_33_170751

2019-02-08 17:51:33.170751 | ubuntu-xenial | {4} nova.tests.unit.db.test_migrations.TestNovaMigrationsMySQL.test_models_sync [640.323899s] ... FAILED
2019-02-08 17:51:33.171097 | ubuntu-xenial |
2019-02-08 17:51:33.171163 | ubuntu-xenial | Captured pythonlogging:
2019-02-08 17:51:33.171216 | ubuntu-xenial | ~~~~~~~~~~~~~~~~~~~~~~~
2019-02-08 17:51:33.171340 | ubuntu-xenial | b'2019-02-08 17:46:18,217 INFO [248_add_expire_reservations_index] Skipped adding reservations_deleted_expire_idx because an equivalent index already exists.'
2019-02-08 17:51:33.171423 | ubuntu-xenial | b'2019-02-08 17:50:49,519 INFO [alembic.runtime.migration] Context impl MySQLImpl.'
2019-02-08 17:51:33.171510 | ubuntu-xenial | b'2019-02-08 17:50:49,520 INFO [alembic.runtime.migration] Will assume non-transactional DDL.'
2019-02-08 17:51:33.171595 | ubuntu-xenial | b"2019-02-08 17:50:54,151 INFO [alembic.autogenerate.compare] Detected removed column 'instances.internal_id'"
2019-02-08 17:51:33.171630 | ubuntu-xenial | b''
2019-02-08 17:51:33.171658 | ubuntu-xenial |
2019-02-08 17:51:33.171692 | ubuntu-xenial | Captured pythonlogging:
2019-02-08 17:51:33.171723 | ubuntu-xenial | ~~~~~~~~~~~~~~~~~~~~~~~
2019-02-08 17:51:33.171831 | ubuntu-xenial | b'2019-02-08 17:40:52,805 INFO [oslo_db.sqlalchemy.provision] CREATE BACKEND mysql+pymysql://openstack_citest:openstack_citest@localhost/ TOKEN skjgipbrzl'
2019-02-08 17:51:33.171948 | ubuntu-xenial | b'2019-02-08 17:51:32,901 INFO [oslo_db.sqlalchemy.provision] DROP ALL OBJECTS, BACKEND mysql+pymysql://openstack_citest:openstack_citest@localhost/skjgipbrzl'
2019-02-08 17:51:33.171979 | ubuntu-xenial | b''
2019-02-08 17:51:33.172000 | ubuntu-xenial |
2019-02-08 17:51:33.172036 | ubuntu-xenial | Captured traceback-1:
2019-02-08 17:51:33.172075 | ubuntu-xenial | ~~~~~~~~~~~~~~~~~~~~~
2019-02-08 17:51:33.172119 | ubuntu-xenial | b'Traceback (most recent call last):'
2019-02-08 17:51:33.172263 | ubuntu-xenial | b' File "/home/zuul/src/git.openstack.org/openstack/nova/.tox/lower-constraints/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context'
2019-02-08 17:51:33.172345 | ubuntu-xenial | b' cursor, statement, parameters, context'
2019-02-08 17:51:33.172477 | ubuntu-xenial | b' File "/home/zuul/src/git.openstack.org/openstack/nova/.tox/lower-constraints/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute'
2019-02-08 17:51:33.172526 | ubuntu-xenial | b' cursor.execute(statement, parameters)'
2019-02-08 17:51:33.172631 | ubuntu-xenial | b' File "/home/zuul/src/git.openstack.org/openstack/nova/.tox/lower-constraints/lib/python3.5/site-packages/pymysql/cursors.py", line 170, in execute'
2019-02-08 17:51:33.172679 | ubuntu-xenial | b' result = self._query(query)'
2019-02-08 17:51:33.172786 | ubuntu-xenial | b' File "/home/zuul/src/git.openstack.org/openstack/nova/.tox/lower-constraints/lib/python3.5/site-packages/pymysql/cursors.py", line 328, in _query'
2019-02-08 17:51:33.172818 | ubuntu-xenial | b' conn.query(q)'
2019-02-08 17:51:33.172923 | ubuntu-xenial | b' File "/home/zuul/src/git.openstack.org/openstack/nova/.tox/lower-constraints/lib/python3.5/site-packages/pymysql/connections.py", line 517, in query'
2019-02-08 17:51:33.172985 | ubuntu-xenial | b' self._affected_rows = self._read_query_result(unbuffered=unbuffered)'
2019-02-08 17:51:33.173124 | ubuntu-xenial | b' File "/home/zuul/src/git.openstack.org/openstack/nova/.tox/lower-constraints/lib/python3.5/site-packages/pymysql/connections.py", line 732, in _read_query_result'
2019-02-08 17:51:33.173162 | ubuntu-xenial | b' result.read()'
2019-02-08 17:51:33.173268 | ubuntu-xenial | b' File "/home/zuul/src/git.openstack.org/openstack/nova/.tox/lower-constraints/lib/python3.5/site-packages/pymysql/connections.py", line 1075, in read'
2019-02-08 17:51:33.173318 | ubuntu-xenial | b' first_packet = self.connection._read_packet()'
2019-02-08 17:51:33.173427 | ubuntu-xenial | b' File "/home/zuul/src/git.openstack.org/openstack/nova/.tox/lower-constraints/lib/python3.5/site-packages/pymysql/connections.py", line 684, in _read_packet'
2019-02-08 17:51:33.173475 | ubuntu-xenial | b' packet.check_error()'
2019-02-08 17:51:33.173595 | ubuntu-xenial | b' File "/home/zuul/src/git.openstack.org/openstack/nova/.tox/lower-constraints/lib/python3.5/site-packages/pymysql/protocol.py", line 220, in check_error'
2019-02-08 17:51:33.173643 | ubuntu-xenial | b' err.raise_mysql_exception(self._data)'
2019-02-08 17:51:33.173752 | ubuntu-xenial | b' File "/home/zuul/src/git.openstack.org/openstack/nova/.tox/lower-constraints/lib/python3.5/site-packages/pymysql/err.py", line 109, in raise_mysql_exception'
2019-02-08 17:51:33.173794 | ubuntu-xenial | b' raise errorclass(errno, errval)'
2019-02-08 17:51:33.173885 | ubuntu-xenial | b'pymysql.err.ProgrammingError: (1146, "Table \'skjgipbrzl.shadow_reservations\' doesn\'t exist")'