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")'
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 .TestNovaMigrat ionsMySQL. test_models_ sync [640.323899s] ... FAILED ~~~~~~~ ~~~~~~~ ~~ expire_ reservations_ index] Skipped adding reservations_ deleted_ expire_ idx because an equivalent index already exists.' runtime. migration] Context impl MySQLImpl.' runtime. migration] Will assume non-transactional DDL.' autogenerate. compare] Detected removed column 'instances. internal_ id'" ~~~~~~~ ~~~~~~~ ~~ sqlalchemy. provision] CREATE BACKEND mysql+pymysql: //openstack_ citest: openstack_ citest@ localhost/ TOKEN skjgipbrzl' sqlalchemy. provision] DROP ALL OBJECTS, BACKEND mysql+pymysql: //openstack_ citest: openstack_ citest@ localhost/ skjgipbrzl' ~~~~~~~ ~~~~~~~ zuul/src/ git.openstack. org/openstack/ nova/.tox/ lower-constrain ts/lib/ python3. 5/site- packages/ sqlalchemy/ engine/ base.py" , line 1236, in _execute_context' zuul/src/ git.openstack. org/openstack/ nova/.tox/ lower-constrain ts/lib/ python3. 5/site- packages/ sqlalchemy/ engine/ default. py", line 536, in do_execute' execute( statement, parameters)' zuul/src/ git.openstack. org/openstack/ nova/.tox/ lower-constrain ts/lib/ python3. 5/site- packages/ pymysql/ cursors. py", line 170, in execute' zuul/src/ git.openstack. org/openstack/ nova/.tox/ lower-constrain ts/lib/ python3. 5/site- packages/ pymysql/ cursors. py", line 328, in _query' zuul/src/ git.openstack. org/openstack/ nova/.tox/ lower-constrain ts/lib/ python3. 5/site- packages/ pymysql/ connections. py", line 517, in query' query_result( unbuffered= unbuffered) ' zuul/src/ git.openstack. org/openstack/ nova/.tox/ lower-constrain ts/lib/ python3. 5/site- packages/ pymysql/ connections. py", line 732, in _read_query_result' zuul/src/ git.openstack. org/openstack/ nova/.tox/ lower-constrain ts/lib/ python3. 5/site- packages/ pymysql/ connections. py", line 1075, in read' ._read_ packet( )' zuul/src/ git.openstack. org/openstack/ nova/.tox/ lower-constrain ts/lib/ python3. 5/site- packages/ pymysql/ connections. py", line 684, in _read_packet' check_error( )' zuul/src/ git.openstack. org/openstack/ nova/.tox/ lower-constrain ts/lib/ python3. 5/site- packages/ pymysql/ protocol. py", line 220, in check_error' mysql_exception (self._ data)' zuul/src/ git.openstack. org/openstack/ nova/.tox/ lower-constrain ts/lib/ python3. 5/site- packages/ pymysql/ err.py" , line 109, in raise_mysql_ exception' err.Programming Error: (1146, "Table \'skjgipbrzl. shadow_ reservations\ ' doesn\'t exist")'
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_
2019-02-08 17:51:33.171423 | ubuntu-xenial | b'2019-02-08 17:50:49,519 INFO [alembic.
2019-02-08 17:51:33.171510 | ubuntu-xenial | b'2019-02-08 17:50:49,520 INFO [alembic.
2019-02-08 17:51:33.171595 | ubuntu-xenial | b"2019-02-08 17:50:54,151 INFO [alembic.
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.
2019-02-08 17:51:33.171948 | ubuntu-xenial | b'2019-02-08 17:51:32,901 INFO [oslo_db.
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/
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/
2019-02-08 17:51:33.172526 | ubuntu-xenial | b' cursor.
2019-02-08 17:51:33.172631 | ubuntu-xenial | b' File "/home/
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/
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/
2019-02-08 17:51:33.172985 | ubuntu-xenial | b' self._affected_rows = self._read_
2019-02-08 17:51:33.173124 | ubuntu-xenial | b' File "/home/
2019-02-08 17:51:33.173162 | ubuntu-xenial | b' result.read()'
2019-02-08 17:51:33.173268 | ubuntu-xenial | b' File "/home/
2019-02-08 17:51:33.173318 | ubuntu-xenial | b' first_packet = self.connection
2019-02-08 17:51:33.173427 | ubuntu-xenial | b' File "/home/
2019-02-08 17:51:33.173475 | ubuntu-xenial | b' packet.
2019-02-08 17:51:33.173595 | ubuntu-xenial | b' File "/home/
2019-02-08 17:51:33.173643 | ubuntu-xenial | b' err.raise_
2019-02-08 17:51:33.173752 | ubuntu-xenial | b' File "/home/
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.