5.9.9 - January 17, 2025 - More Pre-6.0 feature releases

[Tinman]

I cut all the legacy DB files and stuck them in a folder. I left the only new files. I then restarted the BI service and presto, all my clips were still intact. I also did a database compact after that as well.

 

[tinker3433]

I am holding out for Version 5.9.9.31415926535897932384626433832795028841971693993751058209749445923078164062862089986280348253421170679821480865132823066470938446095505822317253594081284811174502841027019385211055596446229489549303819644288109756659334461284756482337867831652712019091456485669234603486104543266482133936072602491412737245870066063155881748815209209628292540917153643678925903600113305305488204665213841469519415116094330572703657595919530921861173819326117931051185480744623799627495673518857527248912279381830119491298336733624406566430860213949463952247371907021798609437027705392171762931767523846748184676694051320005681271452635608277857713427577896091736371787214684409012249534301465495853710507922796892589235420199561121290219608640344181598136297747713099605187072113499999983729780499510597317328160963185950244594553469083026425223082533446850352619311881710100031378387528865875332083814206171776691473035982534904287554687311595628638823537875937519577818577805321712268066130019278766111959092164201989380952572010654858632788659361533818279682303019520353018529689957736225994138912497217752834791315155748572424541506959508295331168617278558890750983817546374649393192550604009277016711390098488240128583616035637076601047101819429555961989467678374494482553797747268471040475346462080466842590694912933136770289891521047521620569660240580381501935112533824300355876402474964732639141992726042699227967823547816360093417216412199245863150302861829745557067498385054945885869269956909272107975093029553211653449872027559602364806654991198818347977535663698074265425278625518184175746728909777727938000816470600161452491921732172147723501414419735685481613611573525521334757418494684385233239073941433345477624168625189835694855620992192221842725502542568876717904946016534668049886272327917860857843838279679766814541009538837863609506800642251252051173929848960841284886269456042419652850222106611863067442786185480744623799627495673518857527248912279381830119491298336733624406566430860213949463952247371907021798609437027705392171762931767523846748184676694051320

 

[jaydeel]

Chicken.

 

[jrbeddow]

I am holding out for Version 5.9.9.31415926535897932384626433832795028841971693993751058209749445923078164062862089986280348253421170679821480865132823066470938446095505822317253594081284811174502841027019385211055596446229489549303819644288109756659334461284756482337867831652712019091456485669234603486104543266482133936072602491412737245870066063155881748815209209628292540917153643678925903600113305305488204665213841469519415116094330572703657595919530921861173819326117931051185480744623799627495673518857527248912279381830119491298336733624406566430860213949463952247371907021798609437027705392171762931767523846748184676694051320005681271452635608277857713427577896091736371787214684409012249534301465495853710507922796892589235420199561121290219608640344181598136297747713099605187072113499999983729780499510597317328160963185950244594553469083026425223082533446850352619311881710100031378387528865875332083814206171776691473035982534904287554687311595628638823537875937519577818577805321712268066130019278766111959092164201989380952572010654858632788659361533818279682303019520353018529689957736225994138912497217752834791315155748572424541506959508295331168617278558890750983817546374649393192550604009277016711390098488240128583616035637076601047101819429555961989467678374494482553797747268471040475346462080466842590694912933136770289891521047521620569660240580381501935112533824300355876402474964732639141992726042699227967823547816360093417216412199245863150302861829745557067498385054945885869269956909272107975093029553211653449872027559602364806654991198818347977535663698074265425278625518184175746728909777727938000816470600161452491921732172147723501414419735685481613611573525521334757418494684385233239073941433345477624168625189835694855620992192221842725502542568876717904946016534668049886272327917860857843838279679766814541009538837863609506800642251252051173929848960841284886269456042419652850222106611863067442786185480744623799627495673518857527248912279381830119491298336733624406566430860213949463952247371907021798609437027705392171762931767523846748184676694051320

Ah, that would be the special pi edition, to be released on some future March 14th.

 

[jaydeel]

5.9.9.75

The changelog is reproduced below. The highlights are mine.

Notes:

1. Remote Management users should heed the final 'Known Issues' heads-up BEFORE UPDATING.
2. As others have reported, I've also successfully updated without incident (so far).
3. The two new (and now only) database files (notably still *.dat files) are highlighted in this screenshot:
   

CHANGELOG:

[5.9.9.75] – 2025-09-14

Added
• N/A

Fixed
• Non-system admin users will no longer see camera IP addresses in the JSON "camlist" results

Changed
• Version 6 database. The DB code has been redesigned and then rebuilt from the ground up. The DB now consists of only 2 files, records.dat (the essential elements) and extra.dat (data that can be regenerated including preview images). If you make DB backups, only the records.dat is required.
• Given the sheer enormity of this change, data will be migrated to the new files when you install this update, but the old files (clips.dat and other view.dat files) will not be deleted automatically until stability is assured, allowing you to safely return to a previous release if required. If you do return to an earlier version, you can run a repair to adopt any new files into the old format and then delete the records and extra files so that they will once again be created when you return to 5.9.9.75 or newer.

Known issues
• Remote management has not been extensively tested against the new database code. The timeline display will be missing until a future release.

 

[IReallyLikePizza2]

So I can delete everything other than records.dat and extra.dat? Thats what I got from that

 

[jaydeel]

So I can delete everything other than records.dat and extra.dat? Thats what I got from that

I read it as you can do this IF AND ONLY IF you are confident you will not need to safely return to a previous release if required.
What's the rush?

 

[VideoDad]

I am holding out for Version 5.9.9.31415926535897932384626433832795028841971693993751058209749445923078164062862089986280348253421170679821480865132823066470938446095505822317253594081284811174502841027019385211055596446229489549303819644288109756659334461284756482337867831652712019091456485669234603486104543266482133936072602491412737245870066063155881748815209209628292540917153643678925903600113305305488204665213841469519415116094330572703657595919530921861173819326117931051185480744623799627495673518857527248912279381830119491298336733624406566430860213949463952247371907021798609437027705392171762931767523846748184676694051320005681271452635608277857713427577896091736371787214684409012249534301465495853710507922796892589235420199561121290219608640344181598136297747713099605187072113499999983729780499510597317328160963185950244594553469083026425223082533446850352619311881710100031378387528865875332083814206171776691473035982534904287554687311595628638823537875937519577818577805321712268066130019278766111959092164201989380952572010654858632788659361533818279682303019520353018529689957736225994138912497217752834791315155748572424541506959508295331168617278558890750983817546374649393192550604009277016711390098488240128583616035637076601047101819429555961989467678374494482553797747268471040475346462080466842590694912933136770289891521047521620569660240580381501935112533824300355876402474964732639141992726042699227967823547816360093417216412199245863150302861829745557067498385054945885869269956909272107975093029553211653449872027559602364806654991198818347977535663698074265425278625518184175746728909777727938000816470600161452491921732172147723501414419735685481613611573525521334757418494684385233239073941433345477624168625189835694855620992192221842725502542568876717904946016534668049886272327917860857843838279679766814541009538837863609506800642251252051173929848960841284886269456042419652850222106611863067442786185480744623799627495673518857527248912279381830119491298336733624406566430860213949463952247371907021798609437027705392171762931767523846748184676694051320

When you get to the last digit of that, does it then roll over to 6.0.0.0?

 

[Tinman]

I have gotten this twice now...something is not right. I did a repair/regenerate, and it fixed it, will see if it comes back.

 

[IReallyLikePizza2]

Looks like I'm getting that too. Just did a repair, will see if that holds

 

[bp2008]

I hope this new database version puts an end to all the DB corruption and storage allocation issues BI has had over the years.

I tested the Repair & Regenerate function and it works more or less exactly as before, in that it takes quite a while (for a large database) and it still renders Blue Iris incapable of recording anything while the DB is being regenerated.

 

[IAmATeaf]

I wonder if you do decide or need to go back then will you lose whatever event details have been written in the time in between upgrading and regressing or do you think the preamble data in the db is still the same and older versions simply ignore the extra data?

Mind you having typed all the above and just re-read the changelogs it does state that the db code has been redesigned ?

 

[IAmATeaf]

I hope this new database version puts an end to all the DB corruption and storage allocation issues BI has had over the years.

I tested the Repair & Regenerate function and it works more or less exactly as before, in that it takes quite a while (for a large database) and it still renders Blue Iris incapable of recording anything while the DB is being regenerated.

Yes, am with you on the db regen and not recording, I have my weekly regen set to Sunday lunch time for this reason.

 

[Tinbum]

I'm having database problems now.

Done a regen but still persists. Wont delete any from aux1 or aux2.

 

[IAmATeaf]

Thinks that nothing needs to be moved ?

What are Aux 1 and 2 ?

 

[Tinbum]

Thinks that nothing needs to be moved ?

What are Aux 1 and 2 ?

Rolled back to 5.9.9.73 and works ok after a regen. Not going to try 5.9.9.75 again.

 

[biggen]

I don't even see .75 any more. He must have pulled it and reverted to .73 as that is the latest one available to update to.

I'm going to let you guys take the grenades on this one. I'll update in a couple months when all the screaming and shouting is over.

 

[Tinman]

I don't even see .75 any more. He must have pulled it and reverted to .73 as that is the latest one available to update to.

I'm going to let you guys take the grenades on this one. I'll update in a couple months when all the screaming and shouting is over.

5.9.9.76 has just been released to address these issues. No yelling here...this is the fun part DB compact now works as well.

 

[jaydeel]

5.9.9.76

As already noted by other users, update 5.9.9.75 has been replaced by 5.9.9.76.

The changelog is unchanged -- except for the version number and date.

[5.9.9.76] – 2025-09-15

Added
• N/A

Fixed
• Non-system admin users will no longer see camera IP addresses in the JSON "camlist" results

Changed
• Version 6 database. The DB code has been redesigned and then rebuilt from the ground up. The DB now consists of only 2 files, records.dat (the essential elements) and extra.dat (data that can be regenerated including preview images). If you make DB backups, only the records.dat is required.
• Given the sheer enormity of this change, data will be migrated to the new files when you install this update, but the old files (clips.dat and other view.dat files) will not be deleted automatically until stability is assured, allowing you to safely return to a previous release if required. If you do return to an earlier version, you can run a repair to adopt any new files into the old format and then delete the records and extra files so that they will once again be created when you return to 5.9.9.75 or newer.

Known issues
• Remote management has not been extensively tested against the new database code. The timeline display will be missing until a future release.

 

[Tinbum]

.76 no better for me. Ran fine with .73