[
https://issues.apache.org/jira/browse/AIRFLOW-2459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ash Berlin-Taylor resolved AIRFLOW-2459.
----------------------------------------
Fix Version/s: (was: 2.0.0)
Resolution: Won't Fix
{{2018-05-13 05:24:37.946481+00:00}} is a valid datetime. What is mysql playing
at?
> Unable to insert 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: database
> Affects Versions: 2.0.0
> Reporter: kunal gupta
> Priority: Major
> Attachments: image-2018-05-13-00-36-20-872.png
>
>
> When i fire airflow initdb, using MySQL 5.7, im getting an error
> 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
(v8.3.4#803005)
