DAG: penzugyi_adatok_toltese

schedule: 0 5 * * *


Task Instance: AMA_szamlak


Log

[2025-12-18 05:00:13,443] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-12-18 05:00:13,762] {base_task_runner.py:112} INFO - Running: ['bash', '-c', u'airflow run penzugyi_adatok_toltese AMA_szamlak 2025-12-17T05:00:00 --job_id 709108 --raw -sd DAGS_FOLDER/penzugyi_adatok_toltese.py']
[2025-12-18 05:00:14,089] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,088] {__init__.py:57} INFO - Using executor SequentialExecutor
[2025-12-18 05:00:14,160] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,159] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt
[2025-12-18 05:00:14,179] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,178] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/PatternGrammar.txt
[2025-12-18 05:00:14,344] {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-12-18 05:00:14,344] {base_task_runner.py:95} INFO - Subtask:   csrf = CsrfProtect()
[2025-12-18 05:00:14,366] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,365] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-12-18 05:00:14,617] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,617] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szamlak 2025-12-17 05:00:00 [queued]>
[2025-12-18 05:00:14,622] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,622] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szamlak 2025-12-17 05:00:00 [queued]>
[2025-12-18 05:00:14,623] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,622] {models.py:1334} INFO - 
[2025-12-18 05:00:14,623] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-12-18 05:00:14,623] {base_task_runner.py:95} INFO - Subtask: Starting attempt 1 of 2
[2025-12-18 05:00:14,624] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-12-18 05:00:14,624] {base_task_runner.py:95} INFO - Subtask: 
[2025-12-18 05:00:14,634] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,633] {models.py:1358} INFO - Executing <Task(BashOperator): AMA_szamlak> on 2025-12-17 05:00:00
[2025-12-18 05:00:14,664] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,663] {bash_operator.py:71} INFO - tmp dir root location: 
[2025-12-18 05:00:14,664] {base_task_runner.py:95} INFO - Subtask: /tmp
[2025-12-18 05:00:14,665] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,664] {bash_operator.py:80} INFO - Temporary script location :/tmp/airflowtmpOAUm6f//tmp/airflowtmpOAUm6f/AMA_szamlakszpe55
[2025-12-18 05:00:14,665] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,664] {bash_operator.py:81} INFO - Running command: python /var/local/erp-data-loader/tajolo_admin/amango_szamlak.py
[2025-12-18 05:00:14,672] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:14,671] {bash_operator.py:90} INFO - Output:
[2025-12-18 05:00:33,071] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:33,070] {bash_operator.py:94} INFO - Traceback (most recent call last):
[2025-12-18 05:00:33,072] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:33,071] {bash_operator.py:94} INFO - File "/var/local/erp-data-loader/tajolo_admin/amango_szamlak.py", line 149, in <module>
[2025-12-18 05:00:33,072] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:33,071] {bash_operator.py:94} INFO - taj_szamlaki.to_sql('szamlak_ama',bi_db,schema='stage',if_exists='replace',dtype=types,index=False)
[2025-12-18 05:00:33,073] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:33,071] {bash_operator.py:94} INFO - File [2025-12-18 05:00:33,318] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:00:33,318] {models.py:1478} ERROR - Bash command failed
[2025-12-18 05:00:33,319] {base_task_runner.py:95} INFO - Subtask: Traceback (most recent call last):
[2025-12-18 05:00:33,319] {base_task_runner.py:95} INFO - Subtask:   File "/usr/local/bin/airflow", line 28, in <module>
[2025-12-18 05:00:33,319] {base_task_runner.py:95} INFO - Subtask:     args.func(args)
[2025-12-18 05:00:33,320] {base_task_runner.py:95} INFO - Subtask:   File "/usr/local/lib/python2.7/dist-packages/airflow/bin/cli.py", line 422, in run
[2025-12-18 05:00:33,320] {base_task_runner.py:95} INFO - Subtask:     pool=args.pool,
[2025-12-18 05:00:33,320] {base_task_runner.py:95} INFO - Subtask:   File "/usr/local/lib/python2.7/dist-packages/airflow/utils/db.py", line 53, in wrapper
[2025-12-18 05:00:33,320] {base_task_runner.py:95} INFO - Subtask:     result = func(*args, **kwargs)
[2025-12-18 05:00:33,321] {base_task_runner.py:95} INFO - Subtask:   File "/usr/local/lib/python2.7/dist-packages/airflow/models.py", line 1390, in run
[2025-12-18 05:00:33,321] {base_task_runner.py:95} INFO - Subtask:     result = task_copy.execute(context=context)
[2025-12-18 05:00:33,322] {base_task_runner.py:95} INFO - Subtask:   File "/usr/local/lib/python2.7/dist-packages/airflow/operators/bash_operator.py", line 100, in execute
[2025-12-18 05:00:33,322] {base_task_runner.py:95} INFO - Subtask:     raise AirflowException("Bash command failed")
[2025-12-18 05:00:33,322] {base_task_runner.py:95} INFO - Subtask: airflow.exceptions.AirflowException: Bash command failed
[2025-12-18 05:00:34,868] {jobs.py:2125} INFO - Task exited with return code 1
[2025-12-18 05:05:43,151] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-12-18 05:05:43,428] {base_task_runner.py:112} INFO - Running: ['bash', '-c', u'airflow run penzugyi_adatok_toltese AMA_szamlak 2025-12-17T05:00:00 --job_id 709133 --raw -sd DAGS_FOLDER/penzugyi_adatok_toltese.py']
[2025-12-18 05:05:43,784] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:43,784] {__init__.py:57} INFO - Using executor SequentialExecutor
[2025-12-18 05:05:43,860] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:43,859] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt
[2025-12-18 05:05:43,879] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:43,879] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/PatternGrammar.txt
[2025-12-18 05:05:44,062] {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-12-18 05:05:44,062] {base_task_runner.py:95} INFO - Subtask:   csrf = CsrfProtect()
[2025-12-18 05:05:44,085] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:44,085] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-12-18 05:05:44,345] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:44,345] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szamlak 2025-12-17 05:00:00 [queued]>
[2025-12-18 05:05:44,366] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:44,366] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szamlak 2025-12-17 05:00:00 [queued]>
[2025-12-18 05:05:44,367] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:44,366] {models.py:1334} INFO - 
[2025-12-18 05:05:44,367] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-12-18 05:05:44,367] {base_task_runner.py:95} INFO - Subtask: Starting attempt 2 of 2
[2025-12-18 05:05:44,368] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-12-18 05:05:44,368] {base_task_runner.py:95} INFO - Subtask: 
[2025-12-18 05:05:44,387] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:44,387] {models.py:1358} INFO - Executing <Task(BashOperator): AMA_szamlak> on 2025-12-17 05:00:00
[2025-12-18 05:05:44,423] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:44,423] {bash_operator.py:71} INFO - tmp dir root location: 
[2025-12-18 05:05:44,424] {base_task_runner.py:95} INFO - Subtask: /tmp
[2025-12-18 05:05:44,424] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:44,424] {bash_operator.py:80} INFO - Temporary script location :/tmp/airflowtmpf4lzO6//tmp/airflowtmpf4lzO6/AMA_szamlak_JF0yl
[2025-12-18 05:05:44,425] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:44,424] {bash_operator.py:81} INFO - Running command: python /var/local/erp-data-loader/tajolo_admin/amango_szamlak.py
[2025-12-18 05:05:44,433] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:05:44,432] {bash_operator.py:90} INFO - Output:
[2025-12-18 05:06:08,191] {base_task_runner.py:95} INFO - Subtask: [2025-12-18 05:06:08,190] {bash_operator.py:97} INFO - Command exited with return code 0
[2025-12-18 05:06:12,553] {jobs.py:2125} INFO - Task exited with return code 0