DAG: penzugyi_adatok_toltese

schedule: 0 5 * * *


Task Instance: szerzodesek_union


Log

[2025-07-21 05:02:18,703] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-07-21 05:02:18,951] {base_task_runner.py:112} INFO - Running: ['bash', '-c', u'airflow run penzugyi_adatok_toltese szerzodesek_union 2025-07-20T05:00:00 --job_id 273251 --raw -sd DAGS_FOLDER/penzugyi_adatok_toltese.py']
[2025-07-21 05:02:19,273] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,272] {__init__.py:57} INFO - Using executor SequentialExecutor
[2025-07-21 05:02:19,352] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,352] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt
[2025-07-21 05:02:19,374] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,374] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/PatternGrammar.txt
[2025-07-21 05:02:19,530] {base_task_runner.py:95} INFO - Subtask: /usr/local/lib/python2.7/dist-packages/airflow/www/app.py:23: FlaskWTFDeprecationWarning: "flask_wtf.CsrfProtect" has been renamed to "CSRFProtect" and will be removed in 1.0.
[2025-07-21 05:02:19,531] {base_task_runner.py:95} INFO - Subtask:   csrf = CsrfProtect()
[2025-07-21 05:02:19,554] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,554] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-07-21 05:02:19,785] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,784] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.szerzodesek_union 2025-07-20 05:00:00 [queued]>
[2025-07-21 05:02:19,806] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,805] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.szerzodesek_union 2025-07-20 05:00:00 [queued]>
[2025-07-21 05:02:19,806] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,805] {models.py:1334} INFO - 
[2025-07-21 05:02:19,807] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-07-21 05:02:19,807] {base_task_runner.py:95} INFO - Subtask: Starting attempt 1 of 2
[2025-07-21 05:02:19,807] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-07-21 05:02:19,807] {base_task_runner.py:95} INFO - Subtask: 
[2025-07-21 05:02:19,825] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,824] {models.py:1358} INFO - Executing <Task(BashOperator): szerzodesek_union> on 2025-07-20 05:00:00
[2025-07-21 05:02:19,870] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,869] {bash_operator.py:71} INFO - tmp dir root location: 
[2025-07-21 05:02:19,870] {base_task_runner.py:95} INFO - Subtask: /tmp
[2025-07-21 05:02:19,871] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,870] {bash_operator.py:80} INFO - Temporary script location :/tmp/airflowtmpmydlR3//tmp/airflowtmpmydlR3/szerzodesek_unionPBQvl2
[2025-07-21 05:02:19,872] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,870] {bash_operator.py:81} INFO - Running command: PGPASSWORD=oe5Su4Aaghae psql worker  -h 127.0.0.1 -d dwh -f /var/local/erp-data-loader/erp_data_union/szerzodesek_union.sql
[2025-07-21 05:02:19,879] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:19,878] {bash_operator.py:90} INFO - Output:
[2025-07-21 05:02:20,048] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:20,047] {bash_operator.py:94} INFO - DELETE 5418
[2025-07-21 05:02:20,141] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:20,141] {bash_operator.py:94} INFO - INSERT 0 5418
[2025-07-21 05:02:20,386] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:20,386] {bash_operator.py:94} INFO - DELETE 17068
[2025-07-21 05:02:20,623] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:20,622] {bash_operator.py:94} INFO - INSERT 0 17068
[2025-07-21 05:02:20,625] {base_task_runner.py:95} INFO - Subtask: [2025-07-21 05:02:20,624] {bash_operator.py:97} INFO - Command exited with return code 0
[2025-07-21 05:02:23,961] {jobs.py:2125} INFO - Task exited with return code 0