PMM doesnt respect timezone if set to UTC

Description

Looking at PMM 2.26.0 - select timezone as UTC. In Query Analytics

the time shown in the "tooltip" (blue band) is that of my current time zone which is BST

 

Shouldnt PMM respect the timezone selected and so show this across any graph ?

 

 

How to test

Please select timezone as UTC in QAN.

The time shown in the "tooltip" (blue band) will be changed from 'browser' timezone to UTC.

How to document

None

Attachments

10
  • 08 Apr 2023, 01:21 PM
  • 30 Mar 2023, 10:51 AM
  • 30 Mar 2023, 08:36 AM
  • 30 Mar 2023, 08:36 AM
  • 30 Mar 2023, 08:35 AM
  • 28 Sep 2022, 11:20 AM
  • 28 Sep 2022, 11:20 AM
  • 06 Apr 2022, 10:55 AM
  • 06 Apr 2022, 10:54 AM
  • 30 Mar 2022, 12:11 PM

Confluence content

mentioned on

Smart Checklist

Activity

Show:

Ihor Cherkasov April 8, 2023 at 1:24 PM

Why does it need documentation changes?

Removed this point (Needs Doc). If somewhy it's needed - please add it again.

Ihor Cherkasov April 8, 2023 at 1:21 PM

Verified on FB: https://github.com/Percona-Lab/pmm-submodules/pull/3201#issuecomment-1499558008

  • Now after selecting UTC timezone, user is able to see queries time in UTC timezone

  • After selecting any another timezone (except browser and UTC), user will see queries time in timezone selected before (browser or UTC timezone)

Issue found during testing this one: https://jira.percona.com/browse/PMM-11969

So, if user will select time range manually, switching to UTC may not work as expected.

Alexey Mukas April 7, 2023 at 5:03 AM

as of now, it is planned to include fix for UTC in 2.37. It doesn't fix the root cause, it fixes only UTC case.

I created https://jira.percona.com/browse/PMM-11959, I cannot guarantee that it will be fixed in 2.38, but I think it is quite realistic.

I'd suggest you watch this ticket.

cc  

Jiří Čtvrtka March 30, 2023 at 11:54 AM

Thank you for verification. I will start on this one tomorrow. 

Mark Stephenson March 30, 2023 at 10:52 AM

hi customer has checked and as you rightly point out it doesnt respect UTC time. See video attached

Done

Details

Assignee

Reporter

Priority

Needs QA

Yes

Needs Doc

No

Planned Version/s

Fix versions

Story Points

Affects versions

Smart Checklist

Created March 30, 2022 at 1:01 PM
Updated November 13, 2024 at 8:30 AM
Resolved April 10, 2023 at 12:09 PM

Flag notifications