DAG: penzugyi_adatok_toltese

schedule: 0 5 * * *


Task Instance: szerzodesek_union


Log

[2025-04-27 05:01:52,105] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-04-27 05:01:52,432] {base_task_runner.py:112} INFO - Running: ['bash', '-c', u'airflow run penzugyi_adatok_toltese szerzodesek_union 2025-04-26T05:00:00 --job_id 135059 --raw -sd DAGS_FOLDER/penzugyi_adatok_toltese.py']
[2025-04-27 05:01:52,764] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:52,764] {__init__.py:57} INFO - Using executor SequentialExecutor
[2025-04-27 05:01:52,830] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:52,829] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt
[2025-04-27 05:01:52,849] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:52,848] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/PatternGrammar.txt
[2025-04-27 05:01:53,022] {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-04-27 05:01:53,022] {base_task_runner.py:95} INFO - Subtask:   csrf = CsrfProtect()
[2025-04-27 05:01:53,048] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,048] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-04-27 05:01:53,357] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,357] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.szerzodesek_union 2025-04-26 05:00:00 [queued]>
[2025-04-27 05:01:53,372] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,371] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.szerzodesek_union 2025-04-26 05:00:00 [queued]>
[2025-04-27 05:01:53,373] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,371] {models.py:1334} INFO - 
[2025-04-27 05:01:53,373] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-04-27 05:01:53,373] {base_task_runner.py:95} INFO - Subtask: Starting attempt 1 of 2
[2025-04-27 05:01:53,373] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-04-27 05:01:53,374] {base_task_runner.py:95} INFO - Subtask: 
[2025-04-27 05:01:53,379] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,379] {models.py:1358} INFO - Executing <Task(BashOperator): szerzodesek_union> on 2025-04-26 05:00:00
[2025-04-27 05:01:53,409] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,409] {bash_operator.py:71} INFO - tmp dir root location: 
[2025-04-27 05:01:53,410] {base_task_runner.py:95} INFO - Subtask: /tmp
[2025-04-27 05:01:53,410] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,410] {bash_operator.py:80} INFO - Temporary script location :/tmp/airflowtmphUUvvA//tmp/airflowtmphUUvvA/szerzodesek_unionFbzpmw
[2025-04-27 05:01:53,411] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,410] {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-04-27 05:01:53,416] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,415] {bash_operator.py:90} INFO - Output:
[2025-04-27 05:01:53,518] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,518] {bash_operator.py:94} INFO - DELETE 5405
[2025-04-27 05:01:53,560] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,559] {bash_operator.py:94} INFO - INSERT 0 5405
[2025-04-27 05:01:53,620] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,619] {bash_operator.py:94} INFO - DELETE 17035
[2025-04-27 05:01:53,705] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,704] {bash_operator.py:94} INFO - INSERT 0 17035
[2025-04-27 05:01:53,707] {base_task_runner.py:95} INFO - Subtask: [2025-04-27 05:01:53,707] {bash_operator.py:97} INFO - Command exited with return code 0
[2025-04-27 05:01:57,438] {jobs.py:2125} INFO - Task exited with return code 0