[Bug]: No possibility to watch motion recordings

[krojew]

Describe the problem you are having

With the new UI, there doesn't seem to be any possibility of watching recordings based only on motion. In the old UI, one simply had to click Recordings -> Hour, but now when I go to Camera -> Reviews -> Motion -> Yellow timeline marker, I simply get a blank rectangle with "No Preview Found". There's no video when clicking on the timeline markers. There's no way to go to a fullscreen recording and skip the preview. There's no way to view a simple list of recordings. With Home Assistant integration, I can see there are, in fact, recordings.

Steps to reproduce

1. Set up a camera to capture on motion only.
2. Wait for some motion events to register.
3. Try to watch recordings.

Version

0.14.0-da913d8

Frigate config file

mqtt:
  enabled: true
  host: xxx
  user: xxx
  password: xxx
birdseye:
  enabled: false
record:
  enabled: true
  retain:
    days: 0
    mode: all
  events:
    retain:
      mode: motion
detect:
  enabled: true
motion:
  threshold: 20
detectors:
  ov:
    type: openvino
    device: CPU
    model:
      path: /openvino-model/ssdlite_mobilenet_v2.xml
model:
  width: 300
  height: 300
  input_tensor: nhwc
  input_pixel_format: bgr
  labelmap_path: /openvino-model/coco_91cl_bkgr.txt
ffmpeg:
  retry_interval: 60
cameras:
  xxx:
    ffmpeg:
      inputs:
        - path: xxx
          roles:
            - detect
            - record
    webui_url: xxx
    detect:
      enabled: false
    record:
      retain:
        days: 2
        mode: motion
    motion:
      mask:
        - 0,68,754,61,758,0,0,0
version: 0.14

Relevant log output

n/a

Operating system

Other Linux

Install method

Docker Compose

Network connection

Wired

Camera make and model

Reolink

Any other information that may be helpful

Please give the option to bring back the old UI.

[NickM-27]

The motion tab only shows previews. To view recordings you need to click on one of those cameras to go to the history viewer.

What time period were you looking at in the motion tab? No preview found would indicate that the preview was deleted or failed to be saved for some reason

[krojew]

Here you can see the problem:

The history viewer is not really an option since there's no possibility to jump to specific hour, like in the previous version, and the timeline scroll speed is absurdly low for 4k displays, to the point of being almost unusable in practice. If I wanted to jump to a recording made hours before, I would need to scroll for a very long time, given there's no option to limit the timeline only to recordings.

[NickM-27]

what timezone is your server and browser set to?

if you would be okay with it, you could email your database file to me [email protected] and I can take a look and see why it is not finding the previews when it should be.

[krojew]

Both are set to UTC+2. Unfortunately, I really cannot share database or anything which will show how the monitoring system is set up.

[NickM-27]

Okay, then perhaps you can run this SQL command locally on the database

SELECT path, start_time, end_time, duration FROM previews WHERE camera = 'YOUR_CAMERA_NAME' AND start_time > 1723993200 AND end_time < 1724079660; where you just need to set the camera name locally before running the command

[krojew]

There are some entries:

/media/frigate/clips/previews/xxx/1724014854.154357-1724018400.051998.mp4|1724014854.15436|1724018400.052|3545.89764094353
/media/frigate/clips/previews/xxx/1724018400.051998-1724022000.522738.mp4|1724018400.052|1724022000.52274|3600.47074007988
/media/frigate/clips/previews/xxx/1724022000.522738-1724025600.842412.mp4|1724022000.52274|1724025600.84241|3600.31967401505
/media/frigate/clips/previews/xxx/1724025600.842412-1724029201.011374.mp4|1724025600.84241|1724029201.01137|3600.1689620018
/media/frigate/clips/previews/xxx/1724029201.011374-1724032801.368087.mp4|1724029201.01137|1724032801.36809|3600.35671305656
/media/frigate/clips/previews/xxx/1724032801.368087-1724036401.740392.mp4|1724032801.36809|1724036401.74039|3600.37230491638

[NickM-27]

thank you, this all looks normal. Can you then open http://frigate_ip:port/api/preview/YOUR_CAMERA_NAME/start/1723971600/end/1724040000 and paste the output here?

[krojew]

[
{
"camera": "xxx",
"end": 1724014854.154357,
"src": "/clips/previews/xxx/1723946435.539624-1724014854.154357.mp4",
"start": 1723946435.539624,
"type": "video/mp4"
},
{
"camera": "xxx",
"end": 1724018400.051998,
"src": "/clips/previews/xxx/1724014854.154357-1724018400.051998.mp4",
"start": 1724014854.154357,
"type": "video/mp4"
},
{
"camera": "xxx",
"end": 1724022000.522738,
"src": "/clips/previews/xxx/1724018400.051998-1724022000.522738.mp4",
"start": 1724018400.051998,
"type": "video/mp4"
},
{
"camera": "xxx",
"end": 1724025600.842412,
"src": "/clips/previews/xxx/1724022000.522738-1724025600.842412.mp4",
"start": 1724022000.522738,
"type": "video/mp4"
},
{
"camera": "xxx",
"end": 1724029201.011374,
"src": "/clips/previews/xxx/1724025600.842412-1724029201.011374.mp4",
"start": 1724025600.842412,
"type": "video/mp4"
},
{
"camera": "xxx",
"end": 1724032801.368087,
"src": "/clips/previews/xxx/1724029201.011374-1724032801.368087.mp4",
"start": 1724029201.011374,
"type": "video/mp4"
},
{
"camera": "xxx",
"end": 1724036401.740392,
"src": "/clips/previews/xxx/1724032801.368087-1724036401.740392.mp4",
"start": 1724032801.368087,
"type": "video/mp4"
}
]

[NickM-27]

thanks, so to be clear if you go in the UI to Review -> Motion -> select xxx as the only camera and then click on 1:15 AM in the timeline, it says no preview found?

[krojew]

Now things are getting strange - there is a preview for 1:15, but no recording. The nearest recording is at 2:46 which has no preview.

[NickM-27]

some of your previews are generated "late", we can see the end time is 1724032801.368087 which is 1 second after the hour while others (as we expect) are generated on the hour. I will have a fix up for this one second issue soon

[NickM-27]

#13193

[NickM-27]

please create a new issue if this is still occurring on 0.14.1