Digging in a bit further. 

{{{{ ti.dag_id }}}}/{{{{ ti.task_id }}}}/{{{{ ts }}}}/{{{{ try_number }}}}.log

is the format

ts = execution_date.isoformat and should be in UTC afaik.

something is weird tbh.

B.


> On 5 Aug 2018, at 21:32, Bolke de Bruin <bdbr...@gmail.com> wrote:
> 
> 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
>>>> 
>>> 
>> 
> 

Reply via email to