composer.blog.gcp-tech-blog.unit-test-dags-cloud-build.dags.example_dag_test: test_dag_import 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: 040bea8
buildURL: Build Status, Sponge
status: failed

Test output

Traceback (most recent call last):
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/dags/example_dag_test.py", line 26, in initalize_airflow_database
    airflow.utils.db.initdb()
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/airflow/utils/db.py", line 323, in initdb
    upgradedb()
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/airflow/utils/db.py", line 386, in upgradedb
    command.upgrade(config, 'heads')
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/alembic/command.py", line 294, in upgrade
    script.run_env()
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/alembic/script/base.py", line 490, in run_env
    util.load_python_file(self.dir, "env.py")
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 97, in load_python_file
    module = load_module_py(module_id, path)
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/alembic/util/compat.py", line 182, in load_module_py
    spec.loader.exec_module(module)
  File "", line 728, in exec_module
  File "", line 219, in _call_with_frames_removed
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/airflow/migrations/env.py", line 97, in 
    run_migrations_online()
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/airflow/migrations/env.py", line 91, in run_migrations_online
    context.run_migrations()
  File "", line 8, in run_migrations
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/alembic/runtime/environment.py", line 813, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/alembic/runtime/migration.py", line 567, in run_migrations
    head_maintainer.update_to_step(step)
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/alembic/runtime/migration.py", line 787, in update_to_step
    self._update_version(from_, to_)
  File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-7/lib/python3.7/site-packages/alembic/runtime/migration.py", line 741, in _update_version
    % (from_, to_, self.context.version_table, ret.rowcount)
alembic.util.exc.CommandError: Online migration expected to match one row when updating '08364691d074' to 'fe461863935f' in 'alembic_version'; 0 found

[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.

---

When run at the same commit (040bea8), this test passed in one build (Build Status, Sponge) and failed in another build (Build Status, Sponge).

[flaky-bot]

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/blog/gcp-tech-blog/unit-test-dags-cloud-build/.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/blog/gcp-tech-blog/unit-test-dags-cloud-build/.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: dag_tag
The above exception was the direct cause of the following exception:
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/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/airflow/utils/db.py", line 420, in resetdb

initdb(rbac)

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/airflow/utils/db.py", line 345, in initdb

dag.sync_to_db()

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/airflow/utils/db.py", line 74, in wrapper

return func(*args, **kwargs)

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/airflow/models/dag.py", line 1535, in sync_to_db

orm_dag.tags = self.get_dagtags(session=session)

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/airflow/utils/db.py", line 70, in wrapper

return func(*args, **kwargs)

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/airflow/models/dag.py", line 1568, in get_dagtags

tag = session.query(

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3429, in first

ret = list(self[0:1])

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3203, in getitem

return list(res)

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3535, in iter

return self._execute_and_instances(context)

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances

result = conn.execute(querycontext.statement, self._params)

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.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/blog/gcp-tech-blog/unit-test-dags-cloud-build/.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/blog/gcp-tech-blog/unit-test-dags-cloud-build/.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/blog/gcp-tech-blog/unit-test-dags-cloud-build/.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/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in handle_dbapi_exception

util.raise(

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.nox/py-3-8/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise

raise exception

File "/workspace/composer/blog/gcp-tech-blog/unit-test-dags-cloud-build/.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/blog/gcp-tech-blog/unit-test-dags-cloud-build/.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: dag_tag

[SQL: SELECT dag_tag.name AS dag_tag_name, dag_tag.dag_id AS dag_tag_dag_id

FROM dag_tag

WHERE dag_tag.name = ? AND dag_tag.dag_id = ?

LIMIT ? OFFSET ?]

[parameters: ('example', 'example_pig_operator', 1, 0)]

(Background on this error at: http://sqlalche.me/e/13/e3q8)

[leahecole]

I am bringing questions related to this to python office hours on Friday. I will see if it reopens between now and then.