DAG: penzugyi_adatok_toltese

schedule: 0 5 * * *


Task Instance: szerzodesek_union


Log

[2025-08-21 05:02:05,836] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-08-21 05:02:06,141] {base_task_runner.py:112} INFO - Running: ['bash', '-c', u'airflow run penzugyi_adatok_toltese szerzodesek_union 2025-08-20T05:00:00 --job_id 363328 --raw -sd DAGS_FOLDER/penzugyi_adatok_toltese.py']
[2025-08-21 05:02:06,521] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:06,521] {__init__.py:57} INFO - Using executor SequentialExecutor
[2025-08-21 05:02:06,605] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:06,604] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt
[2025-08-21 05:02:06,627] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:06,627] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/PatternGrammar.txt
[2025-08-21 05:02:06,821] {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-08-21 05:02:06,822] {base_task_runner.py:95} INFO - Subtask:   csrf = CsrfProtect()
[2025-08-21 05:02:06,843] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:06,842] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-08-21 05:02:07,104] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,103] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.szerzodesek_union 2025-08-20 05:00:00 [queued]>
[2025-08-21 05:02:07,117] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,116] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.szerzodesek_union 2025-08-20 05:00:00 [queued]>
[2025-08-21 05:02:07,117] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,116] {models.py:1334} INFO - 
[2025-08-21 05:02:07,118] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-08-21 05:02:07,118] {base_task_runner.py:95} INFO - Subtask: Starting attempt 1 of 2
[2025-08-21 05:02:07,118] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-08-21 05:02:07,118] {base_task_runner.py:95} INFO - Subtask: 
[2025-08-21 05:02:07,123] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,122] {models.py:1358} INFO - Executing <Task(BashOperator): szerzodesek_union> on 2025-08-20 05:00:00
[2025-08-21 05:02:07,151] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,151] {bash_operator.py:71} INFO - tmp dir root location: 
[2025-08-21 05:02:07,152] {base_task_runner.py:95} INFO - Subtask: /tmp
[2025-08-21 05:02:07,152] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,152] {bash_operator.py:80} INFO - Temporary script location :/tmp/airflowtmpvdEug_//tmp/airflowtmpvdEug_/szerzodesek_unionKjUgEd
[2025-08-21 05:02:07,153] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,152] {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-08-21 05:02:07,161] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,160] {bash_operator.py:90} INFO - Output:
[2025-08-21 05:02:07,251] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,250] {bash_operator.py:94} INFO - DELETE 5421
[2025-08-21 05:02:07,284] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,283] {bash_operator.py:94} INFO - INSERT 0 5421
[2025-08-21 05:02:07,351] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,350] {bash_operator.py:94} INFO - DELETE 17078
[2025-08-21 05:02:07,439] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,439] {bash_operator.py:94} INFO - INSERT 0 17078
[2025-08-21 05:02:07,441] {base_task_runner.py:95} INFO - Subtask: [2025-08-21 05:02:07,441] {bash_operator.py:97} INFO - Command exited with return code 0
[2025-08-21 05:02:11,146] {jobs.py:2125} INFO - Task exited with return code 0