explicit_defaults_for_timestamp

airflow initdb :

出现异常：Exception: Global variable explicit_defaults_for_timestamp needs to be on (1) for mysql

 

解决方式：

https://airflow.readthedocs.io/en/stable/faq.html#how-to-fix-exception-global-variable-explicit-defaults-for-timestamp-needs-to-be-on-1

docker exec -it meu_mysql /bin/bash

cd /etc/mysql/


root@8ab0b9bd6a08:/etc/mysql/conf.d# cat mysql.cnf 
[mysql]
root@8ab0b9bd6a08:/etc/mysql/conf.d# echo '[mysqld]' >> mysql.cnf 
root@8ab0b9bd6a08:/etc/mysql/conf.d# echo 'explicit_defaults_for_timestamp = 1' >> mysql.cnf 
root@8ab0b9bd6a08:/etc/mysql/conf.d# cat mysql.cnf 
[mysql]
[mysqld]
explicit_defaults_for_timestamp = 1

 

无法在进入mysql 后 启动explicit_defaults_for_timestamp

(airflow_c) root@ubuntu:~/airflow# airflow initdb
[2018-10-30 19:36:06,829] {settings.py:174} INFO - setting.configure_orm(): Using pool settings. pool_size=5, pool_recycle=1800
[2018-10-30 19:36:06,974] {__init__.py:51} INFO - Using executor SequentialExecutor
DB: mysql://root:***@47.92.117.63:3306/airflow
[2018-10-30 19:36:07,117] {db.py:338} INFO - Creating tables
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade d2ae31099d61 -> 0e2a74e0fc9f, Add time zone awareness
INFO  [alembic.runtime.migration] Running upgrade d2ae31099d61 -> 33ae817a1ff4, kubernetes_resource_checkpointing
INFO  [alembic.runtime.migration] Running upgrade 33ae817a1ff4 -> 27c6a30d7c24, kubernetes_resource_checkpointing
INFO  [alembic.runtime.migration] Running upgrade 27c6a30d7c24 -> 86770d1215c0, add kubernetes scheduler uniqueness
INFO  [alembic.runtime.migration] Running upgrade 86770d1215c0, 0e2a74e0fc9f -> 05f30312d566, merge heads
INFO  [alembic.runtime.migration] Running upgrade 05f30312d566 -> f23433877c24, fix mysql not null constraint
INFO  [alembic.runtime.migration] Running upgrade f23433877c24 -> 856955da8476, fix sqlite foreign key
INFO  [alembic.runtime.migration] Running upgrade 856955da8476 -> 9635ae0956e7, index-faskfail
Done.
(airflow_c) root@ubuntu:~/airflow#