neutron

[master] Not all fullstack tests running in CI

Bug #2019802 reported by yatin on 2023-05-16

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	neutron	Fix Released	Critical	Unassigned

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.

Tags:

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2023-05-16: Related fix proposed to neutron (master)

Related fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/neutron/+/883120

Lajos Katona (lajos-katona) on 2023-05-16

tags:

added: db gate-failure

Elvira García Ruiz (elviragr) on 2023-05-17

Changed in neutron:
importance:	Undecided → Critical

Elvira García Ruiz (elviragr) on 2023-05-17

tags:	added: fullstack
Changed in neutron:
status:	New → Confirmed

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2023-05-22: Related fix merged to neutron (master)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/883120
Committed: https://opendev.org/openstack/neutron/commit/452973c0dba6c2f1dfce02bd7dce514c8350a846
Submitter: "Zuul (22348)"
Branch: master

commit 452973c0dba6c2f1dfce02bd7dce514c8350a846
Author: yatin <email address hidden>
Date: Tue May 16 08:54:06 2023 +0000

Revert "Use a writer context for the online alembic migrations"

This reverts commit 82029c2c514aaca5b9d45af46d2f7d945ff3099b.

Reason for revert: fullstack tests broken with this.

    Change-Id: Ibd75c3526a3a8c4138c5f266448299786ccbf045
    Related-Bug: #2019802
    Related-Bug: #2015847

Revision history for this message

Rodolfo Alonso (rodolfo-alonso-hernandez) wrote on 2023-05-23:

With [1], the CI is now executing again all the fullstack tests. The patch that was reverted tried to fix LP#2015847 but is now fixed in [2].

We can consider this LP bug as fixed.

[1]https://review.opendev.org/c/openstack/neutron/+/883120
[2]https://review.opendev.org/c/openstack/neutron/+/883287

Changed in neutron:
status:	Confirmed → Fix Committed

Rodolfo Alonso (rodolfo-alonso-hernandez) on 2024-02-19

Changed in neutron:
status:	Fix Committed → Fix Released

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.