database regeneration gives "could not obtain exclusive DB Access"

Post Reply
NGNeer314
Posts: 23
Joined: Tue Nov 26, 2019 9:40 pm

database regeneration gives "could not obtain exclusive DB Access"

Post by NGNeer314 »

on the clip-storage status tab i clicked "Repair DB", and then this showed up in the messages. What could be causing this?
cer.jpg
cer.jpg (34.86 KiB) Viewed 16120 times
NGNeer314
Posts: 23
Joined: Tue Nov 26, 2019 9:40 pm

Re: database regeneration gives "could not obtain exclusive DB Access"

Post by NGNeer314 »

after rebooting the computer i tried the "rebuild DB" button again. This time it seems to be working, but it says regenerating 5549 files, even though there's less than 500 files in the BlueIris folders. When it says "files" does it not mean physical files?
1-29-2020 8-18-26 PM.jpg
1-29-2020 8-18-26 PM.jpg (20.6 KiB) Viewed 16118 times
MikeBwca
Posts: 1122
Joined: Thu Jun 20, 2019 5:39 am

Re: database regeneration gives "could not obtain exclusive DB Access"

Post by MikeBwca »

This reply has been deleted. More accurate info has been posted.
Last edited by MikeBwca on Thu Jan 30, 2020 6:33 am, edited 2 times in total.
MikeBwca
Posts: 1122
Joined: Thu Jun 20, 2019 5:39 am

Re: database regeneration gives "could not obtain exclusive DB Access"

Post by MikeBwca »

NGNeer314 wrote: Thu Jan 30, 2020 1:01 am on the clip-storage status tab i clicked "Repair DB", and then this showed up in the messages. What could be causing this?
Well, something was holding it.

Make sure your BI drive is excluded from Search Indexing, and, Your anti virus program.
MikeBwca
Posts: 1122
Joined: Thu Jun 20, 2019 5:39 am

Re: database regeneration gives "could not obtain exclusive DB Access"

Post by MikeBwca »

NGNeer314 wrote: Thu Jan 30, 2020 1:20 am after rebooting the computer i tried the "rebuild DB" button again. This time it seems to be working, but it says regenerating 5549 files, even though there's less than 500 files in the BlueIris folders. When it says "files" does it not mean physical files?
1-29-2020 8-18-26 PM.jpg
Each clip is counted as a 'file', even if it is a pointer into a contiguous recording and not a physical recording.

I tested this by listing all the clips in the clip list, then adding all the contiguous current records. It all added up. And, yes, I had significantly less physical files.
NGNeer314
Posts: 23
Joined: Tue Nov 26, 2019 9:40 pm

Re: database regeneration gives "could not obtain exclusive DB Access"

Post by NGNeer314 »

MikeBwca wrote: Thu Jan 30, 2020 6:29 am Each clip is counted as a 'file',
if you would excuse another silly question, what defines a "clip"? I have all the camera's set to record continously. I thought each camera gets recorded to a single file until some maximum file size is reached. or does a new "clip" whenever motion is detected?
NGNeer314
Posts: 23
Joined: Tue Nov 26, 2019 9:40 pm

Re: database regeneration gives "could not obtain exclusive DB Access"

Post by NGNeer314 »

MikeBwca wrote: Thu Jan 30, 2020 4:17 am
Well, something was holding it.

Make sure your BI drive is excluded from Search Indexing, and, Your anti virus program.
my BI PC has no antivirus program. I did go ahead just now and disabled indexing, thats a good idea...
MikeBwca
Posts: 1122
Joined: Thu Jun 20, 2019 5:39 am

Re: database regeneration gives "could not obtain exclusive DB Access"

Post by MikeBwca »

Tonight I received the same message when trying to repair/regenerate the database! I just recycled BI, and it was fine.
That was a weird coincidence.
NGNeer314
Posts: 23
Joined: Tue Nov 26, 2019 9:40 pm

Re: database regeneration gives "could not obtain exclusive DB Access"

Post by NGNeer314 »

I might have finally figured out what caused the "locked file" error messages (which hopefully also was causing all my other problems...). I had only allocated 10 Gigs for the "New" folder, after which it was getting moved to Stored. Apparently some BVR files were being moved to Storage even though BI was still writing to them.

ANyway, I bumped up the "New" folder to 100 gig. So far no "locked file" messages, or other problems. Hope this did it...
User avatar
TimG
Posts: 2678
Joined: Tue Jun 18, 2019 10:45 am
Location: Nottinghamshire, UK.

Re: database regeneration gives "could not obtain exclusive DB Access"

Post by TimG »

Now that makes sense. Users usually have the opposite problem after over allocating space, but 10GB is indeed very low. My"New" folder is presently set to 210GB on a 250GB SSD. Keep an eye on the clip storage graph to check it is OK.
Forum Moderator.
Problem ? Ask and we will try to assist, but please check the Help file.
Post Reply