[jira] [Commented] (AIRFLOW-2459) Unable to insert in log table while using MySQL

2018-05-14 Thread kunal gupta (JIRA) 

[ 
https://issues.apache.org/jira/browse/AIRFLOW-2459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16475223#comment-16475223
 ] 

kunal gupta commented on AIRFLOW-2459:
--

[~7yl4r] you are a life saver, this resolved the MySQL issue. thanks a ton

> 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: db
>Affects Versions: Airflow 2.0
>Reporter: kunal gupta
>Priority: Major
> Fix For: Airflow 2.0
>
> 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=), 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)

[jira] [Commented] (AIRFLOW-2459) Unable to insert in log table while using MySQL

2018-05-14 Thread Tylar Murray (JIRA) 

[ 
https://issues.apache.org/jira/browse/AIRFLOW-2459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16474504#comment-16474504
 ] 

Tylar Murray commented on AIRFLOW-2459:
---

https://dba.stackexchange.com/questions/48704/mysql-5-6-datetime-incorrect-datetime-value-2013-08-25t17-with-er

> 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: db
>Affects Versions: Airflow 2.0
>Reporter: kunal gupta
>Priority: Major
> Fix For: Airflow 2.0
>
> 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=), 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)

[jira] [Commented] (AIRFLOW-2459) Unable to insert in log table while using MySQL

2018-05-13 Thread kunal gupta (JIRA) 

[ 
https://issues.apache.org/jira/browse/AIRFLOW-2459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16473734#comment-16473734
 ] 

kunal gupta commented on AIRFLOW-2459:
--

unable to find any information regarding this issue, has anyone else faced this?

> 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: db
>Affects Versions: Airflow 2.0
>Reporter: kunal gupta
>Priority: Major
> Fix For: Airflow 2.0
>
> 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=), 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)