Closed jcastro closed 2 years ago
this is a duplicate of https://github.com/blakeblackshear/frigate/issues/3223
I installed back stable-amd64 and also tried with 0.10.1-amd64 and while now the camera is working, I'm getting a weird behavior where each person identification never disappears and it just piles up. The picture below shows 2 times where I entered the room and now I exited it for more than an hour and it's still showing that. Is this a known bug? Did the 0.11 installation mess somehow with something in the migration part? Or is it just me doing something wrong? Thanks!
There's nothing about detection that is stored so it isn't having to do with 0.11. What do your logs say?
@NickM-27 I don't have logger enabled on my config file (if that's what you mean?) but I'm seeing this logs on my docker
There is nothing to migrate
[2022-05-18 22:34:33] peewee_migrate INFO : There is nothing to migrate
[2022-05-18 22:34:33] detector.coral INFO : Starting detection process: 225
[2022-05-18 22:34:33] frigate.app INFO : Output process started: 227
[2022-05-18 22:34:33] frigate.edgetpu INFO : Attempting to load TPU as usb
[2022-05-18 22:34:33] ws4py INFO : Using epoll
[2022-05-18 22:34:33] frigate.app INFO : Camera processor started for entrance_cam: 233
[2022-05-18 22:34:33] frigate.app INFO : Capture process started for entrance_cam: 236
[2022-05-18 22:34:33] ws4py INFO : Using epoll
[2022-05-18 22:34:35] frigate.edgetpu INFO : TPU found
Exception in thread event_processor:
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: NOT NULL constraint failed: event.retain_indefinitely
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/events.py", line 67, in run
Event.replace(
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: NOT NULL constraint failed: event.retain_indefinitely
Thanks!
Okay, so it isn't detection itself that is the issue but you downgraded without restoring the DB. In this case it is failing due to expected fields that are not being inserted in the older version.
Oh I see, I will remove the db file then. Thanks a lot!
In case you didn't see the resolution to the linked ticket: https://github.com/blakeblackshear/frigate/issues/3223#issuecomment-1130630138
This should be closable now 👍
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
Describe the problem you are having
Frigate is loading but I don't get any stream from my camera
Version
0.11.0-beta2
Frigate config file
Relevant log output
FFprobe output from your camera
Frigate stats
Operating system
Proxmox
Install method
Docker Compose
Coral version
USB
Network connection
Wireless
Camera make and model
Aqara G2H
Any other information that may be helpful
I had stable-amd64 docker image working flawlessly before tried to upgrade to 0.11 beta-2. Hope it helps and thanks a lot