Error in "during" query for specific date/time - Invalid format

[Eric Augustus]

I'm getting an invalid format error for "during" queries using specific date/times which involve the "2 am" time frame. For example, 

This will generate an invalid date error:

project = PROJECT and status changed to Resolved during ("2017/03/12 02:00","2017/03/13 02:00")

If I change the time to 1 min before:

project = PROJECT and status changed to Resolved during ("2017/03/12 01:59","2017/03/13 02:00")

it works, and does not generate an error. For some reason using 2am on 3/12/17 (or 3/12/16), will generate an invalid date error.

I've tested this on JIRA v6.4.12 and v7.2.0, and both show the same behavior. Also, it doesn't seem to matter what project I use. As long as "2017/03/12 02:00" appears as one of the dates, it fails.

Note, the time 2am can also be any time between 02:00 - 02:59, and it will still fail.

Any idea why?

[Eric Augustus]

Not sure when the backup happens, but it is not in the cloud.

I didn't realize it at the time I posted this question, but 2am on 3/12/2017 is when daylight savings time occurred. So, it appears to be an issue with DST. A bug?

[Karalee Kikiros]

So 2am on any other date is okay? is it just on 3/12/2017 that it breaks?

[Eric Augustus]

The bug appears to happen on any of the daylight savings time change start dates.

I tested with 03/12/2017, 03/13/2016, 03/08/2015, and 03/09/2014 and those fail at 2am. 

I also tested with the end of DST, but the bug didn't appear. Only the start of DST at 2am does the bug show.

[Karalee Kikiros]

Whens your backup occurring? Or are you on cloud?