Alert playback starting at beginning of clip versus the trigger point

[hubbend]

If I double click and alert clip, sometimes playback will be from the beginning of the saved clip versus at the trigger point. I have my video setup for continuous sub + alerts and combine or cut video every hour.

For example, lets say I have an alert at 07:35. If I double click that alert in the clips list, sometimes the playback will be from the start of the clip (07:00 in this example) versus from the alert (07:35 in this example). This doesn't happen for all time. I can select the same clip multiple times and it will eventually show the clip starting at the alert time.

Blue Iris version: 5.9.4.5 (this has happened on earlier versions as well).

 

[jaydeel]

This suggests that the alert offset is not always being retrieved from the database.

Are there any database-related entries in the logfile? For example 'DB, DBRegenerate: corruption skipping xxx bytes '

Have you recently performed a database Repair/Regenerate?

 

[hubbend]

This suggests that the alert offset is not always being retrieved from the database.

Are there any database-related entries in the logfile? For example 'DB, DBRegenerate: corruption skipping xxx bytes '

Have you recently performed a database Repair/Regenerate?

I pulled out the DB items from the latest log and there is this:

202407.txt:20250:0 7/3/2024 9:24:11.297 AM DB DBRegenerate: started
202407.txt:20251:1 7/3/2024 9:24:12.047 AM DB DBRegenerate: corruption skipping 730720 bytes
202407.txt:20253:0 7/3/2024 9:35:46.082 AM DB DBRegenerate: 184926 records

I did a DB repair this morning with no issue in the regenerate phase and I still see the clip issue.

Spoiler: Select-String 'DB' output

202407.txt:212:0 7/1/2024 2:00:05.717 AM DB DBCompact: started
202407.txt:213:0 7/1/2024 2:01:39.045 AM DB DBCompact: finished
202407.txt:214:1 7/1/2024 2:01:53.668 AM DB Reindexing: 179300 records 14614 msec
202407.txt:10156:0 7/2/2024 2:00:03.465 AM DB DBCompact: started
202407.txt:10157:0 7/2/2024 2:01:37.312 AM DB DBCompact: finished
202407.txt:10158:1 7/2/2024 2:01:52.277 AM DB Reindexing: 182337 records 14959 msec
202407.txt:11106:0 7/2/2024 8:31:01.610 AM DB DBCompact: started
202407.txt:11108:0 7/2/2024 8:32:33.924 AM DB DBCompact: finished
202407.txt:11109:1 7/2/2024 8:32:48.583 AM DB Reindexing: 182481 records 14666 msec
202407.txt:16401:0 7/2/2024 4:14:17.781 PM DB DBCompact: started
202407.txt:16402:0 7/2/2024 4:15:51.533 PM DB DBCompact: finished
202407.txt:16403:1 7/2/2024 4:16:06.873 PM DB Reindexing: 184218 records 15342 msec
202407.txt:18658:0 7/3/2024 2:00:06.164 AM DB DBCompact: started
202407.txt:18659:0 7/3/2024 2:01:22.400 AM DB DBCompact: finished
202407.txt:18660:1 7/3/2024 2:01:36.690 AM DB Reindexing: 184684 records 14189 msec
202407.txt:20238:0 7/3/2024 9:18:53.697 AM DB DBCompact: started
202407.txt:20242:0 7/3/2024 9:23:29.908 AM DB DBCompact: started
202407.txt:20249:1 7/3/2024 9:24:08.701 AM DB DBCompact: running repair
202407.txt:20250:0 7/3/2024 9:24:11.297 AM DB DBRegenerate: started
202407.txt:20251:1 7/3/2024 9:24:12.047 AM DB DBRegenerate: corruption skipping 730720 bytes
202407.txt:20253:0 7/3/2024 9:35:46.082 AM DB DBRegenerate: 184926 records
202407.txt:20257:0 7/3/2024 9:38:30.311 AM DB DBRegenerate: adopting f:\BlueIris\Stored\Gate\2024.06\Gate.20240614_230000.bvr
202407.txt:20265:0 7/3/2024 9:38:53.856 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\ThirdCar\2024.07\ThirdCar.20240703_090000.252497.3-1.jpg
202407.txt:20266:0 7/3/2024 9:38:53.855 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Right\2024.07\Right.20240703_090000.258085.3-1.jpg
202407.txt:20267:0 7/3/2024 9:38:53.866 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\ThirdCar\2024.07\ThirdCar.20240703_090000.301817.3-1.jpg
202407.txt:20268:0 7/3/2024 9:38:53.880 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Left\2024.07\Left.20240703_090000.306073.3-9.jpg
202407.txt:20269:0 7/3/2024 9:38:53.891 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Right\2024.07\Right.20240703_090000.308903.3-1.jpg
202407.txt:20270:0 7/3/2024 9:38:53.800 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Right\2024.07\Right.20240703_090000.354962.3-1.jpg
202407.txt:20271:0 7/3/2024 9:38:53.911 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Left\2024.07\Left.20240703_090000.356883.3-5.jpg
202407.txt:20272:0 7/3/2024 9:38:53.922 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Right\2024.07\Right.20240703_090000.486582.3-1.jpg
202407.txt:20273:0 7/3/2024 9:38:53.930 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Right\2024.07\Right.20240703_090000.489052.3-1.jpg
202407.txt:20274:0 7/3/2024 9:38:53.940 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Left\2024.07\Left.20240703_090000.489434.3-5.jpg
202407.txt:20275:0 7/3/2024 9:38:53.961 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\ThirdCar\2024.07\ThirdCar.20240703_090000.489713.3-1.jpg
202407.txt:20276:0 7/3/2024 9:38:53.971 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\LPR\2024.07\LPR.20240703_090000.544196.5-0.jpg
202407.txt:20277:0 7/3/2024 9:38:54.012 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Right\2024.07\Right.20240703_090000.548256.3-1.jpg
202407.txt:20278:0 7/3/2024 9:38:54.011 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Left\2024.07\Left.20240703_090000.547640.3-5.jpg
202407.txt:20279:0 7/3/2024 9:38:54.022 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\ThirdCar\2024.07\ThirdCar.20240703_090000.546793.3-1.jpg
202407.txt:20280:0 7/3/2024 9:38:54.032 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Palms\2024.07\Palms.20240703_090002.550202.3-1.jpg
202407.txt:20281:0 7/3/2024 9:38:54.040 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\ThirdCar\2024.07\ThirdCar.20240703_090000.569884.3-1.jpg
202407.txt:20282:0 7/3/2024 9:38:54.058 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Left\2024.07\Left.20240703_090000.573640.3-9.jpg
202407.txt:20283:0 7/3/2024 9:38:54.065 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Palms\2024.07\Palms.20240703_090002.581338.3-1.jpg
202407.txt:20284:0 7/3/2024 9:38:54.073 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Palms\2024.07\Palms.20240703_090002.593693.3-1.jpg
202407.txt:20285:0 7/3/2024 9:38:54.081 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Left\2024.07\Left.20240703_090000.606299.3-9.jpg
202407.txt:20286:0 7/3/2024 9:38:54.091 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Right\2024.07\Right.20240703_090000.607197.3-1.jpg
202407.txt:20287:0 7/3/2024 9:38:54.101 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\ThirdCar\2024.07\ThirdCar.20240703_090000.606242.3-1.jpg
202407.txt:20288:0 7/3/2024 9:38:54.111 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Palms\2024.07\Palms.20240703_090002.628351.3-1.jpg
202407.txt:20289:0 7/3/2024 9:38:54.118 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Right\2024.07\Right.20240703_090000.633986.3-1.jpg
202407.txt:20290:0 7/3/2024 9:38:54.127 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Left\2024.07\Left.20240703_090000.634330.3-3.jpg
202407.txt:20291:0 7/3/2024 9:38:54.138 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\ThirdCar\2024.07\ThirdCar.20240703_090000.639441.3-1.jpg
202407.txt:20292:0 7/3/2024 9:38:54.147 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Left\2024.07\Left.20240703_090000.725730.3-9.jpg
202407.txt:20293:0 7/3/2024 9:38:54.158 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\LPR\2024.07\LPR.20240703_090000.727566.5-0.jpg
202407.txt:20294:0 7/3/2024 9:38:54.191 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\ThirdCar\2024.07\ThirdCar.20240703_090000.726643.3-1.jpg
202407.txt:20295:0 7/3/2024 9:38:54.100 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Right\2024.07\Right.20240703_090000.730807.3-1.jpg
202407.txt:20296:0 7/3/2024 9:38:54.200 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Left\2024.07\Left.20240703_090000.749980.3-5.jpg
202407.txt:20297:0 7/3/2024 9:38:54.222 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\Right\2024.07\Right.20240703_090000.754446.3-1.jpg
202407.txt:20298:0 7/3/2024 9:38:54.233 AM DB DBRegenerate: adopting F:\BlueIris\Alerts\ThirdCar\2024.07\ThirdCar.20240703_090000.761774.3-1.jpg
202407.txt:20299:0 7/3/2024 9:38:54.725 AM DB DBRegenerate: success
202407.txt:20300:0 7/3/2024 9:38:55.876 AM DB Reindexing: 184925 records 1153 msec
202407.txt:27132:0 7/4/2024 2:00:04.733 AM DB DBCompact: started
202407.txt:27133:0 7/4/2024 2:01:20.952 AM DB DBCompact: finished
202407.txt:27134:0 7/4/2024 2:01:22.453 AM DB Reindexing: 186753 records 1505 msec
202407.txt:28305:0 7/4/2024 10:05:46.404 AM DB DBCompact: started
202407.txt:28313:0 7/4/2024 10:07:08.653 AM DB DBCompact: finished
202407.txt:28314:0 7/4/2024 10:07:10.780 AM DB Reindexing: 186938 records 2122 msec
202407.txt:34004:0 7/5/2024 2:00:04.435 AM DB DBCompact: started
202407.txt:34005:0 7/5/2024 2:01:21.413 AM DB DBCompact: finished
202407.txt:34006:1 7/5/2024 2:01:37.303 AM DB Reindexing: 188642 records 15892 msec
202407.txt:35827:0 7/5/2024 11:28:47.591 AM DB DBRegenerate: started
202407.txt:35879:0 7/5/2024 11:46:12.700 AM DB DBRegenerate: 189015 records
202407.txt:35880:0 7/5/2024 11:47:35.406 AM DB DBRegenerate: success
202407.txt:35881:1 7/5/2024 11:47:46.286 AM DB Reindexing: 189015 records 10882 msec

 

[jaydeel]

Have you performed a database Repair & Regenerate

I pulled out the DB items from the latest log and there is this:

202407.txt:20250:0 7/3/2024 9:24:11.297 AM DB DBRegenerate: started
202407.txt:20251:1 7/3/2024 9:24:12.047 AM DB DBRegenerate: corruption skipping 730720 bytes
202407.txt:20253:0 7/3/2024 9:35:46.082 AM DB DBRegenerate: 184926 records

I did a DB repair this morning with no issue in the regenerate phase and I still see the clip issue.

I found a few old threads reporting a similar issue (google search), but found no solutions... except asking if the user was always double-clicking clips list items with the alerts filter applied (the lightning bold icon, not the 'All clips' icon).

You might have to take the next step of blowing out the existing database with a 'Delete & Regenerate' action,
But be warned that this will cause you to lose all database thumbprints in the clips list.
The only way you can preserve Alert images is if you 1) set the alert's Protect flag and 2) are either saving Hi-Res JPGS, or using AI while also saving DAT files and/or burning alert image markups. I only protect alerts that I want to preserve.

If you want to avoid this for now, then I suggest you email Blue Iris Support.
If this is your first time, click the '?' icon in the UI and follow the instructions. And be prepared to wait days for a response; it's a one-man shop.

Also, I note that you have your video recording setup for continuous sub + alerts. Many of us use continuous sub + triggered. This ensures that you recording the best quality video during all events, regardless if an alert is generated. At some point you will be happy you did this.

 

[hubbend]

Have you performed a database Repair & Regenerate

I found a few old threads reporting a similar issue (google search), but found no solutions... except asking if the user was always double-clicking clips list items with the alerts filter applied (the lightning bold icon, not the 'All clips' icon).

You might have to take the next step of blowing out the existing database with a 'Delete & Regenerate' action,
But be warned that this will cause you to lose all database thumbprints in the clips list.
The only way you can preserve Alert images is if you 1) set the alert's Protect flag and 2) are either saving Hi-Res JPGS, or using AI while also saving DAT files and/or burning alert image markups. I only protect alerts that I want to preserve.

If you want to avoid this for now, then I suggest you email Blue Iris Support.
If this is your first time, click the '?' icon in the UI and follow the instructions. And be prepared to wait days for a response; it's a one-man shop.

Also, I note that you have your video recording setup for continuous sub + alerts. Many of us use continuous sub + triggered. This ensures that you recording the best quality video during all events, regardless if an alert is generated. At some point you will be happy you did this.

Thanks @jaydeel for the response. I will change over to continuous sub + triggered and just kind of flow with the oddity in playing back clips for now.