Database error
-
- Posts: 19
- Joined: Mon Apr 05, 2021 6:10 pm
- Location: Antelope, CA
Database error
Im showing a Large database alert see attached. Any ideas on how to correct or what is best practice/settings for keeping the DB from causing any performance issues?
- Attachments
-
- Database settings.png (57 KiB) Viewed 1345 times
-
- Database error.png (9.6 KiB) Viewed 1345 times
Re: Database error
What does it show in the Log ? It could be that the database is corrupted and needs to be rebuilt.
Forum Moderator.
Problem ? Ask and we will try to assist, but please check the Help file.
Problem ? Ask and we will try to assist, but please check the Help file.
-
- Posts: 19
- Joined: Mon Apr 05, 2021 6:10 pm
- Location: Antelope, CA
Re: Database error
I dont see any errors pertaining to the DB in the log, but i also dont see the runing log, can you point me to where it should be?
How do i rebuild the DB? Will i loose any information?
How do i rebuild the DB? Will i loose any information?
Re: Database error
Can you post an image of the BI Status Storage Tab?
-
- Posts: 19
- Joined: Mon Apr 05, 2021 6:10 pm
- Location: Antelope, CA
Re: Database error
What type of drive is your E: drive?
What is the 'Combine or cut video each' set at?
There should be at least 1.5 - 2 times free space available as the total for ALL cameras, for one 'Combine or cut' period, for the maintenance cycle.
Looks okay to me.
Could be a performance issue of the E: drive.
What type of drive it is? Make/Model.
What is the 'Combine or cut video each' set at?
There should be at least 1.5 - 2 times free space available as the total for ALL cameras, for one 'Combine or cut' period, for the maintenance cycle.
Looks okay to me.
Could be a performance issue of the E: drive.
What type of drive it is? Make/Model.
-
- Posts: 19
- Joined: Mon Apr 05, 2021 6:10 pm
- Location: Antelope, CA
Re: Database error
Seagate IronWolf 12TB NAS Internal Hard Drive HDD – 3.5 Inch SATA 6Gb/s 7200 RPM 256MB Cache
What is the process to rebuild the DB?
What is the process to rebuild the DB?
Re: Database error
artamous75 wrote: ↑Tue Jan 30, 2024 10:10 pm Seagate IronWolf 12TB NAS Internal Hard Drive HDD – 3.5 Inch SATA 6Gb/s 7200 RPM 256MB Cache
What is the process to rebuild the DB?
1st - Database 'Repair/Regenerate'. This will keep alerts.
If this doesn't work, then...
2nd - Database Delete & Regenerate. With this option you will loose all alerts. You could use the 'Search' function to generate new alerts, but that would take an extremely large amount of time.
If this doesn't work, then...
3rd - Start with an empty DB...
Shutdown BI. delete the entire BI DB folder and all contents. Then, Start BI. BI will create the necessary folders.
-
- Posts: 1
- Joined: Thu Feb 22, 2024 4:41 am
Re: Database error
Thanks for sharing this processMikeBwca wrote: ↑Sun Feb 04, 2024 4:40 amartamous75 wrote: ↑Tue Jan 30, 2024 10:10 pm Seagate IronWolf 12TB NAS Internal Hard Drive HDD – 3.5 Inch SATA 6Gb/s 7200 RPM 256MB Cache
What is the process to rebuild the DB?
1st - Database 'Repair/Regenerate'. This will keep alerts.
If this doesn't work, then...
2nd - Database Delete & Regenerate. With this option you will loose all alerts. You could use the 'Search' function to generate new alerts, but that would take an extremely large amount of time.
If this doesn't work, then...
3rd - Start with an empty DB...
Shutdown BI. delete the entire BI DB folder and all contents. Then, Start BI. BI will create the necessary folders.