search

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]: #3690

Closed jds11111 closed 2 years ago

jds11111 commented 2 years ago

Describe the problem you are having

Cannot install frigate in a Docker container on Ubuntu 18.04. I have tried more ways than I can count or remember. I am not using network drives, but I still had the disk I/O error on startup. So, I tried mapping individual directories according to the docs. This got rid of the disk I/O errors, but it still keeps crashing and restarting, but with an error [Errno -2] Name or service not known

Version

Never get the Web UI, but it is the latest docker container

Frigate config file

logger:
  default: debug

mqtt:
  host: 192.168.1.91:1883
  user: xxxxx
  password: yyyyyy

cameras:
  front-door:
    ffmpeg:
      inputs:
        - path: rtsp://bbbbb:zzzzzzz@192.168.1.jj:554/cam/realmonitor?channel=1&subtype=0&authbasic=64
          roles:
            - detect
            - rtmp
    rtmp:
      enabled: True
    detect:
      width: 2560
      height: 1920
      fps: 15

database:
  # The path to store the SQLite DB (default: shown below)
  path: /db/frigate.db

Relevant log output

[s6-init] making user provided files available at /var/run/s6/etc...exited 0.
[s6-init] ensuring user provided files have correct perms...exited 0.
[fix-attrs.d] applying ownership & permissions fixes...
[fix-attrs.d] done.
[cont-init.d] executing container initialization scripts...
[cont-init.d] done.
[services.d] starting services
[services.d] done.
[2022-08-21 16:55:02] frigate.app                    INFO    : Starting Frigate (0.10.1-83481af)
Starting migrations
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Starting migrations
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE TABLE IF NOT EXISTS "migratehistory" ("id" INTEGER NOT NULL PRIMARY KEY, "name" VARCHAR(255) NOT NULL, "migrated_at" DATETIME NOT NULL)', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."name", "t1"."migrated_at" FROM "migratehistory" AS "t1" ORDER BY "t1"."id"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('SELECT "t1"."id", "t1"."name", "t1"."migrated_at" FROM "migratehistory" AS "t1" ORDER BY "t1"."id"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('BEGIN', None)
Migrate "001_create_events_table"
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Migrate "001_create_events_table"
sql ('CREATE TABLE IF NOT EXISTS "event" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "label" VARCHAR(20) NOT NULL, "camera" VARCHAR(20) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "top_score" REAL NOT NULL, "false_positive" INTEGER NOT NULL, "zones" JSON NOT NULL, "thumbnail" TEXT NOT NULL)',)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : sql ('CREATE TABLE IF NOT EXISTS "event" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "label" VARCHAR(20) NOT NULL, "camera" VARCHAR(20) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "top_score" REAL NOT NULL, "false_positive" INTEGER NOT NULL, "zones" JSON NOT NULL, "thumbnail" TEXT NOT NULL)',)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE TABLE IF NOT EXISTS "event" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "label" VARCHAR(20) NOT NULL, "camera" VARCHAR(20) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "top_score" REAL NOT NULL, "false_positive" INTEGER NOT NULL, "zones" JSON NOT NULL, "thumbnail" TEXT NOT NULL)', [])
sql ('CREATE INDEX IF NOT EXISTS "event_label" ON "event" ("label")',)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : sql ('CREATE INDEX IF NOT EXISTS "event_label" ON "event" ("label")',)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX IF NOT EXISTS "event_label" ON "event" ("label")', [])
sql ('CREATE INDEX IF NOT EXISTS "event_camera" ON "event" ("camera")',)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : sql ('CREATE INDEX IF NOT EXISTS "event_camera" ON "event" ("camera")',)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX IF NOT EXISTS "event_camera" ON "event" ("camera")', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "migratehistory" ("name", "migrated_at") VALUES (?, ?)', ['001_create_events_table', datetime.datetime(2022, 8, 21, 21, 55, 2, 31185)])
Done 001_create_events_table
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Done 001_create_events_table
[2022-08-21 16:55:02] peewee                         DEBUG   : ('BEGIN', None)
Migrate "002_add_clip_snapshot"
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Migrate "002_add_clip_snapshot"
add_column ('event', 'has_clip', <BooleanField: Event.has_clip>)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : add_column ('event', 'has_clip', <BooleanField: Event.has_clip>)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event" ADD COLUMN "has_clip" INTEGER', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('UPDATE "event" SET "has_clip" = ?', [True])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".table_info("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('select name, sql from sqlite_master where type=? and LOWER(name)=?', ['table', 'event'])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('SELECT name, sql FROM "main".sqlite_master WHERE tbl_name = ? AND type = ? ORDER BY name', ('event', 'index'))
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_camera")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_label")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("sqlite_autoindex_event_1")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".foreign_key_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE IF EXISTS "event__tmp__"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE TABLE "event__tmp__" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "label" VARCHAR(20) NOT NULL, "camera" VARCHAR(20) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "top_score" REAL NOT NULL, "false_positive" INTEGER NOT NULL, "zones" JSON NOT NULL, "thumbnail" TEXT NOT NULL, "has_clip" INTEGER NOT NULL)', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "event__tmp__" ("id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip") SELECT "id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip" FROM "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event__tmp__" RENAME TO "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_camera" ON "event" ("camera")', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_label" ON "event" ("label")', [])
add_column ('event', 'has_snapshot', <BooleanField: Event.has_snapshot>)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : add_column ('event', 'has_snapshot', <BooleanField: Event.has_snapshot>)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event" ADD COLUMN "has_snapshot" INTEGER', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('UPDATE "event" SET "has_snapshot" = ?', [True])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".table_info("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('select name, sql from sqlite_master where type=? and LOWER(name)=?', ['table', 'event'])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('SELECT name, sql FROM "main".sqlite_master WHERE tbl_name = ? AND type = ? ORDER BY name', ('event', 'index'))
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_camera")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_label")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("sqlite_autoindex_event_1")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".foreign_key_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE IF EXISTS "event__tmp__"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE TABLE "event__tmp__" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "label" VARCHAR(20) NOT NULL, "camera" VARCHAR(20) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "top_score" REAL NOT NULL, "false_positive" INTEGER NOT NULL, "zones" JSON NOT NULL, "thumbnail" TEXT NOT NULL, "has_clip" INTEGER NOT NULL, "has_snapshot" INTEGER NOT NULL)', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "event__tmp__" ("id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot") SELECT "id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot" FROM "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event__tmp__" RENAME TO "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_camera" ON "event" ("camera")', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_label" ON "event" ("label")', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "migratehistory" ("name", "migrated_at") VALUES (?, ?)', ['002_add_clip_snapshot', datetime.datetime(2022, 8, 21, 21, 55, 2, 44084)])
Done 002_add_clip_snapshot
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Done 002_add_clip_snapshot
[2022-08-21 16:55:02] peewee                         DEBUG   : ('BEGIN', None)
Migrate "003_create_recordings_table"
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Migrate "003_create_recordings_table"
sql ('CREATE TABLE IF NOT EXISTS "recordings" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "camera" VARCHAR(20) NOT NULL, "path" VARCHAR(255) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "duration" REAL NOT NULL)',)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : sql ('CREATE TABLE IF NOT EXISTS "recordings" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "camera" VARCHAR(20) NOT NULL, "path" VARCHAR(255) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "duration" REAL NOT NULL)',)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE TABLE IF NOT EXISTS "recordings" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "camera" VARCHAR(20) NOT NULL, "path" VARCHAR(255) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "duration" REAL NOT NULL)', [])
sql ('CREATE INDEX IF NOT EXISTS "recordings_camera" ON "recordings" ("camera")',)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : sql ('CREATE INDEX IF NOT EXISTS "recordings_camera" ON "recordings" ("camera")',)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX IF NOT EXISTS "recordings_camera" ON "recordings" ("camera")', [])
sql ('CREATE UNIQUE INDEX IF NOT EXISTS "recordings_path" ON "recordings" ("path")',)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : sql ('CREATE UNIQUE INDEX IF NOT EXISTS "recordings_path" ON "recordings" ("path")',)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE UNIQUE INDEX IF NOT EXISTS "recordings_path" ON "recordings" ("path")', [])
sql ('CREATE INDEX IF NOT EXISTS "recordings_start_time_end_time" ON "recordings" (start_time, end_time)',)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : sql ('CREATE INDEX IF NOT EXISTS "recordings_start_time_end_time" ON "recordings" (start_time, end_time)',)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX IF NOT EXISTS "recordings_start_time_end_time" ON "recordings" (start_time, end_time)', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "migratehistory" ("name", "migrated_at") VALUES (?, ?)', ['003_create_recordings_table', datetime.datetime(2022, 8, 21, 21, 55, 2, 48927)])
Done 003_create_recordings_table
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Done 003_create_recordings_table
[2022-08-21 16:55:02] peewee                         DEBUG   : ('BEGIN', None)
Migrate "004_add_bbox_region_area"
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Migrate "004_add_bbox_region_area"
add_column ('event', 'region', <JSONField: Event.region>)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : add_column ('event', 'region', <JSONField: Event.region>)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event" ADD COLUMN "region" JSON', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('UPDATE "event" SET "region" = json(?)', ['[]'])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".table_info("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('select name, sql from sqlite_master where type=? and LOWER(name)=?', ['table', 'event'])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('SELECT name, sql FROM "main".sqlite_master WHERE tbl_name = ? AND type = ? ORDER BY name', ('event', 'index'))
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_camera")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_label")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("sqlite_autoindex_event_1")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".foreign_key_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE IF EXISTS "event__tmp__"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE TABLE "event__tmp__" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "label" VARCHAR(20) NOT NULL, "camera" VARCHAR(20) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "top_score" REAL NOT NULL, "false_positive" INTEGER NOT NULL, "zones" JSON NOT NULL, "thumbnail" TEXT NOT NULL, "has_clip" INTEGER NOT NULL, "has_snapshot" INTEGER NOT NULL, "region" JSON NOT NULL)', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "event__tmp__" ("id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot", "region") SELECT "id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot", "region" FROM "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event__tmp__" RENAME TO "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_camera" ON "event" ("camera")', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_label" ON "event" ("label")', [])
add_column ('event', 'box', <JSONField: Event.box>)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : add_column ('event', 'box', <JSONField: Event.box>)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event" ADD COLUMN "box" JSON', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('UPDATE "event" SET "box" = json(?)', ['[]'])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".table_info("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('select name, sql from sqlite_master where type=? and LOWER(name)=?', ['table', 'event'])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('SELECT name, sql FROM "main".sqlite_master WHERE tbl_name = ? AND type = ? ORDER BY name', ('event', 'index'))
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_camera")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_label")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("sqlite_autoindex_event_1")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".foreign_key_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE IF EXISTS "event__tmp__"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE TABLE "event__tmp__" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "label" VARCHAR(20) NOT NULL, "camera" VARCHAR(20) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "top_score" REAL NOT NULL, "false_positive" INTEGER NOT NULL, "zones" JSON NOT NULL, "thumbnail" TEXT NOT NULL, "has_clip" INTEGER NOT NULL, "has_snapshot" INTEGER NOT NULL, "region" JSON NOT NULL, "box" JSON NOT NULL)', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "event__tmp__" ("id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot", "region", "box") SELECT "id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot", "region", "box" FROM "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event__tmp__" RENAME TO "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_camera" ON "event" ("camera")', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_label" ON "event" ("label")', [])
add_column ('event', 'area', <IntegerField: Event.area>)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : add_column ('event', 'area', <IntegerField: Event.area>)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event" ADD COLUMN "area" INTEGER', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('UPDATE "event" SET "area" = ?', [0])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".table_info("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('select name, sql from sqlite_master where type=? and LOWER(name)=?', ['table', 'event'])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('SELECT name, sql FROM "main".sqlite_master WHERE tbl_name = ? AND type = ? ORDER BY name', ('event', 'index'))
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_camera")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_label")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("sqlite_autoindex_event_1")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".foreign_key_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE IF EXISTS "event__tmp__"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE TABLE "event__tmp__" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "label" VARCHAR(20) NOT NULL, "camera" VARCHAR(20) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME NOT NULL, "top_score" REAL NOT NULL, "false_positive" INTEGER NOT NULL, "zones" JSON NOT NULL, "thumbnail" TEXT NOT NULL, "has_clip" INTEGER NOT NULL, "has_snapshot" INTEGER NOT NULL, "region" JSON NOT NULL, "box" JSON NOT NULL, "area" INTEGER NOT NULL)', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "event__tmp__" ("id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot", "region", "box", "area") SELECT "id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot", "region", "box", "area" FROM "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event__tmp__" RENAME TO "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_camera" ON "event" ("camera")', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_label" ON "event" ("label")', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "migratehistory" ("name", "migrated_at") VALUES (?, ?)', ['004_add_bbox_region_area', datetime.datetime(2022, 8, 21, 21, 55, 2, 66552)])
Done 004_add_bbox_region_area
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Done 004_add_bbox_region_area
[2022-08-21 16:55:02] peewee                         DEBUG   : ('BEGIN', None)
Migrate "005_make_end_time_nullable"
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Migrate "005_make_end_time_nullable"
drop_not_null ('event', 'end_time')
[2022-08-21 16:55:02] peewee_migrate                 INFO    : drop_not_null ('event', 'end_time')
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".table_info("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('select name, sql from sqlite_master where type=? and LOWER(name)=?', ['table', 'event'])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('SELECT name, sql FROM "main".sqlite_master WHERE tbl_name = ? AND type = ? ORDER BY name', ('event', 'index'))
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_camera")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("event_label")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".index_info("sqlite_autoindex_event_1")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('PRAGMA "main".foreign_key_list("event")', None)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE IF EXISTS "event__tmp__"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE TABLE "event__tmp__" ("id" VARCHAR(30) NOT NULL PRIMARY KEY, "label" VARCHAR(20) NOT NULL, "camera" VARCHAR(20) NOT NULL, "start_time" DATETIME NOT NULL, "end_time" DATETIME , "top_score" REAL NOT NULL, "false_positive" INTEGER NOT NULL, "zones" JSON NOT NULL, "thumbnail" TEXT NOT NULL, "has_clip" INTEGER NOT NULL, "has_snapshot" INTEGER NOT NULL, "region" JSON NOT NULL, "box" JSON NOT NULL, "area" INTEGER NOT NULL)', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "event__tmp__" ("id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot", "region", "box", "area") SELECT "id", "label", "camera", "start_time", "end_time", "top_score", "false_positive", "zones", "thumbnail", "has_clip", "has_snapshot", "region", "box", "area" FROM "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('DROP TABLE "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "event__tmp__" RENAME TO "event"', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_camera" ON "event" ("camera")', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('CREATE INDEX "event_label" ON "event" ("label")', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "migratehistory" ("name", "migrated_at") VALUES (?, ?)', ['005_make_end_time_nullable', datetime.datetime(2022, 8, 21, 21, 55, 2, 74628)])
Done 005_make_end_time_nullable
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Done 005_make_end_time_nullable
[2022-08-21 16:55:02] peewee                         DEBUG   : ('BEGIN', None)
Migrate "006_add_motion_active_objects"
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Migrate "006_add_motion_active_objects"
add_column ('recordings', 'objects', <IntegerField: Recordings.objects>)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : add_column ('recordings', 'objects', <IntegerField: Recordings.objects>)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "recordings" ADD COLUMN "objects" INTEGER', [])
add_column ('recordings', 'motion', <IntegerField: Recordings.motion>)
[2022-08-21 16:55:02] peewee_migrate                 INFO    : add_column ('recordings', 'motion', <IntegerField: Recordings.motion>)
[2022-08-21 16:55:02] peewee                         DEBUG   : ('ALTER TABLE "recordings" ADD COLUMN "motion" INTEGER', [])
[2022-08-21 16:55:02] peewee                         DEBUG   : ('INSERT INTO "migratehistory" ("name", "migrated_at") VALUES (?, ?)', ['006_add_motion_active_objects', datetime.datetime(2022, 8, 21, 21, 55, 2, 78859)])
Done 006_add_motion_active_objects
[2022-08-21 16:55:02] peewee_migrate                 INFO    : Done 006_add_motion_active_objects
[Errno -2] Name or service not known
[cmd] python3 exited 1
[cont-finish.d] executing container finish scripts...
[cont-finish.d] done.
[s6-finish] waiting for services.
[s6-finish] sending all processes the TERM signal.
[s6-finish] sending all processes the KILL signal and exiting.

FFprobe output from your camera

ffprobe version 3.4.11-0ubuntu0.1 Copyright (c) 2007-2022 the FFmpeg developers
  built with gcc 7 (Ubuntu 7.5.0-3ubuntu1~18.04)
  configuration: --prefix=/usr --extra-version=0ubuntu0.1 --toolchain=hardened --libdir=/usr/lib/x86_64-linux-gnu --incdir=/usr/include/x86_64-linux-gnu --enable-gpl --disable-stripping --enable-avresample --enable-avisynth --enable-gnutls --enable-ladspa --enable-libass --enable-libbluray --enable-libbs2b --enable-libcaca --enable-libcdio --enable-libflite --enable-libfontconfig --enable-libfreetype --enable-libfribidi --enable-libgme --enable-libgsm --enable-libmp3lame --enable-libmysofa --enable-libopenjpeg --enable-libopenmpt --enable-libopus --enable-libpulse --enable-librubberband --enable-librsvg --enable-libshine --enable-libsnappy --enable-libsoxr --enable-libspeex --enable-libssh --enable-libtheora --enable-libtwolame --enable-libvorbis --enable-libvpx --enable-libwavpack --enable-libwebp --enable-libx265 --enable-libxml2 --enable-libxvid --enable-libzmq --enable-libzvbi --enable-omx --enable-openal --enable-opengl --enable-sdl2 --enable-libdc1394 --enable-libdrm --enable-libiec61883 --enable-chromaprint --enable-frei0r --enable-libopencv --enable-libx264 --enable-shared
  WARNING: library configuration mismatch
  avcodec     configuration: --prefix=/usr --extra-version=0ubuntu0.1 --toolchain=hardened --libdir=/usr/lib/x86_64-linux-gnu --incdir=/usr/include/x86_64-linux-gnu --enable-gpl --disable-stripping --enable-avresample --enable-avisynth --enable-gnutls --enable-ladspa --enable-libass --enable-libbluray --enable-libbs2b --enable-libcaca --enable-libcdio --enable-libflite --enable-libfontconfig --enable-libfreetype --enable-libfribidi --enable-libgme --enable-libgsm --enable-libmp3lame --enable-libmysofa --enable-libopenjpeg --enable-libopenmpt --enable-libopus --enable-libpulse --enable-librubberband --enable-librsvg --enable-libshine --enable-libsnappy --enable-libsoxr --enable-libspeex --enable-libssh --enable-libtheora --enable-libtwolame --enable-libvorbis --enable-libvpx --enable-libwavpack --enable-libwebp --enable-libx265 --enable-libxml2 --enable-libxvid --enable-libzmq --enable-libzvbi --enable-omx --enable-openal --enable-opengl --enable-sdl2 --enable-libdc1394 --enable-libdrm --enable-libiec61883 --enable-chromaprint --enable-frei0r --enable-libopencv --enable-libx264 --enable-shared --enable-version3 --disable-doc --disable-programs --enable-libopencore_amrnb --enable-libopencore_amrwb --enable-libtesseract --enable-libvo_amrwbenc
  libavutil      55. 78.100 / 55. 78.100
  libavcodec     57.107.100 / 57.107.100
  libavformat    57. 83.100 / 57. 83.100
  libavdevice    57. 10.100 / 57. 10.100
  libavfilter     6.107.100 /  6.107.100
  libavresample   3.  7.  0 /  3.  7.  0
  libswscale      4.  8.100 /  4.  8.100
  libswresample   2.  9.100 /  2.  9.100
  libpostproc    54.  7.100 / 54.  7.100
Input #0, rtsp, from 'rtsp://aaaaa:zzzzz@192.168.1.jj:554/cam/realmonitor?channel=1&subtype=0&authbasic=64':
  Metadata:
    title           : Media Server
  Duration: N/A, start: 0.000000, bitrate: N/A
    Stream #0:0: Video: h264 (Baseline), yuv420p(progressive), 2560x1920, 15 fps, 100 tbr, 90k tbn, 30 tbc
    Stream #0:1: Audio: aac (LC), 8000 Hz, mono, fltp

Frigate stats

No response

Operating system

Debian

Install method

Docker CLI

Coral version

CPU (no coral)

Network connection

Wired

Camera make and model

Amcrest AD410

Any other information that may be helpful

Along with the above config, here are the docker install commands:

docker run   --name frigate   --restart=unless-stopped   --mount type=tmpfs,target=/tmp/cache,tmpfs-size=1000000000   --device /dev/dri/renderD128   --shm-size=64m   -v /media/virtual/frigate/clips:/media/frigate/clips   -v /media/virtual/frigate/recordings:/media/frigate/recordings   -v /home/jay/configs/frigate:/db   -v /home/jay/configs/frigate/config.yml:/config/config.yml:ro   -v /etc/localtime:/etc/localtime:ro   -e FRIGATE_RTSP_PASSWORD='aaaaaaaa'   -p 5001:5000   -p 1935:1935   blakeblackshear/frigate:stable-amd64
NickM-27 commented 2 years ago

You're including the port :1883 in the host but that is incorrect, the port is defined separately

jds11111 commented 2 years ago

D'oh! That was it. Many thanks.