Help with DB repair & maintenance

Discussion in 'Troubleshooting' started by nutt318, Jul 22, 2019.

Share This Page

  1. nutt318

    nutt318 Young grasshopper

    Joined:
    Jul 28, 2015
    Messages:
    48
    Likes Received:
    16
    Hello,

    So for some reason after our upgrade to v5 our DB maintenance kicked off again and caused issues with the DB. We previously had the maintenance disabled because our stored videos are so old.

    We currently have about 31TB of stored video and when searching for video in the past it would always show the little red dot next to the day that there are recordings. Anyways we have only about 3 days showing but the video files are still there.

    Just wondering what is the best way to get all of these recordings to show back up properly. Our DB is on local ssd and the stored and clips are on raid6 array. I've run the compact repair over the weekend but not sure if that really helped.

    Thanks for the help.
     
  2. fenderman

    fenderman Staff Member

    Joined:
    Mar 9, 2014
    Messages:
    30,818
    Likes Received:
    9,792
    Close blue Iris delete the database folder and restart blue Iris and let it regenerate itself.
     
  3. nutt318

    nutt318 Young grasshopper

    Joined:
    Jul 28, 2015
    Messages:
    48
    Likes Received:
    16
    So i've got around 200,000 video files and it took almost 36hours to rebulid/repair. I need to add another 200,000 files back as are retention is 200 days of video recordings. Anyways to speed up this process?

    I notice BlueIris is only using around 25% cpu and doing this causing a recording gap which isnt the greatest. Just looking for a fast way to fix this.

    Thanks!
     
  4. fenderman

    fenderman Staff Member

    Joined:
    Mar 9, 2014
    Messages:
    30,818
    Likes Received:
    9,792
    just disable the auto rebuild.
    Also 200k files for 200 days is 1000 files per day. Use the combine and cut feature and set each clip to an hour so that you have less.
     
    SouthernYankee likes this.
  5. nutt318

    nutt318 Young grasshopper

    Joined:
    Jul 28, 2015
    Messages:
    48
    Likes Received:
    16
    Auto rebuild, is that the compact/repair db every night? Just wondering where I should disable this and then what is the best method then to get BlueIris to know about all the clips.

    I'll go ahead and change the settings for the 1hr clips, that makes sense because copying/managing all these little clips is crazy.
     
  6. fenderman

    fenderman Staff Member

    Joined:
    Mar 9, 2014
    Messages:
    30,818
    Likes Received:
    9,792
    yes. Blue iris does not need to compact/repair every night. It knows where all the clips are.
     
  7. Mike A.

    Mike A. Getting comfortable

    Joined:
    May 6, 2017
    Messages:
    437
    Likes Received:
    262
    While on the subject, what are the differences between the three database maintenance options?

    Compact/Repair - I believe this is a typical compaction of of the database to take out wasted space from deletions, etc.
    Repair/Regenerate - I'd guess is rebuilding the database from scratch?
    Run maintenance - ???
     
  8. Natey2

    Natey2 Young grasshopper

    Joined:
    Sep 14, 2018
    Messages:
    38
    Likes Received:
    13
    Location:
    California
    I hope those 200,000 files are not in 1 [sub-]directory in a Windows filesystem.


    Sent using Tapatalk
     
  9. nutt318

    nutt318 Young grasshopper

    Joined:
    Jul 28, 2015
    Messages:
    48
    Likes Received:
    16
    Is there anyway to have BlueIris rebuild the database while also recording? incase this thing long than the weekend it would be nice to have it record while its regenerating the db.

    Yep, lol