Very slow DB regenerate

[lergolas]

Good morning.

I'm having a problem with a camera server running Blue Iris version 5.9.9.64, the latest version released. I updated it to this version today to see if it fixed the problem, but it didn't.

Last Friday, there was a power outage and the server suddenly shut down.
As has happened to me before, the database became corrupted and I had to rebuild it.

The problem is that the rebuild took almost two days, when it normally takes an hour or less from scratch.
Also, I was still having the Drives Overallocated issue, so it wasn't done correctly.

The rebuild is done from scratch, stopping the service, renaming the db folder, and starting it.

The server has 44 cameras, and the version I had at the time of the outage was 5.9.9.54, which I updated on 02/06/25.

I did the first rebuild on that version, and since it was slow, I updated it to the latest one.

On June 2, 2025, when I updated to version 5.9.9.54, I performed an identical rebuild from scratch, and it performed successfully.

More information: I have two types of disks: an SSD for the database and new recordings, and an HDD for storing older recordings.
I've tried removing the older recordings because they're on slower disks and rebuilding only with the ones on the SSD, but I have the same problem.

Obviously, I've checked the disks, both the SSD and the HDD, and they're fine, with normal reads and writes.

I don't know if you can think of anything I can do or what might be happening.

Thank you very much.

Best regards.

 

[Bruce_H]

Just a suggestion, you might want to consider getting a UPS so that power outages don't crash the BI server!

As for your drives overallocated, some screen captures of the setting for you storage drives might help to see if there is something that can be suggested!

 

[Coldair]

I am having the same problem and my machines are on an UPS.

I tired deleting all recordings and than I only had a hour or so recordings on some cameras and none on others, than it got worse and than I had several fatal errors while in blueiris.

 

[lergolas]

Thank you very much for your reply.

We have a UPS system, but it failed the other day when it was supposed to be working. There are usually power outages in the area, and it doesn't shut down; it was just bad luck.

I've attached a screenshot of the disk notification once the rebuild of the SSD recordings was complete. In theory, it completed the rebuild correctly.



It's supposed to have recorded all the recordings on the SSDs in the database (the top drive), but it still doesn't recognize the disk space occupied by them...


Blue Iris config New folder:


I don't know what could be happening,