After upgrade to 2022.11.1 google calendar starttime is an hour earlier #81527

MagieMalone · 2022-11-04T06:49:56Z

The problem

Google calendar start time seems to have become an hour earlier, while the calendar entry has not changed, after installing 2022.11.1

What version of Home Assistant Core has the issue?

core-2022.11.1

What was the last working version of Home Assistant Core?

core-2022.10.6

What type of installation are you running?

Home Assistant OS

Integration causing the issue

google calendar

Link to integration documentation on our website

https://www.home-assistant.io/integrations/google/

Diagnostics information

No response

Example YAML snippet

template:
  - sensor:
      - name: calc_leave_time_alarm
        unique_id: "e9dce637-9b57-4321-8b95-10e2b9e56411"
        device_class: "timestamp"
        state: >
          {%- if state_attr('calendar.alarm', 'message')  is search('#bike', ignorecase=true) %}
            {%- if states('sensor.here_travel_time_alarm_bike_duration') == None %}
              {%- set offset = timedelta(minutes=0) %}
            {%- else %}
              {%- set offset = timedelta(minutes=states('sensor.here_travel_time_alarm_bike_duration')|int) %}
            {%- endif %}
          {%- else %}
            {%- if states('sensor.here_travel_time_alarm_duration_in_traffic') == None %}
              {%- set offset = timedelta(minutes=5) %}
            {%-  else %}
              {%- set offset = timedelta(minutes=states('sensor.here_travel_time_alarm_duration_in_traffic')|int +5)  %}
            {%- endif %} 
          {%- endif %}
          {{- (state_attr('calendar.alarm', 'start_time')| as_datetime - offset).astimezone()}}

Anything in the logs that might be useful for us?

no.

Additional information

Time jumped an hour after installing 2022.11.1, however, release notes don't mention a breaking change.

I copy the attribute into a template sensor (see yaml snippet) and this show the change to an hour earlier:

Also in developer tools the time is an hour earlier then the actual calendar entry:
{{state_attr('calendar.alarm', 'start_time')}}

Result type: string
2022-11-07 05:30:00

The text was updated successfully, but these errors were encountered:

home-assistant · 2022-11-04T06:50:00Z

Hey there @allenporter, mind taking a look at this issue as it has been labeled with an integration (google) you are listed as a code owner for? Thanks!

Code owner commands

Code owners of google can trigger bot actions by commenting:

@home-assistant close Closes the issue.
@home-assistant rename Awesome new title Change the title of the issue.
@home-assistant reopen Reopen the issue.
@home-assistant unassign google Removes the current integration label and assignees on the issue, add the integration domain after the command.

_{^{(message by CodeOwnersMention)}}

google documentation
google source
_{^{(message by IssueLinks)}}

tunisiano187 · 2022-11-04T07:03:04Z

Hello,
Same for me, i'm currently making tests, but a strange thing is that with my new events, it's not the case...
i'll continue my searchs, but... interested of course if someone else find the solution earlier ;-)

blair287 · 2022-11-04T07:36:18Z

Same issue here.

FL100 · 2022-11-04T07:47:40Z

Idem.
When I see the calendars in HA all seem OK except the calendar that I use for this integration. In the later all items are shifted an hour earlier after the new HA release was installed.

sebfar9172 · 2022-11-04T07:54:05Z

Hello
I confirm the problem but it's not for all my events

realthk · 2022-11-04T08:04:10Z

Same here, some events fine, but most are an hour early since the DST period end (I don't think it has anything to do with 2011.11.1, I reckon the bug might have been already there with 2011.10.x - though not sure, we weren't home between the time change and 11.1), and all of these (recurring events) were added weeks, months ago.

In Google events follow each other hourly, except for a lunch break:

But in HA most of those an hour early:

blair287 · 2022-11-04T08:45:53Z

Same here, some events fine, but most are an hour early since the DST period end (I don't think it has anything to do with 2011.11.1, I reckon the bug was already there with 2011.10.x), though of course all of these were added weeks, months ago.

In Google events follow each other hourly, except for a lunch break:

But in HA most of those an hour early:

Mine was working fine yesterday even after the clock change only had issue after update to 2022.11

blair287 · 2022-11-04T08:46:57Z

Time shifted hour earlier in HA these are reoccurring events. My one off event seem to still be correct.

titiviking · 2022-11-04T08:50:04Z

On top of the mentioned issue, I'm also facing the issue the the calendar in HA is not getting updated anymore... I've removed events from google that remain visible/present in HA calendar...
Anyone having this behaviour as well ?

21Development · 2022-11-04T09:05:06Z

I am having the same issue of calendar offset, here’s what I have identified so far:

Google calendar shows correct times if I log in directly to Google
Home assistant host OS has the correct time set
Home assistant has the correct timezone set
All events in my calendar are offset -1hr when viewed in HA calendar
Events were working correctly after the clocks changed on Sunday
Noticed the incorrect timing last night, following upgrade to 2022.11.1

marc115uk · 2022-11-04T09:38:28Z

Same here seemed to break with the update to 2022.11.0 was correct the day before I upgraded. Seems to report correctly with any new event added but incorrectly with existing events

MagieMalone · 2022-11-04T12:01:34Z

made a new recurring appointment, but that works correctly indeed, the same as a new single event. It's just the old already planned (in my case) recurring events. I can confirm it's not DST end, as the events on monday - thursday all went fine, only after I Installed 2022.11.1 yesterday the issue began.

allenporter · 2022-11-04T12:28:47Z

Calendar had a large rewrite to sync and serve from local so that's definitely the issue. Wasn't a breaking change, but a bug here.

Thanks for the reports.

21Development · 2022-11-04T12:35:57Z

Due to some other issues, I've just restored my 2022.11.0 backup, checked the calendar and it was still the same. Proceeded to restore my 2022.10.5 backup and my calendar entries are now showing the correct time.

(I previously tried disabling the calendar(s) restarting HA 2022.11.1 and then reenabling them which didn't solve the issue)

allenporter · 2022-11-04T12:37:01Z

Can someone give an example timezone this happens? Also curious if home assistant is in the same time zone or different time zone from the Google calendar timezone.

Having some of the raw debug from gcal_sync.auth for one example event could help though may be private info that would need stripping.

21Development · 2022-11-04T12:39:48Z

I am in GMT - HA is set to GMT and Google shows the correct times when logging in directly

MagieMalone · 2022-11-04T12:45:05Z

I'm on GMT+1, set both in Google calendar ( Central European Time - Amsterdam) and in HA (Europe/Amsterdam) and I see the issue.

sebfar9172 · 2022-11-04T12:45:16Z

i am in GMT+1 HA is set to GMT+1 and google GMT+1

realthk · 2022-11-04T12:54:37Z

I'm in GMT+1 zone, both in Google an HA.
Here is debug log from gcal_sync.auth. Sorry for it is quite long, as I have many calendars in Google, but I did not want to strip out anything that might be important. The only one used in HA is with its etag replaced to "zzzzzzzzzzzzzzz" in this log:
2022-11-04 13:41:44.793 DEBUG (MainThread) [gcal_sync.auth] response={'kind': 'calendar#calendarList', 'etag': '"p33sa17ufoaafm0g"', 'nextSyncToken': 'xxxxxxxxxxxxxx', 'items': [{'kind': 'calendar#calendarListEntry', 'etag': '"xxxxxxxx"', 'id': 'p#weather@group.v.calendar.google.com', 'summary': 'Időjárás', 'description': 'A lakóhelynek megfelelő napi időjárás-előrejelzés', 'timeZone': 'Europe/Budapest', 'summaryOverride': 'Weather', 'colorId': '15', 'backgroundColor': '#9fc6e7', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'reader', 'defaultReminders': [], 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}, {'kind': 'calendar#calendarListEntry', 'etag': '"xxxxxxx"', 'id': 'realthk@gmail.com', 'summary': 'realthk@gmail.com', 'timeZone': 'Europe/Budapest', 'colorId': '14', 'backgroundColor': '#9fe1e7', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'owner', 'defaultReminders': [{'method': 'popup', 'minutes': 10}, {'method': 'email', 'minutes': 10}], 'notificationSettings': {'notifications': [{'type': 'eventCreation', 'method': 'email'}, {'type': 'eventChange', 'method': 'email'}, {'type': 'eventCancellation', 'method': 'email'}, {'type': 'eventResponse', 'method': 'email'}]}, 'primary': True, 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}, {'kind': 'calendar#calendarListEntry', 'etag': '"xxxxxxxx"', 'id': 'xxxxxxxx4@group.calendar.google.com', 'summary': 'Fejlesztők', 'description': 'DM-os fejlesztői naptár', 'timeZone': 'Europe/Budapest', 'colorId': '15', 'backgroundColor': '#9fc6e7', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'owner', 'defaultReminders': [], 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}, {'kind': 'calendar#calendarListEntry', 'etag': '"xxxxxxx"', 'id': 'hu.hungarian#holiday@group.v.calendar.google.com', 'summary': 'Ünnepnapok – Magyarország', 'description': 'Ünnepnapok és hagyományok – Magyarország', 'timeZone': 'Europe/Budapest', 'summaryOverride': 'Ünnepnapok – Magyarország', 'colorId': '7', 'backgroundColor': '#42d692', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'reader', 'defaultReminders': [], 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}, {'kind': 'calendar#calendarListEntry', 'etag': '"xxxxxxx"', 'id': 'familyxxxxxxx@group.calendar.google.com', 'summary': 'Családi', 'timeZone': 'UTC', 'colorId': '17', 'backgroundColor': '#9a9cff', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'writer', 'defaultReminders': [{'method': 'popup', 'minutes': 10}, {'method': 'email', 'minutes': 10}], 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}, {'kind': 'calendar#calendarListEntry', 'etag': '"xxxxxxx"', 'id': 'xxxxxxxg@group.calendar.google.com', 'summary': 'Telefonhívások', 'timeZone': 'Europe/Budapest', 'colorId': '20', 'backgroundColor': '#cabdbf', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'owner', 'defaultReminders': [], 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}, {'kind': 'calendar#calendarListEntry', 'etag': '"1623307964726000"', 'id': 'en.hungarian#holiday@group.v.calendar.google.com', 'summary': 'Holidays in Hungary', 'description': 'Holidays and Observances in Hungary', 'timeZone': 'Europe/Budapest', 'summaryOverride': 'Holidays in Hungary', 'colorId': '8', 'backgroundColor': '#16a765', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'reader', 'defaultReminders': [], 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}, {'kind': 'calendar#calendarListEntry', 'etag': '"1646341642788000"', 'id': 'rkhhbddeifkbcik8pst5ipsq4jqj4s36@import.calendar.google.com', 'summary': 'https://www.f1calendar.com/download/f1-calendar_q_gp_alarm-20.ics?t=1582025642623', 'timeZone': 'UTC', 'colorId': '8', 'backgroundColor': '#16a765', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'reader', 'defaultReminders': [], 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}, {'kind': 'calendar#calendarListEntry', 'etag': '"xxxxxxxx"', 'id': 'xxxxxxxxxx@group.calendar.google.com', 'summary': 'Családi események', 'timeZone': 'Europe/Budapest', 'colorId': '3', 'backgroundColor': '#f83a22', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'owner', 'defaultReminders': [], 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}, {'kind': 'calendar#calendarListEntry', 'etag': '"zzzzzzzzzzzzzzz"', 'id': 'zzzzzzzzzzzzzzz@googlemail.com', 'summary': 'zzzzzzzzzzzzzzz@googlemail.com', 'timeZone': 'Europe/Budapest', 'colorId': '5', 'backgroundColor': '#ff7537', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'reader', 'defaultReminders': [], 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}, {'kind': 'calendar#calendarListEntry', 'etag': '"1667564698024000"', 'id': '5s59gaimrq1e2u9ej2qbeoru2o@group.calendar.google.com', 'summary': 'Magyar névnapok', 'timeZone': 'Europe/Budapest', 'colorId': '11', 'backgroundColor': '#fbe983', 'foregroundColor': '#000000', 'selected': True, 'accessRole': 'owner', 'defaultReminders': [], 'conferenceProperties': {'allowedConferenceSolutionTypes': ['hangoutsMeet']}}]}

allenporter · 2022-11-04T13:21:19Z

@realthk thanks that helps. I realize the local calendar event data is also stored in config/.storage/google.xxxxx so maybe you can also snag one event record that shows the problem and let me know the expected time and actual time.

Thank you all, hopefully we can get a quick fix out once I can reproduce.

allenporter · 2022-11-04T13:44:15Z

Seems like the most likely thing for me to explore to reproduce is for a recurring event that crosses the daylight savings time boundary.

realthk · 2022-11-04T13:52:28Z

Exactly, @allenporter. The file from Google in .storage is a mess for human eyes, events with the same name occuring several times, I have to find the latest in effect, but it seems the problem is with crossing the DST boundary with a recurring event indeed.

For example, from my screenshot above "Isti" should be at 13:00, and because it was created in september, still during DST, it got GMT+2, which isn't valid anymore, after DST has ended, it should be GMT+1 now (but do not understand then why it works fine for those who restore HA version 2022.10.x...

            "1ookvdm08gqvkheintf7u8folo": {
              "id": "1ookvdm08gqvkheintf7u8folo",
              "ical_uuid": null,
              "summary": "Isti",
              "start": {
                "date": null,
                "date_time": "2022-09-09T13:00:00+02:00",
                "timezone": "Europe/Budapest"
              },
              "end": {
                "date": null,
                "date_time": "2022-09-09T14:00:00+02:00",
                "timezone": "Europe/Budapest"
              },
              "description": null,
              "location": null,
              "transparency": "opaque",
              "status": "confirmed",
              "event_type": "default",
              "visibility": "default",
              "attendees": [],
              "attendees_omitted": false,
              "recurrence": [
                "RRULE:FREQ=WEEKLY;BYDAY=FR"
              ],
              "recurring_event_id": null,
              "original_start_time": null
            },

allenporter · 2022-11-04T14:05:55Z

Thank you for confirming, i'll get started on trying to reproduce this with a test and working on a fix. No other data needed from users now, thank you all for your patience.

allenporter · 2022-11-04T14:13:14Z

Also to answer your question about 2022.10 vs 2022.11 it's because I added a bug. The context is because in preparation for being able to create/delete calendar events in a future release(!) in the home assistant UI (including recurring events and a local calendar integration) we're now syncing events down to device and expanding them locally. This is instead of repeatedly polling the calendar data, we're now following best practices for efficient sync. However, this is a bug in the common library that handles the expansion logic.

allenporter · 2022-11-04T15:47:52Z

I've reproduced the bug in the underlying gcal_sync library allenporter/gcal_sync#137 and will be pulling in a patch soon.

blair287 · 2022-11-04T20:33:21Z

Wow that was fast thanks a lot. Great work.

MagieMalone · 2022-11-05T08:14:59Z

Thanks a lot for all the work!

FL100 · 2022-11-05T10:43:51Z

Indeed - many thanks for a good job. B.t.w. I love the Google Agenda solution and use it for many things. I find it one of the most handy and amazing things in my HA setup.

home-assistant bot added the integration: google label Nov 4, 2022

home-assistant bot assigned allenporter Nov 4, 2022

allenporter mentioned this issue Nov 4, 2022

Bump gcal_sync to 4.0.0 #81562

Merged

19 tasks

allenporter added this to the 2022.11.2 milestone Nov 4, 2022

allenporter mentioned this issue Nov 5, 2022

Support DATE values for UNTIL parts of recurrence rule allenporter/ical#129

Merged

allenporter closed this as completed in #81562 Nov 6, 2022

allenporter mentioned this issue Nov 6, 2022

Google calendar integration reports offset time when region in DST #81648

Closed

MJHeijster mentioned this issue Nov 7, 2022

Google calendar integration setting a time offset after dst #81713

Closed

This was referenced Nov 11, 2022

Google calendar integration ignores end of daylight savings #81947

Closed

Google calendar not adjusting the event time to dst change #81645

Closed

github-actions bot locked and limited conversation to collaborators Dec 9, 2022

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

After upgrade to 2022.11.1 google calendar starttime is an hour earlier #81527

After upgrade to 2022.11.1 google calendar starttime is an hour earlier #81527

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

After upgrade to 2022.11.1 google calendar starttime is an hour earlier #81527

After upgrade to 2022.11.1 google calendar starttime is an hour earlier #81527

Comments

The problem

What version of Home Assistant Core has the issue?

What was the last working version of Home Assistant Core?

What type of installation are you running?

Integration causing the issue

Link to integration documentation on our website

Diagnostics information

Example YAML snippet

Anything in the logs that might be useful for us?

Additional information

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!