Log
[2025-10-23 05:01:29,302] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-10-23 05:01:29,626] {base_task_runner.py:112} INFO - Running: ['bash', '-c', u'airflow run penzugyi_adatok_toltese AMA_szerzodesek 2025-10-22T05:00:00 --job_id 546402 --raw -sd DAGS_FOLDER/penzugyi_adatok_toltese.py']
[2025-10-23 05:01:30,035] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,035] {__init__.py:57} INFO - Using executor SequentialExecutor
[2025-10-23 05:01:30,119] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,118] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt
[2025-10-23 05:01:30,141] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,141] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/PatternGrammar.txt
[2025-10-23 05:01:30,337] {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-10-23 05:01:30,337] {base_task_runner.py:95} INFO - Subtask: csrf = CsrfProtect()
[2025-10-23 05:01:30,365] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,364] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-10-23 05:01:30,674] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,673] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szerzodesek 2025-10-22 05:00:00 [queued]>
[2025-10-23 05:01:30,679] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,678] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szerzodesek 2025-10-22 05:00:00 [queued]>
[2025-10-23 05:01:30,680] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,679] {models.py:1334} INFO -
[2025-10-23 05:01:30,680] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-10-23 05:01:30,680] {base_task_runner.py:95} INFO - Subtask: Starting attempt 1 of 2
[2025-10-23 05:01:30,681] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-10-23 05:01:30,681] {base_task_runner.py:95} INFO - Subtask:
[2025-10-23 05:01:30,697] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,696] {models.py:1358} INFO - Executing <Task(BashOperator): AMA_szerzodesek> on 2025-10-22 05:00:00
[2025-10-23 05:01:30,728] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,727] {bash_operator.py:71} INFO - tmp dir root location:
[2025-10-23 05:01:30,728] {base_task_runner.py:95} INFO - Subtask: /tmp
[2025-10-23 05:01:30,729] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,728] {bash_operator.py:80} INFO - Temporary script location :/tmp/airflowtmplgCUSo//tmp/airflowtmplgCUSo/AMA_szerzodesekQA1XGV
[2025-10-23 05:01:30,730] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,728] {bash_operator.py:81} INFO - Running command: python /var/local/erp-data-loader/tajolo_admin/amango_szerzodesek.py
[2025-10-23 05:01:30,734] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:30,733] {bash_operator.py:90} INFO - Output:
[2025-10-23 05:01:31,805] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,805] {bash_operator.py:94} INFO - Traceback (most recent call last):
[2025-10-23 05:01:31,806] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,805] {bash_operator.py:94} INFO - File "/var/local/erp-data-loader/tajolo_admin/amango_szerzodesek.py", line 78, in <module>
[2025-10-23 05:01:31,806] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,805] {bash_operator.py:94} INFO - taj_szerz.to_sql('szerzodesek_ama',bi_db,schema='stage',if_exists='replace',dtype=types,index=False)
[2025-10-23 05:01:31,806] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,806] {bash_[2025-10-23 05:01:31,881] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,880] {bash_operator.py:97} INFO - Command exited with return code 1
[2025-10-23 05:01:31,881] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,880] {models.py:1433} ERROR - Bash command failed
[2025-10-23 05:01:31,882] {base_task_runner.py:95} INFO - Subtask: Traceback (most recent call last):
[2025-10-23 05:01:31,882] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/models.py", line 1390, in run
[2025-10-23 05:01:31,882] {base_task_runner.py:95} INFO - Subtask: result = task_copy.execute(context=context)
[2025-10-23 05:01:31,883] {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-10-23 05:01:31,883] {base_task_runner.py:95} INFO - Subtask: raise AirflowException("Bash command failed")
[2025-10-23 05:01:31,883] {base_task_runner.py:95} INFO - Subtask: AirflowException: Bash command failed
[2025-10-23 05:01:31,884] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,881] {models.py:1449} INFO - Marking task as UP_FOR_RETRY
[2025-10-23 05:01:31,884] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,883] {configuration.py:609} WARNING - section/key [smtp/smtp_user] not found in config
[2025-10-23 05:01:31,889] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,889] {models.py:1462} ERROR - Failed to send email to: ['fodorsz@mapsolutions.hu']
[2025-10-23 05:01:31,890] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,889] {models.py:1463} ERROR - STARTTLS extension not supported by server.
[2025-10-23 05:01:31,890] {base_task_runner.py:95} INFO - Subtask: Traceback (most recent call last):
[2025-10-23 05:01:31,890] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/models.py", line 1451, in handle_failure
[2025-10-23 05:01:31,891] {base_task_runner.py:95} INFO - Subtask: self.email_alert(error, is_retry=True)
[2025-10-23 05:01:31,891] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/models.py", line 1611, in email_alert
[2025-10-23 05:01:31,891] {base_task_runner.py:95} INFO - Subtask: send_email(task.email, title, body)
[2025-10-23 05:01:31,891] {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-10-23 05:01:31,892] {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-10-23 05:01:31,892] {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-10-23 05:01:31,892] {base_task_runner.py:95} INFO - Subtask: send_MIME_email(SMTP_MAIL_FROM, recipients, msg, dryrun)
[2025-10-23 05:01:31,893] {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-10-23 05:01:31,893] {base_task_runner.py:95} INFO - Subtask: s.starttls()
[2025-10-23 05:01:31,893] {base_task_runner.py:95} INFO - Subtask: File "/usr/lib/python2.7/smtplib.py", line 644, in starttls
[2025-10-23 05:01:31,893] {base_task_runner.py:95} INFO - Subtask: raise SMTPException("STARTTLS extension not supported by server.")
[2025-10-23 05:01:31,893] {base_task_runner.py:95} INFO - Subtask: SMTPException: STARTTLS extension not supported by server.
[2025-10-23 05:01:31,922] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:01:31,921] {models.py:1478} ERROR - Bash command failed
[2025-10-23 05:01:31,922] {base_task_runner.py:95} INFO - Subtask: Traceback (most recent call last):
[2025-10-23 05:01:31,922] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/bin/airflow", line 28, in <module>
[2025-10-23 05:01:31,922] {base_task_runner.py:95} INFO - Subtask: args.func(args)
[2025-10-23 05:01:31,923] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/bin/cli.py", line 422, in run
[2025-10-23 05:01:31,923] {base_task_runner.py:95} INFO - Subtask: pool=args.pool,
[2025-10-23 05:01:31,923] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/utils/db.py", line 53, in wrapper
[2025-10-23 05:01:31,923] {base_task_runner.py:95} INFO - Subtask: result = func(*args, **kwargs)
[2025-10-23 05:01:31,923] {base_task_runner.py:95} INFO - Subtask: File "/usr/local/lib/python2.7/dist-packages/airflow/models.py", line 1390, in run
[2025-10-23 05:01:31,923] {base_task_runner.py:95} INFO - Subtask: result = task_copy.execute(context=context)
[2025-10-23 05:01:31,924] {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-10-23 05:01:31,924] {base_task_runner.py:95} INFO - Subtask: raise AirflowException("Bash command failed")
[2025-10-23 05:01:31,924] {base_task_runner.py:95} INFO - Subtask: airflow.exceptions.AirflowException: Bash command failed
[2025-10-23 05:01:34,617] {jobs.py:2125} INFO - Task exited with return code 1
[2025-10-23 05:06:37,724] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-10-23 05:06:38,019] {base_task_runner.py:112} INFO - Running: ['bash', '-c', u'airflow run penzugyi_adatok_toltese AMA_szerzodesek 2025-10-22T05:00:00 --job_id 546426 --raw -sd DAGS_FOLDER/penzugyi_adatok_toltese.py']
[2025-10-23 05:06:38,402] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:38,401] {__init__.py:57} INFO - Using executor SequentialExecutor
[2025-10-23 05:06:38,491] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:38,490] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt
[2025-10-23 05:06:38,543] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:38,542] {driver.py:123} INFO - Generating grammar tables from /usr/lib/python2.7/lib2to3/PatternGrammar.txt
[2025-10-23 05:06:38,770] {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-10-23 05:06:38,770] {base_task_runner.py:95} INFO - Subtask: csrf = CsrfProtect()
[2025-10-23 05:06:38,796] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:38,795] {models.py:168} INFO - Filling up the DagBag from /var/local/airflow_dags/dags/penzugyi_adatok_toltese.py
[2025-10-23 05:06:39,095] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:39,094] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szerzodesek 2025-10-22 05:00:00 [queued]>
[2025-10-23 05:06:39,101] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:39,100] {models.py:1128} INFO - Dependencies all met for <TaskInstance: penzugyi_adatok_toltese.AMA_szerzodesek 2025-10-22 05:00:00 [queued]>
[2025-10-23 05:06:39,101] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:39,100] {models.py:1334} INFO -
[2025-10-23 05:06:39,102] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-10-23 05:06:39,102] {base_task_runner.py:95} INFO - Subtask: Starting attempt 2 of 2
[2025-10-23 05:06:39,102] {base_task_runner.py:95} INFO - Subtask: --------------------------------------------------------------------------------
[2025-10-23 05:06:39,103] {base_task_runner.py:95} INFO - Subtask:
[2025-10-23 05:06:39,126] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:39,126] {models.py:1358} INFO - Executing <Task(BashOperator): AMA_szerzodesek> on 2025-10-22 05:00:00
[2025-10-23 05:06:39,170] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:39,169] {bash_operator.py:71} INFO - tmp dir root location:
[2025-10-23 05:06:39,170] {base_task_runner.py:95} INFO - Subtask: /tmp
[2025-10-23 05:06:39,171] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:39,170] {bash_operator.py:80} INFO - Temporary script location :/tmp/airflowtmpUSvDUX//tmp/airflowtmpUSvDUX/AMA_szerzodesekoMAiv5
[2025-10-23 05:06:39,172] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:39,171] {bash_operator.py:81} INFO - Running command: python /var/local/erp-data-loader/tajolo_admin/amango_szerzodesek.py
[2025-10-23 05:06:39,178] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:39,178] {bash_operator.py:90} INFO - Output:
[2025-10-23 05:06:40,559] {base_task_runner.py:95} INFO - Subtask: [2025-10-23 05:06:40,559] {bash_operator.py:97} INFO - Command exited with return code 0
[2025-10-23 05:06:43,031] {jobs.py:2125} INFO - Task exited with return code 0