Database error
-
artamous75
- 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 4758 times
-
- Database error.png (9.6 KiB) Viewed 4758 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.
-
artamous75
- 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
...
Last edited by MikeBwca on Fri Apr 05, 2024 11:50 am, edited 1 time in total.
-
artamous75
- Posts: 19
- Joined: Mon Apr 05, 2021 6:10 pm
- Location: Antelope, CA
Re: Database error
...
Last edited by MikeBwca on Fri Apr 05, 2024 11:51 am, edited 1 time in total.
-
artamous75
- 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
...
Last edited by MikeBwca on Fri Apr 05, 2024 11:51 am, edited 1 time in total.
-
User@CCWebster
- Posts: 1
- Joined: Tue Aug 27, 2024 6:25 pm
Re: Database error
I have been having issue with Blue Iris seeming to reset at various instances. The DB goes through its process of apparently rebuilding.. indexing..verifying.. compacting, etc maybe I have wrong order.
I have a Large DB over 250,000 records. Is there a limit, or practical limit? I have more than enough physical space (2TB) just for the DB, currently showing 7,337,721 records.
When the reset occurs, BI does not allow any console activity, other than watching the DB status do its thing. This takes several minutes (5 to 10?) Also status during this time shows drive(s) over allocated; but, once DB is finalized with rebuild/reset, The Overallocated clears.
I temporarily have disabled several cameras during the day and this does not seem to help.
I've had this going on now intermittently for several weeks.
Currently have 12 cameras (4 @ H.264, 8 @ H.265) running jpegs every 3 seconds to NAS, and motion to BI Server, Not using any AI currently.
Currently running 5.9.5.4 (again) I've tried some of the older versions, same results.
I'd include the log file, but the problem hasn't happened since the last time I changed versions.
I have a Large DB over 250,000 records. Is there a limit, or practical limit? I have more than enough physical space (2TB) just for the DB, currently showing 7,337,721 records.
When the reset occurs, BI does not allow any console activity, other than watching the DB status do its thing. This takes several minutes (5 to 10?) Also status during this time shows drive(s) over allocated; but, once DB is finalized with rebuild/reset, The Overallocated clears.
I temporarily have disabled several cameras during the day and this does not seem to help.
- DataBase Screen Shot 2024-08-27 150029.png (12.09 KiB) Viewed 1799 times
Currently have 12 cameras (4 @ H.264, 8 @ H.265) running jpegs every 3 seconds to NAS, and motion to BI Server, Not using any AI currently.
Currently running 5.9.5.4 (again) I've tried some of the older versions, same results.
I'd include the log file, but the problem hasn't happened since the last time I changed versions.
- DataBase Screen Shot 2024-08-27 150029.png (12.09 KiB) Viewed 1799 times
- Drives _ Screenshot 2024-08-27 151248.png (46.33 KiB) Viewed 1799 times