You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@airflow.apache.org by "Bolke de Bruin (JIRA)" <ji...@apache.org> on 2016/09/11 12:24:20 UTC

[jira] [Created] (AIRFLOW-504) datetime.now() has microseconds Mysql does not store these resulting in issues

Bolke de Bruin created AIRFLOW-504:
--------------------------------------

             Summary: datetime.now() has microseconds Mysql does not store these resulting in issues
                 Key: AIRFLOW-504
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-504
             Project: Apache Airflow
          Issue Type: Bug
            Reporter: Bolke de Bruin


>>> datetime.datetime.utcnow()
datetime.datetime(2016, 9, 11, 12, 22, 22, 483998)
>>> datetime.datetime.now()
datetime.datetime(2016, 9, 11, 14, 22, 31, 363392)
>>>

Mysql rounds those to "2016-05-13 00:00:00". If sqlalchemy now tries to find the the record by primary key (eg. session.merge) it cannot find them due to lost precision.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)