yahoo-eng-team team mailing list archive

Thread
Date
[Bug 2019802] [NEW] [master] Not all fullstack tests running in CI

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: yatin <2019802@xxxxxxxxxxxxxxxxxx>
Date: Tue, 16 May 2023 08:52:39 -0000
Reply-to: Bug 2019802 <2019802@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx
Public bug reported:

>From last couple of days Only few tests(just 6 tests) are running in job
neutron-fullstack-with-uwsgi job.

Example:-
https://d16311159baa9c9fc692-58e8a805a242f8a07eac2fd1c3f6b11b.ssl.cf1.rackcdn.com/880867/6/gate/neutron-
fullstack-with-uwsgi/6b4c3ba/testr_results.html

Builds:- https://zuul.opendev.org/t/openstack/builds?job_name=neutron-
fullstack-with-uwsgi&project=openstack%2Fneutron&branch=master&skip=0

The job logs have below Traceback:-
2023-05-16 06:18:13.539943 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron Traceback (most recent call last):
2023-05-16 06:18:13.539958 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
2023-05-16 06:18:13.539983 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.dialect.do_execute(
2023-05-16 06:18:13.539997 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
2023-05-16 06:18:13.540008 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     cursor.execute(statement, parameters)
2023-05-16 06:18:13.540021 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
2023-05-16 06:18:13.540032 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     result = self._query(query)
2023-05-16 06:18:13.540044 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
2023-05-16 06:18:13.540056 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     conn.query(q)
2023-05-16 06:18:13.540067 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
2023-05-16 06:18:13.540078 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2023-05-16 06:18:13.540090 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
2023-05-16 06:18:13.540118 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     result.read()
2023-05-16 06:18:13.540131 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read
2023-05-16 06:18:13.540143 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     first_packet = self.connection._read_packet()
2023-05-16 06:18:13.540154 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
2023-05-16 06:18:13.540165 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     packet.raise_for_error()
2023-05-16 06:18:13.540177 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
2023-05-16 06:18:13.540188 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     err.raise_mysql_exception(self._data)
2023-05-16 06:18:13.540199 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
2023-05-16 06:18:13.540210 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     raise errorclass(errno, errval)
2023-05-16 06:18:13.540221 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron pymysql.err.OperationalError: (1049, "Unknown database 'ybptypesko'")
2023-05-16 06:18:13.540233 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron
2023-05-16 06:18:13.540244 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron The above exception was the direct cause of the following exception:
2023-05-16 06:18:13.540255 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron
2023-05-16 06:18:13.540266 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron Traceback (most recent call last):
2023-05-16 06:18:13.540277 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/usr/lib/python3.10/runpy.py", line 196, in _run_module_as_main
2023-05-16 06:18:13.540287 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return _run_code(code, main_globals, None,
2023-05-16 06:18:13.540298 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/usr/lib/python3.10/runpy.py", line 86, in _run_code
2023-05-16 06:18:13.540309 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     exec(code, run_globals)
2023-05-16 06:18:13.540325 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/stestr/subunit_runner/run.py", line 93, in <module>
2023-05-16 06:18:13.540337 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     main()
2023-05-16 06:18:13.540361 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/stestr/subunit_runner/run.py", line 87, in main
2023-05-16 06:18:13.540373 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     program.TestProgram(
2023-05-16 06:18:13.540385 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/stestr/subunit_runner/program.py", line 185, in __init__
2023-05-16 06:18:13.540395 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.runTests()
2023-05-16 06:18:13.540406 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/stestr/subunit_runner/program.py", line 226, in runTests
2023-05-16 06:18:13.540417 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.result = testRunner.run(self.test)
2023-05-16 06:18:13.540428 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/stestr/subunit_runner/run.py", line 52, in run
2023-05-16 06:18:13.540447 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     test(result)
2023-05-16 06:18:13.540470 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/usr/lib/python3.10/unittest/suite.py", line 84, in __call__
2023-05-16 06:18:13.540494 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return self.run(*args, **kwds)
2023-05-16 06:18:13.540519 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/usr/lib/python3.10/unittest/suite.py", line 122, in run
2023-05-16 06:18:13.540542 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     test(result)
2023-05-16 06:18:13.540564 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/usr/lib/python3.10/unittest/suite.py", line 84, in __call__
2023-05-16 06:18:13.540587 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return self.run(*args, **kwds)
2023-05-16 06:18:13.540600 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/testresources/__init__.py", line 266, in run
2023-05-16 06:18:13.540611 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.switch(current_resources, new_resources, result)
2023-05-16 06:18:13.540623 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/testresources/__init__.py", line 254, in switch
2023-05-16 06:18:13.540647 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     resource.getResource(result)
2023-05-16 06:18:13.540660 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/testresources/__init__.py", line 522, in getResource
2023-05-16 06:18:13.540671 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._setResource(self._make_all(result))
2023-05-16 06:18:13.540682 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/testresources/__init__.py", line 552, in _make_all
2023-05-16 06:18:13.540693 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     resource = self.make(dependency_resources)
2023-05-16 06:18:13.540704 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/oslo_db/sqlalchemy/provision.py", line 179, in make
2023-05-16 06:18:13.540714 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.generate_schema(dependency_resources['database'].engine)
2023-05-16 06:18:13.540725 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/unit/testlib_api.py", line 115, in _generate_schema_w_migrations
2023-05-16 06:18:13.540742 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     migration.do_alembic_command(
2023-05-16 06:18:13.540754 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/neutron/db/migration/cli.py", line 90, in do_alembic_command
2023-05-16 06:18:13.540765 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     getattr(alembic_command, cmd)(config, *args, **kwargs)
2023-05-16 06:18:13.540776 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/command.py", line 378, in upgrade
2023-05-16 06:18:13.540787 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     script.run_env()
2023-05-16 06:18:13.540807 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/script/base.py", line 569, in run_env
2023-05-16 06:18:13.540820 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     util.load_python_file(self.dir, "env.py")
2023-05-16 06:18:13.540839 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
2023-05-16 06:18:13.540859 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     module = load_module_py(module_id, path)
2023-05-16 06:18:13.540871 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
2023-05-16 06:18:13.540884 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     spec.loader.exec_module(module)  # type: ignore
2023-05-16 06:18:13.540906 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "<frozen importlib._bootstrap_external>", line 883, in exec_module
2023-05-16 06:18:13.540929 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
2023-05-16 06:18:13.540955 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/neutron/db/migration/alembic_migrations/env.py", line 130, in <module>
2023-05-16 06:18:13.540983 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     run_migrations_online()
2023-05-16 06:18:13.541000 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/neutron/db/migration/alembic_migrations/env.py", line 124, in run_migrations_online
2023-05-16 06:18:13.541011 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     context.run_migrations()
2023-05-16 06:18:13.541023 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "<string>", line 8, in run_migrations
2023-05-16 06:18:13.541034 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/runtime/environment.py", line 867, in run_migrations
2023-05-16 06:18:13.541046 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.get_context().run_migrations(**kw)
2023-05-16 06:18:13.541057 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/runtime/migration.py", line 606, in run_migrations
2023-05-16 06:18:13.541068 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._ensure_version_table()
2023-05-16 06:18:13.541079 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/runtime/migration.py", line 544, in _ensure_version_table
2023-05-16 06:18:13.541090 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._version.create(self.connection, checkfirst=True)
2023-05-16 06:18:13.541102 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 960, in create
2023-05-16 06:18:13.541124 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst)
2023-05-16 06:18:13.541161 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2211, in _run_ddl_visitor
2023-05-16 06:18:13.541184 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
2023-05-16 06:18:13.541197 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/sql/visitors.py", line 524, in traverse_single
2023-05-16 06:18:13.541208 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return meth(obj, **kw)
2023-05-16 06:18:13.541220 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line 895, in visit_table
2023-05-16 06:18:13.541238 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.connection.execute(
2023-05-16 06:18:13.541250 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1380, in execute
2023-05-16 06:18:13.541261 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
2023-05-16 06:18:13.541272 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line 80, in _execute_on_connection
2023-05-16 06:18:13.541283 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return connection._execute_ddl(
2023-05-16 06:18:13.541302 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1472, in _execute_ddl
2023-05-16 06:18:13.541315 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     ret = self._execute_context(
2023-05-16 06:18:13.541326 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
2023-05-16 06:18:13.541342 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._handle_dbapi_exception(
2023-05-16 06:18:13.541354 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception
2023-05-16 06:18:13.541365 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     util.raise_(newraise, with_traceback=exc_info[2], from_=e)
2023-05-16 06:18:13.541376 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
2023-05-16 06:18:13.541387 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     raise exception
2023-05-16 06:18:13.541397 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
2023-05-16 06:18:13.541408 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.dialect.do_execute(
2023-05-16 06:18:13.541419 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
2023-05-16 06:18:13.541430 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     cursor.execute(statement, parameters)
2023-05-16 06:18:13.541441 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
2023-05-16 06:18:13.541451 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     result = self._query(query)
2023-05-16 06:18:13.541462 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
2023-05-16 06:18:13.541473 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     conn.query(q)
2023-05-16 06:18:13.541483 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
2023-05-16 06:18:13.541494 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2023-05-16 06:18:13.541505 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
2023-05-16 06:18:13.541522 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     result.read()
2023-05-16 06:18:13.541534 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read
2023-05-16 06:18:13.541544 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     first_packet = self.connection._read_packet()
2023-05-16 06:18:13.541555 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
2023-05-16 06:18:13.541566 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     packet.raise_for_error()
2023-05-16 06:18:13.541577 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
2023-05-16 06:18:13.541588 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     err.raise_mysql_exception(self._data)
2023-05-16 06:18:13.541604 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
2023-05-16 06:18:13.541615 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     raise errorclass(errno, errval)
2023-05-16 06:18:13.541632 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron oslo_db.exception.DBNonExistentDatabase: (pymysql.err.OperationalError) (1049, "Unknown database 'ybptypesko'")
2023-05-16 06:18:13.541644 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron [SQL:
2023-05-16 06:18:13.541655 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron CREATE TABLE alembic_version (
2023-05-16 06:18:13.541666 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron 	version_num VARCHAR(32) NOT NULL,
2023-05-16 06:18:13.541679 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron 	CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num)
2023-05-16 06:18:13.541700 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron )ENGINE=InnoDB
2023-05-16 06:18:13.541722 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron
2023-05-16 06:18:13.541745 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron ]
2023-05-16 06:18:13.541765 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron (Background on this error at: https://sqlalche.me/e/14/e3q8)
2023-05-16 06:18:13.541779 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron

https://review.opendev.org/c/openstack/neutron/+/880867 seems to have
trigerred it.

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/2019802

Title:
  [master] Not all fullstack tests running in CI

Status in neutron:
  New

Bug description:
  From last couple of days Only few tests(just 6 tests) are running in
  job neutron-fullstack-with-uwsgi job.

  Example:-
  https://d16311159baa9c9fc692-58e8a805a242f8a07eac2fd1c3f6b11b.ssl.cf1.rackcdn.com/880867/6/gate/neutron-
  fullstack-with-uwsgi/6b4c3ba/testr_results.html

  Builds:- https://zuul.opendev.org/t/openstack/builds?job_name=neutron-
  fullstack-with-uwsgi&project=openstack%2Fneutron&branch=master&skip=0

  The job logs have below Traceback:-
  2023-05-16 06:18:13.539943 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron Traceback (most recent call last):
  2023-05-16 06:18:13.539958 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
  2023-05-16 06:18:13.539983 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.dialect.do_execute(
  2023-05-16 06:18:13.539997 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
  2023-05-16 06:18:13.540008 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     cursor.execute(statement, parameters)
  2023-05-16 06:18:13.540021 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
  2023-05-16 06:18:13.540032 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     result = self._query(query)
  2023-05-16 06:18:13.540044 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
  2023-05-16 06:18:13.540056 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     conn.query(q)
  2023-05-16 06:18:13.540067 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
  2023-05-16 06:18:13.540078 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2023-05-16 06:18:13.540090 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
  2023-05-16 06:18:13.540118 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     result.read()
  2023-05-16 06:18:13.540131 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read
  2023-05-16 06:18:13.540143 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     first_packet = self.connection._read_packet()
  2023-05-16 06:18:13.540154 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
  2023-05-16 06:18:13.540165 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     packet.raise_for_error()
  2023-05-16 06:18:13.540177 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
  2023-05-16 06:18:13.540188 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     err.raise_mysql_exception(self._data)
  2023-05-16 06:18:13.540199 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
  2023-05-16 06:18:13.540210 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     raise errorclass(errno, errval)
  2023-05-16 06:18:13.540221 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron pymysql.err.OperationalError: (1049, "Unknown database 'ybptypesko'")
  2023-05-16 06:18:13.540233 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron
  2023-05-16 06:18:13.540244 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron The above exception was the direct cause of the following exception:
  2023-05-16 06:18:13.540255 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron
  2023-05-16 06:18:13.540266 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron Traceback (most recent call last):
  2023-05-16 06:18:13.540277 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/usr/lib/python3.10/runpy.py", line 196, in _run_module_as_main
  2023-05-16 06:18:13.540287 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return _run_code(code, main_globals, None,
  2023-05-16 06:18:13.540298 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/usr/lib/python3.10/runpy.py", line 86, in _run_code
  2023-05-16 06:18:13.540309 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     exec(code, run_globals)
  2023-05-16 06:18:13.540325 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/stestr/subunit_runner/run.py", line 93, in <module>
  2023-05-16 06:18:13.540337 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     main()
  2023-05-16 06:18:13.540361 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/stestr/subunit_runner/run.py", line 87, in main
  2023-05-16 06:18:13.540373 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     program.TestProgram(
  2023-05-16 06:18:13.540385 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/stestr/subunit_runner/program.py", line 185, in __init__
  2023-05-16 06:18:13.540395 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.runTests()
  2023-05-16 06:18:13.540406 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/stestr/subunit_runner/program.py", line 226, in runTests
  2023-05-16 06:18:13.540417 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.result = testRunner.run(self.test)
  2023-05-16 06:18:13.540428 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/stestr/subunit_runner/run.py", line 52, in run
  2023-05-16 06:18:13.540447 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     test(result)
  2023-05-16 06:18:13.540470 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/usr/lib/python3.10/unittest/suite.py", line 84, in __call__
  2023-05-16 06:18:13.540494 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return self.run(*args, **kwds)
  2023-05-16 06:18:13.540519 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/usr/lib/python3.10/unittest/suite.py", line 122, in run
  2023-05-16 06:18:13.540542 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     test(result)
  2023-05-16 06:18:13.540564 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/usr/lib/python3.10/unittest/suite.py", line 84, in __call__
  2023-05-16 06:18:13.540587 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return self.run(*args, **kwds)
  2023-05-16 06:18:13.540600 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/testresources/__init__.py", line 266, in run
  2023-05-16 06:18:13.540611 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.switch(current_resources, new_resources, result)
  2023-05-16 06:18:13.540623 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/testresources/__init__.py", line 254, in switch
  2023-05-16 06:18:13.540647 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     resource.getResource(result)
  2023-05-16 06:18:13.540660 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/testresources/__init__.py", line 522, in getResource
  2023-05-16 06:18:13.540671 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._setResource(self._make_all(result))
  2023-05-16 06:18:13.540682 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/testresources/__init__.py", line 552, in _make_all
  2023-05-16 06:18:13.540693 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     resource = self.make(dependency_resources)
  2023-05-16 06:18:13.540704 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/oslo_db/sqlalchemy/provision.py", line 179, in make
  2023-05-16 06:18:13.540714 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.generate_schema(dependency_resources['database'].engine)
  2023-05-16 06:18:13.540725 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/unit/testlib_api.py", line 115, in _generate_schema_w_migrations
  2023-05-16 06:18:13.540742 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     migration.do_alembic_command(
  2023-05-16 06:18:13.540754 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/neutron/db/migration/cli.py", line 90, in do_alembic_command
  2023-05-16 06:18:13.540765 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     getattr(alembic_command, cmd)(config, *args, **kwargs)
  2023-05-16 06:18:13.540776 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/command.py", line 378, in upgrade
  2023-05-16 06:18:13.540787 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     script.run_env()
  2023-05-16 06:18:13.540807 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/script/base.py", line 569, in run_env
  2023-05-16 06:18:13.540820 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     util.load_python_file(self.dir, "env.py")
  2023-05-16 06:18:13.540839 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
  2023-05-16 06:18:13.540859 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     module = load_module_py(module_id, path)
  2023-05-16 06:18:13.540871 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
  2023-05-16 06:18:13.540884 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     spec.loader.exec_module(module)  # type: ignore
  2023-05-16 06:18:13.540906 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "<frozen importlib._bootstrap_external>", line 883, in exec_module
  2023-05-16 06:18:13.540929 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  2023-05-16 06:18:13.540955 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/neutron/db/migration/alembic_migrations/env.py", line 130, in <module>
  2023-05-16 06:18:13.540983 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     run_migrations_online()
  2023-05-16 06:18:13.541000 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/neutron/db/migration/alembic_migrations/env.py", line 124, in run_migrations_online
  2023-05-16 06:18:13.541011 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     context.run_migrations()
  2023-05-16 06:18:13.541023 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "<string>", line 8, in run_migrations
  2023-05-16 06:18:13.541034 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/runtime/environment.py", line 867, in run_migrations
  2023-05-16 06:18:13.541046 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.get_context().run_migrations(**kw)
  2023-05-16 06:18:13.541057 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/runtime/migration.py", line 606, in run_migrations
  2023-05-16 06:18:13.541068 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._ensure_version_table()
  2023-05-16 06:18:13.541079 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/alembic/runtime/migration.py", line 544, in _ensure_version_table
  2023-05-16 06:18:13.541090 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._version.create(self.connection, checkfirst=True)
  2023-05-16 06:18:13.541102 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 960, in create
  2023-05-16 06:18:13.541124 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst)
  2023-05-16 06:18:13.541161 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2211, in _run_ddl_visitor
  2023-05-16 06:18:13.541184 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  2023-05-16 06:18:13.541197 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/sql/visitors.py", line 524, in traverse_single
  2023-05-16 06:18:13.541208 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return meth(obj, **kw)
  2023-05-16 06:18:13.541220 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line 895, in visit_table
  2023-05-16 06:18:13.541238 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.connection.execute(
  2023-05-16 06:18:13.541250 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1380, in execute
  2023-05-16 06:18:13.541261 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
  2023-05-16 06:18:13.541272 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line 80, in _execute_on_connection
  2023-05-16 06:18:13.541283 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     return connection._execute_ddl(
  2023-05-16 06:18:13.541302 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1472, in _execute_ddl
  2023-05-16 06:18:13.541315 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     ret = self._execute_context(
  2023-05-16 06:18:13.541326 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
  2023-05-16 06:18:13.541342 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._handle_dbapi_exception(
  2023-05-16 06:18:13.541354 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception
  2023-05-16 06:18:13.541365 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     util.raise_(newraise, with_traceback=exc_info[2], from_=e)
  2023-05-16 06:18:13.541376 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
  2023-05-16 06:18:13.541387 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     raise exception
  2023-05-16 06:18:13.541397 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
  2023-05-16 06:18:13.541408 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self.dialect.do_execute(
  2023-05-16 06:18:13.541419 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
  2023-05-16 06:18:13.541430 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     cursor.execute(statement, parameters)
  2023-05-16 06:18:13.541441 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
  2023-05-16 06:18:13.541451 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     result = self._query(query)
  2023-05-16 06:18:13.541462 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
  2023-05-16 06:18:13.541473 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     conn.query(q)
  2023-05-16 06:18:13.541483 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
  2023-05-16 06:18:13.541494 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2023-05-16 06:18:13.541505 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
  2023-05-16 06:18:13.541522 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     result.read()
  2023-05-16 06:18:13.541534 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read
  2023-05-16 06:18:13.541544 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     first_packet = self.connection._read_packet()
  2023-05-16 06:18:13.541555 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
  2023-05-16 06:18:13.541566 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     packet.raise_for_error()
  2023-05-16 06:18:13.541577 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
  2023-05-16 06:18:13.541588 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     err.raise_mysql_exception(self._data)
  2023-05-16 06:18:13.541604 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron   File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-fullstack-gate/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
  2023-05-16 06:18:13.541615 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron     raise errorclass(errno, errval)
  2023-05-16 06:18:13.541632 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron oslo_db.exception.DBNonExistentDatabase: (pymysql.err.OperationalError) (1049, "Unknown database 'ybptypesko'")
  2023-05-16 06:18:13.541644 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron [SQL:
  2023-05-16 06:18:13.541655 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron CREATE TABLE alembic_version (
  2023-05-16 06:18:13.541666 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron 	version_num VARCHAR(32) NOT NULL,
  2023-05-16 06:18:13.541679 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron 	CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num)
  2023-05-16 06:18:13.541700 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron )ENGINE=InnoDB
  2023-05-16 06:18:13.541722 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron
  2023-05-16 06:18:13.541745 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron ]
  2023-05-16 06:18:13.541765 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron (Background on this error at: https://sqlalche.me/e/14/e3q8)
  2023-05-16 06:18:13.541779 | controller | 2023-05-16 06:18:13.529 15888 ERROR neutron

  https://review.opendev.org/c/openstack/neutron/+/880867 seems to have
  trigerred it.

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/2019802/+subscriptions
Follow ups

[Bug 2019802] Re: [master] Not all fullstack tests running in CI
From: Rodolfo Alonso, 2024-02-19