Connection Pool is full

[Snowrisk]

Hello, The following message appear daily in my Home Assistant log file.

`Logger: urllib3.connectionpool
Quelle: /usr/local/lib/python3.12/site-packages/urllib3/connectionpool.py:323
Erstmals aufgetreten: 24. Juni 2024 um 16:11:33 (5281 Vorkommnisse)
Zuletzt protokolliert: 13:56:35

Connection pool is full, discarding connection: graph.microsoft.com. Connection pool size: 10
Connection pool is full, discarding connection: login.microsoftonline.com. Connection pool size: 10`

Your integration is the only one that communicates with MS365, so I am opening an issue here.

The error did not occur with your other integration O365.

Thanks Jens

[RogerSelwyn]

How many calendars are you retrieving?

[Snowrisk]

14 🙄

---

Von: RogerSelwyn @.> Gesendet: Dienstag, 25. Juni 2024 14:19 An: RogerSelwyn/MS365-Calendar @.> Cc: Jens @.>; Author @.> Betreff: Re: [RogerSelwyn/MS365-Calendar] Connection Pool is full (Issue #5)

How many calendars are you retrieving?

— Reply to this email directly, view it on GitHubhttps://github.com/RogerSelwyn/MS365-Calendar/issues/5#issuecomment-2188786460, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AB46XDDCLWYMCRJHM7HLHF3ZJFN4JAVCNFSM6AAAAABJ3WVUNSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOBYG44DMNBWGA. You are receiving this because you authored the thread.Message ID: @.***>

[RogerSelwyn]

Do you really need 14?

[Snowrisk]

Yes, my problem is that automations with a trigger "calendar event" for all-day appointments unfortunately do not work if I only search for certain terms in the appointment title.

Therefore, I had to create a search device for each term that should trigger a trigger:

• cal_id: XXXXXXX entities:
  • device_id: Kalender_JundS end_offset: 24 name: Kalender Jens und Silke start_offset: 0 track: true
  • device_id: js_urlaub end_offset: 24 name: js_urlaub start_offset: 0 search: "JS: Urlaub" track: true
  • device_id: js_frei end_offset: 24 name: js_frei start_offset: 0 search: "JS: Frei" track: true
  • device_id: sj_urlaub end_offset: 24 name: sj_urlaub start_offset: 0 search: "SJ: Urlaub" track: true
  • device_id: sj_frei end_offset: 24 name: sj_frei start_offset: 0 search: "SJ: Frei" track: true
  • device_id: jsl_urlaub end_offset: 24 name: jsl_urlaub start_offset: 0 search: "JSL: Urlaub" track: true
  • device_id: jsl_frei end_offset: 24 name: jsl_frei start_offset: 0 search: "JSL: Frei" track: true
  • device_id: sjl_urlaub end_offset: 24 name: sjl_urlaub start_offset: 0 search: "SJL: Urlaub" track: true
  • device_id: sjl_frei end_offset: 24 name: sjl_frei start_offset: 0 search: "SJL: Frei" track: true
  • device_id: j_urlaub end_offset: 24 name: j_urlaub start_offset: 0 search: "J: Urlaub" track: true
  • device_id: j_frei end_offset: 24 name: j_frei start_offset: 0 search: "J: Frei" track: true
  • device_id: s_urlaub end_offset: 24 name: s_urlaub start_offset: 0 search: "S: Urlaub" track: true
  • device_id: s_frei end_offset: 24 name: s_frei start_offset: 0 search: "S: Frei" track: true

This is the only way it works for me. So I just check whether one of the triggers is on or off and that's it. I have not found a way to make a regex query within the "search" parameter.

It was like that before and it didn't work:

trigger:

• platform: calendar event: start offset: "-0:1:0" entity_id: calendar.kalender_junds_junds id: start
• platform: calendar event: end offset: "0:1:0" entity_id: calendar.kalender_junds_junds id: ende condition:
• condition: or conditions:
  • condition: template value_template: "{{ 'Urlaub' in trigger.calendar_event.summary }}" enabled: true
  • condition: template value_template: "{{ 'Frei' in trigger.calendar_event.summary }}" enabled: true

The trigger was not executed.

Thanks Jens

---

Von: RogerSelwyn @.> Gesendet: Dienstag, 25. Juni 2024 15:09 An: RogerSelwyn/MS365-Calendar @.> Cc: Jens @.>; Author @.> Betreff: Re: [RogerSelwyn/MS365-Calendar] Connection Pool is full (Issue #5)

Do you really need 14?

— Reply to this email directly, view it on GitHubhttps://github.com/RogerSelwyn/MS365-Calendar/issues/5#issuecomment-2188904964, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AB46XDEKYLESJGC64SX2QLDZJFTXJAVCNFSM6AAAAABJ3WVUNSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOBYHEYDIOJWGQ. You are receiving this because you authored the thread.Message ID: @.***>

[RogerSelwyn]

I’ll take a look when I get back from holiday inn a couple of weeks

[Snowrisk]

Thank you and have a nice vacation!

---

Von: RogerSelwyn @.> Gesendet: Mittwoch, 26. Juni 2024 03:51 An: RogerSelwyn/MS365-Calendar @.> Cc: Jens @.>; Author @.> Betreff: Re: [RogerSelwyn/MS365-Calendar] Connection Pool is full (Issue #5)

I’ll take a look when I get back from holiday inn a couple of weeks

— Reply to this email directly, view it on GitHubhttps://github.com/RogerSelwyn/MS365-Calendar/issues/5#issuecomment-2190381167, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AB46XDAMXNTVXWLDQR27XVDZJINCHAVCNFSM6AAAAABJ3WVUNSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOJQGM4DCMJWG4. You are receiving this because you authored the thread.Message ID: @.***>

[RogerSelwyn]

Yes, my problem is that automations with a trigger "calendar event" for all-day appointments unfortunately do not work if I only search for certain terms in the appointment title.

Back from holiday...

Is this only for all day events? i.e. it will work for non-all-day events. Maybe this is because all-day events by default in MS are marked as "Free" rather than "Busy".

To be honest I don't use the HA Automation platform (it's too obscure for me), I use Node Red. That said I suspect the issue is really in whatever HA core is doing, since if this works for non-all-day events then I'd expect it to work for all-day as well.

To re-work this so that it will handle large numbers of calendars is a major task. A simpler route you can take to get your setup to work (assuming no HA core fix) is to install two instances of the MS-Calendar integration using the same secrets. This would create a second o365 calendars yaml, where you can put half your device_ids.

[Snowrisk]

Thanks, Roger. I will try it with a 2nd configuration.

---

Von: RogerSelwyn @.> Gesendet: Montag, 8. Juli 2024 12:54 An: RogerSelwyn/MS365-Calendar @.> Cc: Jens @.>; Author @.> Betreff: Re: [RogerSelwyn/MS365-Calendar] Connection Pool is full (Issue #5)

Yes, my problem is that automations with a trigger "calendar event" for all-day appointments unfortunately do not work if I only search for certain terms in the appointment title.

Back from holiday...

Is this only for all day events? i.e. it will work for non-all-day events. Maybe this is because all-day events by default in MS are marked as "Free" rather than "Busy".

To be honest I don't use the HA Automation platform (it's too obscure for me), I use Node Red. That said I suspect the issue is really in whatever HA core is doing, since if this works for non-all-day events then I'd expect it to work for all-day as well.

To re-work this so that it will handle large numbers of calendars is a major task. A simpler route you can take to get your setup to work (assuming no HA core fix) is to duplicate your account in your config with a different account name.

So:

o365: accounts:

• account_name: first client_id: my_client_id client_secret: my_client_secret ....
• account_name: second client_id: my_client_id client_secret: my_client_secret ....

This would create a second o365 calendars yaml, where you can put half your device_ids.

— Reply to this email directly, view it on GitHubhttps://github.com/RogerSelwyn/MS365-Calendar/issues/5#issuecomment-2213680929, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AB46XDGVHD55NRO5NUWAR6TZLJVURAVCNFSM6AAAAABJ3WVUNSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMJTGY4DAOJSHE. You are receiving this because you authored the thread.Message ID: @.***>

[github-actions[bot]]

This issue is stale because it has been open for 30 days with no activity.

[github-actions[bot]]

This issue was closed because it has been inactive for 14 days since being marked as stale.