blakeblackshear / frigate

NVR with realtime local object detection for IP cameras
https://frigate.video
MIT License
18.94k stars 1.73k forks source link

[Support]: Recording never working #2359

Closed aforch closed 2 years ago

aforch commented 2 years ago

Describe the problem you are having

Single camera (so far) installation, recording for events never generates a recording/clip. Event snapshots are created, but clicking on clip results in "The media could not be loaded, either because the server or network failed or because the format is not supported."
Download of event recording results in a broken clip.htm download. Detection is currently working great by CPU.

Deployment details:
Proxmox hypervisor, Ubuntu 18.04.3 LTS
Storage is NFS mounted FreeNAS store. Database stored locally on SSD. Docker compose:

  frigate:
    container_name: frigate
    privileged: true # this may not be necessary for all setups
    restart: unless-stopped
    image: blakeblackshear/frigate:0.9.1-amd64
    shm_size: "64mb" # update for your cameras based on calculation above
    #    devices:
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - /mnt/docker_data/frigate/config/config.yml:/config/config.yml:ro
      - /mnt/frigate:/media/frigate
      - /configs/frigate/database:/db
      - type: tmpfs # Optional: 1GB of memory, reduces SSD/SD Card wear
        target: /tmp/cache
        tmpfs:
          size: 1000000000
    ports:
      - "5000:5000"
      - "1935:1935" # RTMP feeds
    environment:
      FRIGATE_RTSP_PASSWORD: <password>

Version

0.9.1, 0.9.4, 0.10.0 problem persists across all 3 tried

Frigate config file

mqtt:
  host: 192.168.3.9
  user: frigate
  password: <password>

database:
  path: /db/frigate.db

logger:
  default: info
  logs:
    frigate.app: debug

cameras:
  doorbell:
    ffmpeg:
      inputs:
        - path: rtsp://<user>:<password>@192.168.3.27:554
          roles:
            - detect
            - record
    detect:
      width: 1920
      height: 1080
    objects:
      track:
        - person
      filters:
        person:
          mask: 0,438,1312,345,1319,841,0,1004
    snapshots:
      enabled: True
    motion:
      mask: 1920,0,1920,134,1314,312,1314,907,980,994,0,1009,0,0
    record:
      enabled: True
      retain_days: 0
      events:
        max_seconds: 300
        # pre_capture: 15
        #post_capture: 15
        retain:
          default: 10

Relevant log output

frigate                       | [services.d] starting services
frigate                       | [services.d] done.
frigate                       | [2021-12-01 14:58:23] frigate.app                    INFO    : Starting Frigate (0.9.1-800f33e)
frigate                       | [2021-12-01 14:58:23] frigate.app                    WARNING : Camera doorbell has rtmp enabled, but rtmp is not assigned to an input.
frigate                       | Starting migrations
frigate                       | [2021-12-01 14:58:23] peewee_migrate                 INFO    : Starting migrations
frigate                       | [2021-12-01 14:58:23] peewee                         DEBUG   : ('CREATE TABLE IF NOT EXISTS "migratehistory" ("id" INTEGER NOT NULL PRIMARY KEY, "name" VARCHAR(255) NOT NULL, "migrated_at" DATETIME NOT NULL)', [])
frigate                       | [2021-12-01 14:58:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."name", "t1"."migrated_at" FROM "migratehistory" AS "t1" ORDER BY "t1"."id"', [])
frigate                       | There is nothing to migrate
frigate                       | [2021-12-01 14:58:23] peewee_migrate                 INFO    : There is nothing to migrate
frigate                       | [2021-12-01 14:58:23] frigate.mqtt                   INFO    : MQTT connected
frigate                       | [2021-12-01 14:58:23] frigate.app                    INFO    : Output process started: 213
frigate                       | [2021-12-01 14:58:23] frigate.app                    INFO    : Camera processor started for doorbell: 215
frigate                       | [2021-12-01 14:58:23] detector.cpu                   INFO    : Starting detection process: 211
frigate                       | [2021-12-01 14:58:23] frigate.edgetpu                WARNING : CPU detectors are not recommended and should only be used for testing or for trial purposes.
frigate                       | [2021-12-01 14:58:23] frigate.app                    INFO    : Capture process started for doorbell: 216
frigate                       | [2021-12-01 14:58:23] ws4py                          INFO    : Using epoll
frigate                       | [2021-12-01 14:58:23] ws4py                          INFO    : Using epoll
frigate                       | [2021-12-01 14:58:28] frigate.record                 WARNING : Discarding a corrupt recording segment: doorbell-20211201121116.mp4
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : Start expire recordings (new).
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : Start deleted cameras.
frigate                       | [2021-12-01 14:59:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" NOT IN (?)) AND ("t1"."end_time" < ?))', ['doorbell', 1638367163.821984])
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 14:59:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 14:59:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : End deleted cameras.
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : Start all cameras.
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : Start camera: doorbell.
frigate                       | [2021-12-01 14:59:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" = ?) AND ("t1"."end_time" < ?)) ORDER BY "t1"."start_time"', ['doorbell', 1638366863.828366])
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 14:59:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 14:59:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : End camera: doorbell.
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : End all cameras.
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : End expire recordings (new).
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : Start expire files (legacy).
frigate                       | [2021-12-01 14:59:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" ORDER BY "t1"."start_time" DESC LIMIT ? OFFSET ?', [1, 0])
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : Oldest recording in the db: 1638367163.833912
frigate                       | [2021-12-01 14:59:23] frigate.record                 DEBUG   : End expire files (legacy).
frigate                       | [2021-12-01 14:59:33] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/stats.
frigate                       | [2021-12-01 15:00:23] frigate.record                 DEBUG   : Start expire recordings (new).
frigate                       | [2021-12-01 15:00:23] frigate.record                 DEBUG   : Start deleted cameras.
frigate                       | [2021-12-01 15:00:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" NOT IN (?)) AND ("t1"."end_time" < ?))', ['doorbell', 1638367223.847944])
frigate                       | [2021-12-01 15:00:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:00:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:00:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:00:23] frigate.record                 DEBUG   : End deleted cameras.
frigate                       | [2021-12-01 15:00:23] frigate.record                 DEBUG   : Start all cameras.
frigate                       | [2021-12-01 15:00:23] frigate.record                 DEBUG   : Start camera: doorbell.
frigate                       | [2021-12-01 15:00:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" = ?) AND ("t1"."end_time" < ?)) ORDER BY "t1"."start_time"', ['doorbell', 1638366923.850816])
frigate                       | [2021-12-01 15:00:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:00:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:00:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:00:23] frigate.record                 DEBUG   : End camera: doorbell.
frigate                       | [2021-12-01 15:00:23] frigate.record                 DEBUG   : End all cameras.
frigate                       | [2021-12-01 15:00:23] frigate.record                 DEBUG   : End expire recordings (new).
frigate                       | [2021-12-01 15:00:33] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/stats.
frigate                       | [2021-12-01 15:01:23] frigate.record                 DEBUG   : Start expire recordings (new).
frigate                       | [2021-12-01 15:01:23] frigate.record                 DEBUG   : Start deleted cameras.
frigate                       | [2021-12-01 15:01:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" NOT IN (?)) AND ("t1"."end_time" < ?))', ['doorbell', 1638367283.856864])
frigate                       | [2021-12-01 15:01:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:01:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:01:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:01:23] frigate.record                 DEBUG   : End deleted cameras.
frigate                       | [2021-12-01 15:01:23] frigate.record                 DEBUG   : Start all cameras.
frigate                       | [2021-12-01 15:01:23] frigate.record                 DEBUG   : Start camera: doorbell.
frigate                       | [2021-12-01 15:01:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" = ?) AND ("t1"."end_time" < ?)) ORDER BY "t1"."start_time"', ['doorbell', 1638366983.859182])
frigate                       | [2021-12-01 15:01:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:01:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:01:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:01:23] frigate.record                 DEBUG   : End camera: doorbell.
frigate                       | [2021-12-01 15:01:23] frigate.record                 DEBUG   : End all cameras.
frigate                       | [2021-12-01 15:01:23] frigate.record                 DEBUG   : End expire recordings (new).
frigate                       | [2021-12-01 15:01:33] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/stats.
frigate                       | [2021-12-01 15:02:23] frigate.record                 DEBUG   : Start expire recordings (new).
frigate                       | [2021-12-01 15:02:23] frigate.record                 DEBUG   : Start deleted cameras.
frigate                       | [2021-12-01 15:02:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" NOT IN (?)) AND ("t1"."end_time" < ?))', ['doorbell', 1638367343.862854])
frigate                       | [2021-12-01 15:02:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:02:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:02:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:02:23] frigate.record                 DEBUG   : End deleted cameras.
frigate                       | [2021-12-01 15:02:23] frigate.record                 DEBUG   : Start all cameras.
frigate                       | [2021-12-01 15:02:23] frigate.record                 DEBUG   : Start camera: doorbell.
frigate                       | [2021-12-01 15:02:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" = ?) AND ("t1"."end_time" < ?)) ORDER BY "t1"."start_time"', ['doorbell', 1638367043.865123])
frigate                       | [2021-12-01 15:02:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:02:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:02:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:02:23] frigate.record                 DEBUG   : End camera: doorbell.
frigate                       | [2021-12-01 15:02:23] frigate.record                 DEBUG   : End all cameras.
frigate                       | [2021-12-01 15:02:23] frigate.record                 DEBUG   : End expire recordings (new).
frigate                       | [2021-12-01 15:02:33] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/stats.
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('SELECT DISTINCT "t1"."label" FROM "event" AS "t1" WHERE ("t1"."camera" NOT IN (?))', ['doorbell'])
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('SELECT DISTINCT "t1"."label" FROM "event" AS "t1" WHERE ("t1"."camera" = ?)', ['doorbell'])
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ((("t1"."camera" = ?) AND ("t1"."start_time" < ?)) AND ("t1"."label" = ?))', ['doorbell', 1637503403.82347, 'person'])
frigate                       | [2021-12-01 15:03:23] peewee.sqliteq                 DEBUG   : received query UPDATE "event" SET "has_clip" = ? WHERE ((("event"."camera" = ?) AND ("event"."start_time" < ?)) AND ("event"."label" = ?))
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('UPDATE "event" SET "has_clip" = ? WHERE ((("event"."camera" = ?) AND ("event"."start_time" < ?)) AND ("event"."label" = ?))', [False, 'doorbell', 1637503403.82347, 'person'])
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('SELECT DISTINCT "t1"."label" FROM "event" AS "t1" WHERE ("t1"."camera" NOT IN (?))', ['doorbell'])
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('SELECT DISTINCT "t1"."label" FROM "event" AS "t1" WHERE ("t1"."camera" = ?)', ['doorbell'])
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ((("t1"."camera" = ?) AND ("t1"."start_time" < ?)) AND ("t1"."label" = ?))', ['doorbell', 1637503403.826428, 'person'])
frigate                       | [2021-12-01 15:03:23] peewee.sqliteq                 DEBUG   : received query UPDATE "event" SET "has_snapshot" = ? WHERE ((("event"."camera" = ?) AND ("event"."start_time" < ?)) AND ("event"."label" = ?))
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('UPDATE "event" SET "has_snapshot" = ? WHERE ((("event"."camera" = ?) AND ("event"."start_time" < ?)) AND ("event"."label" = ?))', [False, 'doorbell', 1637503403.826428, 'person'])
frigate                       | [2021-12-01 15:03:23] peewee.sqliteq                 DEBUG   : received query with grouped_events as (
frigate                       |           select id,
frigate                       |             label,
frigate                       |             camera,
frigate                       |                 has_snapshot,
frigate                       |                 has_clip,
frigate                       |                 row_number() over (
frigate                       |               partition by label, camera, round(start_time/5,0)*5
frigate                       |               order by end_time-start_time desc
frigate                       |             ) as copy_number
frigate                       |           from event
frigate                       |         )
frigate                       |
frigate                       |         select distinct id, camera, has_snapshot, has_clip from grouped_events
frigate                       |         where copy_number > 1;
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('with grouped_events as (\n          select id,\n            label,\n            camera,\n          \thas_snapshot,\n          \thas_clip,\n          \trow_number() over (\n              partition by label, camera, round(start_time/5,0)*5\n              order by end_time-start_time desc\n            ) as copy_number\n          from event\n        )\n\n        select distinct id, camera, has_snapshot, has_clip from grouped_events\n        where copy_number > 1;', [])
frigate                       | [2021-12-01 15:03:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "event" WHERE (0 = 1)
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('DELETE FROM "event" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:03:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "event" WHERE (("event"."has_clip" = ?) AND ("event"."has_snapshot" = ?))
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('DELETE FROM "event" WHERE (("event"."has_clip" = ?) AND ("event"."has_snapshot" = ?))', [False, False])
frigate                       | [2021-12-01 15:03:23] frigate.record                 DEBUG   : Start expire recordings (new).
frigate                       | [2021-12-01 15:03:23] frigate.record                 DEBUG   : Start deleted cameras.
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" NOT IN (?)) AND ("t1"."end_time" < ?))', ['doorbell', 1638367403.868386])
frigate                       | [2021-12-01 15:03:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:03:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:03:23] frigate.record                 DEBUG   : End deleted cameras.
frigate                       | [2021-12-01 15:03:23] frigate.record                 DEBUG   : Start all cameras.
frigate                       | [2021-12-01 15:03:23] frigate.record                 DEBUG   : Start camera: doorbell.
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" = ?) AND ("t1"."end_time" < ?)) ORDER BY "t1"."start_time"', ['doorbell', 1638367103.870612])
frigate                       | [2021-12-01 15:03:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:03:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:03:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:03:23] frigate.record                 DEBUG   : End camera: doorbell.
frigate                       | [2021-12-01 15:03:23] frigate.record                 DEBUG   : End all cameras.
frigate                       | [2021-12-01 15:03:23] frigate.record                 DEBUG   : End expire recordings (new).
frigate                       | [2021-12-01 15:03:33] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/stats.
frigate                       | [2021-12-01 15:03:43] ws4py                          INFO    : Managing websocket [Local => 127.0.0.1:5002 | Remote => 127.0.0.1:41506]
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."camera" = ?) ORDER BY "t1"."start_time" DESC LIMIT ?', ['doorbell', '25'])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638362401.511064-sqpcjc', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638359587.237706-poo2pc', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638359603.052962-rjoiig', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638352950.773699-nhpu25', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638298842.049346-8320m7', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638293848.285563-i036fu', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638293838.862755-e06h45', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638292022.652714-nxs0ym', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638279990.270089-vuu5fo', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638268877.290388-z292hn', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638283465.872176-r3xxc0', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638282068.603898-bbvk9m', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638280110.24904-k55cr0', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638268860.949326-cxmfej', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638256736.532287-703swz', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638191520.154829-odvtk4', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638191274.801328-kijvcu', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638191134.750675-5xfz14', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638177310.554889-g7yjts', 1, 0])
frigate                       | [2021-12-01 15:03:44] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638177327.341528-xyukx6', 1, 0])
frigate                       | [2021-12-01 15:03:45] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638362401.511064-sqpcjc', 1, 0])
frigate                       | [2021-12-01 15:03:46] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638362401.511064-sqpcjc', 1, 0])
frigate                       | [2021-12-01 15:03:46] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (((("t1"."start_time" BETWEEN ? AND ?) OR ("t1"."end_time" BETWEEN ? AND ?)) OR (("t1"."start_time" < ?) AND ("t1"."end_time" > ?))) AND ("t1"."camera" = ?)) ORDER BY "t1"."start_time" ASC', [1638362396.511064, 1638362419.203743, 1638362396.511064, 1638362419.203743, 1638362396.511064, 1638362419.203743, 'doorbell'])
frigate                       | [2021-12-01 15:03:46] frigate.http                   ERROR   : ffmpeg version 4.3.1 Copyright (c) 2000-2020 the FFmpeg developers
frigate                       |   built with gcc 9 (Ubuntu 9.3.0-17ubuntu1~20.04)
frigate                       |   configuration: --disable-debug --disable-doc --disable-ffplay --enable-shared --enable-avresample --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-gpl --enable-libfreetype --enable-libvidstab --enable-libmfx --enable-libmp3lame --enable-libopus --enable-libtheora --enable-libvorbis --enable-libvpx --enable-libwebp --enable-libxcb --enable-libx265 --enable-libxvid --enable-libx264 --enable-nonfree --enable-openssl --enable-libfdk_aac --enable-postproc --enable-small --enable-version3 --enable-libzmq --extra-libs=-ldl --prefix=/opt/ffmpeg --enable-libopenjpeg --enable-libkvazaar --enable-libaom --extra-libs=-lpthread --enable-vaapi --extra-cflags=-I/opt/ffmpeg/include --extra-ldflags=-L/opt/ffmpeg/lib
frigate                       |   libavutil      56. 51.100 / 56. 51.100
frigate                       |   libavcodec     58. 91.100 / 58. 91.100
frigate                       |   libavformat    58. 45.100 / 58. 45.100
frigate                       |   libavdevice    58. 10.100 / 58. 10.100
frigate                       |   libavfilter     7. 85.100 /  7. 85.100
frigate                       |   libavresample   4.  0.  0 /  4.  0.  0
frigate                       |   libswscale      5.  7.100 /  5.  7.100
frigate                       |   libswresample   3.  7.100 /  3.  7.100
frigate                       |   libpostproc    55.  7.100 / 55.  7.100
frigate                       | pipe:: Invalid data found when processing input
frigate                       |
frigate                       | [2021-12-01 15:04:23] frigate.record                 DEBUG   : Start expire recordings (new).
frigate                       | [2021-12-01 15:04:23] frigate.record                 DEBUG   : Start deleted cameras.
frigate                       | [2021-12-01 15:04:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" NOT IN (?)) AND ("t1"."end_time" < ?))', ['doorbell', 1638367463.873617])
frigate                       | [2021-12-01 15:04:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:04:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:04:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:04:23] frigate.record                 DEBUG   : End deleted cameras.
frigate                       | [2021-12-01 15:04:23] frigate.record                 DEBUG   : Start all cameras.
frigate                       | [2021-12-01 15:04:23] frigate.record                 DEBUG   : Start camera: doorbell.
frigate                       | [2021-12-01 15:04:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" = ?) AND ("t1"."end_time" < ?)) ORDER BY "t1"."start_time"', ['doorbell', 1638367163.87623])
frigate                       | [2021-12-01 15:04:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:04:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:04:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:04:23] frigate.record                 DEBUG   : End camera: doorbell.
frigate                       | [2021-12-01 15:04:23] frigate.record                 DEBUG   : End all cameras.
frigate                       | [2021-12-01 15:04:23] frigate.record                 DEBUG   : End expire recordings (new).
frigate                       | [2021-12-01 15:04:33] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/stats.
frigate                       | [2021-12-01 15:05:23] frigate.record                 DEBUG   : Start expire recordings (new).
frigate                       | [2021-12-01 15:05:23] frigate.record                 DEBUG   : Start deleted cameras.
frigate                       | [2021-12-01 15:05:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" NOT IN (?)) AND ("t1"."end_time" < ?))', ['doorbell', 1638367523.879494])
frigate                       | [2021-12-01 15:05:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:05:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:05:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:05:23] frigate.record                 DEBUG   : End deleted cameras.
frigate                       | [2021-12-01 15:05:23] frigate.record                 DEBUG   : Start all cameras.
frigate                       | [2021-12-01 15:05:23] frigate.record                 DEBUG   : Start camera: doorbell.
frigate                       | [2021-12-01 15:05:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" = ?) AND ("t1"."end_time" < ?)) ORDER BY "t1"."start_time"', ['doorbell', 1638367223.88308])
frigate                       | [2021-12-01 15:05:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:05:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:05:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:05:23] frigate.record                 DEBUG   : End camera: doorbell.
frigate                       | [2021-12-01 15:05:23] frigate.record                 DEBUG   : End all cameras.
frigate                       | [2021-12-01 15:05:23] frigate.record                 DEBUG   : End expire recordings (new).
frigate                       | [2021-12-01 15:05:31] frigate.events                 DEBUG   : Event received: start doorbell 1638367531.541407-ri3khm
frigate                       | [2021-12-01 15:05:33] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/events.
frigate                       | [2021-12-01 15:05:33] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/doorbell/person/snapshot.
frigate                       | [2021-12-01 15:05:33] frigate.mqtt                   DEBUG   : MQTT payload for frigate/doorbell/person/snapshot wasn't text. Skipping...
frigate                       | [2021-12-01 15:05:33] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/doorbell/person.
frigate                       | [2021-12-01 15:05:35] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/stats.
frigate                       | [2021-12-01 15:05:38] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/events.
frigate                       | [2021-12-01 15:05:43] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/events.
frigate                       | [2021-12-01 15:05:43] frigate.events                 DEBUG   : Event received: end doorbell 1638367531.541407-ri3khm
frigate                       | [2021-12-01 15:05:43] peewee.sqliteq                 DEBUG   : received query INSERT INTO "event" ("id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot", "region", "box", "area") VALUES (?, ?, ?, ?, ?, ?, ?, json(?), ?, ?, ?, json(?), json(?), ?)
frigate                       | [2021-12-01 15:05:43] peewee                         DEBUG   : ('INSERT INTO "event" ("id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot", "region", "box", "area") VALUES (?, ?, ?, ?, ?, ?, ?, json(?), ?, ?, ?, json(?), json(?), ?)', ['1638367531.541407-ri3khm', 'person', 'doorbell', 1638367526.541407, 1638367547.247712, 0.779296875, False, '[]', '/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIfIiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCACvAK8DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1aiiigAooooAKKKKACiiigAooooAKKKgub20skD3dzDbqehlcKD+dAE9FVrTUrC/JFne29wR1EUqsR+RqzQAUUUUAFFU7/V9O0tN19eRQcZCu3zH6DqfwrkNV+KmmW2U0+3kuW7PIdi/lyfzAoA7uql9qun6Ym++vIbcEZAkcAt9B1P4V43qvxG1/UCVS6NrGf4YBs/Xlv1rl57yedy8srMzH5iTyfqepp2A9f1b4paPaBks4pbtv7x/dr/8AFfpXAah481Kd5RZgWcUhyyQkjPOepJP5YHtXLlqaTT2GfUNFFFSIKKKKACiiigAooooAKKK5Hxt4q/smBrG0f/SZF+Zh/wAswf6/5+gBB4r8drp7yWGlFXuF4knIysZ9AO5/Qe9eb3l411M1zfXMk8h6vIxJPsKp3FzuJPIqlJKXbLHp0FXYuxox6sYnzBGEx0Petew8VXdm2+CdoZD1KNw31HeuVVz64pN+D3oA9T034mTrbNHd2i3MwHySKwTP+8AD+mK57WPiFr16zxJOLNOhWAbT+f3v1rklmK8ip5i09v5pUZHoc0WQrEU91LOzNLKzsxyxJ6/X1quWpC1MJoEKzZqMmlJpu0noDQAuaaTQcKcMcH0ppcehP6UgPqWiiipEFFFFABRRRQAVHNIIojI2cLzxVDUfEWlaW2y5u0Eg/wCWafOw/AdPxrEXx5Zvdr5lrLHBzmUvyo7Hb0/WnYaTZrapr1rYwsZtxPRVXrIT2B6fjXkHibUJ7rUJJ5+JJcN1PAIGOvtXWeK9ZRYGVZEYTRgwIV5Klsk8H5eVA554xgc15ve3BuJ2dnzjue9VYqxE0hximZ3uB61GW5qWFfm3UNjSJhGAMYo2DHSlJppNRc05UNZcdKRSyZ5GDwcilJpw+dSvrVJkuIzyHY5xgU0pEv35V/PP8qhlLbiGJP1OajoMyx5kC/dBb6Cmm6A+7GB9TmoDSGgCe8TDRtj78YaoKu34/wBDsn/6Z7fyxVHNIR9SRzRS58uRXwATg560+uD8KalDa38gluAsLg7dzHHJ4I689OvNdLrfiCLR7SKdITdecCU2OAuAMkk88fQGiwjXqpfapY6aoa8uo4c9FY/MfoOprhp/EutaoHMc62kKkZEIK9Rnljk/lisOO4geZ2nlMpG7JTJ3Hsd3vTUR2O11DxzDGGXT7YysP+Wkp2r+XU/pXL3uuavqwk827kaOM4kigPlouex9foSapLqIspftEcA+VSMlj6etZMVxdxXtzOHb/SWy6pgknqOp9/1o0K5TWtrVpYCyoECS+XsHJ6ZzVeUbSgZGTaNxBPPt/WobV5ZyUkjkVDgncwO76j8KddlItuAAFRsj24psqO5zmrag811IdxxnA+lZ6fNTbh90pPc0kLAPgng0gvdkpT5uKnA2imDrinZqLlJAXAPJpN6nvTJRnoKgwc+lA27FkmnxH5xmqwLAdaaS5G4nAHvTRLYs5xIfeoS1SSAtHvHIB5qEmmZsUtSZpKKYjRu/m0Wyf0Zx+p/wrOrQm50C3/2ZWH86z6QHdWuoeQSu8J5g2kBR9eOOPwqSLxFf3cH9mQuohhDKokwSqnggcdKx0R5UMnmqiRkBg0oU5xnpnJ49v/rSf2ehVJY23NLG2AWwMgHk5I4z6CqimtRsuyJcGVI3uOOMYIO3g9CScdB0qSK2aNiWkZmDKRulJIByDx+IrJbR2ZQ5lhcHgbFkJz6AlQP1qS28PTyyqz2SmFl4InXn0OA2abY0XNRuvLjUAEAnbn/GqqXaxOJXJKg5wefpmhfCur+ZKYNJvHUBwhSFmB64wRTo/BuvzeWr6Vfouctm3bjnt+FZ2KuaaXcZkEa7QxX5QCeg7/rTJSrqd21FPXJ3M1NudLvdOBub2KZJNoXzLjcpY5Prye35VSeeOFiHfccZPGQabY00c5dxNHJllwDnH51WY1p6rMJ9oQnYOuRjmss9aEQ9yzA2UwT0qbNVIGwcVZDCpaNIsU00gZpSe9QmUUinYl7VDOcAL604TZ4qF33SZqkRJqxZijJXAHUHIqnV6CRMb87QDkmqk7I0zNGMKTmhGbGUmaKKoRov/wAgCP2nP8jWdWg//IAT/rv/AENZ9ID1mHTrS5hQ3enW4kxyzKq/zORWR4h0m1s44WsfIjaVisgWcYAwevOB3/PHOcVvNatnKMCPQtxUclpuzkAH1rVq6sWtHc4aPUVkUeUm+PPAfOeB0+Ug9x6VvS/2haW5EMTPDsBKW0xKB/4iVySeMcn0q1deHLe7dXkJ3r0I4rDh1ElVkIeBiMlSc7T9f89alKxU5uWrOk8MeI9QhMNlL9rjjuQRFJLuKvIOcKTxg4IwO+Petl9ZuZhxdzKD3VyK4sX73BiWVnkRX8xQsh+92Yc9R6+5rqU1HSpbMz3GnE3mSDmR1Vj/AHtoIH5VaM3cs3E0moafNay3Dujrz5jlgD1BOfQiuR1Ox0uOR7gSTRpt+a3UD5W9BIeNvpwTUl7qQyQGVRnIVRgCue1C9lnOwYaPHKk96UkmgVzKupPOndgMKTwB6VXPWpnAB4BHsaiIyazARDhqsntVYKcg1YFSykBORjNRMSDgDNSkVEcjqc0DbELEdqYAScDkml+8as2kEZffIchTnGcZ/GmiGQywz2/Esbx7um4EZqKuztdRimgMEqpLCTzHKuR/+usDW9Mjs5RPanNvIeFJyUPp7j0NU1YRlUUUVIGjJxoEXvMf61nVoz8aFaj1kY/qazqAPYra+guQfKYNt60rzgf/AK65DTpZ7a9RcllYHB3Dnr+I6iukDF0B3dR3rVSuUPlvVjGQucds1w141zb3cziANCxyoB+Yen6V2EqEjFZ1xab+doNDGc3HIt8wt7d2imlIXkcgZ5PHXAzVu/1DEoggZhFGgRec5A96klt0svMuGxuPyLx0z1/TI/GsZ3LMW7nmlewiw8x28dTUBOeabnPem7gDilcBGOetQFcmpWI9KZnNSxDMYpQcU7ApCOlILjdxzQeadgCkxQMaF54qRR2pUQYzT8DrTQh0blOhxVt5PtFs1uxyCPl9j1FUfxpysVYYNO4FA9aUKWzgdOal3RxyuJYfMBPZiCPp/wDqpxe38t/JhkU45Mkgb8sKKkksXp26VZJ/vH9f/r1n1e1I/ubJOmIAfzA/wqhQM7SS5jkuluLcrG79WA6n1x0yfy/Ktiwu/tcBcAcMVO1siuCE8i4+bkepzWvoWozLcGFmUQ4L7QoAVuBnjFEdCjrmwWx0zTHQEcHH1pF8rhhLk4yCR1FLtUnaAxPc9TWtxnNeI5cSJAp6HJx6/wCTWJk1Z1Of7RezODkbzj6Zqr2qWITOKQ80GkqRBTe59qcORSAYoAQ8jikzzSsMUgpAHfmgD8qXvSrQAoPHFLnimd6UHimApPakZsEUZ5prctmgCGb/AFh+gpAcRsO56CnTffHuBRbp5lzEn95wD+dIks6txdrH/wA841WqVWdQfffzN/tY/Liq1AzRSMMMFiD9P8K1NFs5Bdh0bDAYy33cfgM1Nb2iA9P0rVtoVjdXUlD0JAFXGIy9bq8PyzTAEj7wXCn2weaZezC2tJZYn3BUJwM4Bx27fhUrIJEIZmYHv0x+VZeuzGLSJIj95yFzjGRnOa0tZAckepNN3djRkUhrEBc0UvlssayHo+QPwpKAEHApMnvS9aKAGknGaKCOcUUAJxml70lLQAHpRQaTNAhc80jdPxpM4pC3GKAGz/eX/d/qal01d19GT0XJP5VFN1T/AHf6mp7L5FuJf7sePz//AFUhFWRt8jP/AHmJptLSHPYZPpQB3KoAQQT6VaUqB979agWNiPvKAexXP9akSUINpBLDjpW6GWEmdW2A4GOMqayPEE4dBETkgEn2PFXpZDKm0IVPYk4xXPak5knZsg/Sh7AZnenwqJJ4426MwBx7mmHqa0NGgWW83OgZYxnnoD2rIZHfhEmWGMEJCgUAnJzyT+pqpU07+bcSSf3nJqI0gEHSjOaO1J0FAAetJR/FThQA2lpcCgj0oAbim4xT8HvSEUCI2OaQDJxSkc0+MYoAbcrtkUdtoqVf3emMe8smPwFRXJzIMnooqW8/dxW8P91Nx+ppCKpqzpkYlvVyMhQSf5f1qqTWjpa7IZZuhJCg/qf50AdKsrngkY9hS7n3BuW7HpVaJpWcA7UHA6ljn9KtrYX8g4CqvY8f4mtrlBIzrE7FCAqk8kentXLyOexyK6i9sbi3sJZpZgQq42rnnJx/WuVlOTSbAjzzWxpCMbY7IyxZ8jAz0rHxmvQbSFLS1ihRQFjUD/E0oq4HA0lOf7xx0zTetSAhHFIRwKdSdKQDcc0Up6UgFACilpBS0AJQQNuaWmnpQAw9aclNp8fJFAhgTz7xI+zMAfp3pL2XzbyVgeN2B+HFS2Z2STz/APPJCR9T0/rVOkIK0pGNrp0SDhiM/ieaoQR+bOkZ6M3P071Z1KXfPtHQUAf/2Q==', True, True, '[304, 0, 1920, 1616]', '[1002, 247, 1641, 1068]', 524619])
frigate                       | [2021-12-01 15:05:43] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/doorbell/person.
frigate                       | [2021-12-01 15:05:43] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/doorbell/person/snapshot.
frigate                       | [2021-12-01 15:05:43] frigate.mqtt                   DEBUG   : MQTT payload for frigate/doorbell/person/snapshot wasn't text. Skipping...
frigate                       | [2021-12-01 15:06:23] frigate.record                 DEBUG   : Start expire recordings (new).
frigate                       | [2021-12-01 15:06:23] frigate.record                 DEBUG   : Start deleted cameras.
frigate                       | [2021-12-01 15:06:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" NOT IN (?)) AND ("t1"."end_time" < ?))', ['doorbell', 1638367583.887628])
frigate                       | [2021-12-01 15:06:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:06:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:06:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:06:23] frigate.record                 DEBUG   : End deleted cameras.
frigate                       | [2021-12-01 15:06:23] frigate.record                 DEBUG   : Start all cameras.
frigate                       | [2021-12-01 15:06:23] frigate.record                 DEBUG   : Start camera: doorbell.
frigate                       | [2021-12-01 15:06:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" = ?) AND ("t1"."end_time" < ?)) ORDER BY "t1"."start_time"', ['doorbell', 1638367283.890921])
frigate                       | [2021-12-01 15:06:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:06:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:06:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:06:23] frigate.record                 DEBUG   : End camera: doorbell.
frigate                       | [2021-12-01 15:06:23] frigate.record                 DEBUG   : End all cameras.
frigate                       | [2021-12-01 15:06:23] frigate.record                 DEBUG   : End expire recordings (new).
frigate                       | [2021-12-01 15:06:33] ws4py                          DEBUG   : Closing message received (1001) 'b'''
frigate                       | [2021-12-01 15:06:33] ws4py                          INFO    : Terminating websocket [Local => 127.0.0.1:5002 | Remote => 127.0.0.1:41506]
frigate                       | [2021-12-01 15:06:34] ws4py                          INFO    : Managing websocket [Local => 127.0.0.1:5002 | Remote => 127.0.0.1:42322]
frigate                       | [2021-12-01 15:06:34] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."camera" = ?) ORDER BY "t1"."start_time" DESC LIMIT ?', ['doorbell', '25'])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638362401.511064-sqpcjc', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638359603.052962-rjoiig', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638359587.237706-poo2pc', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638352950.773699-nhpu25', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638298842.049346-8320m7', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638293848.285563-i036fu', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638292022.652714-nxs0ym', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638293838.862755-e06h45', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638280110.24904-k55cr0', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638282068.603898-bbvk9m', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638283465.872176-r3xxc0', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638279990.270089-vuu5fo', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638268877.290388-z292hn', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638256736.532287-703swz', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638268860.949326-cxmfej', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638191520.154829-odvtk4', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638191274.801328-kijvcu', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638191134.750675-5xfz14', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638177327.341528-xyukx6', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638177310.554889-g7yjts', 1, 0])
frigate                       | [2021-12-01 15:06:35] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638367531.541407-ri3khm', 1, 0])
frigate                       | [2021-12-01 15:06:35] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/stats.
frigate                       | [2021-12-01 15:06:37] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638367531.541407-ri3khm', 1, 0])
frigate                       | [2021-12-01 15:06:38] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638367531.541407-ri3khm', 1, 0])
frigate                       | [2021-12-01 15:06:38] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (((("t1"."start_time" BETWEEN ? AND ?) OR ("t1"."end_time" BETWEEN ? AND ?)) OR (("t1"."start_time" < ?) AND ("t1"."end_time" > ?))) AND ("t1"."camera" = ?)) ORDER BY "t1"."start_time" ASC', [1638367526.541407, 1638367547.247712, 1638367526.541407, 1638367547.247712, 1638367526.541407, 1638367547.247712, 'doorbell'])
frigate                       | [2021-12-01 15:06:45] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."label", "t1"."camera", "t1"."start_time", "t1"."end_time", "t1"."top_score", "t1"."false_positive", "t1"."zones", "t1"."thumbnail", "t1"."has_clip", "t1"."has_snapshot", "t1"."region", "t1"."box", "t1"."area" FROM "event" AS "t1" WHERE ("t1"."id" = ?) LIMIT ? OFFSET ?', ['1638367531.541407-ri3khm', 1, 0])
frigate                       | [2021-12-01 15:06:45] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (((("t1"."start_time" BETWEEN ? AND ?) OR ("t1"."end_time" BETWEEN ? AND ?)) OR (("t1"."start_time" < ?) AND ("t1"."end_time" > ?))) AND ("t1"."camera" = ?)) ORDER BY "t1"."start_time" ASC', [1638367526.541407, 1638367547.247712, 1638367526.541407, 1638367547.247712, 1638367526.541407, 1638367547.247712, 'doorbell'])
frigate                       | [2021-12-01 15:06:45] frigate.http                   ERROR   : ffmpeg version 4.3.1 Copyright (c) 2000-2020 the FFmpeg developers
frigate                       |   built with gcc 9 (Ubuntu 9.3.0-17ubuntu1~20.04)
frigate                       |   configuration: --disable-debug --disable-doc --disable-ffplay --enable-shared --enable-avresample --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-gpl --enable-libfreetype --enable-libvidstab --enable-libmfx --enable-libmp3lame --enable-libopus --enable-libtheora --enable-libvorbis --enable-libvpx --enable-libwebp --enable-libxcb --enable-libx265 --enable-libxvid --enable-libx264 --enable-nonfree --enable-openssl --enable-libfdk_aac --enable-postproc --enable-small --enable-version3 --enable-libzmq --extra-libs=-ldl --prefix=/opt/ffmpeg --enable-libopenjpeg --enable-libkvazaar --enable-libaom --extra-libs=-lpthread --enable-vaapi --extra-cflags=-I/opt/ffmpeg/include --extra-ldflags=-L/opt/ffmpeg/lib
frigate                       |   libavutil      56. 51.100 / 56. 51.100
frigate                       |   libavcodec     58. 91.100 / 58. 91.100
frigate                       |   libavformat    58. 45.100 / 58. 45.100
frigate                       |   libavdevice    58. 10.100 / 58. 10.100
frigate                       |   libavfilter     7. 85.100 /  7. 85.100
frigate                       |   libavresample   4.  0.  0 /  4.  0.  0
frigate                       |   libswscale      5.  7.100 /  5.  7.100
frigate                       |   libswresample   3.  7.100 /  3.  7.100
frigate                       |   libpostproc    55.  7.100 / 55.  7.100
frigate                       | pipe:: Invalid data found when processing input
frigate                       |
frigate                       | [2021-12-01 15:07:23] frigate.record                 DEBUG   : Start expire recordings (new).
frigate                       | [2021-12-01 15:07:23] frigate.record                 DEBUG   : Start deleted cameras.
frigate                       | [2021-12-01 15:07:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" NOT IN (?)) AND ("t1"."end_time" < ?))', ['doorbell', 1638367643.895738])
frigate                       | [2021-12-01 15:07:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:07:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:07:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:07:23] frigate.record                 DEBUG   : End deleted cameras.
frigate                       | [2021-12-01 15:07:23] frigate.record                 DEBUG   : Start all cameras.
frigate                       | [2021-12-01 15:07:23] frigate.record                 DEBUG   : Start camera: doorbell.
frigate                       | [2021-12-01 15:07:23] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."camera", "t1"."path", "t1"."start_time", "t1"."end_time", "t1"."duration" FROM "recordings" AS "t1" WHERE (("t1"."camera" = ?) AND ("t1"."end_time" < ?)) ORDER BY "t1"."start_time"', ['doorbell', 1638367343.899973])
frigate                       | [2021-12-01 15:07:23] frigate.record                 DEBUG   : Expiring 0 recordings
frigate                       | [2021-12-01 15:07:23] peewee.sqliteq                 DEBUG   : received query DELETE FROM "recordings" WHERE (0 = 1)
frigate                       | [2021-12-01 15:07:23] peewee                         DEBUG   : ('DELETE FROM "recordings" WHERE (0 = 1)', [])
frigate                       | [2021-12-01 15:07:23] frigate.record                 DEBUG   : End camera: doorbell.
frigate                       | [2021-12-01 15:07:23] frigate.record                 DEBUG   : End all cameras.
frigate                       | [2021-12-01 15:07:23] frigate.record                 DEBUG   : End expire recordings (new).
frigate                       | [2021-12-01 15:07:35] frigate.mqtt                   DEBUG   : Received mqtt message on frigate/stats.

FFprobe output from your camera

root@8117ee5eb1a3:/opt/frigate# ffprobe rtsp://<user>:<password>@192.168.3.27:554
ffprobe version 4.3.1 Copyright (c) 2007-2020 the FFmpeg developers
  built with gcc 9 (Ubuntu 9.3.0-17ubuntu1~20.04)
  configuration: --disable-debug --disable-doc --disable-ffplay --enable-shared --enable-avresample --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-gpl --enable-libfreetype --enable-libvidstab --enable-libmfx --enable-libmp3lame --enable-libopus --enable-libtheora --enable-libvorbis --enable-libvpx --enable-libwebp --enable-libxcb --enable-libx265 --enable-libxvid --enable-libx264 --enable-nonfree --enable-openssl --enable-libfdk_aac --enable-postproc --enable-small --enable-version3 --enable-libzmq --extra-libs=-ldl --prefix=/opt/ffmpeg --enable-libopenjpeg --enable-libkvazaar --enable-libaom --extra-libs=-lpthread --enable-vaapi --extra-cflags=-I/opt/ffmpeg/include --extra-ldflags=-L/opt/ffmpeg/lib
  libavutil      56. 51.100 / 56. 51.100
  libavcodec     58. 91.100 / 58. 91.100
  libavformat    58. 45.100 / 58. 45.100
  libavdevice    58. 10.100 / 58. 10.100
  libavfilter     7. 85.100 /  7. 85.100
  libavresample   4.  0.  0 /  4.  0.  0
  libswscale      5.  7.100 /  5.  7.100
  libswresample   3.  7.100 /  3.  7.100
  libpostproc    55.  7.100 / 55.  7.100
Input #0, rtsp, from 'rtsp://<user>:<password>@192.168.3.27:554':
  Metadata:
    title           : Media Server
  Duration: N/A, start: 0.070000, bitrate: N/A
    Stream #0:0: Video: h264, yuvj420p(pc, bt709, progressive), 1920x1080, 100 tbr, 90k tbn, 180k tbc
    Stream #0:1: Audio: aac, 16000 Hz, mono, fltp

Frigate stats

{"detection_fps":0.0,"detectors":{"cpu":{"detection_start":0.0,"inference_speed":10.0,"pid":211}},"doorbell":{"camera_fps":5.1,"capture_pid":216,"detection_fps":0.0,"pid":215,"process_fps":5.1,"skipped_fps":0.0},"service":{"storage":{"/dev/shm":{"free":63.7,"mount_type":"tmpfs","total":67.1,"used":3.4},"/media/frigate/clips":{"free":7263363.9,"mount_type":"nfs","total":7263670.1,"used":306.2},"/media/frigate/recordings":{"free":7263363.9,"mount_type":"nfs","total":7263670.1,"used":306.2},"/tmp/cache":{"free":13517.1,"mount_type":"ext4","total":89029.4,"used":71838.6}},"uptime":21,"version":"0.9.1-800f33e"}}

Operating system

Debian

Install method

Docker Compose

Coral version

CPU (no coral)

Network connection

Mixed

Camera make and model

Amcrest AD110

Any other information that may be helpful

No response

blakeblackshear commented 2 years ago

It should be saving 10s segments in the /tmp/cache folder first and moving them to /media/frigate/recordings based on your config. Also, can you post the json compiled version of your config from the debug page?

aforch commented 2 years ago

Sure, thanks for the response, here you go:

{
  "birdseye": {
    "enabled": true,
    "height": 720,
    "mode": "objects",
    "quality": 8,
    "width": 1280
  },
  "cameras": {
    "doorbell": {
      "best_image_timeout": 60,
      "detect": {
        "enabled": true,
        "fps": 5,
        "height": 1080,
        "max_disappeared": 25,
        "stationary_interval": 50,
        "width": 1920
      },
      "ffmpeg": {
        "global_args": [
          "-hide_banner",
          "-loglevel",
          "warning"
        ],
        "hwaccel_args": [],
        "input_args": [
          "-avoid_negative_ts",
          "make_zero",
          "-fflags",
          "+genpts+discardcorrupt",
          "-rtsp_transport",
          "tcp",
          "-stimeout",
          "5000000",
          "-use_wallclock_as_timestamps",
          "1"
        ],
        "inputs": [
          {
            "global_args": [],
            "hwaccel_args": [],
            "input_args": [],
            "path": "rtsp://admin:<password>@192.168.3.27:554",
            "roles": [
              "record",
              "rtmp",
              "detect"
            ]
          }
        ],
        "output_args": {
          "detect": [
            "-f",
            "rawvideo",
            "-pix_fmt",
            "yuv420p"
          ],
          "record": [
            "-f",
            "segment",
            "-segment_time",
            "10",
            "-segment_format",
            "mp4",
            "-reset_timestamps",
            "1",
            "-strftime",
            "1",
            "-c",
            "copy",
            "-an"
          ],
          "rtmp": [
            "-c",
            "copy",
            "-f",
            "flv"
          ]
        }
      },
      "ffmpeg_cmds": [
        {
          "cmd": "ffmpeg -hide_banner -loglevel warning -avoid_negative_ts make_zero -fflags +genpts+discardcorrupt -rtsp_transport tcp -stimeout 5000000 -use_wallclock_as_timestamps 1 -i rtsp://admin:q2U3UJ5fdNSgjTBh73@192.168.3.27:554 -f segment -segment_time 10 -segment_format mp4 -reset_timestamps 1 -strftime 1 -c copy -an /tmp/cache/doorbell-%Y%m%d%H%M%S.mp4 -c copy -f flv rtmp://127.0.0.1/live/doorbell -r 5 -s 1920x1080 -f rawvideo -pix_fmt yuv420p pipe:",
          "roles": [
            "record",
            "rtmp",
            "detect"
          ]
        }
      ],
      "live": {
        "height": 720,
        "quality": 8
      },
      "motion": {
        "contour_area": 30,
        "delta_alpha": 0.2,
        "frame_alpha": 0.2,
        "frame_height": 50,
        "mask": "1920,0,1920,134,1314,312,1314,907,980,994,0,1009,0,0",
        "threshold": 25
      },
      "mqtt": {
        "bounding_box": true,
        "crop": true,
        "enabled": true,
        "height": 270,
        "quality": 70,
        "required_zones": [],
        "timestamp": true
      },
      "name": "doorbell",
      "objects": {
        "filters": {
          "person": {
            "mask": "0,438,1312,345,1319,841,0,1004",
            "max_area": 24000000,
            "min_area": 0,
            "min_score": 0.5,
            "threshold": 0.7
          }
        },
        "mask": "",
        "track": [
          "person"
        ]
      },
      "record": {
        "enabled": true,
        "events": {
          "max_seconds": 300,
          "objects": null,
          "post_capture": 5,
          "pre_capture": 5,
          "required_zones": [],
          "retain": {
            "default": 10,
            "objects": {}
          }
        },
        "retain_days": 0
      },
      "rtmp": {
        "enabled": true
      },
      "snapshots": {
        "bounding_box": true,
        "clean_copy": true,
        "crop": false,
        "enabled": true,
        "height": null,
        "quality": 70,
        "required_zones": [],
        "retain": {
          "default": 10,
          "objects": {}
        },
        "timestamp": false
      },
      "timestamp_style": {
        "color": {
          "blue": 255,
          "green": 255,
          "red": 255
        },
        "effect": null,
        "format": "%m/%d/%Y %H:%M:%S",
        "position": "tl",
        "thickness": 2
      },
      "zones": {}
    }
  },
  "database": {
    "path": "/db/frigate.db"
  },
  "detect": {
    "enabled": true,
    "fps": 5,
    "height": 720,
    "max_disappeared": null,
    "stationary_interval": null,
    "width": 1280
  },
  "detectors": {
    "cpu": {
      "device": "usb",
      "num_threads": 3,
      "type": "cpu"
    }
  },
  "environment_vars": {},
  "ffmpeg": {
    "global_args": [
      "-hide_banner",
      "-loglevel",
      "warning"
    ],
    "hwaccel_args": [],
    "input_args": [
      "-avoid_negative_ts",
      "make_zero",
      "-fflags",
      "+genpts+discardcorrupt",
      "-rtsp_transport",
      "tcp",
      "-stimeout",
      "5000000",
      "-use_wallclock_as_timestamps",
      "1"
    ],
    "output_args": {
      "detect": [
        "-f",
        "rawvideo",
        "-pix_fmt",
        "yuv420p"
      ],
      "record": [
        "-f",
        "segment",
        "-segment_time",
        "10",
        "-segment_format",
        "mp4",
        "-reset_timestamps",
        "1",
        "-strftime",
        "1",
        "-c",
        "copy",
        "-an"
      ],
      "rtmp": [
        "-c",
        "copy",
        "-f",
        "flv"
      ]
    }
  },
  "live": {
    "height": 720,
    "quality": 8
  },
  "logger": {
    "default": "info",
    "logs": {
      "frigate.record": "debug"
    }
  },
  "model": {
    "height": 320,
    "labelmap": {},
    "labelmap_path": null,
    "path": null,
    "width": 320
  },
  "motion": null,
  "mqtt": {
    "client_id": "frigate",
    "host": "192.168.3.9",
    "password": "<password>",
    "port": 1883,
    "stats_interval": 60,
    "tls_ca_certs": null,
    "tls_client_cert": null,
    "tls_client_key": null,
    "tls_insecure": null,
    "topic_prefix": "frigate",
    "user": "frigate"
  },
  "objects": {
    "filters": null,
    "mask": "",
    "track": [
      "person"
    ]
  },
  "record": {
    "enabled": false,
    "events": {
      "max_seconds": 300,
      "objects": null,
      "post_capture": 5,
      "pre_capture": 5,
      "required_zones": [],
      "retain": {
        "default": 10,
        "objects": {}
      }
    },
    "retain_days": 0
  },
  "rtmp": {
    "enabled": true
  },
  "snapshots": {
    "bounding_box": true,
    "clean_copy": true,
    "crop": false,
    "enabled": false,
    "height": null,
    "quality": 70,
    "required_zones": [],
    "retain": {
      "default": 10,
      "objects": {}
    },
    "timestamp": false
  },
  "timestamp_style": {
    "color": {
      "blue": 255,
      "green": 255,
      "red": 255
    },
    "effect": null,
    "format": "%m/%d/%Y %H:%M:%S",
    "position": "tl",
    "thickness": 2
  }
}

In /tmp/cache only one file is being created

root@8117ee5eb1a3:/tmp/cache# ls -lh
total 5.9G
-rw-r--r-- 1 root root 5.9G Dec  2 08:41 doorbell-20211201145826.mp4

Nothing is getting written to /media/frigate/recordings

root@8117ee5eb1a3:/media/frigate/recordings# ls -lh
total 0

Tested write permissions in the /media/frigate/recordings directory

root@8117ee5eb1a3:/media/frigate/recordings# touch test
root@8117ee5eb1a3:/media/frigate/recordings# ls
test
root@8117ee5eb1a3:/media/frigate/recordings# echo "this is a test" >> test
root@8117ee5eb1a3:/media/frigate/recordings# cat test 
this is a test
blakeblackshear commented 2 years ago

I don't see an obvious reason why, but something about your stream is preventing ffmpeg from properly segmenting. You should have many small files in the cache, not one giant file. I would suggest checking your camera settings to see if you can switch to constant bit rate (CBR) and/or disable anything like variable I-frame rates. If that doesn't work, I can suggest some ffmpeg commands to test with.

aforch commented 2 years ago

I took a look at the settings, but there are no options like what you mention. This is an Amcrest AD110 doorbell, so I guess they don't figure you need much customization ability for the video stream.

aforch commented 2 years ago

I just found that this is a duplicate of issue 2068. I looks like I need to remove "low_delay" from ffmpeg input args. How do I specify the input args removing only "low_delay"? I tried the below but then the stream fails and ffmpeg crashes:

  doorbell:
    ffmpeg:
      inputs:
        - path: rtsp://admin:q2U3UJ5fdNSgjTBh73@192.168.3.27:554/cam/realmonitor?channel=1&subtype=0
          roles:
            - detect
            - record
      input_args:
        - -avoid_negative_ts
        - make_zero
        - -fflags
        - nobuffer
        - -flags
        - -strict
        - experimental
        - -fflags
        - +genpts
        - +discardcorrupt
        - -rw_timeout
        - 5000000
        - -use_wallclock_as_timestamp
        - 1
    detect:
      width: 1920
      height: 1080
    objects:
      track:
        - person
      filters:
        person:
          mask: 0,438,1312,345,1319,841,0,1004
    snapshots:
      enabled: True
    motion:
      mask: 1920,0,1920,134,1314,312,1314,907,980,994,0,1009,0,0
    record:
      enabled: True
      retain_days: 0
      events:
        max_seconds: 300
        # pre_capture: 15
        #post_capture: 15
        retain:
          default: 10
blakeblackshear commented 2 years ago

The default args no longer include the low latency flag, so it must be something else.

spikeygg commented 2 years ago

For the record I have the same problem with my array. I have seven cameras and Frigate (0.9.4-26AE608) seems to work well with all of them. However, I analyzed the last 41 clips "captured" by Frigate and this was the result:

From 12/03/21-12/04/21

CASE#1 1111111111111111111111 <-- 22 ==> ~53% CASE#2 1111111111 <-- 10 ==> ~24% CASE#3 111111111 <-- 9 ==> ~22%

I noticed was that there were some duplicates in the last day of clips too but that's less of a concern. @blakeblackshear, I'm not sure how best to help debug this kind of thing but I'm definitely willing to help. I think Frigate is awesome and, for me, this missing/wrong recording problem is the biggest hole in the app at the moment. I have it integrated with HA and regularly I'll get notification of a clip that was created (with the snapshot image), I'll click to view the clip and it is broken, no video captured. :( If there's any way I can help just let me know.

Party on! -Greg

aforch commented 2 years ago

I added a second CPU core to the VM on which docker/frigate is running, as utilization was overall about double what it was from before I installed frigate, and rebooted. I didn't notice right away, but now recording from the Amcrest AD110 is working.