You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "kunal gupta (JIRA)" <ji...@apache.org> on 2018/05/13 05:39:00 UTC
[jira] [Created] (AIRFLOW-2459) Unable to inset in log table while
using MySQL
kunal gupta created AIRFLOW-2459:
------------------------------------
Summary: Unable to inset in log table while using MySQL
Key: AIRFLOW-2459
URL: https://issues.apache.org/jira/browse/AIRFLOW-2459
Project: Apache Airflow
Issue Type: Bug
Components: db
Affects Versions: Airflow 2.0
Reporter: kunal gupta
Fix For: Airflow 2.0
Attachments: image-2018-05-13-00-36-20-872.png
When i fire airflow initdb, using MySQL 5.7
MySQL version:
mysql Ver 14.14 Distrib 5.7.20-19, for Linux (x86_64) using 6.2
Airflow 2.0
MySQL set up for global variables:
show global variables like '%timestamp%';
!image-2018-05-13-00-36-20-872.png!
Error message:
sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (_mysql_exceptions.OperationalError) (1292, "Incorrect datetime value: '2018-05-13 05:24:37.946481+00:00' for column 'dttm' at row 1") [SQL: u'INSERT INTO log (dttm, dag_id, task_id, event, execution_date, owner, extra) VALUES (%s, %s, %s, %s, %s, %s, %s)'] [parameters: (datetime.datetime(2018, 5, 13, 5, 24, 37, 946481, tzinfo=<sqlalchemy_utc.timezone.Utc object at 0x7f4123196100>), None, None, 'cli_scheduler', None, 'default', '\{"full_command": "[\'/usr/bin/airflow\', \'scheduler\']", "host_name": "airflow-35-8jn6w"}')]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)