Repository navigation
composer.workflows.unit_testing_test: test_dag_with_variables failed #5487
Description
This test failed!
To configure my behavior, see the Flaky Bot documentation.
If I'm commenting on this issue too often, add the flakybot: quiet label and
I will stop commenting.
commit: 455f574
buildURL: Build Status, Sponge
status: failed
Test output
Traceback (most recent call last):
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/base.py", line 171, in _catch_revision_errors
yield
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/base.py", line 365, in _upgrade_revs
revs = list(revs)
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/revision.py", line 904, in _iterate_revisions
requested_lowers = self.get_revisions(lower)
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/revision.py", line 455, in get_revisions
return sum([self.get_revisions(id_elem) for id_elem in id_], ())
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/revision.py", line 455, in
return sum([self.get_revisions(id_elem) for id_elem in id_], ())
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/revision.py", line 460, in get_revisions
for rev_id in resolved_id
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/revision.py", line 460, in
for rev_id in resolved_id
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/revision.py", line 536, in _revision_for_ident
resolved_id,
alembic.script.revision.ResolutionError: No such revision or branch '03afc6b6f902'
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/workspace/composer/workflows/conftest.py", line 22, in initalize_airflow_database
airflow.utils.db.initdb()
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/airflow/utils/db.py", line 323, in initdb
upgradedb()
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/airflow/utils/db.py", line 386, in upgradedb
command.upgrade(config, 'heads')
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/command.py", line 294, in upgrade
script.run_env()
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/base.py", line 490, in run_env
util.load_python_file(self.dir, "env.py")
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 97, in load_python_file
module = load_module_py(module_id, path)
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/util/compat.py", line 182, in load_module_py
spec.loader.exec_module(module)
File "", line 678, in exec_module
File "", line 219, in _call_with_frames_removed
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/airflow/migrations/env.py", line 97, in
run_migrations_online()
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/airflow/migrations/env.py", line 91, in run_migrations_online
context.run_migrations()
File "", line 8, in run_migrations
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/runtime/environment.py", line 813, in run_migrations
self.get_context().run_migrations(**kw)
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/runtime/migration.py", line 548, in run_migrations
for step in self._migrations_fn(heads, self):
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/command.py", line 283, in upgrade
return script.upgrade_revs(revision, rev)
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/base.py", line 370, in upgrade_revs
for script in reversed(list(revs))
File "/usr/local/lib/python3.6/contextlib.py", line 99, in exit
self.gen.throw(type, value, traceback)
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/script/base.py", line 203, in catch_revision_errors
compat.raise(util.CommandError(resolution), from=re)
File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/alembic/util/compat.py", line 294, in raise
raise exception
alembic.util.exc.CommandError: Can't locate revision identified by '03afc6b6f902'
Activity
flaky-bot commentedon Mar 7, 2021
Looks like this issue is flaky. 😟
I'm going to leave this open and stop commenting.
A human should fix and close this.
When run at the same commit (455f574), this test passed in one build (Build Status, Sponge) and failed in another build (Build Status, Sponge).
flaky-bot commentedon Mar 12, 2021
Oops! Looks like this issue is still flaky. It failed again. 😬
I reopened the issue, but a human will need to close it again.
commit: 5e139ba
buildURL: Build Status, Sponge
status: failed
Test output
Traceback (most recent call last): File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such table: variableThe above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/workspace/composer/workflows/unit_testing_test.py", line 24, in set_variables
models.Variable.set('gcp_project', 'example-project')
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/airflow/utils/db.py", line 74, in wrapper
return func(*args, **kwargs)
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/airflow/models/variable.py", line 139, in set
Variable.delete(key, session=session)
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/airflow/utils/db.py", line 70, in wrapper
return func(*args, **kwargs)
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/airflow/models/variable.py", line 146, in delete
session.query(cls).filter(cls.key == key).delete()
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3926, in delete
delete_op.exec_()
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py", line 1697, in exec_
self._do_exec()
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py", line 1930, in _do_exec
self._execute_stmt(delete_stmt)
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py", line 1702, in _execute_stmt
self.result = self.query._execute_crud(stmt, self.mapper)
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3568, in _execute_crud
return conn.execute(stmt, self._params)
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
ret = self._execute_context(
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
self.handle_dbapi_exception(
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in handle_dbapi_exception
util.raise(
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise
raise exception
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/workspace/composer/workflows/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: variable
[SQL: DELETE FROM variable WHERE variable."key" = ?]
[parameters: ('gcp_project',)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)