composer.workflows.bq_copy_across_locations_test: test_dag failed

[flaky-bot]

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'

[flaky-bot]

commit: beb1de1
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'

[flaky-bot]

commit: 040bea8
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'

[flaky-bot]

Looks like this issue is flaky. 😟

I'm going to leave this open and stop commenting.

A human should fix and close this.

---

commit: 6560ce4
buildURL: Build Status, Sponge
status: failed

Test output

Traceback (most recent call last):
  File "/workspace/composer/conftest.py", line 25, in airflow_database
    airflow.utils.db.resetdb(rbac=None)  # this command will change in Airflow 2.0
  File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/airflow/utils/db.py", line 397, in resetdb
    from airflow.models.serialized_dag import SerializedDagModel  # noqa: F401
  File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/airflow/models/serialized_dag.py", line 35, in 
    from airflow.serialization.serialized_objects import SerializedDAG
  File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/airflow/serialization/serialized_objects.py", line 40, in 
    from airflow.www.utils import get_python_source
  File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/airflow/www/utils.py", line 40, in 
    import flask_admin.contrib.sqla.filters as sqlafilters
  File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/flask_admin/contrib/sqla/__init__.py", line 2, in 
    from .view import ModelView
  File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/flask_admin/contrib/sqla/view.py", line 18, in 
    from flask_admin.contrib.sqla.tools import is_relationship
  File "/workspace/composer/workflows/.nox/py-3-6/lib/python3.6/site-packages/flask_admin/contrib/sqla/tools.py", line 4, in 
    from sqlalchemy.ext.declarative.clsregistry import _class_resolver
ModuleNotFoundError: No module named 'sqlalchemy.ext.declarative.clsregistry'