Log
[2025-09-07 05:00:28,127] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-09-07 05:00:28,416] {base_task_runner.py:112} INFO - Running: ['bash', '-c', u'airflow run penzugyi_adatok_toltese AMA_szamlak 2025-09-06T05:00:00 --job_id 412728 --raw -sd DAGS_FOLDER/penzugyi_adatok_toltese.py']
[2025-09-07 05:00:28,784] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:28,783] {__init__.py:57} INFO - Using executor SequentialExecutor
[2025-09-07 05:00:28,863] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:28,862] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt
[2025-09-07 05:00:28,882] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:28,881] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/PatternGrammar.txt
[2025-09-07 05:00:29,070] {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-09-07 05:00:29,070] {base_task_runner.py:95} INFO - Subtask: csrf = CsrfProtect()
[2025-09-07 05:00:29,094] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:29,093] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-09-07 05:00:29,375] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:29,374] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szamlak 2025-09-06 05:00:00 [queued]>
[2025-09-07 05:00:29,389] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:29,389] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szamlak 2025-09-06 05:00:00 [queued]>
[2025-09-07 05:00:29,390] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:29,389] {models.py:1334} INFO -
[2025-09-07 05:00:29,390] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-09-07 05:00:29,390] {base_task_runner.py:95} INFO - Subtask: Starting attempt 1 of 2
[2025-09-07 05:00:29,390] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-09-07 05:00:29,390] {base_task_runner.py:95} INFO - Subtask:
[2025-09-07 05:00:29,409] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:29,409] {models.py:1358} INFO - Executing <Task(BashOperator): AMA_szamlak> on 2025-09-06 05:00:00
[2025-09-07 05:00:29,444] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:29,443] {bash_operator.py:71} INFO - tmp dir root location:
[2025-09-07 05:00:29,444] {base_task_runner.py:95} INFO - Subtask: /tmp
[2025-09-07 05:00:29,445] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:29,444] {bash_operator.py:80} INFO - Temporary script location :/tmp/airflowtmp1yyuJR//tmp/airflowtmp1yyuJR/AMA_szamlakv5pIvw
[2025-09-07 05:00:29,445] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:29,444] {bash_operator.py:81} INFO - Running command: python /var/local/erp-data-loader/tajolo_admin/amango_szamlak.py
[2025-09-07 05:00:29,450] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:29,449] {bash_operator.py:90} INFO - Output:
[2025-09-07 05:00:57,733] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:57,732] {bash_operator.py:94} INFO - Traceback (most recent call last):
[2025-09-07 05:00:57,733] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:57,733] {bash_operator.py:94} INFO - File "/var/local/erp-data-loader/tajolo_admin/amango_szamlak.py", line 149, in <module>
[2025-09-07 05:00:57,734] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:57,733] {bash_operator.py:94} INFO - taj_szamlaki.to_sql('szamlak_ama',bi_db,schema='stage',if_exists='replace',dtype=types,index=False)
[2025-09-07 05:00:57,734] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:57,734] {bash_operator.py:94} INFO - File [2025-09-07 05:00:58,090] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:58,090] {bash_operator.py:97} INFO - Command exited with return code 1
[2025-09-07 05:00:58,091] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:58,090] {models.py:1433} ERROR - Bash command failed
[2025-09-07 05:00:58,091] {base_task_runner.py:95} INFO - Subtask: Traceback (most recent call last):
[2025-09-07 05:00:58,092] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/models.py", line 1390, in run
[2025-09-07 05:00:58,092] {base_task_runner.py:95} INFO - Subtask: result = task_copy.execute(context=context)
[2025-09-07 05:00:58,092] {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-09-07 05:00:58,093] {base_task_runner.py:95} INFO - Subtask: raise AirflowException("Bash command failed")
[2025-09-07 05:00:58,093] {base_task_runner.py:95} INFO - Subtask: AirflowException: Bash command failed
[2025-09-07 05:00:58,093] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:58,092] {models.py:1449} INFO - Marking task as UP_FOR_RETRY
[2025-09-07 05:00:58,095] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:58,095] {configuration.py:609} WARNING - section/key [smtp/smtp_user] not found in config
[2025-09-07 05:00:58,108] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:58,107] {models.py:1462} ERROR - Failed to send email to: ['fodorsz@mapsolutions.hu']
[2025-09-07 05:00:58,109] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:58,107] {models.py:1463} ERROR - STARTTLS extension not supported by server.
[2025-09-07 05:00:58,109] {base_task_runner.py:95} INFO - Subtask: Traceback (most recent call last):
[2025-09-07 05:00:58,110] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/models.py", line 1451, in handle_failure
[2025-09-07 05:00:58,110] {base_task_runner.py:95} INFO - Subtask: self.email_alert(error, is_retry=True)
[2025-09-07 05:00:58,110] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/models.py", line 1611, in email_alert
[2025-09-07 05:00:58,110] {base_task_runner.py:95} INFO - Subtask: send_email(task.email, title, body)
[2025-09-07 05:00:58,111] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/utils/email.py", line 44, in send_email
[2025-09-07 05:00:58,111] {base_task_runner.py:95} INFO - Subtask: return backend(to, subject, html_content, files=files, dryrun=dryrun, cc=cc, bcc=bcc, mime_subtype=mime_subtype)
[2025-09-07 05:00:58,111] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/utils/email.py", line 86, in send_email_smtp
[2025-09-07 05:00:58,112] {base_task_runner.py:95} INFO - Subtask: send_MIME_email(SMTP_MAIL_FROM, recipients, msg, dryrun)
[2025-09-07 05:00:58,112] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/utils/email.py", line 106, in send_MIME_email
[2025-09-07 05:00:58,112] {base_task_runner.py:95} INFO - Subtask: s.starttls()
[2025-09-07 05:00:58,112] {base_task_runner.py:95} INFO - Subtask: File "/usr/lib/python2.7/smtplib.py", line 644, in starttls
[2025-09-07 05:00:58,113] {base_task_runner.py:95} INFO - Subtask: raise SMTPException("STARTTLS extension not supported by server.")
[2025-09-07 05:00:58,113] {base_task_runner.py:95} INFO - Subtask: SMTPException: STARTTLS extension not supported by server.
[2025-09-07 05:00:58,131] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:00:58,131] {models.py:1478} ERROR - Bash command failed
[2025-09-07 05:00:58,131] {base_task_runner.py:95} INFO - Subtask: Traceback (most recent call last):
[2025-09-07 05:00:58,132] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/bin/airflow", line 28, in <module>
[2025-09-07 05:00:58,132] {base_task_runner.py:95} INFO - Subtask: args.func(args)
[2025-09-07 05:00:58,132] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/bin/cli.py", line 422, in run
[2025-09-07 05:00:58,132] {base_task_runner.py:95} INFO - Subtask: pool=args.pool,
[2025-09-07 05:00:58,132] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/utils/db.py", line 53, in wrapper
[2025-09-07 05:00:58,133] {base_task_runner.py:95} INFO - Subtask: result = func(*args, **kwargs)
[2025-09-07 05:00:58,133] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/models.py", line 1390, in run
[2025-09-07 05:00:58,133] {base_task_runner.py:95} INFO - Subtask: result = task_copy.execute(context=context)
[2025-09-07 05:00:58,133] {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-09-07 05:00:58,133] {base_task_runner.py:95} INFO - Subtask: raise AirflowException("Bash command failed")
[2025-09-07 05:00:58,134] {base_task_runner.py:95} INFO - Subtask: airflow.exceptions.AirflowException: Bash command failed
[2025-09-07 05:00:59,417] {jobs.py:2125} INFO - Task exited with return code 1
[2025-09-07 05:06:00,356] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-09-07 05:06:00,652] {base_task_runner.py:112} INFO - Running: ['bash', '-c', u'airflow run penzugyi_adatok_toltese AMA_szamlak 2025-09-06T05:00:00 --job_id 412752 --raw -sd DAGS_FOLDER/penzugyi_adatok_toltese.py']
[2025-09-07 05:06:01,008] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,007] {__init__.py:57} INFO - Using executor SequentialExecutor
[2025-09-07 05:06:01,090] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,089] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt
[2025-09-07 05:06:01,110] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,109] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/PatternGrammar.txt
[2025-09-07 05:06:01,285] {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-09-07 05:06:01,286] {base_task_runner.py:95} INFO - Subtask: csrf = CsrfProtect()
[2025-09-07 05:06:01,310] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,309] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-09-07 05:06:01,603] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,602] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szamlak 2025-09-06 05:00:00 [queued]>
[2025-09-07 05:06:01,608] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,608] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szamlak 2025-09-06 05:00:00 [queued]>
[2025-09-07 05:06:01,609] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,608] {models.py:1334} INFO -
[2025-09-07 05:06:01,610] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-09-07 05:06:01,610] {base_task_runner.py:95} INFO - Subtask: Starting attempt 2 of 2
[2025-09-07 05:06:01,610] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-09-07 05:06:01,611] {base_task_runner.py:95} INFO - Subtask:
[2025-09-07 05:06:01,625] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,624] {models.py:1358} INFO - Executing <Task(BashOperator): AMA_szamlak> on 2025-09-06 05:00:00
[2025-09-07 05:06:01,660] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,659] {bash_operator.py:71} INFO - tmp dir root location:
[2025-09-07 05:06:01,660] {base_task_runner.py:95} INFO - Subtask: /tmp
[2025-09-07 05:06:01,660] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,660] {bash_operator.py:80} INFO - Temporary script location :/tmp/airflowtmpl_UoaL//tmp/airflowtmpl_UoaL/AMA_szamlaktPXC3u
[2025-09-07 05:06:01,661] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,660] {bash_operator.py:81} INFO - Running command: python /var/local/erp-data-loader/tajolo_admin/amango_szamlak.py
[2025-09-07 05:06:01,666] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:01,665] {bash_operator.py:90} INFO - Output:
[2025-09-07 05:06:33,053] {base_task_runner.py:95} INFO - Subtask: [2025-09-07 05:06:33,053] {bash_operator.py:97} INFO - Command exited with return code 0
[2025-09-07 05:06:35,758] {jobs.py:2125} INFO - Task exited with return code 0