[confirm] - DataBase Size Error

Hi,

I have no way to reproduce the problem, but for me the logs are clear enough.

Nowhere in the code we define the "max database size" parameter for the connection.

Mantis entry opened for that bug : http://mantis.team-mediaportal.com/view.php?id=3812

Cheers.

 

Yesterday, Smeulf found a resource in the internet which describes the problem: http://blogs.msdn.com/b/sqlserverco...atabase-size-connection-string-parameter.aspx
guytpetj, do you have a setup where you can compile/run MP2? I.e. do you have checked the sources out and VS 2010 installed? I don't want to make you too much work, so don't bother. We can also give you a precompiled test version, just let us know.

The problem doesn't seem to be a broken DB, it seems only to be a connection string which restricts the DB size to 256 MB by default. Changing that string should avoid the problem.

If you can do it yourself, can you please test this: Go to file 'SQLCEDatabase.cs' line 58 and use a connection string like this:

Code (Text):

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

If you're using VS, you also might have to set MediaPortal.Server project as main (startup) project. Then, you can run the server from the IDE. Our Wiki has also some tips about compiling MP2 if you have problems.
Alternatively, you can compile the server after changing the source file using MSBuild by opening Build/MSBUILD_Rebuild_Release_Server.bat and then run it from the Bin directory.

Thanks for testing!

 

Smeulf, we can also do another check; can you please try to start your server with an SQLCEDatabase compiled with the connection string I wrote above and use a Max Database Size value which is a bit smaller than your local database? If you can reproduce the error, I would say I'll do two things:
1) Use a bigger default value for that switch in the connection string
2) Make that value configurable

 

mmm, "funny" : I can't reproduce the problem with "Max Database Size" = 1 or 10 as my db is 27Mb

But maybe it just means the max database size can't be less than the default minumum, even if I can't find any KB about that...

Albert, I would also think about an auto increase of the max database size value. IE if the initial value is 1Gb, and the db is more than 512Mb at server startup, then the Max DB size would grown up to 1.5Gb. It would avoid anyone to forgot to increase the value in the config file or setting.

 

Also, I can eventually provide a test version of the plugin with a 1024Mb max database string...

 

Good idea. If we have confirmed that the problem is gone with the new setting, I can implement such an auto-increment.