Page 1 of 1

Database error

Posted: Mon Jan 29, 2024 4:28 pm
by artamous75
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?

Re: Database error

Posted: Mon Jan 29, 2024 4:33 pm
by TimG
What does it show in the Log ? It could be that the database is corrupted and needs to be rebuilt.

Re: Database error

Posted: Tue Jan 30, 2024 3:25 pm
by artamous75
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?

Re: Database error

Posted: Tue Jan 30, 2024 4:10 pm
by MikeBwca
...

Re: Database error

Posted: Tue Jan 30, 2024 4:14 pm
by artamous75
See Attached

Re: Database error

Posted: Tue Jan 30, 2024 4:34 pm
by MikeBwca
...

Re: Database error

Posted: Tue Jan 30, 2024 10:10 pm
by artamous75
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?

Re: Database error

Posted: Sun Feb 04, 2024 4:40 am
by MikeBwca
...

Re: Database error

Posted: Tue Aug 27, 2024 7:18 pm
by User@CCWebster
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.
DataBase Screen Shot 2024-08-27 150029.png
DataBase Screen Shot 2024-08-27 150029.png (12.09 KiB) Viewed 1873 times
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.
DataBase Screen Shot 2024-08-27 150029.png
DataBase Screen Shot 2024-08-27 150029.png (12.09 KiB) Viewed 1873 times
Drives _ Screenshot 2024-08-27 151248.png
Drives _ Screenshot 2024-08-27 151248.png (46.33 KiB) Viewed 1873 times