[confirm] DataBase Size Error (1 Viewer)

[Smeulf]

Please use MP2_Alpha_1 branch to avoid any problem

 

[guytpetj]

OK,
I've downloaded, modified and compiled the branch.
Restored a copy of the original database that gave me the error.

I'm happy to say that the line of code below fixed my problem.

_connectionString = "Data Source='" + databaseFile + "'; Default Lock Timeout=" + LOCK_TIMEOUT + "; Max Buffer Size = " + MAX_BUFFER_SIZE + "; Max Database Size = " + 1024;


I'll try to drastically increase my database size tommorow as test to see if it keeps working as expected.

 

[Albert]

Thanks guytpetj very much. Then I'll fix our code in that area.

 

[Smeulf]

Hi guytpetj,

The issue should be solved in the "dev" branch, with the correct connection string and and auto increment of the value. If you have some time to pull the last commits on that one, build and try, that would be great to confirm it works...

 

[guytpetj]

Hi Smeulf,

I've compiled with the files in the "dev" branch and run it with my now 284MB database, and all seems to work fine.

Just to make sure that I did do the right thing I'm attching the "SQLCEDatabase.cs" I used for the test.

 

[Smeulf]

Yes, you pulled the right branch, the code is the right one

Thank you very much guytpetj for your time.

Cheers.

 

[morpheus_xx]

Seems like this issue is not fully solved yet:
https://forum.team-mediaportal.com/...with-many-surprises.107122/page-2#post-858896

• When the DB size increases while server is running, it still might fail (size parameter is only adapted on open, not when running)
• DB seems to be blown up too much, does free space get's reused properly? Or did the ML create new tables and left the old ones existing?

 

[guytpetj]

Compacting the 1.2GB database did not do much.

If you want I can delete the database and start from scratch to see if it ends up growing to the same size.

Eventhough the database is this big, everything works fine, and it finaly stopped growing at 1.2GB, now if I have MP2 server running the database size remains the same.

 

[morpheus_xx]

Please keep the current (big) database. Can you share it with us? How big is it when packed with 7z?

If it is too big, I would be interested in the contained tables and record counts of each table

 

[guytpetj]

compressed with 7z the database is 634MB

Is there a place/system you want me to use to upload?