Possible DST change issue in Home Assistant

[Ysbrand]

Hi,

This is not really Frigate related, but as we have seen in Europe this issue will possibly impact Frigate operations.

There is an issue in HA (core-2021.10.6 and below) which caused a lot of systems in Europe to fail after switching to Wintertime. This also caused my Frigate instance to stop recording. A restart fixed things, but obviously all details between the time switch and the time of reboot are lost.

Fortunately, they have released a fix in core-2021.10.7. Obviously it might make sense to upgrade before the upcoming weekend (assuming you are in the USA)

[alexmarsaudon]

I am running Frigate on a separate device from my HA, and use the Frigate Proxy to present to HA. My HA is current, as is my Frigate docker container. Unfortunately my Frigate container still tanked right at the DST time change this morning ( PDT --> PST ). Might be a random fluke / unrelated to the time change, I still found it odd though. My Frigate installation is normally pretty damn solid! Curious if others experienced this.

[blakeblackshear]

I definitely did.

[alexmarsaudon]

Ok! On the off chance this is relevant:
Docker container does have an environment variable flipping TZ to TZ=America/Los_Angeles
Docker host is Ubuntu 20.04.3 LTS on baremetal (Intel NUC7). Host has /etc/timezone defined as America/Los_Angeles as well.
Minus proxying my frigate instance, HA has no involvement except for the fact that it hosts the MQTT server I am using for frigate.
Actual crash in the docker containers logs appears to be the following:

Exception in thread recording_maint:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 3129, in execute_sql
cursor.execute(sql, params or ())
sqlite3.IntegrityError: UNIQUE constraint failed: recordings.path

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/lib/python3.8/threading.py", line 932, in _bootstrap_inner
self.run()
File "/opt/frigate/frigate/record.py", line 137, in run
self.move_files()
File "/opt/frigate/frigate/record.py", line 123, in move_files
Recordings.create(
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 6324, in create
inst.save(force_insert=True)
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 6534, in save
pk = self.insert(**field_dict).execute()
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 1898, in inner
return method(self, database, *args, **kwargs)
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 1969, in execute
return self._execute(database)
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 2730, in _execute
return super(Insert, self)._execute(database)
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 2466, in _execute
return self.handle_result(database, cursor)
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 2739, in handle_result
return database.last_insert_id(cursor, self._query_type)
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 3218, in last_insert_id
return cursor.lastrowid
File "/usr/local/lib/python3.8/dist-packages/playhouse/sqliteq.py", line 88, in lastrowid
self._wait()
File "/usr/local/lib/python3.8/dist-packages/playhouse/sqliteq.py", line 63, in _wait
raise self._exc
File "/usr/local/lib/python3.8/dist-packages/playhouse/sqliteq.py", line 178, in execute
cursor = self.database._execute(obj.sql, obj.params, obj.commit)
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 3136, in execute_sql
self.commit()
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 2902, in exit
reraise(new_type, new_type(exc_value, *exc_args), traceback)
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 185, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/python3.8/dist-packages/peewee.py", line 3129, in execute_sql
cursor.execute(sql, params or ())
peewee.IntegrityError: UNIQUE constraint failed: recordings.path