Skip to content

Instantly share code, notes, and snippets.

@ryanditjia
Last active September 10, 2020 11:15
Show Gist options
  • Save ryanditjia/d0fd1ba5294b1c7af0912a431687d26a to your computer and use it in GitHub Desktop.
Save ryanditjia/d0fd1ba5294b1c7af0912a431687d26a to your computer and use it in GitHub Desktop.
Error Airflow
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
INFO [alembic.runtime.migration] Running upgrade cc1e65623dc7 -> bdaa763e6c56, Make xcom value column a large binary
INFO [alembic.runtime.migration] Running upgrade bdaa763e6c56 -> 947454bf1dff, add ti job_id index
INFO [alembic.runtime.migration] Running upgrade 947454bf1dff -> d2ae31099d61, Increase text size for MySQL (not relevant for other DBs' text types)
INFO [alembic.runtime.migration] Running upgrade d2ae31099d61 -> 0e2a74e0fc9f, Add time zone awareness
INFO [alembic.runtime.migration] Running upgrade d2ae31099d61 -> 33ae817a1ff4, kubernetes_resource_checkpointing
INFO [alembic.runtime.migration] Running upgrade 33ae817a1ff4 -> 27c6a30d7c24, kubernetes_resource_checkpointing
INFO [alembic.runtime.migration] Running upgrade 27c6a30d7c24 -> 86770d1215c0, add kubernetes scheduler uniqueness
INFO [alembic.runtime.migration] Running upgrade 86770d1215c0, 0e2a74e0fc9f -> 05f30312d566, merge heads
INFO [alembic.runtime.migration] Running upgrade 05f30312d566 -> f23433877c24, fix mysql not null constraint
INFO [alembic.runtime.migration] Running upgrade f23433877c24 -> 856955da8476, fix sqlite foreign key
INFO [alembic.runtime.migration] Running upgrade 856955da8476 -> 9635ae0956e7, index-faskfail
INFO [alembic.runtime.migration] Running upgrade 9635ae0956e7 -> dd25f486b8ea, add idx_log_dag
INFO [alembic.runtime.migration] Running upgrade dd25f486b8ea -> bf00311e1990, add index to taskinstance
INFO [alembic.runtime.migration] Running upgrade 9635ae0956e7 -> 0a2a5b66e19d, add task_reschedule table
INFO [alembic.runtime.migration] Running upgrade 0a2a5b66e19d, bf00311e1990 -> 03bc53e68815, merge_heads_2
INFO [alembic.runtime.migration] Running upgrade 03bc53e68815 -> 41f5f12752f8, add superuser field
INFO [alembic.runtime.migration] Running upgrade 41f5f12752f8 -> c8ffec048a3b, add fields to dag
INFO [alembic.runtime.migration] Running upgrade c8ffec048a3b -> dd4ecb8fbee3, Add schedule interval to dag
INFO [alembic.runtime.migration] Running upgrade dd4ecb8fbee3 -> 939bb1e647c8, task reschedule fk on cascade delete
INFO [alembic.runtime.migration] Running upgrade 939bb1e647c8 -> 6e96a59344a4, Make TaskInstance.pool not nullable
INFO [alembic.runtime.migration] Running upgrade 6e96a59344a4 -> d38e04c12aa2, add serialized_dag table
Revision ID: d38e04c12aa2
Revises: 6e96a59344a4
Create Date: 2019-08-01 14:39:35.616417
INFO [alembic.runtime.migration] Running upgrade d38e04c12aa2 -> b3b105409875, add root_dag_id to DAG
INFO [alembic.runtime.migration] Running upgrade 6e96a59344a4 -> 74effc47d867, change datetime to datetime2(6) on MSSQL tables
INFO [alembic.runtime.migration] Running upgrade 939bb1e647c8 -> 004c1210f153, increase queue name size limit
INFO [alembic.runtime.migration] Running upgrade c8ffec048a3b -> a56c9515abdc, Remove dag_stat table
INFO [alembic.runtime.migration] Running upgrade a56c9515abdc, 004c1210f153, 74effc47d867, b3b105409875 -> 08364691d074, Merge the four heads back together
INFO [alembic.runtime.migration] Running upgrade 08364691d074 -> fe461863935f, increase_length_for_connection_password
INFO [alembic.runtime.migration] Running upgrade fe461863935f -> 7939bcff74ba, Add DagTags table
INFO [alembic.runtime.migration] Running upgrade 7939bcff74ba -> a4c2fd67d16b, add pool_slots field to task_instance
INFO [alembic.runtime.migration] Running upgrade a4c2fd67d16b -> 852ae6c715af, Add RenderedTaskInstanceFields table
INFO [alembic.runtime.migration] Running upgrade 852ae6c715af -> 952da73b5eff, add dag_code table
INFO [alembic.runtime.migration] Running upgrade 952da73b5eff -> a66efa278eea, Add Precision to execution_date in RenderedTaskInstanceFields table
INFO [alembic.runtime.migration] Running upgrade a66efa278eea -> da3f683c3a5a, Add dag_hash Column to serialized_dag table
Done.
____________ _____________
____ |__( )_________ __/__ /________ __
____ /| |_ /__ ___/_ /_ __ /_ __ \_ | /| / /
___ ___ | / _ / _ __/ _ / / /_/ /_ |/ |/ /
_/_/ |_/_/ /_/ /_/ /_/ \____/____/|__/
[2020-09-10 10:12:08,413] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:12:08,423] {scheduler_job.py:1367} INFO - Starting the scheduler
[2020-09-10 10:12:08,423] {scheduler_job.py:1375} INFO - Running execute loop for -1 seconds
[2020-09-10 10:12:08,423] {scheduler_job.py:1376} INFO - Processing each file at most -1 times
[2020-09-10 10:12:08,424] {scheduler_job.py:1379} INFO - Searching for files in /root/airflow/dags
[2020-09-10 10:12:08,431] {scheduler_job.py:1381} INFO - There are 25 files in /root/airflow/dags
[2020-09-10 10:12:08,431] {scheduler_job.py:1438} INFO - Resetting orphaned tasks for active dag runs
[2020-09-10 10:12:08,456] {dag_processing.py:562} INFO - Launched DagFileProcessorManager with pid: 29
[2020-09-10 10:12:08,460] {settings.py:55} INFO - Configured default timezone <Timezone [UTC]>
[2020-09-10 10:12:08,474] {dag_processing.py:774} WARNING - Because we cannot use more than 1 thread (max_threads = 2) when using sqlite. So we set parallelism to 1.
____________ _____________
____ |__( )_________ __/__ /________ __
____ /| |_ /__ ___/_ /_ __ /_ __ \_ | /| / /
___ ___ | / _ / _ __/ _ / / /_/ /_ |/ |/ /
_/_/ |_/_/ /_/ /_/ /_/ \____/____/|__/
[2020-09-10 10:12:08,607] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:12:08,607] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
Running the Gunicorn Server with:
Workers: 4 sync
Host: 0.0.0.0:8080

Timeout: 120
Logfiles: - -
=================================================================
[2020-09-10 10:12:09 +0000] [31] [INFO] Starting gunicorn 20.0.4
[2020-09-10 10:12:09 +0000] [31] [INFO] Listening at: http://0.0.0.0:8080 (31)
[2020-09-10 10:12:09 +0000] [31] [INFO] Using worker: sync
[2020-09-10 10:12:09 +0000] [33] [INFO] Booting worker with pid: 33
[2020-09-10 10:12:09 +0000] [34] [INFO] Booting worker with pid: 34
[2020-09-10 10:12:10 +0000] [35] [INFO] Booting worker with pid: 35
[2020-09-10 10:12:10 +0000] [36] [INFO] Booting worker with pid: 36
[2020-09-10 10:12:11,135] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:12:11,136] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
[2020-09-10 10:12:11,154] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:12:11,154] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
[2020-09-10 10:12:11,218] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:12:11,219] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
[2020-09-10 10:12:11,226] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:12:11,228] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
[2020-09-10 10:12:39 +0000] [31] [INFO] Handling signal: ttin
[2020-09-10 10:12:39 +0000] [72] [INFO] Booting worker with pid: 72
[2020-09-10 10:12:39,689] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:12:39,690] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
[2020-09-10 10:12:40 +0000] [31] [INFO] Handling signal: ttou
[2020-09-10 10:12:40 +0000] [33] [INFO] Worker exiting (pid: 33)
[2020-09-10 10:13:09 +0000] [31] [INFO] Handling signal: ttin
[2020-09-10 10:13:09 +0000] [93] [INFO] Booting worker with pid: 93
[2020-09-10 10:13:10,163] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:13:10,164] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
[2020-09-10 10:13:10 +0000] [31] [INFO] Handling signal: ttou
[2020-09-10 10:13:10 +0000] [34] [INFO] Worker exiting (pid: 34)
[2020-09-10 10:13:40 +0000] [31] [INFO] Handling signal: ttin
[2020-09-10 10:13:40 +0000] [114] [INFO] Booting worker with pid: 114
[2020-09-10 10:13:40,678] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:13:40,678] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
[2020-09-10 10:13:41 +0000] [31] [INFO] Handling signal: ttou
[2020-09-10 10:13:41 +0000] [35] [INFO] Worker exiting (pid: 35)
[2020-09-10 10:14:10 +0000] [31] [INFO] Handling signal: ttin
[2020-09-10 10:14:10 +0000] [136] [INFO] Booting worker with pid: 136
[2020-09-10 10:14:11,162] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:14:11,162] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
[2020-09-10 10:14:11 +0000] [31] [INFO] Handling signal: ttou
[2020-09-10 10:14:11 +0000] [36] [INFO] Worker exiting (pid: 36)
[2020-09-10 10:14:41 +0000] [31] [INFO] Handling signal: ttin
[2020-09-10 10:14:41 +0000] [157] [INFO] Booting worker with pid: 157
[2020-09-10 10:14:41,696] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:14:41,697] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
[2020-09-10 10:14:42 +0000] [31] [INFO] Handling signal: ttou
[2020-09-10 10:14:42 +0000] [72] [INFO] Worker exiting (pid: 72)
[2020-09-10 10:15:11 +0000] [31] [INFO] Handling signal: ttin
[2020-09-10 10:15:11 +0000] [178] [INFO] Booting worker with pid: 178
[2020-09-10 10:15:12,231] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:15:12,231] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
[2020-09-10 10:15:12 +0000] [31] [INFO] Handling signal: ttou
[2020-09-10 10:15:12 +0000] [93] [INFO] Worker exiting (pid: 93)
[2020-09-10 10:15:42 +0000] [31] [INFO] Handling signal: ttin
[2020-09-10 10:15:42 +0000] [199] [INFO] Booting worker with pid: 199
[2020-09-10 10:15:42,706] {__init__.py:50} INFO - Using executor SequentialExecutor
[2020-09-10 10:15:42,707] {dagbag.py:417} INFO - Filling up the DagBag from /root/airflow/dags
/usr/local/lib/python3.8/site-packages/airflow/models/dag.py:1337: PendingDeprecationWarning: The requested task could not be added to the DAG because a task with task_id create_tag_template_field_result is already in the DAG. Starting in Airflow 2.0, trying to overwrite a task will raise an exception.
warnings.warn(
/usr/local/lib/python3.8/site-packages/airflow/www/gunicorn_config.py:27: DeprecationWarning: PY_SSIZE_T_CLEAN will be required for '#' formats
settings.GUNICORN_WORKER_READY_PREFIX + setproctitle.getproctitle()
[2020-09-10 10:15:43 +0000] [31] [INFO] Handling signal: ttou
[2020-09-10 10:15:43 +0000] [114] [INFO] Worker exiting (pid: 114)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment