Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-9243

squash KPM plot points are ~8 hours ahead of UTC

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: squash
    • Labels:
      None

      Description

      KPM timeseries plot points are ~8 ahead of US/Pacific and ~16 ahead of UTC.

      See the attached screenshot of the dashboard vs. the corresponding qadb record

      MariaDB [qadb]> select date from dashboard_job order by date desc limit 1;
      +----------------------------+
      | date                       |
      +----------------------------+
      | 2017-02-02 16:39:33.826112 |
      +----------------------------+
      1 row in set (0.00 sec)
      

      My hunch is that bokeh is assuming that data is in the local TZ and doing a -> conversion by default.

        Attachments

          Issue Links

            Activity

            Hide
            afausti Angelo Fausti added a comment -

            Reviewing backlog tickets. Date and time are stored and reported in UTC. This issue is fixed since the migration of the API to Flask (See screenshots attached)

            Show
            afausti Angelo Fausti added a comment - Reviewing backlog tickets. Date and time are stored and reported in UTC. This issue is fixed since the migration of the API to Flask (See screenshots attached)

              People

              Assignee:
              afausti Angelo Fausti
              Reporter:
              jhoblitt Joshua Hoblitt
              Watchers:
              Angelo Fausti, Jonathan Sick, Joshua Hoblitt
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: