Airflow安装错误:sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError)

1 完整的异常信息：

?

1 2

raise errorclass, errorvalue sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1292, "Incorrect datetime value: '2019-10-18 13:41:07.937196+00:00' for column 'last_scheduler_run' at row 1") [SQL: u'UPDATE dag SET last_scheduler_run=%s, description=%s, schedule_interval=%s WHERE dag.dag_id = %s'] [parameters: (datetime.datetime(2019, 10, 18, 13, 41, 7, 937196, tzinfo=<Timezone [UTC]>), 'spark ETL ', '"55 00  * * *"', 'sparkEtl’)]

　　

2 安装Airflow 执行 airflow initdb，遇到上面的错误

3 最后解决，Stack Overflow查到一条回答

?

1 2 3 4 5 6 7 8 9 10 11 12

mysql的模式问题 Just to recap for future users: Stop the service: systemctl stop mysql Get the current state: mysql> select @@sql_mode; Add statement to the config without "STRICT_TRANS_TABLES": sudo nano /etc/mysql/my.cnf under [mysqld]: sql_mode="paste "select @@sql_mode;" output **without** STRICT_TRANS_TABLES" Then start the service again: systemctl start mysql

4 最后解决，原来是自己的/etc/my.cnf中配置了

sql_mode='STRICT_TRANS_TABLES'

 

删除上面的STRICT_TRANS_TABLES参数，重启就ok了。如果这个配置和其他配置冲突，建议airflow安装独立的mysql。