[GitHub] [airflow] Bowrna commented on issue #19104: airflow db reset throws error while initialising breeze with python version 3.8 and mysql as backend

[GitBox]

Bowrna commented on issue #19104:
URL: https://github.com/apache/airflow/issues/19104#issuecomment-948307343


   On further verification,
   
   I connected to the mysql that starts up as docker container via 
docker-compose as part of airflow installation and found `airflow` database 
created there. 
   
   I verified `explicit_defaults_for_timestamp` key and found out it is OFF. 
Attaching the screenshots for more clarification,
   <img width="1259" alt="Screenshot 2021-10-21 at 12 13 03 PM" 
src="https://user-images.githubusercontent.com/10162465/138225382-76acc9d5-61e9-4bf8-bef2-de2949d2de8f.png";>
   <img width="1024" alt="Screenshot 2021-10-21 at 12 14 22 PM" 
src="https://user-images.githubusercontent.com/10162465/138225416-be7c6de6-1968-450b-ad6d-5f77412fb0ee.png";>
   
   I connected to the mysql running in port 23306 via tcp to check this. That 
mysql(version 5.7) has started as part of airflow installation. Is it expected 
to have `explicit_defaults_for_timestamp ` key set ON by default.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@airflow.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org