Dundo777 commented on issue #13529: URL: https://github.com/apache/airflow/issues/13529#issuecomment-757956126
The problem is related to my previous comment that timestamps that are being compared are different. In task_instance table default value of execution_date is current_timestamp(6) with on update current_timestamp(6). Since my timezone in MariaDB is setup to SYSTEM which is set to Europe/Zagreb it will save timestamp in my local time instead of utc. When I altered table to default utc_timestamp(6) on update utc_timestamp(6) everything is working fine. Another option is to change the database timezone. This means that it is assumed that metadata db timezone will be utc. Since this is not mentioned anywhere in the documentation, I'm wondering if this is expected behaviour? And it looks like there should be option to change that or insist on utc for database backend. ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
