Ash, Reading your proposed changes on your “set-timezone-to-utc” branch and below analysis, I am not sure what you are perceiving as an issue.
For conversion we assume everything is stored in UTC and in a naive format. Conversion then adds the timezone information. This results in the following postgres timezone = “Europe/Amsterdam” airflow=# select * from task_instance; get_op | example_http_operator | 2018-07-27 02:00:00+02 airflow=# set timezone=UTC; airflow=# select * from task_instance; get_op | example_http_operator | 2018-07-27 00:00:00+00 If we don’t set the timezone in the connection postgres assumes server timezone (in my case “Europe/Amsterdam”). So every datetime Airflow receives will be in “Europe/Amsterdam” format. However as we defined the model to use UTCDateTime it will always convert the returned DateTime to UTC. If we have configured Airflow to support something else as UTC as the default timezone or a DAG has a associated timezone we only convert to that timezone when calculating the next runtime (not for cron btw). Nowhere else and thus we are UTC everywhere. What do you think is inconsistent? Bolke > On 5 Aug 2018, at 18:13, Ash Berlin-Taylor <ash_airflowl...@firemirror.com> > wrote: > > Relating to 2): I'm not sure that the upgrade from timezoneless to timezone > aware colums in the task instance is right, or at least it's not what I > expected. > > Before weren't all TZs from schedule dates etc in UTC? For the same task > instance (these outputs from psql directly): > > before: execution_date=2017-09-04 00:00:00 > after: execution_date=2017-09-04 01:00:00+01 > > **Okay the migration is fine**. It appears that the migration has done the > right thing, but my local DB I'm testing with has a Timezone of GB set, so > Postgres converts it to that TZ on returning an object. > > 3) Do we need to set the TZ of the connection to UTC in SQLAlchemy to have > consistent behaviour? Is this possible some how? I don't know SQLAlchemy that > well. > > > -ash > >> On 5 Aug 2018, at 16:01, Ash Berlin-Taylor <ash_airflowl...@firemirror.com> >> wrote: >> >> 1.) Missing UPDATING note about change of task_log_reader to now always >> being "task" (was "s3.task" before.). Logging config is much simpler now >> though. This may be particular to my logging config, but given how much of a >> pain it was to set up S3 logging in 1.9 I have shared my config with some >> people in the Gitter chat so It's not just me. >> >> 2) The path that log-files are written to in S3 has changed (again - this >> happened from 1.8 to 1.9). I'd like to avoid having to move all of my log >> files again to continue viewing them. The change is that the path now (in >> 1.10) has a timezone in it, and the date is in local time, before it was UTC: >> >> before: 2018-07-23T00:00:00/1.log >> after: 2018-07-23T01:00:00+01:00/1.log >> >> We can possibly get away with an updating note about this to set a custom >> log_filename_template. Testing this now. >> >>> On 5 Aug 2018, at 15:00, Ash Berlin-Taylor <a...@firemirror.com> wrote: >>> >>> -1(binding) from me. >>> >>> Installed with: >>> >>> AIRFLOW_GPL_UNIDECODE=yes pip install >>> 'https://dist.apache.org/repos/dist/dev/incubator/airflow/1.10.0rc3/apache-airflow-1.10.0rc3+incubating-bin.tar.gz#egg=apache-airflow[emr >>> >>> <https://dist.apache.org/repos/dist/dev/incubator/airflow/1.10.0rc3/apache-airflow-1.10.0rc3+incubating-bin.tar.gz#egg=apache-airflow[emr>, >>> s3, crypto]>=1.10' >>> >>> Install went fine. >>> >>> Our DAGs that use SparkSubmitOperator are now failing as there is now a >>> hard dependency on the Kubernetes client libs, but the `emr` group doesn't >>> mention this. >>> >>> Introduced in https://github.com/apache/incubator-airflow/pull/3112 >>> <https://github.com/apache/incubator-airflow/pull/3112> >>> >>> I see two options for this - either conditionally enable k8s:// support if >>> the import works, or (less preferred) add kube-client to the emr deps >>> (which I like less) >>> >>> Sorry - this is the first time I've been able to test it. >>> >>> I will install this dep manually and continue testing. >>> >>> -ash >>> >>> (Normally no time at home due to new baby, but I got a standing desk, and a >>> carrier meaning she can sleep on me and I can use my laptop. Win!) >>> >>> >>> >>>> On 4 Aug 2018, at 22:32, Bolke de Bruin <bdbr...@gmail.com >>>> <mailto:bdbr...@gmail.com>> wrote: >>>> >>>> Bump. >>>> >>>> Committers please cast your vote. >>>> >>>> B. >>>> >>>> Sent from my iPhone >>>> >>>>> On 3 Aug 2018, at 13:23, Driesprong, Fokko <fo...@driesprong.frl >>>>> <mailto:fo...@driesprong.frl>> wrote: >>>>> >>>>> +1 Binding >>>>> >>>>> Installed it using: SLUGIFY_USES_TEXT_UNIDECODE=yes pip install >>>>> https://dist.apache.org/repos/dist/dev/incubator/airflow/1.10.0rc3/apache-airflow-1.10.0rc3+incubating-bin.tar.gz >>>>> >>>>> <https://dist.apache.org/repos/dist/dev/incubator/airflow/1.10.0rc3/apache-airflow-1.10.0rc3+incubating-bin.tar.gz> >>>>> >>>>> Cheers, Fokko >>>>> >>>>> 2018-08-03 9:47 GMT+02:00 Bolke de Bruin <bdbr...@gmail.com>: >>>>> >>>>>> Hey all, >>>>>> >>>>>> I have cut Airflow 1.10.0 RC3. This email is calling a vote on the >>>>>> release, >>>>>> which will last for 72 hours. Consider this my (binding) +1. >>>>>> >>>>>> Airflow 1.10.0 RC 3 is available at: >>>>>> >>>>>> https://dist.apache.org/repos/dist/dev/incubator/airflow/1.10.0rc3/ < >>>>>> https://dist.apache.org/repos/dist/dev/incubator/airflow/1.10.0rc3/> >>>>>> >>>>>> apache-airflow-1.10.0rc3+incubating-source.tar.gz is a source release >>>>>> that >>>>>> comes with INSTALL instructions. >>>>>> apache-airflow-1.10.0rc3+incubating-bin.tar.gz is the binary Python >>>>>> "sdist" >>>>>> release. >>>>>> >>>>>> Public keys are available at: >>>>>> >>>>>> https://dist.apache.org/repos/dist/release/incubator/airflow/ < >>>>>> https://dist.apache.org/repos/dist/release/incubator/airflow/> >>>>>> >>>>>> The amount of JIRAs fixed is over 700. Please have a look at the >>>>>> changelog. >>>>>> Since RC2 the following has been fixed: >>>>>> >>>>>> * [AIRFLOW-2817] Force explicit choice on GPL dependency >>>>>> * [AIRFLOW-2716] Replace async and await py3.7 keywords >>>>>> * [AIRFLOW-2810] Fix typo in Xcom model timestamp >>>>>> >>>>>> Please note that the version number excludes the `rcX` string as well >>>>>> as the "+incubating" string, so it's now simply 1.10.0. This will allow >>>>>> us >>>>>> to rename the artifact without modifying the artifact checksums when we >>>>>> actually release. >>>>>> >>>>>> WARNING: Due to licensing requirements you will need to set >>>>>> SLUGIFY_USES_TEXT_UNIDECODE=yes in your environment when >>>>>> installing or upgrading. We will try to remove this requirement for the >>>>>> next release. >>>>>> >>>>>> Cheers, >>>>>> Bolke >>> >> >
